0xtableauTiny Dinos
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- tiny dinos
select block_timestamp::date,
count(tx_hash) as sales,
sum(price) as eth_vol,
sum(price_usd) as usd_vol,
avg(price_usd) as avg_usd_price
from
ethereum_core.ez_nft_sales
where block_timestamp::date > '2022-03-01' and block_timestamp::date <> current_date
and nft_address = lower('0xd9b78A2F1dAFc8Bb9c60961790d2beefEBEE56f4')
group by 1
order by 1 desc
-- moon birds mints
select *
from ethereum_core.ez_nft_mints
where nft_address = lower('0x23581767a106ae21c074b2276D25e5C3e136a68b')
Run a query to Download Data