winnie-fsSpecific Avalanche Project's Volume Over Time
    Updated 2024-06-28
    select date_trunc ({{Time_Interval}},date) as date,
    case when protocol ilike '%benqi%' then 'Benqi'
    when protocol ilike '%joe%' then 'Trader Joe'
    when protocol ilike '%GMX%' then 'GMX'
    when protocol ilike '%AAVE%' then 'AAVE'
    else initcap(protocol) end as "Project Name",
    sum (volume) as volume
    from external.defillama.fact_dex_volume
    where chain ilike 'Avalanche'
    and "Project Name" ilike '%{{Project_Name}}%'
    group by 1,2
    order by 1 desc




    QueryRunArchived: QueryRun has been archived