Query editor
with gns_price as (with tmp as (select date_trunc('day', evt_block_time) as day,avg(if(amount0In/1e18 > 0, amount0In/1e18, amount0Out/1e18)/ if(amount1Out/1e18 > 0, amount1Out/1e18, amount1In/1e18)) as pricefrom quickswap_polygon.UniswapV2Pair_evt_Swapwhere contract_address = '0x6e53cb6942e518376e9e763554db1a45ddcd25c4' and evt_block_time >= '2021-10-27 00:00'group by 1)select day, price,lead(day, 1, date_trunc('day', now()) + interval '1 day') over (order by day) as next_dayfrom tmp),gns_staked_polygon as(with dws as(select `evt_block_time` as `block_time`, `contract_address`,`evt_tx_hash` as `tx_hash`, `user`, `amount` / 1e18 as `amount`from gains_network_polygon.GNSStakingV6_2_evt_TokensStakedunion allselect `evt_block_time` as `block_time`, `contract_address`,`evt_tx_hash` as `tx_hash`, `user`, `amount` * (-1) / 1e18 as `amount`from gains_network_polygon.GNSStakingV6_2_evt_TokensUnstaked), daily as(select date_trunc('day', `block_time`) as `day`, sum(`amount`) as `amount`from dwsgroup by 1)select `day`, `amount` as change, sum(`amount`) over (order by `day`) as `balance`,lead(day, 1, date_trunc('day', now()) + interval '1 day') over (order by day) as next_dayfrom daily),gns_supply_polygon as (with migrate_txs as(select `hash` as `tx_hash`from polygon.transactionswhere block_time >='2021-10-27' and `success` and `to` = lower('0xd285f881886505b9Ef6684E1aaa7949a56B0C7Da')order by 1),gns_trasnfrs as(select date_trunc('day',`evt_block_time`) AS `hour`, `evt_tx_hash` as `tx_hash`,(case when `to` = '0x0000000000000000000000000000000000000000' then `value`/1e18 else (`value`*(-1))/1e18 end) `amount`from erc20_polygon.evt_Transferwhere evt_block_time >= '2021-10-27'and `contract_address` = lower('0xE5417Af564e4bFDA1c483642db72007871397896')and (`to` = '0x0000000000000000000000000000000000000000' or `from` = '0x0000000000000000000000000000000000000000')and `evt_tx_hash` not in (select `tx_hash` from migrate_txs)order by 1),gns_burnt_daily as(select A.`hour`, sum(A.`amount`) `amount`from gns_trasnfrs Agroup by 1order by 1