samMints Overview copy
Updated 2024-12-13Copy Reference Fork
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
26
27
28
29
30
31
32
33
34
35
36
›
-- -- forked from alitaslimi / Mints Overview @ https://flipsidecrypto.xyz/alitaslimi/q/GHVSCKpKnFC_/mints-overview
-- with
-- logs as (
-- select
-- block_number,
-- block_timestamp,
-- tx_hash,
-- origin_from_address,
-- origin_to_address,
-- origin_function_signature,
-- '0x' || right(topics[1], 40) as from_address,
-- '0x' || right(topics[2], 40) as to_address,
-- livequery.utils.udf_hex_to_int(topics[3]) as token_id
-- from
-- core.core.fact_event_logs
-- where
-- tx_succeeded
-- and block_timestamp::date >= '2024-12-12'
-- and contract_address = '0xe48696582061011beadcdb1eb132ff2261ced5cf'
-- and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- ERC-20 & ERC-721
-- and topics[1] is not null
-- and topics[2] is not null
-- ),
-- mints as (
-- select
-- block_timestamp,
-- tx_hash,
-- to_address as minter,
-- token_id
-- from
-- logs
-- where
-- from_address = '0x0000000000000000000000000000000000000000'
-- )
-- select
QueryRunArchived: QueryRun has been archived