SELECT DISTINCT contract_address as token_address

from ethereum.erc20_balances P

where balance_date = '2022-04-17'

and has_price = 'TRUE'

SELECT block_timestamp::date as daily , platform , sum(D.AMOUNT_USD)

from ethereum.dex_swaps D

left outer join price P on P.token_address = D.token_address

where daily >'2022-04-10'

and platform <>'curve'

and D.AMOUNT_USD is not NULL

and D.AMOUNT_USD <10000000

group by 1 , 2