DATE | DAILY_VOLUME | |
|---|---|---|
1 | 2025-02-17 00:00:00.000 | 0.001 |
2 | 2025-02-18 00:00:00.000 | 9.31 |
3 | 2025-02-19 00:00:00.000 | 601.294503925 |
4 | 2025-02-20 00:00:00.000 | 9218.951947984 |
5 | 2025-02-21 00:00:00.000 | 56420.562278022 |
6 | 2025-02-22 00:00:00.000 | 83772.272766206 |
7 | 2025-02-23 00:00:00.000 | 181851.482824675 |
8 | 2025-02-24 00:00:00.000 | 80502.405017934 |
9 | 2025-02-25 00:00:00.000 | 97764.557644236 |
10 | 2025-02-26 00:00:00.000 | 146134.517992243 |
11 | 2025-02-27 00:00:00.000 | 74722.12631792 |
12 | 2025-02-28 00:00:00.000 | 52992.391694114 |
13 | 2025-03-01 00:00:00.000 | 39417.252396158 |
14 | 2025-03-02 00:00:00.000 | 43545.456650749 |
15 | 2025-03-03 00:00:00.000 | 48255.799529711 |
16 | 2025-03-04 00:00:00.000 | 52118.558312984 |
17 | 2025-03-05 00:00:00.000 | 48772.668068565 |
18 | 2025-03-06 00:00:00.000 | 47475.754775106 |
19 | 2025-03-07 00:00:00.000 | 41176.706160531 |
20 | 2025-03-08 00:00:00.000 | 39016.062103395 |
pepperatzichristian-harlequin
Updated 3 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 raw as (
select
block_timestamp,
tx_hash,
from_address,
left(input, 10) as funct_sig,
input,
value,
output
from monad.testnet.fact_traces
where to_address = '0xca810d095e90daae6e867c19df6d9a8c56db2c89'
and trace_address = 'ORIGIN'
and tx_succeeded = 'TRUE'
),
native_others as (
select
block_timestamp,
tx_hash,
from_address,
regexp_substr_all(substr(input, 11), '.{64}') as segmented_input,
regexp_substr_all(substr(output, 3), '.{64}') as segmented_output,
'0x'|| substr(segmented_input[2], 25) as user,
'0x' || substr(segmented_input[5], 25) as token_in,
livequery.utils.udf_hex_to_int(segmented_output[2]) as amount_in,
'0x'|| substr(segmented_input[6], 25) as token_out,
livequery.utils.udf_hex_to_int(segmented_output[3]) as amount_out,
from raw
where funct_sig = '0x7ff36ab5'
),
transfers_native as (
select
block_timestamp,
tx_hash,
from_address,
Last run: 3 days ago
29
1KB
58s