BLOCK_TIMESTAMP | TX_ID | TX_FROM | TX_TO | AMOUNT | MINT | |
---|---|---|---|---|---|---|
1 | 2025-02-27 13:04:55.000 | 5oVVyZUxhmiPmqwCF3XWchjfgY2TGFuQPbj4sZYNNyLZCYKDHzG6BbcunysK93rRLCZDHW1m... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 123.69752551 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
2 | 2025-02-28 12:56:32.000 | 4WuZjat6kWUJesySGejdFM1iABFynTaKzs658VUngi3PfSg9ZLQCj16Uynm5Gp7EqscZMjP6... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 4635.61518012 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
3 | 2025-02-28 14:06:14.000 | 2KFrAGRkKBVFkaqXuXk4hs7R41E7mSJ2TXto66fGKezBVuq4WR4kmAgK5r6u8RWgdci9N2wo... | GoWQNYsebpwMuKTQLzHMKdypfYjoSPLKehZzX2ewgC1y | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 23187.32062232 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
4 | 2025-02-28 14:07:48.000 | 5ByrKwiLpHsxxduVBsJFXAwVcqNKRmncDSY9uYSQ31exZoVgwrjLRf3FuUr72aRoeEUoh3Bh... | 5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1 | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 13487.17629301 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
5 | 2025-03-01 14:14:22.000 | kp9DutXh8Q7QptcMQT7jTho29dpKD2pTfTqfDF7NoTwUWTD8jJYBiG3333JF4GFdp3EfQWPA... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 5490.26177676 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
6 | 2025-03-02 08:32:21.000 | 4MXi5btrvPnALV1xHx6cr3QJcegihNrZR28VTx6Y2zUjAdW7YEfR1RN7uaewEbWpXWW1PyV1... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 4739.33436854 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
7 | 2025-03-02 21:37:06.000 | 2FesP6TwygZfMc3CBHXqR6SSaMSuSUhDuUxWvfDMJ6EMgCShqgHzeBYo9SNkAVBuTvBFWCiM... | GoWQNYsebpwMuKTQLzHMKdypfYjoSPLKehZzX2ewgC1y | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 8000 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
8 | 2025-03-03 11:31:56.000 | 26dEX3KXociVoPFexfzeRXeqRwF6K1S44vQgvHk4AnB5SYJoYKAP4FVkTutsuTtsqcvU1GUP... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 6340.9612513 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
9 | 2025-03-04 11:06:54.000 | 4Mxf5tbeLKzwUx7LiG2SaXuwaMLGemBoc42SyoyCMesdemPZqDS1T11QV5iVhC9cagxXSuVY... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 2395.12271816 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
10 | 2025-03-05 13:04:56.000 | 2tJHLyaTxBfg3tvspquWVKSBXiLWrQNZPF6NbvXYCsu4fQp7t54agtJJ2FnYPNah2vGxFXyq... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 5848.27715339 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
11 | 2025-03-06 13:38:17.000 | 4wrNy4kxK4PK9kPg6qxCz812kdDBhtCazYtrReSQtNwHDk55eFZULNCe1ZUM1z345FUrN3Bs... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 8053.03637596 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
12 | 2025-03-07 08:23:31.000 | 3ehULp914nWDR3ytLXvFB3dHw6nVMmQacKVK1nrzpY6Kq4mqQFBp9kJEP8sXr1FUP6R7VWkA... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 10396.041663 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
13 | 2025-03-08 11:53:55.000 | Y8JFCFzMoEF2XDGLrVQPwqDyk9gUy2APKi6Mf2eBUt8FURreRHDqi93YXbX9jZVzv5XUhG7b... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 9372.87655614 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
14 | 2025-03-09 14:23:15.000 | 4rvg1Coj1RY3NJwBAKk3vy3z77E4y7KidQ6yAcCMNxHFVje2kN5xkr3a9fMSTDTvYK4EknmA... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 7095.28784751 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
15 | 2025-03-10 14:31:42.000 | 5MujMkbfmdSQTcTq5S4i67qwYDvELapJ9qth5gjjPLwE9YXjmkpaG61GeM2RKs6huAWDHBkm... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 5688.46404782 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
16 | 2025-03-11 17:00:22.000 | 3wP31HqVQggNE7FdFMSoPvyyR7V3D9rk9bbMNjUrG963FCUEdRJd4GZg5CTtBtoKBUFMngWx... | 6UjDTV5eWoRCYPR274jWF43G7pptwVXRj52A5U2aoebn | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 582.780016 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
17 | 2025-03-11 21:29:45.000 | 2xoxEjH11uD4iC91eZsWuUBBtwHFoiR3odvdSqx8Yaa8tkRdYvCGT3oUh3yu4Xjb5rsJx96Q... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 10568.75375079 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
18 | 2025-03-12 14:46:23.000 | tTN9tt3xirpneXmmvZiUSHLEjTUgFJMUVmQZgwTuBseewuhwvc38hvPGxRQbmK2PNGY87Mt2... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 9792.50447343 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
19 | 2025-03-13 09:19:50.000 | 2j6SQLfsnHi1F447g3zx3MRsoUTFUCVLkUMFaNCQT9ioaovA2jyrERBd9pU8YNfrLip6YGa1... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 5549.28752622 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
20 | 2025-03-14 12:17:40.000 | 2rDwroeAdU5vBWWUDy9TSpAyybaZvzna92hTzt5dQEosbZ3722nErWTmXqbWH3YNiYMuM7ZD... | 2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1V | F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS | 4458.20571436 | ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx |
sauronecro-R7cYWgConsorzio atl
Updated 2025-04-28Copy 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
›
⌄
WITH params AS (
SELECT
'F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS' AS my_wallet,
-- Indirizzo del wallet
'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' AS atlas_mint,
-- Mint address ATLAS
DATEADD('day', -60, CURRENT_DATE) AS start_date,
-- Data di inizio (30 giorni fa)
CURRENT_DATE AS end_date -- Data di fine (oggi)
) -- Transazioni giornaliere
SELECT
t.BLOCK_TIMESTAMP,
t.TX_ID,
t.TX_FROM,
t.TX_TO,
t.AMOUNT,
t.MINT
FROM
solana.core.fact_transfers t
JOIN params p ON 1 = 1
WHERE
t.BLOCK_TIMESTAMP BETWEEN p.start_date
AND p.end_date
AND t.MINT = p.atlas_mint
AND t.TX_TO = p.my_wallet -- Solo le transazioni in cui il wallet è il destinatario
UNION
ALL -- Totale ATLAS ricevuti
SELECT
MAX(t.BLOCK_TIMESTAMP) AS BLOCK_TIMESTAMP,
-- Utilizza l'ultimo BLOCK_TIMESTAMP disponibile
NULL AS TX_ID,
NULL AS TX_FROM,
NULL AS TX_TO,
SUM(t.AMOUNT) AS total_received,
p.atlas_mint AS MINT
FROM
Last run: 2 months ago
88
23KB
9s