jackguyETH Derivatives 2
    Updated 2022-09-11
    SELECT
    date_trunc('day', block_timestamp) as day1,
    CASE
    WHEN token_out LIKE lower('0xFe2e637202056d30016725477c5da089Ab0A043A') THEN 'Stakewise ETH'
    WHEN token_out LIKE lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb') THEN 'stkr ETH'
    WHEN token_out LIKE lower('0xae78736Cd615f374D3085123A210448E74Fc6393') THEN 'Rocket pool ETH'
    WHEN token_out LIKE lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') THEN 'Lido ETH' END as token,
    avg(amount_out_usd/ amount_out) as price

    from ethereum.core.ez_dex_swaps
    WHERE token_out in (lower('0xFe2e637202056d30016725477c5da089Ab0A043A'), lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb'), lower('0xae78736Cd615f374D3085123A210448E74Fc6393'), lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'))
    GROUP BY 1,2
    Run a query to Download Data