Metiocreaverage USDC transfer size [Eth, Solana, Algo]
Updated 2022-04-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with solana as (
SELECT avg(amount) as average
from solana.fact_transfers
where date(block_timestamp) >= '2022-01-01'
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
),
algo as (
SELECT avg(asset_amount)/10e6 as average
from algorand.asset_transfer_transaction
where date(block_timestamp) >= '2022-01-01'
and asset_id = '31566704'
),
eth as (
select avg(udm.amount) as average
from ethereum.transactions as transactions , ethereum.udm_events as udm
where DATE(transactions.BLOCK_TIMESTAMP) >= '2022-01-01'
and transactions.FUNCTION_NAME = 'transfer'
and transactions.symbol = 'USDC'
and transactions.tx_id = udm.tx_id
)
SELECT eth.average as Eth , algo.average as Algo, solana.average as Solana
from solana , algo , eth
Run a query to Download Data