crypto_edgarWallet Interactions - Behavioral Patterns
Updated 2025-06-14Copy Reference Fork
999
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
›
⌄
-- FACC
-- 0x4d754910d570b30f9a0150eeb7281cb3ce0cf42f - Gnosis Safe Proxy
-- 0x67976cea42d4831cf0b17ac3173e90496388fbf4 - iFACC Staking Contract
-- 0x35bce29f52f51f547998717cd598068afa2b29b7 - StakedLockingCrowdSale
-- 0x30efee8d51a949813d1dd40e68f18c4e2147c760 - Uniswap V3 Pool
-- 0x6c20d622d0bc3ec86e6536995ae444ce09da7cf3 - Safe Proxy
WITH TOKEN_SUPPLY_INFO_RAW as (
select
livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/2f5a6445-f5ff-4cd1-9c1f-16cd94fcb136/data/latest'
): data as data
),
TOKEN_SUPPLY_INFO as (
SELECT
VALUE:CONTRACT_ADDRESS :: STRING AS CONTRACT_ADDRESS,
VALUE:SYMBOL :: STRING AS SYMBOL,
VALUE:NAME :: STRING AS NAME,
VALUE:TOTAL_AMOUNT_MINTED :: STRING AS TOTAL_AMOUNT_MINTED
FROM
(
select
*
from
TOKEN_SUPPLY_INFO_RAW
) response,
LATERAL FLATTEN(INPUT => PARSE_JSON(response.data))
),
TOP_HOLDERS AS (
SELECT
LAST_ACTIVITY_BLOCK_TIMESTAMP,
USER_ADDRESS,
CURRENT_BAL,
SYMBOL
FROM
ethereum.core.ez_current_balances
WHERE
QueryRunArchived: QueryRun has been archived