mcasto_Contract Deployment Locator - LITKEY
Updated 2025-04-14
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
›
⌄
-- forked from Contract Deployment Locator - LITKEY @ https://flipsidecrypto.xyz/studio/queries/75c7e950-a458-478d-86df-8c7367e76026
WITH contract_deployments AS (
SELECT
MODIFIED_TIMESTAMP AS creation_time,
SYMBOL AS symbol,
NAME AS name,
ADDRESS AS contract_address
FROM arbitrum.core.dim_contracts
WHERE symbol = 'LITKEY'
),
total_supply AS (
SELECT
CONTRACT_ADDRESS AS contract_address,
TO_ADDRESS AS receiving_address,
SUM(AMOUNT) AS total_supply
FROM arbitrum.core.ez_token_transfers
WHERE FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
GROUP BY CONTRACT_ADDRESS, TO_ADDRESS
),
supply_sent AS (
SELECT
FROM_ADDRESS AS sending_address,
SUM(AMOUNT) AS supply_sent
FROM arbitrum.core.ez_token_transfers
WHERE FROM_ADDRESS IN (SELECT receiving_address FROM total_supply)
AND TO_ADDRESS <> '0x0000000000000000000000000000000000000000'
GROUP BY FROM_ADDRESS
)
SELECT
contract_deployments.creation_time,
contract_deployments.symbol,
contract_deployments.name,
contract_deployments.contract_address,
total_supply.receiving_address,
QueryRunArchived: QueryRun has been archived