freemartianDaily Basepaint Animation
Updated 2024-09-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
block_timestamp::date AS day,
count(tx_hash) AS animations,
count(DISTINCT nft_to_address) AS user,
count(tx_hash) * 2 AS nft_burned,
SUM(animations) OVER(ORDER BY day ASC) AS cum_animations
-- FROM base.core.fact_event_logs
FROM base.nft.ez_nft_transfers
WHERE nft_address = '0xc59f475122e914afcf31c0a9e0a2274666135e4e'
-- WHERE tx_hash = '0x0bc75e548e049f7f5772953f07349c3acf8457d7bb3ba5a0bca5b68ce04f7e48'
AND block_timestamp::date >= '2024-08-29'
AND event_type = 'mint'
GROUP BY 1
ORDER BY 1 ASC
QueryRunArchived: QueryRun has been archived