KARTODOP Airdrop Sells/Transfers
Updated 2023-04-13
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 op_claims as (
SELECT
BLOCK_TIMESTAMP as block_time,
RAW_AMOUNT/POW(10,18) as claim_amount,
TO_ADDRESS as claimer
FROM optimism.core.fact_token_transfers
WHERE
CONTRACT_ADDRESS = lower('0x4200000000000000000000000000000000000042') --OP token
AND FROM_ADDRESS = lower('0xfedfaf1a10335448b7fa0268f56d2b44dbd357de') --claim contract
),
sells as (
SELECT
SENDER_ADDRESS as seller,
SUM(AMOUNT_IN) as sell_amount
from optimism.velodrome.ez_swaps
WHERE SENDER_ADDRESS IN (SELECT claimer from op_claims)
AND TOKEN_ADDRESS_IN = lower('0x4200000000000000000000000000000000000042')
AND BLOCK_TIMESTAMP > '2022-05-31 23:45:00'
GROUP BY seller
),
transfers as (
SELECT
BLOCK_TIMESTAMP as block_time,
RAW_AMOUNT/POW(10,18) as t_amount,
FROM_ADDRESS as sender,
TO_ADDRESS as receiver
FROM optimism.core.fact_token_transfers
WHERE CONTRACT_ADDRESS = lower('0x4200000000000000000000000000000000000042') --OP token
AND FROM_ADDRESS IN (SELECT claimer from op_claims)
AND BLOCK_TIMESTAMP > '2022-05-31 23:45:00'
),
merge as (
SELECT
Run a query to Download Data