Sajjadiiimr esi69
Updated 2022-06-24Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with holder as (
select DISTINCT ORIGIN_FROM_ADDRESS as holders
from ethereum.core.ez_dex_swaps
where ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c'
)
select avg(balance)
from holder a
inner join flipside_prod_db.ethereum.erc20_balances b
on a.holders = b.USER_ADDRESS
where symbol = 'ETH'
and CONTRACT_ADDRESS = 'ETH'
and BALANCE_DATE::date = '2022-06-22'
Run a query to Download Data