talebimorteza_72Untitled Query
Updated 2022-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
--select *from ethereum.core.fact_event_logs
--where block_timestamp >= CURRENT_DATE -20
-- and event_name='swap'
-- and CONTRACT_ADDRESS=lower('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0') ;
SELECT
*
FROM
ETHEREUM.CORE.FACT_EVENT_LOGS
WHERE
block_timestamp >= CURRENT_DATE - 6
AND contract_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')
-- this is the USDC-WETH SushiSwap Pool Address
AND event_name= 'Swap'
Run a query to Download Data