flipside

    Copy of The Arts District 6
    jackguyCopy of The Arts District 6
    Updated 2022-10-17
    SELECT
    SUM(action_data:deposit / power(10,24)) as volume,
    COUNT(*) as sales
    FROM near.core.fact_actions_events
    --WHERE TXN_HASH LIKE 'YvsLu2f7XWHmRWzAvggdSprLZQbcLfi1PE8MbuYfyXm'
    WHERE tx_hash in (
    SELECT
    DISTINCT tx_hash
    FROM near.core.fact_actions_events_function_call
    --WHERE TXN_HASH LIKE 'YvsLu2f7XWHmRWzAvggdSprLZQbcLfi1PE8MbuYfyXm'
    WHERE args LIKE '%nft_contract_id":"asac.near%'
    )
    AND action_data:method_name LIKE 'buy'
    and block_timestamp > '2022-01-01'

    Run a query to Download Data