DigitalDanUser Activity with $ARB Tokens Users copy
Updated 2023-03-29Copy Reference Fork
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 dbd7773d-08b2-42ad-9c65-40ef885cd555
WITH all_arb_airdrops AS (
SELECT
CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS AIRDROP_WALLET_RECIPIENT,
ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS CLAIMED_AMOUNT
FROM
arbitrum.core.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
AND ORIGIN_FUNCTION_SIGNATURE = '0xae373c1b'
AND BLOCK_NUMBER >= 70506697
AND TX_STATUS = 'SUCCESS'
),
token_transfers AS (
SELECT
FROM_ADDRESS,
TO_ADDRESS,
RAW_AMOUNT / POWER(10, 18) AS AMOUNT,
BLOCK_TIMESTAMP
FROM
arbitrum.core.fact_token_transfers
WHERE
contract_address = lower('0x912CE59144191C1204E64559FE8253a0e49E6548')
AND from_address != '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
),
transfers_with_labels AS (
SELECT
tt.FROM_ADDRESS,
tt.TO_ADDRESS,
tt.AMOUNT,
tt.BLOCK_TIMESTAMP,
dl.ADDRESS_NAME,
dl.LABEL_TYPE,
dl.LABEL_SUBTYPE,
dl.PROJECT_NAME
Run a query to Download Data