jon_pendleupset-brown
    Updated 2024-10-17
    select user, market, weight, tx_hash, block_timestamp
    from
    (
    select block_number, block_timestamp, tx_hash, event_index,
    origin_to_address as user,
    decoded_log['_epoch'] as epoch,
    decoded_log['_user'] as user2,
    decoded_log['_pid'] as pid,
    decoded_log['_market'] as market,
    decoded_log['_weight'] as weight
    from arbitrum.core.ez_decoded_event_logs
    where contract_address = '0x2a21a084bab4e13169b7d4f7f50474aa96c94acd' and event_name = 'Voted' and origin_to_address = '0xb2a40e133c20287dc4ff74a840028ca32e7b3243'
    )
    where market = lower('0x58f50de493b6be3585558f95f208de489c296e24')
    order by block_timestamp
    QueryRunArchived: QueryRun has been archived