flipside

    2022-03-09 cumulative outbound memo UT costs
    Multipartite2022-03-09 cumulative outbound memo UT costs
    Updated 2022-03-09
    SELECT DISTINCT block_id, SUM(POWER(10,-8) * 2 * asset_e8 / (3 * 1000)) OVER(ORDER BY block_id ASC) AS cumulative_outmemo_ut_cost
    FROM thorchain.fee_events
    WHERE (asset = 'BTC.BTC')
    ORDER BY block_id DESC
    Run a query to Download Data