DAY | ETH_AGG_FEES_USD | AVAX_AGG_FEES_USD | AGG_FEES_USD_CUMULATIVE | |
|---|---|---|---|---|
1 | 2025-04-08 00:00:00.000 | 2.43 | 0 | 149100.7 |
2 | 2025-04-07 00:00:00.000 | 10.11 | 0 | 149098.27 |
3 | 2025-04-06 00:00:00.000 | 3 | 0 | 149088.16 |
4 | 2025-04-02 00:00:00.000 | 0.3 | 0 | 149085.16 |
5 | 2025-03-30 00:00:00.000 | 14.97 | 0 | 149084.86 |
6 | 2025-03-29 00:00:00.000 | 29.79 | 0 | 149069.89 |
7 | 2025-03-28 00:00:00.000 | 39.86 | 0 | 149040.1 |
8 | 2025-03-26 00:00:00.000 | 28.67 | 0 | 149000.24 |
9 | 2025-03-25 00:00:00.000 | 4.77 | 0 | 148971.57 |
10 | 2025-03-24 00:00:00.000 | 9.02 | 0 | 148966.8 |
11 | 2025-03-22 00:00:00.000 | 1.24 | 0 | 148957.78 |
12 | 2025-03-17 00:00:00.000 | 0.05 | 0 | 148956.54 |
13 | 2025-03-16 00:00:00.000 | 2.16 | 0.11 | 148956.49 |
14 | 2025-03-15 00:00:00.000 | 50.37 | 0 | 148954.22 |
15 | 2025-03-14 00:00:00.000 | 5.51 | 0 | 148903.85 |
16 | 2025-03-13 00:00:00.000 | 48.89 | 0 | 148898.34 |
17 | 2025-03-11 00:00:00.000 | 0.05 | 0 | 148849.45 |
18 | 2025-03-10 00:00:00.000 | 2.98 | 0 | 148849.4 |
19 | 2025-03-09 00:00:00.000 | 14.76 | 0 | 148846.42 |
20 | 2025-03-08 00:00:00.000 | 47.38 | 0 | 148831.66 |
pietrektaggregator fees
Updated 13 hours ago
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
eth_agg AS (
select
to_date(block_timestamp) as day,
sum(amount_usd) as eth_agg_usd,
sum(amount) as eth_agg_eth
from
ethereum.core.ez_native_transfers
where
(to_address = '0x7d8911eb1c72f0ba29302be30301b75cec81f622' or to_address = '0x9f9a7d3e131ed45225396613e383d59a732f7beb')
and DAY <> '2022-05-17'
group by
day
-- and TOKEN_NAME = 'Native Ether'
-- and eth_agg_eth > 0
-- and bal_delta_usd < 100000
),
avax_agg AS (
select
to_date(block_timestamp) as day,
sum(amount) as avax_agg_avax,
sum(amount_usd) as avax_agg_usd
from
avalanche.core.ez_native_transfers
where
to_address = '0xc510d02cee9ef8d9bfb880b212ff0e3a5c46a6be'
group by
day
),
joined as (
select
a.day,
avax_agg_avax as avax_earned,
a.eth_agg_eth as eth_earned,
a.eth_agg_usd,
Last run: about 13 hours agoAuto-refreshes every 24 hours
...
909
42KB
9s