Flipside TeamUnique NFT contracts deployed and Minted
Updated 2024-09-06
999
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 Unique NFT contracts deployed and Minted @ https://flipsidecrypto.xyz/edit/queries/07d88249-ef71-43b9-9761-9b07f0bb020d
-- forked from 2024-04-09 08:15 AM @ https://flipsidecrypto.xyz/edit/queries/382c5b17-b5b5-45e1-b978-15090b22690f
with arbitrum_data AS
(
with hlg_contracts_arbitrum as
(
select address from arbitrum.core.dim_contracts
where creator_address in (
lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55'),
lower('0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
)
group by 1
)
select
contract_address as contract,
topics[3] as tokenId
from arbitrum.core.fact_event_logs
where 1=1
and block_timestamp >= '2022-11-01 00:00:00'
and contract_address in (select address from hlg_contracts_arbitrum group by 1)
and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
AND topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000'
and topics[3] is not null
group by contract_address, tokenId
),
avalanche_data AS
(
with hlg_contracts_avalanche as
(
select address from avalanche.core.dim_contracts
where creator_address in (
lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55'),
lower('0xf3ddf3dc6ebb5c5dc878c7a0c8b2c5e051c37594')
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived