nitsDeposit from L1
    Updated 2022-06-15
    WITH t AS (
    SELECT tx_id, COUNT(1) AS n
    FROM thorchain.swaps
    GROUP BY 1
    )

    SELECT date(block_timestamp) as day , blockchain, sum(from_amount_usd) as total_amt,
    sum(total_amt) over (partition by blockchain order by day ) as cumulative_amt
    from
    (SELECT * from
    (SELECT s.*, CASE WHEN t.n = 1 THEN 0 ELSE 1 END AS two_sided_swap_via_rune
    FROM thorchain.swaps s
    JOIN t ON t.tx_id = s.tx_id)
    where two_sided_swap_via_rune = 0)
    where to_asset = 'THOR.RUNE' and blockchain != 'THOR'
    GROUP by 1,2
    -- limit 100
    Run a query to Download Data