freemartianTop Animation Minters
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
23
24
25
›
⌄
-- forked from Daily Basepaint Animation @ https://flipsidecrypto.xyz/studio/queries/2a61d0df-77c8-4dfb-81b4-0ce5fe52049c
SELECT
nft_to_address AS user,
count(tx_hash) AS animations,
count(tx_hash) * 2 AS nft_burned
-- 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 2 DESC
LIMIT 20
QueryRunArchived: QueryRun has been archived