JimMyersTechLQ: Seaport Real-time Orders
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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