Query editor
WITHget_netflows AS (SELECTday,SUM(inflow) AS inflow,SUM(outflow) AS outflowFROM (SELECTdate_trunc('day', evt_block_time) AS day,SUM(value/1e18) AS inflow,0 AS outflowFROM enosys_loans_flare.boldtoken_evt_transferWHERE evt_block_time >= date_trunc('day', now() - interval '30' day)AND "from" = 0x0000000000000000000000000000000000000000GROUP BY 1UNION ALLSELECTdate_trunc('day', evt_block_time) AS day,0 AS inflow,-SUM(value/1e18) AS outflowFROM enosys_loans_flare.boldtoken_evt_transferWHERE evt_block_time >= date_trunc('day', now() - interval '30' day)AND to = 0x0000000000000000000000000000000000000000GROUP BY 1)GROUP BY 1)SELECT * FROM get_netflowsorder by day DESC