jackguyETH Derivatives 2
Updated 2022-09-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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