Untitled Query

betadiggerUntitled Query

Updated 2022-07-01

-- SELECT * FROM ethereum.core.fact_event_logs

-- WHERE block_timestamp >= CURRENT_DATE - 6

-- AND contract_address = lower ('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')

-- AND event_name IN ('Swap')

-- SELECT pool_name, pool_address, token0, token1 FROM ethereum.core.dim_dex_liquidity_pools

-- WHERE pool_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')

-- WITH pools AS (

-- SELECT

-- pool_name,

-- pool_address,

-- token0,

-- token1

-- FROM

-- ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS

-- WHERE

-- pool_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')

-- )

-- SELECT

-- address,

-- symbol,

-- decimals

-- FROM

-- ETHEREUM_CORE.DIM_CONTRACTS

-- WHERE

-- address = (

-- SELECT

-- LOWER(token1)

-- FROM

-- pools

-- )

-- OR address = (

-- SELECT

-- LOWER(token0)

Run a query to Download Data

flipside