mehrancrypto-dxoepqQ67-8
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT block_timestamp::date as daily ,
case
when PRICE < 0.01 then 'Price is less than 0.01 ETH'
when PRICE < 0.1 and price >= 0.01 then 'Price is above than 0.01 ETH & less than 0.1 ETH'
when PRICE < 1 and price >= 0.1 then 'Price is above than 0.1 ETH & less than 1 ETH'
when price >= 1 then 'Price is above than 1 ETH'
end as type , count(tx_hash) AS number
FROM Ethereum.core.ez_nft_sales
where CURRENCY_SYMBOL ilike '%ETH%'
and daily >= '2021-12-20'
GROUP BY 1 , 2
Run a query to Download Data