feyikemi$ARB After Day 1
Updated 2025-01-09
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 initial_claims AS (
SELECT
ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS Total_claimed,
CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS USER
FROM
arbitrum.core.fact_event_logs
WHERE
TOPICS[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
AND ORIGIN_FROM_ADDRESS = '0x2b9acfd85440b7828db8e54694ee07b2b056b30c'
AND TX_STATUS = 'SUCCESS'
AND DATEDIFF('Day', '2023-03-23', BLOCK_TIMESTAMP) <= 1
),
claimers_sales AS (
SELECT
ORIGIN_FROM_ADDRESS AS USER,
ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS Total_sent
FROM arbitrum.core.fact_event_logs
WHERE 1=1
AND TOPICS[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
AND USER IN (SELECT USER FROM initial_claims)
AND TX_STATUS = 'SUCCESS'
AND DATEDIFF('Day', '2023-03-23', BLOCK_TIMESTAMP) <= 1
),
purchases_after_airdrop AS (
SELECT
ORIGIN_TO_ADDRESS AS USER,
ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS Total_bought
FROM arbitrum.core.fact_event_logs
WHERE 1=1
AND TOPICS[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
AND ORIGIN_TO_ADDRESS NOT IN (SELECT USER FROM initial_claims)
AND ORIGIN_FROM_ADDRESS != '0x2b9acfd85440b7828db8e54694ee07b2b056b30c'
AND TX_STATUS = 'SUCCESS'
AND DATEDIFF('Day', '2023-03-23', BLOCK_TIMESTAMP) <= 1
QueryRunArchived: QueryRun has been archived