Query editor
WITH app_names(app_id, app_name) AS (VALUES(0x3b4bf6bf3ad5000ecf0f989d5befde585c6860fea3e574a4fab4c49d1c177d9c, 'kernel.aragonpm.eth'),(0xe3262375f45a6e2026b7e7b18c2b807434f2508fe1a2a3dfb493c7df8f4aad6a, 'acl.aragonpm.eth'),(0xddbcfd564f642ab5627cf68b9b7d374fb4f8a36e941a75d89c87998cef03bd61, 'evmreg.aragonpm.eth'),(0x9ac98dc5f995bf0211ed589ef022719d1487e5cb2bab505676f0d084c07cf89a, 'agent.aragonpm.eth'),(0xbf8491150dafc5dcaee5b861414dca922de09ccffa344964ae167212e8c673ae, 'finance.aragonpm.eth'),(0x6b20a3010614eeebf2138ccec99f028a61c811b3b1a3343b6ff635985c75c91f, 'token-manager.aragonpm.eth'),(0x9fa3927f639745e587912d4b0fea7ef9013bf93fb907d29faeab57417ba6e1d4, 'voting.aragonpm.eth'),(0x7a0495dbeb66081f64dddfec2669c82ac3113a65bd84e40344e31185f9bd3bbe, 'voting-proxy.aragonpm.eth'),(0x7e852e0fcfce6551c13800f1e7476f982525c2b5277ba14b24339c68416336d1, 'vault.aragonpm.eth')),created_universe AS (SELECT COUNT(*) AS creation_records, COUNT(DISTINCT address) AS unique_contractsFROM ethereum.creation_traces),app_instances AS (SELECT output_0 AS contract_address, contract_address AS kernel, _appId AS app_id, 'kernel.newAppProxy' AS evidence, call_block_time AS first_seen, call_tx_hash AS tx_hashFROM aragon_ethereum.kernel_call_newappproxyWHERE call_successUNION ALLSELECT output_appProxy AS contract_address, contract_address AS kernel, _appId AS app_id, 'kernel.newAppInstance' AS evidence, call_block_time AS first_seen, call_tx_hash AS tx_hashFROM aragon_ethereum.kernel_call_newappinstanceWHERE call_successUNION ALLSELECT output_appProxy AS contract_address, contract_address AS kernel, _appId AS app_id, 'kernel.newPinnedAppInstance' AS evidence, call_block_time AS first_seen, call_tx_hash AS tx_hashFROM aragon_ethereum.kernel_call_newpinnedappinstanceWHERE call_success),app_instances_dedup AS (SELECT contract_address, kernel, app_id,array_join(array_sort(array_distinct(array_agg(evidence))), ', ') AS evidence,MIN(first_seen) AS first_seen,MIN_BY(tx_hash, first_seen) AS first_txFROM app_instancesGROUP BY 1,2,3),active_acl AS (SELECT app AS contract_address,COUNT(*) AS active_acl_roles,COUNT(DISTINCT entity) AS active_acl_entities,COUNT(DISTINCT role) AS active_acl_role_typesFROM (SELECT from_hex(substr(to_hex(topic1), 25)) AS entity,from_hex(substr(to_hex(topic2), 25)) AS app,topic3 AS role,bytearray_to_uint256(data) != 0 AS allowed,row_number() OVER (PARTITION BY topic1, topic2, topic3 ORDER BY block_number DESC, index DESC) AS rnFROM ethereum.logsWHERE topic0 = 0x9a72a4780c9d7acb8334c9dc1fcee69ab4218d4d70b29ef06019cbb9fb3b2621AND block_time >= TIMESTAMP '2015-07-30') xWHERE rn = 1 AND allowedGROUP BY 1),tm AS (SELECT contract_address, _token AS governance_token, CAST(_transferable AS VARCHAR) AS transferable, _maxAccountTokens AS max_account_tokens,call_block_time AS init_timeFROM aragon_ethereum.tokenmanager_call_initializeWHERE call_success