jonestrinhUntitled Query
Updated 2022-12-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with wallet as (
select
distinct(address) as name
from crosschain.core.address_tags
where tag_name IN ('wallet billionaire', 'wallet millionaire')
and creator = 'flipside'
and blockchain = 'ethereum')
select
date_trunc('day', block_timestamp) as daytime,
sum (amount_out_usd) + sum(amount_in_usd) as activity
from ethereum.core.ez_dex_swaps
where tx_to in (select name from wallet)
and daytime >= current_date - interval '30 day'
and symbol_in in ('USDT', 'USDC', 'DAI', 'BUSD', 'MIM', 'FRAX')
and symbol_out in ('USDT', 'USDC', 'DAI', 'BUSD', 'MIM', 'FRAX')
group by 1
Run a query to Download Data