PapasotUntitled Query
    Updated 2022-01-12
    with zam as (
    select
    block_timestamp,
    block_id
    from algorand.block
    group by 1,2),
    tran as (
    SELECT
    count(tx_id) as transactions,
    block_id
    FROM algorand.transactions
    where asset_id='2513338'
    group by 2)

    select
    date_trunc('day',block_timestamp) as day,
    count(transactions) as transaction_count
    from(
    select
    block_timestamp,
    transactions
    from zam
    inner join tran on zam.block_id=tran.block_id
    group by 1,2)
    group by day
    order by day asc
    limit 10
    Run a query to Download Data