BLOCK_TIMESTAMP | TX_HASH | COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD) | |
|---|---|---|---|
1 | 2025-01-10 18:06:22.000 | 14471103.183333 | |
2 | 2025-01-10 18:06:20.000 | 14471103.166667 | |
3 | 2025-01-10 18:06:19.000 | 14471103.158333 | |
4 | 2025-01-10 18:06:19.000 | 14471103.158333 | |
5 | 2025-01-10 18:06:19.000 | 14471103.158333 | |
6 | 2025-01-10 18:06:19.000 | 14471103.158333 | |
7 | 2025-01-10 18:06:19.000 | 14471103.158333 | |
8 | 2025-01-10 18:06:18.000 | 14471103.15 | |
9 | 2025-01-10 18:06:18.000 | 14471103.15 | |
10 | 2025-01-10 18:06:18.000 | 14471103.15 | |
11 | 2025-01-10 18:06:14.000 | 14471103.116667 | |
12 | 2025-01-10 18:06:14.000 | 14471103.116667 | |
13 | 2025-01-10 18:06:14.000 | 14471103.116667 | |
14 | 2025-01-10 18:05:59.000 | 14471102.991667 | |
15 | 2025-01-10 18:05:59.000 | 14471102.991667 | |
16 | 2025-01-10 18:05:59.000 | 14471102.991667 | |
17 | 2025-01-10 18:05:59.000 | 14471102.991667 | |
18 | 2025-01-10 18:05:56.000 | 14471102.966667 | |
19 | 2025-01-10 18:05:53.000 | 14471102.941667 | |
20 | 2025-01-10 18:05:53.000 | 14471102.941667 |
freeman_7test
Updated 2025-01-10
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
›
⌄
select
--to_timestamp(floor(EXTRACT(EPOCH from block_timestamp)/(60*5))*(60*5)) as five_minutes_interval, -- To get the minute interval , adjust as per choice
--sum(coalesce(amount_in_usd,amount_out_usd)) as TotalVolumeEXTRACT(EPOCH from block_timestamp)/(60*5)
block_timestamp,
EXTRACT(EPOCH from block_timestamp)/(60*2)
tx_hash,
coalesce(amount_in_usd,amount_out_usd)
from arbitrum.defi.ez_dex_swaps
where contract_address = lower('0xC6962004f452bE9203591991D15f6b388e09E8D0')
and block_timestamp::date >= '2024-01-01'
--group by 1
order by 1 desc
limit 100
Last run: 2 months ago
100
5KB
2s