logx_tradeNov. 2021
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with daily as (
select
block_timestamp::date as date,
min(price) as floor_eth
from ethereum.core.ez_nft_sales
where nft_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'
and block_timestamp >= '2021-11-01'
and block_timestamp < '2021-12-01'
group by date
order by date asc
)
select
avg(floor_eth) as avg_floor
from daily
Run a query to Download Data