vegardTop 10 Velodrome Pairs Symbol out USD Amount and Number of Swaps in last month
    Updated 2022-11-03
    select
    count(distinct(origin_from_address)) as wallets_number,
    count(distinct(tx_hash)) as tx_num,
    sum(amount_in_usd) as total_amount_usd,
    avg(amount_in_usd) as average_amount_usd,
    min(amount_in_usd) as min_amount_usd,
    max(amount_in_usd) as max_amount_usd,
    median(amount_in_usd) as median_amount_usd
    from optimism.velodrome.ez_swaps
    where block_timestamp >= current_date - interval '{{ days}} days'
    Run a query to Download Data