flipside

    Total swap amount (in $) in the first 24 hours after the launch of the pool
    nitsTotal swap amount (in $) in the first 24 hours after the launch of the pool
    Updated 2022-01-29
    select pool_name, sum(from_amount_usd)/pow(10,6) as total_swap_amt_in_M_USD, count(DISTINCT from_address) as unique_users from
    (select * from (select pool_name as pn , min(block_timestamp) as first_addition from thorchain.swaps
    GROUP by pool_name)
    inner join thorchain.swaps
    on pool_name = pn and timestampdiff(SQL_TSI_HOUR, first_addition, block_timestamp)< 24)
    GROUP by pool_name
    order by total_swap_amt_in_M_Usd desc
    limit 100
    Run a query to Download Data