rustygeeaark-MarketData
Updated 2023-10-30
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
›
⌄
-- forked from more-experiments @ https://flipsidecrypto.xyz/edit/queries/19a8e580-d60b-4a88-9422-2fa94853b7c2
SELECT *
FROM arbitrum.core.fact_event_logs
WHERE CONTRACT_ADDRESS = '0xF45f2903438d383769CA3E80356c167e9D9aF1AD'
AND TOPICS[0] = '0xbd68bd00f6c811ab0e1b60300c14b5b4a98992e250c7e02032e6f6d40070790d'
--AND TOPICS[1] = '0x00196834ad19e18bcab573766c501e3a5cf9a022e5fc21614e0dc7655b7e9c8f'
ORDER BY BLOCK_TIMESTAMP DESC
LIMIT 100
-- WITH topic_match_tx AS(
-- SELECT *
-- FROM arbitrum.core.fact_event_logs
-- WHERE CONTRACT_ADDRESS = '0xF45f2903438d383769CA3E80356c167e9D9aF1AD'
-- AND TOPICS[0] = '0xbd68bd00f6c811ab0e1b60300c14b5b4a98992e250c7e02032e6f6d40070790d'
-- --AND TOPICS[1] = '0x00196834ad19e18bcab573766c501e3a5cf9a022e5fc21614e0dc7655b7e9c8f'
-- ORDER BY BLOCK_TIMESTAMP DESC
-- LIMIT 100
-- )
-- SELECT *
-- FROM topic_match_tx
-- SELECT BLOCK_NUMBER, BLOCK_TIMESTAMP, DECODED_LOG-- ,DECODED_LOG:eventData[0][0][0][1] as market
-- FROM arbitrum.core.fact_decoded_event_logs
-- WHERE TX_HASH IN (SELECT TX_HASH FROM topic_match_tx)
-- AND DECODED_LOG:eventData[0][0][0][1] = '0x70d95587d40a2caf56bd97485ab3eec10bee6336'
-- ORDER BY BLOCK_TIMESTAMP DESC
-- LIMIT 100
--BLOCK_NUMBER
-- SELECT *
-- FROM arbitrum.core.fact_decoded_event_logs
Run a query to Download Data