crypto_edgarAll Airdropped Communities
Updated 2024-01-03
9999
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
›
⌄
with boogles as (
select
MINT,
NFT_NAME
from
solana.nft.dim_nft_metadata
where
nft_name REGEXP 'BOOGLE #[0-9]{3}$'
),
boogles_from_events as (
select
block_timestamp,
instruction:parsed:info:mint as mint
from
solana.core.fact_events
where
succeeded
and block_timestamp between '2021-08-15'
and '2022-09-15'
and program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
and event_type = 'mintTo'
and instruction:parsed:info:mintAuthority = 'J2AQypFpiKeDnp8feiVDptnyjcEsb4noPudcjGmnp6XB'
),
boogles_mint_tmp as (
select
boogles_from_events.mint as MINT,
'BOOGLE' as COLLECTION_NAME
from
boogles
inner join boogles_from_events on boogles.MINT = boogles_from_events.mint
),
boogles_mint as (
select
BLOCK_TIMESTAMP,
MINT,
PURCHASER AS TX_TO
QueryRunArchived: QueryRun has been archived