sauronecro-R7cYWgConsorzio atl
    Updated 2025-04-28
    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
    BLOCK_TIMESTAMP
    TX_ID
    TX_FROM
    TX_TO
    AMOUNT
    MINT
    1
    2025-02-27 13:04:55.000
    5oVVyZUxhmiPmqwCF3XWchjfgY2TGFuQPbj4sZYNNyLZCYKDHzG6BbcunysK93rRLCZDHW1m...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS123.69752551ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    2
    2025-02-28 12:56:32.000
    4WuZjat6kWUJesySGejdFM1iABFynTaKzs658VUngi3PfSg9ZLQCj16Uynm5Gp7EqscZMjP6...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS4635.61518012ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    3
    2025-02-28 14:06:14.000
    2KFrAGRkKBVFkaqXuXk4hs7R41E7mSJ2TXto66fGKezBVuq4WR4kmAgK5r6u8RWgdci9N2wo...
    GoWQNYsebpwMuKTQLzHMKdypfYjoSPLKehZzX2ewgC1yF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS23187.32062232ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    4
    2025-02-28 14:07:48.000
    5ByrKwiLpHsxxduVBsJFXAwVcqNKRmncDSY9uYSQ31exZoVgwrjLRf3FuUr72aRoeEUoh3Bh...
    5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1F9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS13487.17629301ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    5
    2025-03-01 14:14:22.000
    kp9DutXh8Q7QptcMQT7jTho29dpKD2pTfTqfDF7NoTwUWTD8jJYBiG3333JF4GFdp3EfQWPA...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS5490.26177676ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    6
    2025-03-02 08:32:21.000
    4MXi5btrvPnALV1xHx6cr3QJcegihNrZR28VTx6Y2zUjAdW7YEfR1RN7uaewEbWpXWW1PyV1...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS4739.33436854ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    7
    2025-03-02 21:37:06.000
    2FesP6TwygZfMc3CBHXqR6SSaMSuSUhDuUxWvfDMJ6EMgCShqgHzeBYo9SNkAVBuTvBFWCiM...
    GoWQNYsebpwMuKTQLzHMKdypfYjoSPLKehZzX2ewgC1yF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS8000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    8
    2025-03-03 11:31:56.000
    26dEX3KXociVoPFexfzeRXeqRwF6K1S44vQgvHk4AnB5SYJoYKAP4FVkTutsuTtsqcvU1GUP...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS6340.9612513ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    9
    2025-03-04 11:06:54.000
    4Mxf5tbeLKzwUx7LiG2SaXuwaMLGemBoc42SyoyCMesdemPZqDS1T11QV5iVhC9cagxXSuVY...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS2395.12271816ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    10
    2025-03-05 13:04:56.000
    2tJHLyaTxBfg3tvspquWVKSBXiLWrQNZPF6NbvXYCsu4fQp7t54agtJJ2FnYPNah2vGxFXyq...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS5848.27715339ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    11
    2025-03-06 13:38:17.000
    4wrNy4kxK4PK9kPg6qxCz812kdDBhtCazYtrReSQtNwHDk55eFZULNCe1ZUM1z345FUrN3Bs...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS8053.03637596ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    12
    2025-03-07 08:23:31.000
    3ehULp914nWDR3ytLXvFB3dHw6nVMmQacKVK1nrzpY6Kq4mqQFBp9kJEP8sXr1FUP6R7VWkA...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS10396.041663ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    13
    2025-03-08 11:53:55.000
    Y8JFCFzMoEF2XDGLrVQPwqDyk9gUy2APKi6Mf2eBUt8FURreRHDqi93YXbX9jZVzv5XUhG7b...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS9372.87655614ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    14
    2025-03-09 14:23:15.000
    4rvg1Coj1RY3NJwBAKk3vy3z77E4y7KidQ6yAcCMNxHFVje2kN5xkr3a9fMSTDTvYK4EknmA...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS7095.28784751ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    15
    2025-03-10 14:31:42.000
    5MujMkbfmdSQTcTq5S4i67qwYDvELapJ9qth5gjjPLwE9YXjmkpaG61GeM2RKs6huAWDHBkm...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS5688.46404782ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    16
    2025-03-11 17:00:22.000
    3wP31HqVQggNE7FdFMSoPvyyR7V3D9rk9bbMNjUrG963FCUEdRJd4GZg5CTtBtoKBUFMngWx...
    6UjDTV5eWoRCYPR274jWF43G7pptwVXRj52A5U2aoebnF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS582.780016ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    17
    2025-03-11 21:29:45.000
    2xoxEjH11uD4iC91eZsWuUBBtwHFoiR3odvdSqx8Yaa8tkRdYvCGT3oUh3yu4Xjb5rsJx96Q...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS10568.75375079ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    18
    2025-03-12 14:46:23.000
    tTN9tt3xirpneXmmvZiUSHLEjTUgFJMUVmQZgwTuBseewuhwvc38hvPGxRQbmK2PNGY87Mt2...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS9792.50447343ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    19
    2025-03-13 09:19:50.000
    2j6SQLfsnHi1F447g3zx3MRsoUTFUCVLkUMFaNCQT9ioaovA2jyrERBd9pU8YNfrLip6YGa1...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS5549.28752622ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    20
    2025-03-14 12:17:40.000
    2rDwroeAdU5vBWWUDy9TSpAyybaZvzna92hTzt5dQEosbZ3722nErWTmXqbWH3YNiYMuM7ZD...
    2N8aQdNGjPzLa4br5t3Eeu3afKj29bnwQLVHsSKSaj1VF9Xi1ivxYc99rrVc6MJSAPiercvD888zDWfY8EJ7ppjS4458.20571436ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx
    88
    23KB
    9s