De-mystifying cryptocurrency data
How to find stories on ransoms, scams and betting markets
Caitlin Ostroff, The Wall Street Journal
Jeremy Merrill, The Washington Post
Some Kinds of Crypto Stories
Our goal: give you the tools to cover this when it intersects your beat.
A Lot Has Happened
Jargon: Silly words that explain crypto
Blockchain: Immutable ledger that records transactions and tracks assets in a network. It’s really just a distributed database. Some examples: Bitcoin, Ethereum, Tron, Stellar, Solana.
Token: Digital representations of assets or interests on a blockchain. Some high-level types include payment tokens (like bitcoin), utility tokens and security tokens.
Stablecoin: A type of token that is pegged to a real-world asset, like the U.S. dollar or a nugget of gold.
The jargon gets worse. You don't have to learn it all.
A blockchain is just a database
More Jargon (Sorry)
Bitcoin | Ethereum | Tron |
Starts with 1, 3, or bc1 | Starts with 0x | Starts with T |
1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa | 0x71C7656EC7ab88b098defB751B7401B5f6d8976F | TF48MUvZhSDpLFfC414b94Nj4LwqBFbXom |
Where to find wallet addresses
Examples from the Wild: Sanctions
Full list here: https://github.com/ultrasoundmoney/ofac-ethereum-addresses
Link to Treasury release: https://ofac.treasury.gov/recent-actions/20220808
Examples from the Wild: Sanctions
Examples from the Wild: Sanctions
These hacks are still happening and are likely to proliferate as crypto’s value grows. A crypto exchange called Bybit was hacked for $1.5 billion, which an analytics firm Elliptic tied to Lazarus Group.
Examples from the Wild: Trading Rooms
Examples from the Wild: Trading Rooms
All sorts of things happen in public in the crypto world if you know where to look.
Telegram and Discord are often filled with interactions between investors and cryptocurrency developers.
It’s possible to extract these messages in bulk.
There are other tools and libraries for interacting with Telegram and Discord.
Examples from the Wild: Social Media
Examples from the Wild: Social Media
Examples from the Wild: Social Media
Examples from the Wild: Social Media
Examples from the Wild: Researchers
Examples from the Wild: Researchers
In 2019, a U.K. tourism currency-exchange company got hit by a ransomware attack
We wanted to know if they paid (or were going to pay) the ransom
Researchers suspected the ransomware gang was called Sodinokibi (there are loads of them) and they used an exploit in the company VPN. I asked them if there was a (safeish) way we could get in touch.
Examples from the Wild: Researchers
With the help of the researcher, we got Sodinokibi ransomware files and instructions on how to safely deploy them (air gapped computer not connected to any network)
Basically we intentionally infected a computer with ransomware.
The reasoning: Infected users get a chat line to the hackers.
Examples from the Wild: Researchers
Yes, we identified ourselves as WSJ reporters. Even sent them my author page.
And you’ll see the hackers gave us the payment bitcoin address, which we later confirmed with government sources.
Prediction markets
Prediction markets
Prediction markets
Prediction markets
Let's learn about a new project or coin via Dune
Suppose our editor assigns us to learn about predictive betting on the 2024 election. (This literally happened to me.)
Literally, go do it. Right now.
Let's learn about a new project or coin via Dune
Suppose our editor assigns us to learn about predictive betting on the 2024 election. (This literally happened to me.)
Literally, go do it. Right now.
E.g. https://dune.com/filarm/polymarket-activity or https://dune.com/rchen8/polymarket
Let's learn about a new project or coin via Dune
https://dune.com/filarm/polymarket-activity
E.g. Monthly volume on Polymarket… someone already did it.
Let's learn about a new project or coin via Dune
https://dune.com/queries/3995178 / @rchen8
Somebody else had non-election volume.
Let's learn about a new project or coin via Dune
So I used their methodology.
With modifications.
Let's learn about a new project or coin via Dune
https://dune.com/filarm/polymarket-activity
With SQL available.
Let's learn about a new project or coin via Dune
https://dune.com/filarm/polymarket-activity
With SQL available.
So you need to check what's election related!
Let's learn about a new project or coin via Dune
https://dune.com/filarm/polymarket-activity
With SQL available.
So you need to check what's election related!
(But it is just a database.)
Let's learn about a new project or coin via Dune
https://dune.com/filarm/polymarket-activity
And they answered my next question. What are the top post-election bets?
Is it right?
Databases usually don't always reflect reality:
Crypto is different. If the blockchain says you have 10 BTC, then you do.
Questions? Need a sense check?