Afonso_DiazOvertime
    Updated 2025-01-05
    with

    main as (
    select
    tx_id,
    block_timestamp,
    from_address as swapper,
    nvl(from_amount_usd, to_amount_usd) as amount_usd
    from
    thorchain.defi.fact_swaps
    where
    (
    from_asset like 'ETH_FOX-0XC770EEFAD204B5180DF6A14EE197D99D808EE52D'
    or to_asset like 'ETH_FOX-0XC770EEFAD204B5180DF6A14EE197D99D808EE52D'
    )
    and block_timestamp between '{{ start_date }}' and '{{ end_date }}'
    )

    select
    date_trunc('{{ period }}', block_timestamp) as date,
    count(distinct tx_id) as swaps,
    count(distinct swapper) as swappers,
    sum(amount_usd) as volume_usd,
    avg(amount_usd) as average_amount_usd,
    sum(swaps) over (order by date) as cumulative_swaps,
    sum(volume_usd) over (order by date) as cumulative_volume_usd
    from
    main
    group by 1
    order by 1

    QueryRunArchived: QueryRun has been archived