davidpee0718-ITr-tHGetting Started
    Updated 2024-10-19
    WITH volume_data AS (
    SELECT
    DATE,
    SUM(VOLUME) AS daily_volume
    FROM external.defillama.fact_dex_volume
    WHERE Chain = 'flow'
    AND DATE >= '2024-01-01'
    GROUP BY DATE
    ),
    total_volume AS (
    SELECT
    SUM(daily_volume) AS total_volume_2024
    FROM volume_data
    ),
    volume_last_20_days AS (
    SELECT
    SUM(daily_volume) AS volume_last_20
    FROM volume_data
    WHERE DATE >= CURRENT_DATE - INTERVAL '20 days'
    ),
    volume_change AS (
    SELECT
    (vl.volume_last_20 - (tv.total_volume_2024 - vl.volume_last_20)) AS change_in_volume
    FROM total_volume tv, volume_last_20_days vl
    ),
    percentage_change_volume AS (
    SELECT
    (vc.change_in_volume / NULLIF((tv.total_volume_2024 - vl.volume_last_20), 0)) * 100 AS percent_change
    FROM volume_change vc, total_volume tv, volume_last_20_days vl
    )

    SELECT
    tv.total_volume_2024 AS "Total Volume for 2024",
    vl.volume_last_20 AS "Volume in Last 20 Days",
    vc.change_in_volume AS "Change in Volume in Last 20 Days",
    pcv.percent_change AS "% Change in Volume in Last 20 Days"
    QueryRunArchived: QueryRun has been archived