DATE | USD_VOLUME | CUMULATIVE | TRADERS | SWAPS | |
|---|---|---|---|---|---|
1 | 2025-01-10 00:00:00.000 | 16043.3 | 411868.39 | 264 | 590 |
2 | 2025-03-02 00:00:00.000 | 12693.63 | 2688889.58 | 679 | 1805 |
3 | 2025-02-16 00:00:00.000 | 58036.31 | 2427336.92 | 8365 | 18694 |
4 | 2025-02-17 00:00:00.000 | 30646.25 | 2457983.17 | 3262 | 7297 |
5 | 2025-02-13 00:00:00.000 | 34923.93 | 2289547.35 | 2418 | 8844 |
6 | 2025-02-15 00:00:00.000 | 43159.36 | 2369300.61 | 2808 | 11100 |
7 | 2025-02-04 00:00:00.000 | 62525.14 | 1926960.59 | 393 | 983 |
8 | 2025-01-27 00:00:00.000 | 114860.97 | 1195223.65 | 4767 | 5264 |
9 | 2025-02-09 00:00:00.000 | 14060.21 | 2125510.37 | 822 | 2182 |
10 | 2025-01-19 00:00:00.000 | 35821.71 | 647368.04 | 386 | 602 |
11 | 2025-01-04 00:00:00.000 | 11200.57 | 104432.19 | 383 | 594 |
12 | 2025-02-03 00:00:00.000 | 87845.45 | 1864435.45 | 322 | 808 |
13 | 2025-01-07 00:00:00.000 | 77903.2 | 335784.09 | 456 | 770 |
14 | 2025-01-08 00:00:00.000 | 22782.06 | 358566.15 | 228 | 496 |
15 | 2025-01-22 00:00:00.000 | 47293.7 | 728799.81 | 466 | 858 |
16 | 2025-02-11 00:00:00.000 | 60798.27 | 2213076.42 | 3890 | 16478 |
17 | 2025-02-25 00:00:00.000 | 27536.04 | 2638546.66 | 909 | 2221 |
18 | 2025-01-26 00:00:00.000 | 201558.51 | 1080362.68 | 6119 | 7086 |
19 | 2025-02-19 00:00:00.000 | 25709.26 | 2502757.98 | 1678 | 4171 |
20 | 2024-12-27 00:00:00.000 | 16071.23 | 21579.78 | 27 | 31 |
Sbhn_NPextensive-coffee
Updated 2025-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('day',block_timestamp) as date,
sum(amount_usd) as usd_volume,
sum(usd_volume) over (order by date) as cumulative,
count(distinct concat('0x', right(topics[2],40))) as traders,
count(distinct tx_hash) as swaps
from ink.core.fact_event_logs
join ink.core.ez_token_transfers a using(tx_hash)
where topic_0 = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
and concat('0x', right(topics[1],40)) = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
and a.contract_address = '0x4200000000000000000000000000000000000006'
and concat('0x', right(topics[2],40)) != '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
group by 1
Last run: 3 months ago
73
4KB
3s