mehrancrypto-dxoepqUntitled Query
Updated 2022-11-08
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with tab_lable as
(
SELECT ADDRESS
from ethereum.core.dim_labels
where (ADDRESS_NAME ilike '%Alameda%' or label ilike '%Alameda%')
)
SELECT block_timestamp::date as daily , symbol , sum(amount_usd) as in_volume
FROM ethereum.core.ez_token_transfers A , tab_lable B
WHERE to_address = B.ADDRESS
AND symbol in ('USDT', 'USDC', 'DAI', 'TUSD', 'BUSD')
AND block_timestamp > CURRENT_DATE - 60
GROUP by 1 , 2
Run a query to Download Data