NavidCopy of Copy of Untitled Query
Updated 2022-10-18Copy Reference Fork
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_sales as (
select
'Ethereum' as network,
date(block_timestamp) as day,
price,
case
when price <= 0.01 then '0.01 ETH'
when price > 0.01 and price <= 0.1 then '0.1 ETH'
when price > 0.1 and price <= 1 then '1 ETH'
else '>1 ETH'
end as price_label
from
ethereum.core.ez_nft_sales
where currency_symbol = 'ETH' -- 'OP'
and block_timestamp > CURRENT_DATE-60
), op_sales as (
select
'Optimism' as network,
date(block_timestamp) as day,
price,
case
when price <= 0.01 then '0.01 ETH'
when price > 0.01 and price <= 0.1 then '0.1 ETH'
when price > 0.1 and price <= 1 then '1 ETH'
else '>1 ETH'
end as price_label
from
optimism.core.ez_nft_sales
where currency_symbol = 'ETH' -- 'OP'
and block_timestamp > CURRENT_DATE-60
)
select
day,
network,
price_label,
count(*) as cnt
Run a query to Download Data