Crypto: market snapshot
For crypto desks, digital-asset funds and allocators
Every active token, quoted every 5 minutes around the clock, weekends included. Ranked lists only count tokens with at least $100k traded in 24 hours.
- Financial markets
- 6 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
Top movers right now
The ten biggest moves either way among liquid tokens, re-ranked after every 5-minute snapshot. Swap movers for gainers, losers or active.
GET crypto.movers10 SELECT symbol, name, last_price, chg_pct, day_volume, mcap
Largest tokens by market cap
The 20 largest tokens with today's change. crypto.top<N> works for any N.
GET crypto.top20 SELECT symbol, name, base_currency, last_price, chg_pct, mcap SORT mcap DESC
Most traded tokens
Where the money is trading today: ranked by dollar volume over the last 24 hours.
GET crypto.active10 SELECT symbol, name, last_price, chg_pct, day_volume, mcap
Stablecoins: are they holding the peg?
Each dollar stablecoin's distance from $1 in percent. Anything beyond a few tenths of a percent deserves a look.
GET crypto.stablecoins SELECT symbol, name, last_price, (last_price - 1) * 100 AS peg_gap_pct, mcap SORT mcap DESC
Tokens quoted per 1,000 or more
Sub-cent tokens are stored per 1,000, 1 million or more tokens (1MSHIBUSD). price_unit gives the unit; dividing by it gives the price of one token.
GET crypto.all SELECT symbol, name, price_unit, last_price, last_price / price_unit AS price_per_token, mcap WHERE price_unit > 1 SORT mcap DESC
Large caps up the most today
The 50 largest tokens ranked by today's change: the large-cap leaders and laggards without the small-cap noise.
GET crypto.top50 SELECT symbol, name, last_price, chg_pct, mcap SORT chg_pct DESC
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.