SELECT symbol , token_address , avg(price)

from ethereum.token_prices_hourly

where hour::date = '2022-04-17'

group by 1 , 2

)

SELECT symbol , sum(D.AMOUNT_USD)

from ethereum.dex_swaps D

left outer join name L on L.token_address = D.token_address

where block_timestamp::date > '2022-02-24'

and platform <>'curve'

and D.AMOUNT_USD is not null

and direction = 'IN'

and pool_name not like '%BurnX-WETH LP%'

and pool_name not like '%MGH-WETH 3000 60 UNI-V3 LP%'

and pool_name not like '%QOM-WETH LP%'

and pool_name not like '%BUILD-WETH LP%'

and pool_name not like '%WETH-BEAN UNI-V2 LP%'

and pool_name not like '%CAT-WETH LP%'

and pool_name not like '%WETH-BEAN UNI-V2 LP%'

and pool_name not like '%CAT-WETH LP%'

and pool_name not like '%LAMBO-WETH LP%'

and pool_name not like '%SHINTAMA-WETH LP%'

and pool_name not like '%Para-WETH LP%'

and pool_name not like '%SHIBURN-WETH LP%'

and pool_name not like '%VOLT-WETH LP%'

and pool_name not like '%COLLAR-WETH LP%'

and pool_name not like '%$WEAPON-WETH LP%'

and pool_name not like '%ABC-WETH LP%'

and pool_name not like '%EVDC-WETH LP%'

and pool_name not like '%UTD-USDC 10000 200 UNI-V3 LP%'

and pool_name not like '%WETH-ETHM 10000 200 UNI-V3 LP%'

and pool_name not like '%FEI-USDC 100 1 UNI-V3 LP%'

and pool_name not like '%DEPO-WETH LP%'

and pool_name not like '%GVT-WETH LP%'