Luqmaninitial
Updated 2022-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- select * from optimism.core.fact_event_logs
-- WHERE contract_address = '0x2b91c14ce9aa828ed124d12541452a017d8a2148'
-- order by BLOCK_TIMESTAMP desc
SELECT
concat('0x',substr(data,27,40)) as game_contract
, HEX_DECODE_STRING( substr(data,3+13*64,64) ) as home_team
, HEX_DECODE_STRING( substr(data,3+15*64,64) ) as away_team
, *
from
optimism.core.fact_event_logs
where
tx_hash = '0x83fa82d6be618963d5ed0c8dc266d459383c77643019f2661191964d02238f91'
and topics[0] = lower('0x7A5c149DD29233C6eA8300a6b00029c279a63B7c')
and contract_address = '0x2b91c14ce9aa828ed124d12541452a017d8a2148'
Run a query to Download Data