Mikey_avg fee of uni, blur and gem where nft <= 10 --- 1
Updated 2022-12-17
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 det1 as (
select
distinct tx_hash,
count(distinct event_inputs:tokenId) as count_of_nft
from ethereum.core.fact_event_logs
where origin_to_address in ('0x39da41747a83aee658334415666f3ef92dd0d541', '0x000000000000Ad05Ccc4F10045630fb830B95127')
and event_inputs:tokenId is not null
and block_timestamp::DATE >= '2022-11-29'
group by 1
),
Blur as (
select avg(tx_fee) as Blur_fee,
count_of_nft
from det1
join ethereum.core.fact_transactions FT
on det1.tx_hash = FT.tx_hash
group by 2
),
det3 as (
select
distinct tx_hash,
count(distinct event_inputs:tokenId) as count_of_nft
from ethereum.core.fact_event_logs
where origin_to_address = '0x83c8f28c26bf6aaca652df1dbbe0e1b56f8baba2'
and event_inputs:tokenId is not null
and block_timestamp::DATE >= '2022-11-29'
group by 1
),
Gem1 as (
select avg(tx_fee) as Gem_fee,
count_of_nft
from det3
join ethereum.core.fact_transactions FT
on det3.tx_hash = FT.tx_hash
group by 2
),
Run a query to Download Data