jackguybase mints copy
Updated 2023-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from base mints @ https://flipsidecrypto.xyz/edit/queries/125d6b8b-9b0e-4382-8dc1-e818a8f74460
SELECT
*,
sum(new_nft_contracts) over (ORDER BY min_day) as total_contracts
FROM (
SELECT
min_day,
count(*) as new_nft_contracts
FROM (
SELECT
NFT_ADDRESS,
min(date_trunc('day', block_timestamp)) as min_day
FROM base.core.ez_nft_transfers
WHERE nft_from_address LIKE '0x0000000000000000000000000000000000000000'
GROUP BY 1
)
GROUP BY 1
)
Run a query to Download Data