strawbetty daily volume of USDC that is sent between wallets on each blockchain
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with eth_usdc as (
select
block_timestamp::date as date,
sum(amount) as total_volumes
from
ethereum.udm_events
where
YEAR(block_timestamp) = 2022
and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
and origin_function_name = 'transfer'
and event_name = 'transfer'
and event_type = 'erc20_transfer'
group by 1)
, data_algorand as (
select
block_timestamp::date as date,
sum(asset_amount/pow(10, 6)) as total_volumes
from algorand.asset_transfer_transaction
where YEAR(block_timestamp) = 2022
and asset_id = 31566704
group by 1
)
, data_solana as (
select
block_timestamp::date as date,
sum(amount) as total_volumes
from solana.fact_transfers
where
YEAR(block_timestamp) = 2022
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
group by 1
)
select 'Ethereum' as labeling, * from eth_usdc
union all
select 'Algorand' as labeling, * from data_algorand
union all
Run a query to Download Data