flipside

    2023-05-29 07:03 PM
    freemartian2023-05-29 07:03 PM
    Updated 2023-05-29
    -- select * from optimism.core.fact_event_logs
    -- where tx_hash = '0xc2371114b29293856c05d0ee544d24ac1d64e2a51739390c33e9e0fd15e719f1'

    -- select
    -- sum(event_inputs:_balance)/pow(10,18) as Total_PIKA_Claimed,
    -- count(distinct origin_from_address) as Total_Users_Claimed
    -- from optimism.core.fact_event_logs
    -- where event_name = 'Claimed'
    -- and topics[0] = '0xd8138f8a3f377c5259ca548e70e4c2de94f129f5a11036a15b69513cba2b426a'--tx_hash = '0xc2371114b29293856c05d0ee544d24ac1d64e2a51739390c33e9e0fd15e719f1'
    -- and origin_function_signature = '0x3d13f874'

    SELECT * from optimism.core.ez_eth_transfers
    WHERE tx_hash = '0x1f0222e7ee88acdf657a379e94c6a211b8516b28ce59d1e29dcd945772b471f4'


    Run a query to Download Data