Updated 2022-06-12
    SELECT x.rank,
    x.sum_amnt as osmo_amnt,
    y.sum_amnt as thor_amnt,
    z.sum_amnt as sushi_amnt
    FROM
    (
    SELECT date_trunc('day', block_timestamp) as date,
    sum(amount/pow(10,decimal)) as amnt,
    rank() OVER(order by date) as rank,
    sum(amnt)over(ORDER BY date) as sum_amnt
    FROM osmosis.core.fact_liquidity_provider_actions
    WHERE currency IN
    ('ibc/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5',
    'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5')
    AND action = 'pool_joined'
    GROUP BY date
    ) x
    LEFT JOIN (
    SELECT date_trunc('day',block_timestamp) as date,
    sum(zeroifnull(rune_amount_usd)+zeroifnull(asset_amount_usd)) as amnt,
    rank() OVER(order by date) as rank,
    sum(amnt)over(ORDER BY date) as sum_amnt
    FROM flipside_prod_db.thorchain.liquidity_actions
    WHERE pool_name = 'ETH.ETH'
    AND lp_action = 'add_liquidity'
    GROUP BY date
    ) y
    ON x.rank = y.rank
    LEFT JOIN (
    SELECT date_trunc('day',a.block_timestamp) as date,
    sum(c.raw_amount)/pow(10,18) as amnt,
    rank()OVER(order by date) as rank,
    sum(amnt)over(ORDER BY date) as sum_amnt
    FROM ethereum.core.fact_event_logs a
    LEFT JOIN ethereum.core.dim_labels b
    ON a.ORIGIN_TO_ADDRESS = b.address
    Run a query to Download Data