rustygeeevent_logs?
Updated 2024-08-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT BLOCK_TIMESTAMP, TX_HASH, DECODED_LOG
FROM polygon.core.fact_decoded_event_logs
WHERE CONTRACT_ADDRESS = lower('0xC5d563A36AE78145C45a50134d48A1215220f80a')
AND EVENT_NAME = 'OrdersMatched'
-- AND BLOCK_NUMBER = 59833145
AND (CAST(DECODED_LOG:takerAssetId AS FLOAT) = 7.729000442046981e+76 OR CAST(DECODED_LOG:makerAssetId AS FLOAT) = 7.729000442046981e+76 )
--josS vp 4.631113243624706e+76
--timW vp 7.729000442046981e+76
--marK vp 5.769315986894845e+76
--andB vp 8.071242075838392e+76
--kamH pres 6.923692362007769e+76
--joeB pres 8.802783960924362e+76
--kamH vp 8.211995823708176e+76
QueryRunArchived: QueryRun has been archived