ArioUntitled Query
Updated 2022-08-21
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
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
/*select
'[
{
"id": "0x3836363061383264353938623966316461323935653534663365653339313663",
"timestamp": "1657106566",
"address": "0xd67c96fa2d3070085c5ee32104773ccc2dbd21ac",
"maturityDate": "1656982800",
"tags": [
"9010"
],
"isOpen": false,
"isResolved": true,
"isCanceled": false,
"finalResult": "3",
"poolSize": "0",
"numberOfParticipants": "0",
"homeTeam": "FC Dallas FC",
"awayTeam": "Inter Miami CF Inter Miami CF",
"homeOdds": "621368994443010509",
"awayOdds": "155024392841257961",
"drawOdds": "223606612715731529",
"homeScore": null,
"awayScore": null
}' as data */
--hex_decode_string(TOPICS[0])
--0xaba5c0e34b9b54828db4e0ac6b951ca282a0b171289eebf93353c296f9e82613
--select base64_decode_string('0xaba5c0e34b9b54828db4e0ac6b951ca282a0b171289eebf93353c296f9e82613')
/*from optimism.core.fact_event_logs
WHERE contract_address = '0x2b91c14ce9aa828ed124d12541452a017d8a2148' limit 1 */
/*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
Run a query to Download Data