flipside

    solana.nft.fact_nft_mints
    Flipside Communitysolana.nft.fact_nft_mints
    Updated 2025-04-03
    -- the fact_nft_mints table
    -- includes all nft mints
    SELECT *
    FROM solana.nft.fact_nft_mints
    WHERE block_timestamp >= CURRENT_DATE - 1
    LIMIT 100








    Last run: 26 days ago
    BLOCK_TIMESTAMP
    BLOCK_ID
    TX_ID
    SUCCEEDED
    PROGRAM_ID
    PURCHASER
    MINT_PRICE
    MINT_CURRENCY
    MINT
    IS_COMPRESSED
    FACT_NFT_MINTS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		2025-04-02 12:29:01.000330807786
    4QGcf5et2rmVy2rFmByEk7VJ4cBDAuqEciASdXG2UdvTymDt8ZyRkY1WKcBHwH46XaeYQZTm...
    		TRUE9oWPtX1mtzA837WnHUdxaekWmyhwFU2iNFj9nK3G3UvwFALSEeac5bb67fcf7c966a27a3f5112f1a59f2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    2
    		2025-04-02 14:18:01.000330824073
    2fy6FmqzGyxx1LkTaaeqtG4M75tHrdMP1rhcGHr7nJHYwzViiFm4gAyPhDA4s4yc1xFPB6nf...
    		TRUEmetaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1sDzmCXKCP4Q5FGVDetRxdtMWH9Pj6iCujNThPjdgFp8Z90.02178328So11111111111111111111111111111111111111111ECQWka242ywRfYpZGqSxnSevyRWZ4zhQ7KsaZ7MXEcCFFALSE90e2fa8f0ac294db99e66d2bf29922252025-04-02 16:09:34.3632025-04-03 03:40:05.124
    3
    		2025-04-02 13:35:29.000330817714
    2Sr9byDZg8LkbQ473EebhmRawZxn74Krn4bcAsYA4nRWYmXkRa6gd8fqXJCFaoxUZPjREb4G...
    		TRUEEKfXhzPQo1PTUzYC6hjwEQGNwdT6xY44sZ9ks5yFigdPFALSE3bac877f933c5f489348143cf453bb462025-04-02 16:09:34.3632025-04-03 03:40:05.124
    4
    		2025-04-02 14:53:46.000330829428
    VRk4LJNe2EcGyPw1utaYkNc6xwGHwTRXwLJJkzoapoAWFxvjx2SUXFhgpRd9ebsbphMKXmi6...
    		TRUE7DKS3FdkRRkxDAh7UHsUqaoW6tVhJie9LT5fxLTb5okmFALSE93043efa3ba05c623405c341cdb0e9512025-04-02 16:09:34.3632025-04-03 03:40:05.124
    5
    		2025-04-02 14:03:48.000330821930
    5AeL567BcrGpvgokr2zZYq6LDpCghegViHHhgNNsMeuQkgtgDLpunVdRnJJGeytpm6W4ifb3...
    		TRUE7DyMY9nnGK7rh5uez94NEGQQ8CDAm9kLbZ3Rk1DGcVDYFALSEd28e8dfc3668d1359867e9b3bfd1a3b02025-04-02 16:09:34.3632025-04-03 03:40:05.124
    6
    		2025-04-02 13:39:59.000330818389
    3PXpB5Qac1m37ZKM3XkBf5nB7YEy1GJy4nUc1t8iEt16KufcH7ZiArHh8StgtFCSojK6Au9J...
    		TRUEAnJ7P3gToDZd4DoQ4fNB4ENaiHNbn2MfowxE6W9TFF5wFALSE81157a0c9efae2b8e114787638f79db02025-04-02 16:09:34.3632025-04-03 03:40:05.124
    7
    		2025-04-02 12:23:33.000330806967
    4yjgFcG47QQNudNTyezTqah8Sqsg1XDQ5ESabvwmb2HuhmczitdbKhXzDpvbmvPv2wsRyL7g...
    		TRUE8KKP8NoGm81Jmdd2qtpKTKhauutoLLKvZJekhmmGPXcBFALSEf47fe179e67f190d407d5febc87d5d522025-04-02 16:09:34.3632025-04-03 03:40:05.124
    8
    		2025-04-02 15:22:58.000330833804
    4Bq9FCkjwuVjHW2f98TU1buzRomezN9KnwoD7wHbBQxzV64RVKffFdCNBhnYF5orBbBP5gqe...
    		TRUEC7XFxYQKTH6rXDVbsiFkCd2zayhM5WCZUHp6sLwxGLnNFALSEd2c535238f15bd71d4dad1a898e52f922025-04-02 16:09:34.3632025-04-03 03:40:05.124
    9
    		2025-04-02 14:31:17.000330826051
    5vCgUQRFQiS2YDuHsF2BXGHRrJjA3tbb3Lq4hUtbbG9U4LgXwamXUBzvhseu6fdziSRiAoH8...
    		TRUEmetaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s5vqmCZvyC932Y7tANKkQ5qWRK4PvdbRLqfUdWJAUpNkF0.16824256So111111111111111111111111111111111111111119xgD3nkFCCCNxXFQdri5Niy224gRnwvQrUBPLqVdsyjeFALSE4b491ef14baf12160df60c1f9349ae072025-04-02 16:09:34.3632025-04-03 03:40:05.124
    10
    		2025-04-02 14:58:34.000330830152
    517478JVfHjHh8a4JHGwzitriMrEA3qALuEnfSNmbzVPwSDFLFo52mNNcKdtbJRPaTuti32D...
    		TRUE41iU4egQe9kcpEWT293Jy7bio6PigQEq454btZb2jZNGFALSE3c21c9091d89de9e6e60863428e2157e2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    11
    		2025-04-02 12:28:13.000330807669
    dsajgaiAjXEWH7ZLdXRHuVMmBtLLKSf8zidZsWZrKKhv7fMkuEy2VkV3wr1ZizURbwrYyKwx...
    		TRUECCvC73iENFBWierJSLzwx1KoA78TtpnmqjXmSobyoFekFALSE208bf9960c0249c47a1ee6261e54b5ac2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    12
    		2025-04-02 15:04:08.000330830975
    QnbA7pFxVcMg7WvNsqvEbXG2rxCH3pVLEBKmcQqhbTVBN3QuXjobom2W8kDUB5DGfUbcfmwY...
    		TRUEv5Xi9KeM5dk5ps5QcRK5MN8mGeuHUw79TcV15UFs3UFFALSEe16a43c62bae21d1c23531db0a19066c2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    13
    		2025-04-02 15:18:46.000330833170
    5prXSArKSX9pDsm6BJyGzwpjQdFr7tRAFUwxTjJ87d9AjLzik2YAmAi5y4gFjW553MzPz2sM...
    		TRUEmetaqbxxUerdq28cj1RbAWkYQm3ybzjb6a8bt518x1s8xwtZAQW7dWEiFq5ph9zsZ2hKQ9FLce8NECnkKgH3Uns0.16824256So11111111111111111111111111111111111111111DoyjbF3jDmQo6oYHsLV7QZsUVH4uPu2dg9ZMQoyzxbBAFALSE499fec74c717fe2d652d1a14f0c03c4f2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    14
    		2025-04-02 15:31:05.000330835014
    2qjXJ8vrDiRY58XMavjXJAf6GUdFnG6DNq1XdawWoK3CswvjgtH6zc8w7BY3EiLTchoN5Wc5...
    		TRUEEwqJofpyKUBXgzZfoD5WsG1kcTYWa1fg2pgFUp39Pdp8FALSE7ae73fea4f7fcfba64bbaa1188c046802025-04-02 16:09:34.3632025-04-03 03:40:05.124
    15
    		2025-04-02 14:43:13.000330827842
    5wjcHCqGrrvndgqqtyPC6Ppydhf5LiF8yk2CsZgCw6NKZ7pcxu1Npyt9bcYtUDsS9CJUTzME...
    		TRUE4fVMPzGSNfG7i9jCgma5FQF8HMQ8fM4kkAUZYeXUdMo1FALSE463c3a4c66aff2ab08cb41776b6054242025-04-02 16:09:34.3632025-04-03 03:40:05.124
    16
    		2025-04-02 14:21:29.000330824581
    5MmDDSGsePYvy1sBZXEHFEmR6W2EFv6xvFX8iMeXtRBpRFvV2gB2qhvxBjdbh56WcYsyFnJN...
    		TRUE94StRaA3oLbLsa5xogSeDZGsWQYMQCcssgrYejg21T1jFALSEc5653b0bc50010d27bab97d9b2455d702025-04-02 16:09:34.3632025-04-03 03:40:05.124
    17
    		2025-04-02 15:47:12.000330837427
    3DbCF1ebNNF7qDeC1Q98L5tejwUMs3oiZPxmFTGHzKC8woGQQ5AZspuPoDL654CVKNZvEJ44...
    		TRUE5WSFL8TL5MtQF3b18SzZ7E3UuvtFk4rskUMXC1v72718FALSE98dee301b49ab0433136b058b7f3858b2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    18
    		2025-04-02 15:21:47.000330833623
    XiXxX4huJaqovryMzY4bU1jUk5WEnHZYknfh8TziVWTxMw6RcVsN52sgjM2QEG9Br7SoHBVM...
    		TRUE2jEG4jXMK4voMrot7uH8WfXw4BvnCZJxhzWfoNVv31XyFALSE448016dcfa25a1676fc14674f0a94a222025-04-02 16:09:34.3632025-04-03 03:40:05.124
    19
    		2025-04-02 13:57:45.000330821038
    3ZgH8tF8n8FgsVh6Y7c1eWoGFFoWUkG1RH2ENW9cse71vXSHDitLHFjhNLLyCdZJUjW4MC4z...
    		TRUEH2nKJysL2R22TR5WSQHpbcGATrPToZVaB2axztxMGFUFFALSE5d94ea7a3831222abed9c2a911834aa82025-04-02 16:09:34.3632025-04-03 03:40:05.124
    20
    		2025-04-02 15:00:43.000330830465
    4X1ukotaubMaHR5VTJrQAxqYRNr2Sj6s2FnyAVsE47aMK7k3TtvX28GJyb4bakG5L3mZkkxA...
    		TRUEFBqwuiAW17HqYsi7zryGMexaADWbzycFNrwvJBvgaG2FFALSEddc50f62240bfbd2b955fc22186c9cad2025-04-02 16:09:34.3632025-04-03 03:40:05.124
    100
    29KB
    1s