flipside

    Total APT distributed DOD (ak)
    GetstanTotal APT distributed DOD (ak)
    Updated 24 minutes ago
    ---2.Total APT distributed DOD
    select
    ACCOUNT_ADDRESS,
    date(BLOCK_TIMESTAMP) as Date,
    -- month(BLOCK_TIMESTAMP) as Month,
    count( distinct VERSION) as count,
    sum(EVENT_DATA:amount)/100000000 AS APT
    from aptos.core.fact_events
    where ACCOUNT_ADDRESS in
    ('0xa36a6931005aa20a57fa58000c648d3b0b53b0a354354d7f81515f47cd9a7a81',
    '0xc94e16736910cc160347d01de345407fe2d350fce5635ac1150319b0fbf5630e',
    '0xd667a331f8ddb2f02200c8ec8396c57cb2ec9b7f66b8d228d58d4ddef1ec04e0',
    '0x1291608dbd5c59a3b7719e48f78af89eda28aa9b15ffdcb6e1421900b64eaf89',
    '0x5040fa223f564e4ec24c3750186beab697f542e56edbd6fc234fdfc23ea8067c',
    '0xb5e1cc180e603037887c9e9eb4a8a06774ebcddafac37ceea9e33f3b6552bb25',
    '0x24e31431ca604bd24c5cc8424d3a895b15a910d5ece00fe98fe6d7c6a026f60a',
    '0x6de4fb960cb70ce522da0a39e51e93d9399f767eb6e173993e99572b972c39a3',
    '0xad4aa57fd878819a0248c11875df84f781335a4dd437ff21bf132ae5f8e14662',
    '0x811c12a7ed028a9969b71f86689bcf42ca50144f3b6008bd8cdb550c0e2fffe6',
    '0xe6a9ec8e5c0ef2e5670ab3e7fd86c5af7098a9a9893cc254e893ee3c87f99a61',
    '0x23e89c5073173b21cc30e6949b34608f0ff8b90c6ea7fa1b58831c8d89ce54d8',
    '0xef82b1d818007db4f3c45874706374553a34ae84181396bac8950023af7dea4e',
    '0xd2d637ef890f8472a0b6798098a35f10e19a95fff0a46b4bdc360cd70d80dc10',
    '0xcd9eb9ba34a6e28826aa6c434dbca38d6f9bdaa109cd359a396e8a77539c31eb',
    '0x6e2f14bca17268ff0fedc4e7aa3e34274f21dc75d0c567368e4d704476a6d97b',
    '0x45c798416c158c1fd93fed2e40fbc2cd9f27bd640e6a6ed7ce58c9e4f413695b',
    '0xbe54ed8012d6b7701a88a4d156032b8222d65d447b47ce22657e44b06a3ea7dc',
    '0x172ce5c92cd7b757735ed163cd657c820aa4e028bb43270975759c0038f1f8d6',
    '0x562c0f6141a4665821231b84c489fb55700c802b5fbf7751bc3f4b2fa671b61f',
    '0xfb2d24725eb38ccee2143a62e219659673120f5109906a44dc1c1ca401a9537e',
    '0xacf3215271a81e17aeeca6014268fc4ab0576769b5e04958495baeddf63c283f',
    '0x6a36699aaf6e53fce3891721c7fd62fd5d7979baa93951fbdce00b7e6bad7e90',
    '0x6a1dbd5888f083a5cb2cb0e62dc91106231451b3db54c33855d652bc3e7c4e94',
    '0x4c7db6eba3369afe8162a671e1a2bd212259ded1a57af2922b0fd35d3398f6da',
    '0xc62418ebb59517960c79cc0c4b1d7c8d8d7c13291246f071537715df3fac5734',
    '0x0bc382ab5b45e48f9c8f86114f21526ef7a8afbb82575b1ad738eec8290593b2',
    Last run: 24 minutes ago
    ACCOUNT_ADDRESS
    DATE
    COUNT
    APT
    1
    		0xe6a9ec8e5c0ef2e5670ab3e7fd86c5af7098a9a9893cc254e893ee3c87f99a612025-04-27 00:00:00.00020091.4978
    2
    		0x172ce5c92cd7b757735ed163cd657c820aa4e028bb43270975759c0038f1f8d62025-04-27 00:00:00.00020211.5149
    3
    		0xd2d637ef890f8472a0b6798098a35f10e19a95fff0a46b4bdc360cd70d80dc102025-04-27 00:00:00.00020161.5154
    4
    		0x23e89c5073173b21cc30e6949b34608f0ff8b90c6ea7fa1b58831c8d89ce54d82025-04-27 00:00:00.00020111.5139
    5
    		0xfb2d24725eb38ccee2143a62e219659673120f5109906a44dc1c1ca401a9537e2025-04-27 00:00:00.00020201.517
    6
    		0x776148780e5acf9b3c6b21039744c54526461095cd05fe50420928a7ac388eba2025-04-27 00:00:00.00019371.4484
    7
    		0x1291608dbd5c59a3b7719e48f78af89eda28aa9b15ffdcb6e1421900b64eaf892025-04-27 00:00:00.00019911.49
    8
    		0x6de4fb960cb70ce522da0a39e51e93d9399f767eb6e173993e99572b972c39a32025-04-27 00:00:00.00020061.506
    9
    		0x4c7db6eba3369afe8162a671e1a2bd212259ded1a57af2922b0fd35d3398f6da2025-04-27 00:00:00.00019581.464
    10
    		0xb5e1cc180e603037887c9e9eb4a8a06774ebcddafac37ceea9e33f3b6552bb252025-04-27 00:00:00.00019951.4949
    11
    		0xb0bf3059befbed1213d223d77f41adcea45f79b4bbfe4e81fc0dce69220baa332025-04-27 00:00:00.00020111.5139
    12
    		0xc62418ebb59517960c79cc0c4b1d7c8d8d7c13291246f071537715df3fac57342025-04-27 00:00:00.00019481.4605
    13
    		0x6e2f14bca17268ff0fedc4e7aa3e34274f21dc75d0c567368e4d704476a6d97b2025-04-27 00:00:00.00019711.4863
    14
    		0x811c12a7ed028a9969b71f86689bcf42ca50144f3b6008bd8cdb550c0e2fffe62025-04-27 00:00:00.00020051.5088
    15
    		0x10254fffda02ed4d8dd7b4e208c4b5d5f85d22779b3f450be36225f83fcb84662025-04-27 00:00:00.00019601.4697
    16
    		0x63fca31adda7f904d8d93a4392c520aa8f13f3639f8d46f79cdd4a09b234e1fc2025-04-27 00:00:00.00020031.5033
    17
    		0xcd9eb9ba34a6e28826aa6c434dbca38d6f9bdaa109cd359a396e8a77539c31eb2025-04-27 00:00:00.00019571.4729
    18
    		0xc94e16736910cc160347d01de345407fe2d350fce5635ac1150319b0fbf5630e2025-04-27 00:00:00.00019731.4744
    19
    		0x5405b7158bcf0275009bea394e8a3c1fd394454555a44582bda9fbab2c98e0692025-04-27 00:00:00.00020091.5026
    20
    		0xad4aa57fd878819a0248c11875df84f781335a4dd437ff21bf132ae5f8e146622025-04-27 00:00:00.00020061.5027
    ...
    417
    44KB
    12s