rajsSell Order
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
SELECT
tx_hash,
block_timestamp,
-- origin_function_signature,
substr(input_data,1,2) || substr(input_data,35,40) as seller_address,
substr(input_data,1,2) || substr(input_data,675,40) as buyer_address,
substr(input_data,1,2) || substr(input_data,99,40) as nft_address,
tokenflow_eth.hextoint(substr(input_data,331,64)) / pow(10,18) as price,
substr(input_data,1,2) || substr(input_data,547,40) as currency_address,
case when currency_address = '0x4200000000000000000000000000000000000042' then 'OP' else 'WETH' end as currency_symbol
-- tokenflow_eth.hextoint(substr(input_data,395,64)) as quantity
from optimism.core.fact_transactions
where tx_hash IN
(
SELECT
tx_hash
from optimism.core.fact_event_logs
where origin_to_address IN
(
'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70',
'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',
'0x20975da6eb930d592b9d78f451a9156db5e4c77b'
)
and topics[0] = '0x70ba0d31158674eea8365d0f7b9ac70e552cc28b8bb848664e4feb939c6578f8'
)
-- and tx_hash = '0x2dc44572537f9d6dd1d5257946f80743ffa7b4915d556aaf1ce148e7681ecccd'
Run a query to Download Data