KowalskiDeFiOvertime markets
Updated 2023-04-19
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- CreateSportsMarket(address,bytes32,(bytes32,uint256,int24,int24,int24,string,string),uint256[],uint256[])
SELECT
concat('0x',RIGHT(substr(data, 0,66),40)) as address1,
-- ethereum.public.udf_hex_to_int(substr(data,0,66)),
*
FROM optimism.core.fact_event_logs
WHERE block_timestamp::date >= CURRENT_DATE
AND topics[0] ='0x889e2060e46779287c2fcbf489c195ef20f5b44a74e3dcb58d491ae073c1370f'
ORDER BY block_timestamp DESC
LIMIT 1
Run a query to Download Data