VOLUME_CATEGORY | NUM_TRADERS | TOP_5_TOKENS | |
|---|---|---|---|
1 | Under 10 USD | 42303 | USD₮0 (23743 trades), Fartcoin (15441 trades), AK47 (13213 trades), PURP... |
2 | 10-50 USD | 20859 | USD₮0 (44216 trades), PURPLE (21702 trades), AK47 (17932 trades), SHROOM... |
3 | 50-100 USD | 3750 | USD₮0 (12072 trades), PURPLE (6973 trades), AK47 (6868 trades), CAT (409... |
4 | 100-500 USD | 2584 | USD₮0 (10381 trades), PURPLE (3199 trades), AK47 (2995 trades), IAGENT (... |
5 | 500-1000 USD | 516 | USD₮0 (1655 trades), PURPLE (985 trades), AK47 (685 trades), Kraken (651... |
6 | 1000-5000 USD | 686 | USD₮0 (12716 trades), PURPLE (990 trades), AK47 (827 trades), IAGENT (72... |
7 | 5000-10000 USD | 174 | PURPLE (414 trades), USD₮0 (276 trades), AK47 (254 trades), IAGENT (221 ... |
8 | 10000+ USD | 202 | MAD (5870 trades), PURPLE (1536 trades), AK47 (712 trades), IAGENT (545 ... |
datavortexwhat categories are trading
Updated 8 days ago
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH SwapData AS (
SELECT
tx_hash,
origin_from_address AS trader,
block_timestamp
FROM
ink.core.ez_decoded_event_logs
WHERE
event_name = 'Swap'
AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
AND block_timestamp IS NOT NULL
AND tx_succeeded = TRUE
),
token_transfers AS (
SELECT
tx_hash,
symbol,
amount_usd
FROM
ink.core.ez_token_transfers
),
transfers_with_index AS (
SELECT
tx_hash,
symbol,
amount_usd,
ROW_NUMBER() OVER (
PARTITION BY tx_hash
ORDER BY
LOWER(symbol) ASC
) AS symbol_index
FROM
token_transfers
),
amounts_with_index AS (
SELECT
Last run: 8 days ago
8
1KB
8s