flipside

    Curve Pool Name
    nitsCurve Pool Name
    Updated 2022-05-07
    -- SELECT * from ethereum_core.dim_dex_liquidity_pools
    -- where platform like '%curve%' and tokens[2] is NULL and tokens[1] is not NULL and ((tokens[0] ilike '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'
    -- or tokens[1] ilike '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')
    -- or (tokens[0] ilike '0x6b175474e89094c44da98b954eedeac495271d0f'
    -- or tokens[1] ilike '0x6b175474e89094c44da98b954eedeac495271d0f'))
    -- SELECT pool_name, platform, count(*) FROM ETHEREUM.dex_swaps
    -- where contains(pool_name, 'USDC') and contains(pool_name, 'USDT') and block_timestamp >= '2021-11-14' and platform ilike '%curve%'
    -- GROUP by 1,2

    -- SELECT * from ethereum.dex_liquidity_pools
    -- where platform = 'curve' and tokens[2] is NULL and ((tokens[1]= '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' or tokens[0]= '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')OR (tokens[1]= '0xdac17f958d2ee523a2206206994597c13d831ec7' or tokens[0]= '0xdac17f958d2ee523a2206206994597c13d831ec7'))
    -- limit 100

    -- token_in = '0x6b175474e89094c44da98b954eedeac495271d0f' and token_out ilike '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48' and
    -- platform ilike '%curve%'

    -- 0xba6f08adb52badc392d803e70d48c8071734131e

    -- 0xfc789fc17368c2b66709efe09c0aa76dc2c131d3




    -- Curve: 0xeb16ae0052ed37f479f7fe63849198df1765a733 (DAI-sUSD) (dai-usdc)=0xa2b47e3d5c44877cca798226b7b8118f9bfb7a56


    -- USDC-USDT 100 1 UNI-V3 LP

    with crv as
    (SELECT date(block_timestamp) as day, sum(amount_usd) as total_vol, count(DISTINCT from_address) as unique_senders, count(DISTINCT to_address) as receivers, 'curve' as platform from ethereum.dex_swaps
    WHERE pool_ADDRESS = '0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7' and platform = 'curve' and day >= '2021-11-14'
    GROUP by 1 ),
    uni_usdc_usdt as
    (SELECT date(block_timestamp) as day, sum(amount_usd) as total_vol, count(DISTINCT from_address) as unique_senders, count(DISTINCT to_address) as receivers,'USDC-USDT uniswap' as platform from ethereum.dex_swaps
    WHERE pool_name = 'USDC-USDT 100 1 UNI-V3 LP' and platform ilike '%uniswap%' and day >= '2021-11-14'
    GROUP by 1 ),
    Run a query to Download Data