Query editor
withepoch_dates as (select date_trunc('week', evt_block_time - interval 3 days ) + interval 3 days as epoch_start, date_trunc('week', evt_block_time - interval 3 days ) + interval 10 days - interval 1 seconds as epoch_endfrom velodrome_optimism.Minter_evt_MintORDER BY evt_block_time),emissions as (select weekly/1e18 as emission, evt_block_time as emit_timefrom velodrome_optimism.Minter_evt_Mint)selectsum(value / 1e18) as velos_locked,sum(value / 1e18 *(datediff(from_unixtime(locktime) , from_unixtime(ts) ))/1461) as vevelos_locked,emission, epoch_startfrom velodrome_optimism.VotingEscrow_evt_Depositinner join epoch_dates on evt_block_time between epoch_start and epoch_endinner join emissions on emit_time between epoch_start and epoch_endwhere (deposit_type == 1 or deposit_type == 2)group by emission, epoch_startorder by epoch_start