day | token | number of transfers | trading volume (USD) | |
|---|---|---|---|---|
1 | 2025-05-18 00:00:00.000 | WRON | 361 | 32052.19 |
2 | 2025-05-18 00:00:00.000 | WETH | 77 | 15613.37 |
3 | 2025-05-18 00:00:00.000 | USDC | 58 | 14345.62 |
4 | 2025-05-18 00:00:00.000 | AXS | 54 | 14147.3 |
5 | 2025-05-18 00:00:00.000 | RONEN | 20 | 9215.56 |
6 | 2025-05-18 00:00:00.000 | Ronke | 3 | 4380.07 |
7 | 2025-05-18 00:00:00.000 | SLP | 12 | 2659.83 |
8 | 2025-05-18 00:00:00.000 | YGG | 11 | 2568.72 |
9 | 2025-05-18 00:00:00.000 | PIXEL | 16 | 1400.85 |
10 | 2025-05-18 00:00:00.000 | CAG | 12 | 718.08 |
11 | 2025-05-18 00:00:00.000 | BANANA | 3 | 142.05 |
12 | 2025-05-18 00:00:00.000 | PHPC | 1 | 0.1 |
13 | 2025-05-17 00:00:00.000 | WRON | 2373 | 509028.19 |
14 | 2025-05-17 00:00:00.000 | WETH | 905 | 321677.63 |
15 | 2025-05-17 00:00:00.000 | USDC | 762 | 287890.15 |
16 | 2025-05-17 00:00:00.000 | SLP | 319 | 157425.86 |
17 | 2025-05-17 00:00:00.000 | AXS | 446 | 137388.56 |
18 | 2025-05-17 00:00:00.000 | RONEN | 162 | 48764.21 |
19 | 2025-05-17 00:00:00.000 | YGG | 89 | 34619.55 |
20 | 2025-05-17 00:00:00.000 | PIXEL | 196 | 23150.16 |
defi__joshDaily trading activity on Katana
Updated 2025-05-18
99
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 katana_transfers AS (
-- SELECT
-- block_timestamp,
-- tx_hash,
-- contract_address,
-- symbol,
-- from_address,
-- to_address,
-- amount,
-- amount_usd
-- FROM ronin.core.ez_token_transfers
-- WHERE block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP)
-- AND (
-- origin_to_address = '0x7d0556d55ca1a92708681e2e231733ebd922597d' -- Katana Router
-- OR from_address = '0x7d0556d55ca1a92708681e2e231733ebd922597d'
-- OR to_address = '0x7d0556d55ca1a92708681e2e231733ebd922597d'
-- )
-- )
-- SELECT
-- distinct symbol as "token",
-- FROM katana_transfers
-- WHERE amount_usd IS NOT NULL;
WITH katana_transfers AS (
SELECT
block_timestamp,
tx_hash,
contract_address,
symbol,
from_address,
to_address,
amount,
amount_usd
FROM ronin.core.ez_token_transfers
Last run: 23 days ago
...
544
24KB
2s