itsxenuxEarly Pool Activity swap volume after first week
    Updated 2022-05-13
    with first_pool as (
    SELECT pool_name, min(block_timestamp) as min_date from thorchain.swaps
    group by pool_name
    )
    SELECT sw.pool_name, sum(sw.FROM_AMOUNT_USD) as total_usd
    FROM thorchain.swaps sw
    join first_pool fp on fp.pool_name = sw.pool_name
    -- where sw.tx_id = '13944C1631DA455BC43136D1364187FFEFDC9208A878D6B45F34EF24F3AB1BE8'
    where date(sw.block_timestamp) = date(fp.min_date) + 7
    group by sw.pool_name
    Run a query to Download Data