sixahi6066probable-violet
Updated 2024-09-19
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 transfer_data AS (
SELECT
tx_to,
mint,
tx_id,
block_timestamp,
amount,
ROW_NUMBER() OVER (PARTITION BY tx_to, mint ORDER BY block_timestamp) AS rn
FROM solana.core.fact_transfers
WHERE mint IN ('FJ1DHFFHvW4UFNELFu6VonuAvaMK3Ch58LUMqsNqLnwk', '69SEPKGCzFzJLoSawb3xPfcqnZdiVm21Xu28AWZB5pzk')
),
first_transfers AS (
SELECT
tx_to,
mint,
tx_id AS first_tx_id,
block_timestamp AS first_block_timestamp
FROM transfer_data
WHERE rn = 1
),
total_inflows AS (
SELECT
tx_to,
mint,
SUM(amount) AS total_inflow
FROM transfer_data
GROUP BY tx_to, mint
),
filtered_receivers AS (
SELECT tx_to
FROM first_transfers
GROUP BY tx_to
HAVING
COUNT(DISTINCT mint) = 2
AND MAX(CASE WHEN mint = 'FJ1DHFFHvW4UFNELFu6VonuAvaMK3Ch58LUMqsNqLnwk' THEN first_block_timestamp END) < '2024-04-18 09:54'
AND MAX(CASE WHEN mint = '69SEPKGCzFzJLoSawb3xPfcqnZdiVm21Xu28AWZB5pzk' THEN first_block_timestamp END) < '2024-04-01 07:26'
QueryRunArchived: QueryRun has been archived