lannguyen54025My Algorand YLDLY Staking in Context
    Updated 2023-01-03
    select
    date_trunc('hours', block_timestamp) as hours,
    case when sender = 'V3WKMY7WTOUYXGB5PAPICM5FOEQVZ4C62ZZC6U3WO2EPRIJFSTHS3TNV2A' then 'me' else 'others' end as transaction_sender,
    count(*) as transaction_count
    from algorand.asset_transfer_transaction
    where asset_receiver = 'FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY'
    and tx_type = 'axfer'
    and block_timestamp::date = '2022-01-24'
    group by hours, transaction_sender
    Run a query to Download Data