MLDZMNUSDA2
Updated 2023-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from mod2 @ https://flipsidecrypto.xyz/edit/queries/fdd5312f-723d-43ce-9887-e1f771aff386
SELECT
date_trunc('{{Granularity}}',BLOCK_TIMESTAMP) as date,
count(distinct tx_hash) as "Transfers",
count(distinct ACCOUNT_ADDRESS) as "Senders",
sum(AMOUNT/1e6) as volume,
avg(AMOUNT/1e6) as "Average volume",
median(AMOUNT/1e6) as median_sent,
sum(volume) over (order by date) as "Cumulative volume"
from aptos.core.fact_transfers
where TOKEN_ADDRESS = '0x1000000fa32d122c18a6a31c009ce5e71674f22d06a581bb0a15575e6addadcc::usda::USDA'
group by 1
order by 1 desc
Run a query to Download Data