vendettaETH OA 5 copy
Updated 2023-02-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from 4a887e8b-5aca-406c-81bb-4be071093d2b
select
date_trunc('week', block_timestamp) as "date",
symbol,
avg(token_price)
from ethereum.aave.ez_flashloans
where FLASHLOAN_AMOUNT_USD < 1e9
and PREMIUM_AMOUNT_USD < 1e9
and symbol in ('USDC', 'WETH', 'DAI', 'WBTC', 'USDT' )
group by 1, 2
Run a query to Download Data