RECIPIENT_ADDRESS | TO_ADDRESS | TO_ADDRESS_LBL_TYPE | TO_ADDRESS_LBL_SUBTYPE | TOTAL_UNI_RECEIVED | TOTAL_UNI_SENT | |
|---|---|---|---|---|---|---|
1 | 0xd3f85ade70adf48ed17c8cb182b8b1aff542e51f | 507.00522457 | 0 | |||
2 | 0x6930fdae68a07575f135805ca2d2d7231e21a373 | 1.42005622 | 0 | |||
3 | 0x8fe4c5688fc801b986e13ce9d37b284f82748dd7 | 1.25779102 | 0 | |||
4 | 0xb028522b0914e29da2dd4e58521103de8cc5de41 | 0.05810765 | 0 | |||
5 | 0x95e54ae763d4c270274aa470fc0cd0ae1b2dc652 | 0.0823103 | 0 | |||
6 | 0xbeab25ed3782d7c41cca64a7bef868ab385714cc | 0.21260641 | 0 | |||
7 | 0x7f248e4301f5a16b2a8289989584a509f7157845 | 1.79719158 | 0 | |||
8 | 0x478683278e0f1093baf890f9a53d9cc5b5a55369 | 0.00308825 | 0 | |||
9 | 0x953659a063400eba9905c0cfebb2c5e78b73810a | 0x35d84ae687f0d3bf8548d5470fd04d2abe74f074 | dex | pool | 0 | -0.71228906 |
10 | 0x193f0ee42a199a0cecd479a9f09ba293eb1ca357 | 193.21086628 | 0 | |||
11 | 0x82abfea07b21a7e10ff7ef738e61608e876454f7 | 0.57562673 | 0 | |||
12 | 0xf5f5f604b2654b1cbf7dc96296c18b9e3a44ae91 | 182.86126158 | 0 | |||
13 | 0x856066c2ba008b6d7b3eb338a57223bf097a5f7b | 0.03094138 | 0 | |||
14 | 0x26e4e660dea98ce40be7e5b4ddec5a1cb61b4289 | 0.5449051 | 0 | |||
15 | 0x0a33c762801e3a460b8550bce4c9173d35b8e762 | 3.69216132 | 0 | |||
16 | 0x3be9154557623160af0456216f03324d27da545b | 0.00297635 | 0 | |||
17 | 0xfc65a7703939f14c396ab1d935f9a31784d6babe | 36.48404204 | 0 | |||
18 | 0x4e42acaec7379db6c9325b5b11f4bcd7f373652a | 0x0000000000000000000000000000000000000000 | chadmin | general_contract | 0 | -815.91823899 |
19 | 0xdfc0ab76bdf12ee8fa7f8052e11e948e015a9534 | 128.27827396 | 0 | |||
20 | 0xcf605d8152effee0f9d169d16ee55233e84f6446 | 1.35273699 | 0 |
frankmaseopost-incentive-claim
Updated 2025-02-05
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
claims as (
SELECT
block_number,
block_timestamp,
tx_hash,
REPLACE(decoded_log['token'], '"', '') as token_address,
REPLACE(decoded_log['user'], '"', '') as recipient_address,
CAST(REPLACE(decoded_log['amount'], '"', '') as double) / 1E18 as amount_claimed,
SUM(
CAST(REPLACE(decoded_log['amount'], '"', '') as double) / 1E18
) OVER (
PARTITION BY REPLACE(decoded_log['user'], '"', '')
ORDER BY block_number
) as cumulative_amount_claimed
FROM base.core.fact_decoded_event_logs
WHERE
contract_address = '0x3ef3d8ba38ebe18db133cec108f4d14ce00dd9ae' --Distributor contract
AND EVENT_NAME = 'Claimed'
AND REPLACE(decoded_log['token'], '"', '') = lower('0xc3De830EA07524a0761646a6a4e4be0e114a3C83')
AND CAST(REPLACE(decoded_log['amount'], '"', '') as double) / 1E18 > 0
)
,post_claim_outflows as (
SELECT
block_number,
from_address,
to_address,
amount
FROM base.core.ez_token_transfers erc20_t
JOIN (
SELECT recipient_address, min(block_number) as first_claim_bn
FROM claims
GROUP BY 1
) c
Last run: 2 months ago
...
1647
132KB
53s