normie-Yld1pllively-coral
Updated 2024-09-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select distinct tx_hash, origin_from_address, block_number
from
arbitrum.core.ez_decoded_event_logs
where tx_status = 'SUCCESS'
-- and type = 'CALL'
and event_name = 'CreatedOrder'
and contract_address = '0xef4fb24ad0916217251f553c0596f8edc630eb66'
--and block_timestamp >= '2024-01-01'
--and block_timestamp < '2024-07-01'
and block_number >= 236728735
--and tx_hash = '0x9fca8cccf2939c28006dbcb8aeb5ff195751596f4f5e854ccb4ae8a5ccb3662e'
order by block_number asc
limit 110000