flipside

    R2
    zyroqR2
    Updated 2025-05-22
    SELECT
    event_data:"owner_address" AS claimer,
    (event_data:"rewards"::FLOAT / 1e8) AS amt_claimed,
    TO_TIMESTAMP(event_data:"timestamp"::BIGINT) AS claim_date
    FROM aptos.core.fact_events
    WHERE payload_function = '0x9f1ffdea234d96c84cf49e80c97f6ebbba06ef6e7ec1f8abd66f47eeeea535ca::draconian::claim_nfts'
    AND event_module = 'draconian'
    AND event_resource = 'ClaimEvent'
    and amt_claimed != 0
    ORDER BY amt_claimed ;

    Last run: 11 days ago
    CLAIMER
    AMT_CLAIMED
    CLAIM_DATE
    1
    0x941407657ec80f52c88c1069612e0150bd97164a9abea518752abe65525be7e4
    		15002025-03-26 10:16:46.000
    2
    0xe688cbb3facaace2eb64266b4686c2b97d87ba06c8bbdb32a367db0c9ba749e1
    		15002025-04-25 12:18:59.000
    3
    0x5b825830cb255e101a5468a170b3f2352f63ce6fd8de466194ba191ebe614cf8
    		15002025-03-28 03:43:51.000
    4
    0xde3d536369febf61766a7e2f9b45c161a16ed7c710d790560243ab2d40d59813
    		15002025-03-27 06:38:30.000
    5
    0x428cc6fb89a56dd651fbe6c1df349c0e85d60651b774f5e7592db2a4c2a2edc4
    		15002025-03-26 17:53:12.000
    6
    0xc2c96970d0ea248f6a0a8e2c81f5b9e6130c8cce5ce22b751d038ff88b781b83
    		15002025-03-26 10:15:36.000
    7
    0x18b2e4c83e9250c52f4606113ee2ecd47fbbf080855a210f34416474ede5c9fc
    		15002025-03-26 15:21:34.000
    8
    0x28ceb916c9f0b93549f136c093155f24e8fe6694480ef98074476ca505e25f1a
    		15002025-03-26 10:15:26.000
    9
    0x94a0802a41af9e53362cc4c78de72944c91c73d350d90c17dc6c473a6f4c8c27
    		15002025-05-08 17:01:27.000
    10
    0xd559ebee1473ca698b1c7bdfb79e71e9f01cb758ce6473e92d92cfa73b5ad618
    		15002025-03-27 16:31:26.000
    11
    0x2bee8b078f7bfd368b0680e116195f08eb5f6975ac27d1c3ff5d2389bac49f22
    		15002025-04-02 13:45:01.000
    12
    0x66e0af71eca57208fb36f8079112e8f9c54ac5b5b73de786bad52beb149b5a1a
    		15002025-03-27 10:17:27.000
    13
    0x15ab3667f396b13e3a04b230285b99fa6c84c4004d1c58549f6d0b4d588811d8
    		15002025-03-26 11:40:59.000
    14
    0xd7c448134c957cdac25fe8f361f1a8f546b6934f0aa88ea60faf2b90cf08c4b7
    		15002025-03-26 11:02:25.000
    15
    0x4b3c16fd51e42acc5589e39b46237cbeaed5895f4ad58439d74a0b8df63397b9
    		15002025-03-26 11:28:56.000
    16
    0x93df455ec948840738142123460dfb2f236316e2e06438930dc3b5c5d06fe9f5
    		15002025-03-26 10:16:00.000
    17
    0x63ded5e8ac27108b86847e7f5332416f2434dd835e4fe1458bad2a566ba87a59
    		15002025-03-26 11:21:50.000
    18
    0x5e27a1c57f1a189379d9035524209561547ae1cc394a73754bef3027563c8cc6
    		15002025-03-26 15:06:56.000
    19
    0xa73997f8906d145a6dda238a555d7169ff7db2cc6a646302cab2a052fe09b9e0
    		15002025-03-26 13:10:47.000
    20
    0xb4e64b71e1b7d3c680dccc3026fec00c87d007a0df0c3852bebe6ac8be25609a
    		15002025-03-26 16:23:01.000
    ...
    1550
    154KB
    4s