datavortexpurchases
    Updated 2025-02-28
    SELECT
    COUNT(DISTINCT tx_hash) AS "total purchases",
    COUNT(DISTINCT from_address) AS "purchasers",
    SUM(VALUE) AS "total Wklay",
    SUM(tx_fee) AS "total Purchase Fees(kaia)"
    FROM
    kaia.core.fact_transactions
    WHERE
    to_address = '0x703e56244b73427fe1fea3374e296606ca64096b'
    AND block_timestamp >= '2025-01-28'
    Last run: 2 months ago
    total purchases
    purchasers
    total Wklay
    total Purchase Fees(kaia)
    1
    68664359293510140723.5296242341.844886537
    1
    48B
    8s