Pmisha-bmlMdxfondation.1
Updated 2022-04-24
9
1
2
3
4
5
6
7
8
›
⌄
select
date_trunc('day',block_timestamp) as dt,
count(distinct event_inputs:tokenId::string) as total_mint,
count(distinct event_inputs:creator::string) as total_creator
from Ethereum_core.fact_event_logs
where CONTRACT_ADDRESS='0x3b3ee1931dc30c1957379fac9aba94d1c48a5405' and event_name = 'Minted'
and block_timestamp>='2022-01-01'
group by dt
Run a query to Download Data