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')),universe AS (SELECT COUNT(*) creation_records, COUNT(DISTINCT address) unique_contractsFROM ethereum.creation_traces),app_instances AS (SELECT 'aragon_ethereum' AS source_namespace, output_0 AS contract_address, contract_address AS kernel, _appId AS app_id, 'kernel.newAppProxy' AS evidence, call_block_time first_seen, call_tx_hash first_txFROM aragon_ethereum.kernel_call_newappproxy WHERE call_successUNION ALLSELECT 'aragon_ethereum', output_appProxy, contract_address, _appId, 'kernel.newAppInstance', call_block_time, call_tx_hashFROM aragon_ethereum.kernel_call_newappinstance WHERE call_successUNION ALLSELECT 'aragon_ethereum', output_appProxy, contract_address, _appId, 'kernel.newPinnedAppInstance', call_block_time, call_tx_hashFROM aragon_ethereum.kernel_call_newpinnedappinstance WHERE call_successUNION ALLSELECT 'lido_ethereum', output_0, contract_address, _appId, 'kernel.newAppProxy', call_block_time, call_tx_hashFROM lido_ethereum.kernel_call_newappproxy WHERE call_successUNION ALLSELECT 'lido_ethereum', output_appProxy, contract_address, _appId, 'kernel.newAppInstance', call_block_time, call_tx_hashFROM lido_ethereum.kernel_call_newappinstance WHERE call_successUNION ALLSELECT 'lido_ethereum', output_appProxy, contract_address, _appId, 'kernel.newPinnedAppInstance', call_block_time, call_tx_hashFROM lido_ethereum.kernel_call_newpinnedappinstance WHERE call_success),apps AS (SELECT source_namespace, contract_address, kernel, app_id,array_join(array_sort(array_distinct(array_agg(evidence))), ', ') AS evidence,MIN(first_seen) AS first_seen,MIN_BY(first_tx, first_seen) AS first_txFROM app_instancesGROUP BY 1,2,3,4),acl_changes AS (SELECT _app AS contract_address, _entity AS entity, _role AS role, true AS allowed, call_block_time AS ts, call_block_number AS bn, call_tx_index AS txi, cardinality(call_trace_address) AS depthFROM aragon_ethereum.acl_call_createpermission WHERE call_successUNION ALL SELECT _app, _entity, _role, true, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM aragon_ethereum.acl_call_grantpermission WHERE call_successUNION ALL SELECT _app, _entity, _role, true, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM aragon_ethereum.acl_call_grantpermissionp WHERE call_successUNION ALL SELECT _app, _entity, _role, false, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM aragon_ethereum.acl_call_revokepermission WHERE call_successUNION ALL SELECT _app, _entity, _role, true, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM lido_ethereum.acl_call_createpermission WHERE call_successUNION ALL SELECT _app, _entity, _role, true, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM lido_ethereum.acl_call_grantpermission WHERE call_successUNION ALL SELECT _app, _entity, _role, true, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM lido_ethereum.acl_call_grantpermissionp WHERE call_successUNION ALL SELECT _app, _entity, _role, false, call_block_time, call_block_number, call_tx_index, cardinality(call_trace_address)FROM lido_ethereum.acl_call_revokepermission WHERE call_success