MajorM111raw v1
    Updated 2024-12-14
    -- forked from get list event @ https://flipsidecrypto.xyz/studio/queries/d765bc94-9fad-4bdb-87ec-9c1d49ea17ee

    select *
    from avalanche.core.fact_decoded_event_logs t1
    where lower(t1.contract_address) = lower('0xaA4443f05FC1AE0Ea83090b7745e41592Fc4a980')
    order by t1.block_number desc, t1.event_index ASC
    limit 25

    -- token 0x8bc516DbF1A3399250C4d7fa9eBD8F516F156aFa
    -- pair 0xaA4443f05FC1AE0Ea83090b7745e41592Fc4a980



    QueryRunArchived: QueryRun has been archived