dannyamahSpot Trading Volume By Assets
    Updated 2024-08-08
    -- forked from Spot Trading Volume By Assets @ https://flipsidecrypto.xyz/studio/queries/3acfb2db-0ef0-40d0-af6a-62c0c1903b00

    SELECT
    date_trunc(week, block_timestamp) AS date,
    symbol,
    sum(amount_usd) AS "Trading Volume"
    FROM arbitrum.vertex.ez_spot_trades
    WHERE is_taker = TRUE
    GROUP BY 1,2


    QueryRunArchived: QueryRun has been archived