JimMyersTechLQ: Seaport Real-time Orders
    WITH realtime_events AS (
    SELECT
    block_number,
    tx_hash,
    event_index,
    event_name,
    decoded_data
    FROM TABLE(
    ethereum_mainnet.latest_contract_events_decoded('0x00000000000000ADc04C56Bf30aC9d3c0aAF14dC')
    )
    )
    SELECT
    block_number,
    tx_hash,
    event_index,
    event_name,
    decoded_data:offerer::varchar as offerer_address,
    decoded_data:orderHash::varchar as order_hash,
    value as offer
    FROM realtime_events, LATERAL FLATTEN (input => decoded_data:offer)
    ORDER BY block_number DESC, event_index DESC
    Run a query to Download Data