BLOCK_TIMESTAMP::DATE | Volume in eth | Volume in USD | TYPE | |
|---|---|---|---|---|
1 | 2025-02-18 00:00:00.000 | 0.4231216112 | 1133.621602682 | Mint fee |
2 | 2025-02-18 00:00:00.000 | 0.0100697134 | 26.978637684 | Referral |
3 | 2025-03-21 00:00:00.000 | 0.003253292022 | 6.410348954 | Referral |
4 | 2025-03-24 00:00:00.000 | 0.08760650658 | 180.780151143 | Mint fee |
5 | 2025-03-29 00:00:00.000 | 0.1381680868 | 257.135357483 | Mint fee |
6 | 2025-02-26 00:00:00.000 | 0.2219209915 | 539.688826975 | Mint fee |
7 | 2024-12-24 00:00:00.000 | 0.9670911528 | 3319.234942415 | Mint fee |
8 | 2024-12-22 00:00:00.000 | 0.3337801609 | 1112.435593164 | Mint fee |
9 | 2025-04-02 00:00:00.000 | 0.2856312936 | 536.476861041 | Mint fee |
10 | 2025-01-05 00:00:00.000 | 0.01152815013 | 41.865418677 | Referral |
11 | 2025-03-25 00:00:00.000 | 0.07405112316 | 152.944325846 | Mint fee |
12 | 2025-02-25 00:00:00.000 | 0.1901626646 | 466.399448425 | Mint fee |
13 | 2025-03-12 00:00:00.000 | 0.003679318358 | 6.962208559 | Referral |
14 | 2024-12-25 00:00:00.000 | 0.001266756032 | 4.408994512 | Referral |
15 | 2025-02-14 00:00:00.000 | 0.5403756778 | 1465.044697384 | Mint fee |
16 | 2025-01-01 00:00:00.000 | 0.2892024129 | 966.478313505 | Mint fee |
17 | 2024-12-25 00:00:00.000 | 0.6287600536 | 2188.424255041 | Mint fee |
18 | 2025-01-07 00:00:00.000 | 0.05750670241 | 206.050276642 | Referral |
19 | 2025-02-14 00:00:00.000 | 0.008617350891 | 23.36301345 | Referral |
20 | 2025-03-11 00:00:00.000 | 0.008230054222 | 15.643817373 | Referral |
Hessishzink fees
Updated 9 days 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
›
⌄
with all_txs as (SELECT VALUE as cost,
TO_ADDRESS as receiver ,
case when
TO_ADDRESS = '0xd00c70f9b78c63a36519c488f862df95b7a73d90' then 'Mint fee'
else 'Referral' end as type,
tx_hash,
BLOCK_TIMESTAMP
from ink.core.fact_traces
where --tx_hash = '0x6b764622974863ec8809d96ec45f92d38c6c3353f3e7566581da0de41effd56c' and
TYPE = 'CALL'
and TRACE_ADDRESS != 'ORIGIN'
and TX_SUCCEEDED = 'TRUE'
and FROM_ADDRESS = lower('0xFb2Cd41a8aeC89EFBb19575C6c48d872cE97A0A5')),
price as (
SELECT HOUR::date as time, avg(close) as pr
from crosschain.price.fact_prices_ohlc_hourly
where PROVIDER = 'coingecko'
and ASSET_ID = 'ethereum'
group by all)
select BLOCK_TIMESTAMP::date, sum(cost) as "Volume in eth",
"Volume in eth"*avg(pr) as "Volume in USD",
type
from all_txs
join price
on time = BLOCK_TIMESTAMP::date
group by all
Last run: 9 days ago
...
237
15KB
43s