brb2jmerge6
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH miners AS (
SELECT distinct miner
FROM ethereum.core.fact_blocks
where BLOCK_TIMESTAMP <='2022-09-14'
)
SELECT
BLOCK_TIMESTAMP::date as date,
sum (AMOUNT_IN) as ETH_amounts,
case
when ORIGIN_FROM_ADDRESS IN (SELECT * FROM miners) then 'Miners'
else 'Others'
end as type
from ethereum.core.ez_dex_swaps
where SYMBOL_IN='WETH'
and BLOCK_TIMESTAMP >='2022-06-01'
group by 1,3
Run a query to Download Data