arabianhorses-jZtVNa2023-06-27 05:04 PM
Updated 2023-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
contract_addresses AS (
SELECT
LENGTH(PARAMETERS[0]:value) AS length_value,
CASE LENGTH(PARAMETERS[0]:value)
WHEN 60 THEN CONCAT('0x000000', SUBSTR(PARAMETERS[0]:value, 3, 58))
WHEN 61 THEN CONCAT('0x00000', SUBSTR(PARAMETERS[0]:value, 3, 59))
WHEN 62 THEN CONCAT('0x0000', SUBSTR(PARAMETERS[0]:value, 3, 60))
WHEN 63 THEN CONCAT('0x000', SUBSTR(PARAMETERS[0]:value, 3, 61))
WHEN 64 THEN CONCAT('0x00', SUBSTR(PARAMETERS[0]:value, 3, 62))
WHEN 65 THEN CONCAT('0x0', SUBSTR(PARAMETERS[0]:value, 3, 63))
ELSE 'CHECK'
END AS editedAddress,
PARAMETERS[0]:value AS rawContractAddresses,
*
FROM
external.tokenflow_starknet.decoded_events
WHERE
CHAIN_ID = 'mainnet'
AND NAME = 'ContractDeployed'
AND TX_HASH NOT IN (
SELECT
TX_HASH FROM external.tokenflow_starknet.decoded_events
WHERE NAME IN ('AccountCreated', 'account_deployed'
, 'AccountInitialized', 'account_created', 'account_initialized')
AND CHAIN_ID = 'mainnet'
)
)
SELECT
PARAMETERS[1]:value
, COUNT(TX_HASH)
FROM external.tokenflow_starknet.decoded_events
WHERE CHAIN_ID = 'mainnet'
AND NAME = 'Transfer'
Run a query to Download Data