Sandeshalgorand usdc metrics without price
Updated 2022-11-23
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 algo_usdc as
(
select
block_id,
date_trunc('{{granularity}}',block_timestamp) as time,
tx_id as tx_hash,
asset_sender as sender,
receiver,
asset_name as currency,
amount as usd_amount,
case
when usd_amount < 1 and usd_amount > 0 then 'shrimp (0-1)'
when usd_amount < 10 and usd_amount >= 1 then 'crab (1-10)'
when usd_amount < 50 and usd_amount >= 10 then 'Octpus (10-50)'
when usd_amount < 100 and usd_amount >= 50 then 'Fish (50-100)'
when usd_amount < 500 and usd_amount >= 100 then 'Dolphins (100-500)'
when usd_amount < 1000 and usd_amount >= 500 then ' Shark (500-1000)'
when usd_amount < 5000 and usd_amount >= 1000 then ' Whale (1000-5000)'
when usd_amount >= 5000 then 'Humpback whale (5000+)'
else 'holder'
end as tx_type
from algorand.core.ez_transfer
where 1=1
and asset_id='31566704'
and time between '{{start_date}}' and '{{end_date}}'
),
daily as
(
select
date_trunc('{{granularity}}',time) as time,
count(distinct tx_hash) as number_of_transfers,
sum(number_of_transfers) over (order by time asc) as cum_number_of_transfers,
sum(usd_amount) as daily_amount,
sum(daily_amount) over(order by time asc) as cum_daily_amount,
count(distinct sender) as number_of_senders,
sum(number_of_senders) over(order by time asc) as cum_senders,
Run a query to Download Data