KaskoazulAlgo transaction payments >0 Size CTE
    Updated 2022-03-27
    with U10 as (
    select block_timestamp::date as fecha,
    '0-10 ALGO' as payment_size,
    count(tx_id) as number_payments,
    sum(amount) as total_value_transacted
    from algorand.payment_transaction
    where fecha >= '2022-01-01'
    and amount > 0 and amount <= 10
    group by 1, 2
    ),

    U100 as (
    select block_timestamp::date as fecha,
    '10-100 ALGO' as payment_size,
    count(tx_id) as number_payments,
    sum(amount) as total_value_transacted
    from algorand.payment_transaction
    where fecha >= '2022-01-01'
    and amount > 10 and amount <= 100
    group by 1, 2
    ),

    U1k as (
    select block_timestamp::date as fecha,
    '100-1k ALGO' as payment_size,
    count(tx_id) as number_payments,
    sum(amount) as total_value_transacted
    from algorand.payment_transaction
    where fecha >= '2022-01-01'
    and amount > 100 and amount <= 1000
    group by 1, 2
    ),

    U10k as (
    select block_timestamp::date as fecha,
    '1k-10k ALGO' as payment_size,
    Run a query to Download Data