rustygeeaark-MarketData
    Updated 2023-10-30
    -- forked from more-experiments @ https://flipsidecrypto.xyz/edit/queries/19a8e580-d60b-4a88-9422-2fa94853b7c2

    SELECT *
    FROM arbitrum.core.fact_event_logs
    WHERE CONTRACT_ADDRESS = '0xF45f2903438d383769CA3E80356c167e9D9aF1AD'
    AND TOPICS[0] = '0xbd68bd00f6c811ab0e1b60300c14b5b4a98992e250c7e02032e6f6d40070790d'
    --AND TOPICS[1] = '0x00196834ad19e18bcab573766c501e3a5cf9a022e5fc21614e0dc7655b7e9c8f'
    ORDER BY BLOCK_TIMESTAMP DESC
    LIMIT 100


    -- WITH topic_match_tx AS(
    -- SELECT *
    -- FROM arbitrum.core.fact_event_logs
    -- WHERE CONTRACT_ADDRESS = '0xF45f2903438d383769CA3E80356c167e9D9aF1AD'
    -- AND TOPICS[0] = '0xbd68bd00f6c811ab0e1b60300c14b5b4a98992e250c7e02032e6f6d40070790d'
    -- --AND TOPICS[1] = '0x00196834ad19e18bcab573766c501e3a5cf9a022e5fc21614e0dc7655b7e9c8f'
    -- ORDER BY BLOCK_TIMESTAMP DESC
    -- LIMIT 100
    -- )

    -- SELECT *
    -- FROM topic_match_tx

    -- SELECT BLOCK_NUMBER, BLOCK_TIMESTAMP, DECODED_LOG-- ,DECODED_LOG:eventData[0][0][0][1] as market
    -- FROM arbitrum.core.fact_decoded_event_logs
    -- WHERE TX_HASH IN (SELECT TX_HASH FROM topic_match_tx)
    -- AND DECODED_LOG:eventData[0][0][0][1] = '0x70d95587d40a2caf56bd97485ab3eec10bee6336'
    -- ORDER BY BLOCK_TIMESTAMP DESC
    -- LIMIT 100
    --BLOCK_NUMBER



    -- SELECT *
    -- FROM arbitrum.core.fact_decoded_event_logs
    Run a query to Download Data