strawbettystaking actions a day
    Updated 2022-05-03

    with staking_num as (
    select
    t2.tx_message:txn:aamt/1e6 as vol,
    t2.*
    from
    algorand.transactions t1
    join algorand.transactions t2 on t1.tx_group_id = t2.tx_group_id
    and t2.asset_id = '571576867'
    and t2.block_timestamp >= '2022-03-01'
    where TRY_BASE64_DECODE_STRING(t1.tx_message :txn :apaa [0] :: STRING) = 'S'
    and t1.tx_message:txn:apid = '710543830'
    and t1.block_timestamp >= '2022-03-01'
    )
    select
    block_timestamp::date as date,
    count(distinct tx_group_id) as transact,
    sum(vol) as staked_volume
    from staking_num
    group by date
    Run a query to Download Data