elsinadaily activity
    Updated 2025-01-23
    SELECT
    count(DISTINCT buyer_address) as buyer_count,
    count(DISTINCT tx_id) as tx_count,
    count(distinct project_name) as collection_count,
    sum(amount) as total_vol,
    avg(amount) as avg_tx_vol,
    from
    sei.nft.ez_nft_sales
    where
    block_timestamp::date >= '2025-01-01' and platform_name = 'pallet'

    Last run: 3 months ago
    BUYER_COUNT
    TX_COUNT
    COLLECTION_COUNT
    TOTAL_VOL
    AVG_TX_VOL
    1
    340184219289760.07069343.849570441
    1
    42B
    3s