mariyaYet Another Acme Question
Updated 2022-04-22
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 solana as (
SELECT
date(block_timestamp) as date,
count(DISTINCT tx_id) as counter,
ROUND(sum(amount), 1) as volume,
'solana' as chain
from solana.fact_transfers
where mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- usd coin
and date(block_timestamp) >= '2022-01-01'
and amount > 0
GROUP BY date
),
algorand as (
SELECT
date(block_timestamp) as date,
count(DISTINCT tx_group_id) as counter,
ROUND(sum(asset_amount)::float/1e6, 1) as volume,
'algorand' as chain
from algorand.asset_transfer_transaction
where date(block_timestamp) >= '2022-01-01'
and asset_amount > 0
and asset_amount is not NULL
and asset_id = '31566704' -- USDC
GROUP BY date
),
ethereum as (
SELECT
date(block_timestamp) as date,
count(DISTINCT tx_id) as counter,
ROUND(sum(amount), 1) as volume,
'ethereum' as chain
from ethereum.udm_events
where date(block_timestamp) >= '2022-01-01'
and amount > 0
and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC
and event_name = 'transfer'
Run a query to Download Data