Sandeshalgorand usdc metrics without price
    Updated 2022-11-23
    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