mr_sami7-pmCkDGاستیک وای ال دی وای من در تاریخ2022/01/28 ساعت17:07
    Updated 2022-04-15

    select
    date_trunc('hour',ab.block_timestamp) as block_hour,
    case
    when apt.sender = 'BIVF642JIVUHICPX3DZ3M6NSEXDIGCU5VDAMJLYAXW6YQ5MZMB65EHUIUY' then 'me'
    else 'others' end as transaction_sender,
    count(*) as transaction_count
    from algorand.asset_transfer_transaction apt
    left join algorand.block ab
    on ab.block_id = apt.block_id
    where apt.asset_receiver = 'FMBXOFAQCSAD4UWU4Q7IX5AV4FRV6AKURJQYGXLW3CTPTQ7XBX6MALMSPY'
    and apt.block_timestamp::date = '2022-01-28'
    group by block_hour, transaction_sender

    Run a query to Download Data