flipside

    $GHST Count on Base
    feyikemi$GHST Count on Base
    Updated 2024-09-20
    SELECT
    --DATE_TRUNC('day', block_timestamp) AS date,
    SUM(amount_USD) AS total_volume
    , COUNT(DISTINCT Tx_hash) AS Transaction_Count
    , COUNT(DISTINCT From_address) AS Active_Addresses
    FROM
    base.core.ez_token_transfers
    WHERE 1=1
    AND CONTRACT_ADDRESS = '0xcd2f22236dd9dfe2356d7c543161d4d260fd9bcb' -- $GHST CA on Base'

    QueryRunArchived: QueryRun has been archived