crypto_edgarAll Airdropped Communities
    Updated 2024-01-03
    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