DAY | Volume ETH | Volume USD | AVG_VOLUME | |
|---|---|---|---|---|
1 | 2024-04-19 00:00:00.000 | 8.0678 | 24690.39 | 45.055456204 |
2 | 2024-03-10 00:00:00.000 | 22.3672 | 87904.26 | 237.579081081 |
3 | 2024-03-29 00:00:00.000 | 54.8843 | 194306.19 | 768.008656126 |
4 | 2024-04-04 00:00:00.000 | 26.3422 | 88098.6 | 168.127099237 |
5 | 2024-04-06 00:00:00.000 | 27.7972 | 92748.5 | 236.603316327 |
6 | 2024-03-11 00:00:00.000 | 24.946 | 99542.91 | 317.015636943 |
7 | 2024-04-20 00:00:00.000 | 11.9378 | 36770.99 | 83.380929705 |
8 | 2024-04-26 00:00:00.000 | 14.216 | 44614.28 | 80.822971014 |
9 | 2024-03-08 00:00:00.000 | 22.0322 | 85996.27 | 216.615289673 |
10 | 2024-04-24 00:00:00.000 | 16.7946 | 54084.42 | 135.890502513 |
11 | 2024-03-05 00:00:00.000 | 20.981 | 76829.55 | 189.235344828 |
12 | 2024-04-08 00:00:00.000 | 33.0066 | 118194.9 | 248.831368421 |
13 | 2024-04-25 00:00:00.000 | 13.3667 | 42038.15 | 98.913294118 |
14 | 2024-03-12 00:00:00.000 | 26.3702 | 105616.21 | 354.416812081 |
15 | 2024-03-19 00:00:00.000 | 6.495 | 21250.06 | 49.533939394 |
16 | 2024-03-06 00:00:00.000 | 19.9652 | 75172.53 | 198.869126984 |
17 | 2024-04-18 00:00:00.000 | 14.8811 | 44914.44 | 89.649580838 |
18 | 2024-03-24 00:00:00.000 | 16.9092 | 57290.8 | 125.637719298 |
19 | 2024-04-07 00:00:00.000 | 34.5519 | 117256.94 | 303.774455959 |
20 | 2024-03-03 00:00:00.000 | 23.2871 | 79925.27 | 168.975200846 |
MLDZMNyolo2- protocol fee2
Updated 2025-02-07
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
›
⌄
-- forked from yolo2- protocol fee @ https://flipsidecrypto.xyz/edit/queries/ac8adc6f-d458-41e2-800c-ebf640872bfd
-- forked from yolo2 @ https://flipsidecrypto.xyz/edit/queries/d73954ca-d252-4e52-9db4-0d4785112f9e
with tb1 as (select
*
from blast.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = lower('0x0000000000E14E87e5c80A8A90817308fFF715d3')
and ORIGIN_FUNCTION_SIGNATURE in ('0x7d7c3c74','0x7d33ca3f') --fee payment
)
select
BLOCK_TIMESTAMP::date as day,
sum(amount) as "Volume ETH",
sum(AMOUNT_USD) as "Volume USD",
avg(AMOUNT_USD) as avg_volume
from blast.core.ez_native_transfers
where tx_hash in (select tx_hash from tb1)
and to_address = lower('0x6b86fF7863e27d1C8CCf05dF9cB03b8eFaA52125')
group by 1
Last run: 3 months ago
65
4KB
51s