GetstanTotal APT Received
    Updated 2024-04-24
    select
    date(BLOCK_TIMESTAMP) as Date
    ,count(VERSION) as count,
    sum(EVENT_DATA:amount)/100000000
    from aptos.core.fact_events
    where ACCOUNT_ADDRESS ='0x34ca84470e8d2907562f9a2f144c6c780282953b8b025ba220b0ecc5fc0aead9'
    and EVENT_TYPE = '0x1::coin::DepositEvent'
    and EVENT_DATA:amount = '6000'
    group by 1


    QueryRunArchived: QueryRun has been archived