day | token | number of transfers | trading volume (USD) | |
|---|---|---|---|---|
1 | 2025-06-13 00:00:00.000 | WRON | 2240 | 491772.4 |
2 | 2025-06-13 00:00:00.000 | WETH | 1064 | 465997.16 |
3 | 2025-06-13 00:00:00.000 | USDC | 1075 | 391884.62 |
4 | 2025-06-13 00:00:00.000 | AXS | 352 | 104977.33 |
5 | 2025-06-13 00:00:00.000 | SLP | 210 | 68848.91 |
6 | 2025-06-13 00:00:00.000 | YGG | 106 | 38458.78 |
7 | 2025-06-13 00:00:00.000 | PIXEL | 213 | 15861.3 |
8 | 2025-06-13 00:00:00.000 | BANANA | 80 | 2120.84 |
9 | 2025-06-13 00:00:00.000 | CAG | 18 | 1437.6 |
10 | 2025-06-13 00:00:00.000 | Ronke | 16 | 794.49 |
11 | 2025-06-13 00:00:00.000 | RONEN | 10 | 532.83 |
12 | 2025-06-13 00:00:00.000 | LUA | 9 | 23.89 |
13 | 2025-06-13 00:00:00.000 | LUAUSD | 9 | 23.52 |
14 | 2025-06-13 00:00:00.000 | JAIHOZ | 2 | 6.35 |
15 | 2025-06-13 00:00:00.000 | APRS | 2 | 0.59 |
16 | 2025-06-13 00:00:00.000 | PHPC | 2 | 0.32 |
17 | 2025-06-13 00:00:00.000 | ANIMA | 1 | 0.21 |
18 | 2025-06-12 00:00:00.000 | WRON | 2840 | 307465.83 |
19 | 2025-06-12 00:00:00.000 | WETH | 780 | 268476.33 |
20 | 2025-06-12 00:00:00.000 | USDC | 961 | 261353.68 |
defi__joshDaily trading activity on Katana
Updated 2025-06-13
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: 21 days ago
...
548
25KB
2s