marqudegods 404 - y00ts bridged back to sol and burned
    Updated 2024-09-17
    with

    y00t_burns as (

    select

    block_timestamp
    , tx_id
    , signers[0] as user_address
    , instruction :accounts[11] ::string as mint

    from solana.core.fact_events
    where succeeded
    and program_id = '8avhY6jYWsHMfxxsdcp1rwpW5rGmQCacG8tZbzctQ53e'
    and substr(livequery.utils.udf_base58_to_hex(instruction :data), 3, 16) = '4c8f0ab72592f9b3' -- ClaimWithYoot
    and block_timestamp > '2024-09-15'
    ),

    bridge_sol_txs as (
    select

    fact_events.block_timestamp
    , fact_events.tx_id
    , y00t_burns.mint

    from solana.core.fact_events
    inner join y00t_burns
    on fact_events.instruction :accounts[7] = y00t_burns.mint
    where fact_events.succeeded
    and fact_events.program_id = '35iLrpYNNR9ygHLcvE1xKFHbHq6paHthrF6wSovdWgGu'
    and substr(utils.udf_base58_to_hex(fact_events.instruction :data), 3, 16) = '02601f70a097a1d8' -- ReceiveAndMint
    and fact_events.block_timestamp > '2024-04-22'
    ),

    aggregated as (
    QueryRunArchived: QueryRun has been archived