mohammadh3)NFT Comparison
Updated 2022-09-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 FLOW as
(select
'FLOW' as BLOCKCHAIN ,
date_trunc('day', block_timestamp) as block_day,
count(distinct TX_ID) as tx_count,
sum(tx_count) over (order by block_day asc) as cum_tx_count
from flow.core.ez_nft_sales
where (block_day >= '2022-01-01' and block_day < current_date -1)
and TX_SUCCEEDED = 'TRUE'
group by block_day
),
ETH as
(select
'ETHEREUMM' as BLOCKCHAIN,
date_trunc('day', block_timestamp)as block_day,
count(distinct TX_HASH) as tx_count,
sum(tx_count) over (order by block_day asc) as cum_tx_count
from ethereum.core.ez_nft_sales
where CURRENCY_SYMBOL in ('ETH','WETH')
and (block_day >= '2022-01-01' and block_day < current_date -1)
and TX_HASH !='0xc5531fa64ce1e5c609489e734325835471215ad5f8e0972c94b64d12242d97e4'
group by block_day
),
SOL as (
with A as(select
date_trunc('day', block_timestamp) as block_Day,
avg(swap_to_amount/swap_from_amount) as sol_price
from solana.core.fact_swaps
where block_Day >= '2022-01-01'
and swap_from_amount > 0
and swap_to_amount > 0
and swap_from_mint = 'So11111111111111111111111111111111111111112'
and swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
Run a query to Download Data