Query editor
with aggregated_metric as (SELECT block_time, 'polkadot' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='polkadot',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'assethub' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='assethub',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'interlay' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='interlay',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'bifrost' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='bifrost',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'hydradx' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='hydradx',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'moonbeam' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3813333(date_type='{{date_type}}', chain='moonbeam')"UNION ALLSELECT block_time, 'acala' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='acala',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'unique' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='unique',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'astar' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3813333(date_type='{{date_type}}', chain='astar')"UNION ALLSELECT block_time, 'centrifuge' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='centrifuge',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'phala' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='phala',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'neuroweb' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='neuroweb',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'manta' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='manta',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'mythos' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='mythos',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'pendulum' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='pendulum',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'collectives' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='collectives',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'polimec' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='polimec',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'nodle' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='nodle',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'invarch' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='invarch',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'frequency' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='frequency',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'bridgehub' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='bridgehub',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'energywebx' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='energywebx',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'ajuna' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='ajuna',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'polkadex' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='polkadex',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'hyperbridge' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='hyperbridge',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 't3rn' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='t3rn',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'litentry' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='litentry',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'bitgreen' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='bitgreen',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'logion' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='logion',table_name='extrinsics',count='DISTINCT signer_ss58')"UNION ALLSELECT block_time, 'hashed' as chain, extrinsics_cnt as active_cnt, null as union_cnt, null as transfers_cnt, null as events_cnt, null as extrinsics_cnt FROM "query_3547036(date_type='{{date_type}}', chain='hashed',table_name='extrinsics',count='DISTINCT signer_ss58')"