mattkstewPooly NFTs 1
Updated 2022-06-23Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
date_trunc('day', block_timestamp),
count(event_inputs:to) as Total_NFTs
FROM ethereum.core.fact_event_logs
WHERE contract_address in ( lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'), lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'), lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
AND event_inputs:from LIKE '0x0000000000000000000000000000000000000000'
GROUP BY 1
Run a query to Download Data