flipside

    solana.defi.fact_liquidity_pool_actions
    Flipside Communitysolana.defi.fact_liquidity_pool_actions
    Updated 2025-04-03
    -- the fact_liquidity_pool_actions table
    -- includes all token staking and unstaking actions into liquidity pools
    SELECT *
    FROM solana.defi.fact_liquidity_pool_actions
    WHERE block_timestamp >= CURRENT_DATE - 1
    LIMIT 100





    Last run: 19 days ago
    BLOCK_ID
    BLOCK_TIMESTAMP
    TX_ID
    SUCCEEDED
    PROGRAM_ID
    ACTION
    LIQUIDITY_PROVIDER
    LIQUIDITY_POOL_ADDRESS
    AMOUNT
    MINT
    _INSERTED_TIMESTAMP
    FACT_LIQUIDITY_POOL_ACTIONS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		3306979662025-04-02 00:16:20.000
    4f9jdd8tDkiP6kU4LzJBm1ryzkakAe213mnCn5x9Gu9CB58diQM7jiSUzLC1snh8EvYaBdUt...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawE4VSFquazTV3PrSSKS7TMxuQxRCNBwk5ATVTSNhEUpgk5zpyutJu9ee6jFymDGoK7F6S5Kczqtc9FomP3ueKuyA91.422007496So111111111111111111111111111111111111111122025-04-02 00:22:27.0008759a0e6c31bef6b111122c241cb06982025-04-02 04:21:03.6302025-04-02 04:21:03.630
    2
    		3307093042025-04-02 01:32:00.000
    2Dfek5vRHMHna7hzD9Z8uFPX2btuq2bceD6EkmcSb2VHjF4DFqYujqSxHccFES2Gaeb3BGna...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdraw915xo7soBvFDQrr57bWnCPTy2ZFBAMscT3JQts59bpwg6a3m2EgFFKfsFuQtP4LJJXPcAe3TQYXNyHUjjZpUxYgd1.851946432So111111111111111111111111111111111111111122025-04-02 01:40:43.000a0122f37c3588594f59f3c8af7f52c062025-04-02 04:21:03.6302025-04-02 04:21:03.630
    3
    		3307148332025-04-02 02:08:54.000
    4B6ZKAuLzBWCc3NdTvt38RSe5rSPD5p11oed8mVJmtrbhYUbvtP78eFHdk234DzU8onbRzzV...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdraw4fGQxszuvrboCz9BDq3oNE6XeykehpTE17unnfwuWZHJA6cVoMU1Z7oRi9R774QarVxHUmHPQkxQfYVFGNQuAx2b0.005546591So111111111111111111111111111111111111111122025-04-02 02:22:58.000073538ce1704184e5ac424becf9e94212025-04-02 04:21:03.6302025-04-02 04:21:03.630
    4
    		3307078762025-04-02 01:22:21.000
    WafqkFwe72CBekgfxfwHSjGf1SYhuSx59VchoBjxnvicvRvojMRPYaQwEdyjByMBWH2tJp5A...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawGUivgA3N3DBWF8QkeGUzjvb7WjmeBDcDzZfqoRjh1ywY55BrDTCLWayM16GwrMEQU57o4PTm6ceF9wavSdNZcEiy31.078721EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 01:28:49.000e79fe8c63d5bb5de906d801ebed77f152025-04-02 04:21:03.6302025-04-02 04:21:03.630
    5
    		3307243102025-04-02 03:12:04.000
    3GNoJfgQkPQPypJqaHfxM3dvdbYv7W9R9nw3EF63JPAiw5k2jRzCS4jwct6AfLfFsifCDjNS...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawE4VSFquazTV3PrSSKS7TMxuQxRCNBwk5ATVTSNhEUpgkCzfq3xZZDmsdGdUyrNLtRhGc47cXcZtLG4crryfu44zE5.670450263So111111111111111111111111111111111111111122025-04-02 03:16:24.000f0aafc7338f76dfc6ef823f9b674d5322025-04-02 04:21:03.6302025-04-02 04:21:03.630
    6
    		3307078292025-04-02 01:22:02.000
    47LKPtJP3AvuhSVu5ks15e83m7i1K3jRTMpqo5EFnhXB4yC8VBV5VKCUT5EmGMd7iKUP8UGg...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawJAAjLACTM7vVpqt1QYpKCn6GH8k7dVUmkUjdKN6KUAx96NUiVmsNjsi4AfsMsEiaezsaV9N4N1ZrD4jEnuWNRvyb11.807279EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 01:28:49.000354bf91d6eedf25f26e523c21cba22b42025-04-02 04:21:03.6302025-04-02 04:21:03.630
    7
    		3307295272025-04-02 03:46:55.000
    JJwTbbgDCNrtpkL6bvt2RczKdqUpUUpERU4hHKheig9K9HUBrCtt65nCfzngvKybwF56bQnY...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawD3sguK6sGdqvBLLCsVQDpDP44ZWobd6qb6kvdReYAViUCzfq3xZZDmsdGdUyrNLtRhGc47cXcZtLG4crryfu44zE0EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 03:51:56.0003b25913cfe202cd11c3fbfb9d5865c9f2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    8
    		3307146982025-04-02 02:08:01.000
    2LtUWJnJkEnsTs4TtARrojBgWqFAR2vgYNiyAz5qFS7cnzeruMzzFPiU7oUDzPW8iEMwtkZ7...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdraw6nATHHoEC2qTXi7Zcu5Ad2NcSTzUU1SaseZvv3iifgfB5zpyutJu9ee6jFymDGoK7F6S5Kczqtc9FomP3ueKuyA912.780301096So111111111111111111111111111111111111111122025-04-02 02:11:35.0009b26b7bbe53b3e4989aaf323cbb0b7b62025-04-02 04:21:03.6302025-04-02 04:21:03.630
    9
    		3307088862025-04-02 01:29:12.000
    4MJcVZRhkR6fA3B57oziTt8on7JPfQWLWojDGGZ8a4Ew5n8ycREM2GDqR1b33pt1Kc5jJk4Q...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdraw7BipTb8pQh7xbjioxjzdCGDMV1AJspjnjMXq1e5HjvZNC1MgLojNLWBKADvu9BHdtgzz1oZX4dZ5zGdGcgvvW8Wz3.998644764So111111111111111111111111111111111111111122025-04-02 01:40:53.00091ad2cc3a4a1805746b2f8813503260a2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    10
    		3307200342025-04-02 02:43:33.000
    LYmgPMhT4J5euvDVbRjpapweN5XyTm4GrH11dvmfKN5L5x3ZoyAWd1NKXPszoZgVyx2ffCo1...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawBUJjbJBu5kkxZGQNxx5QLXdyxx5HThht2NepcDZJ1P2fCzfq3xZZDmsdGdUyrNLtRhGc47cXcZtLG4crryfu44zE45.451301418So111111111111111111111111111111111111111122025-04-02 02:52:35.000cd1d05816a62493f69280aa5efc2d3dc2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    11
    		3307195422025-04-02 02:40:14.000
    2kYr4FesNVT2o1KaQJkjCzqFuZX4JxRiBTJJeAC4aq2KpgujZnEyoGwfgXEEnBQuy2NB3BA5...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawAECTMxLqHaSL8QznVZSWp3ozuKjzKfRPTy65ZP2jdvvr6NUiVmsNjsi4AfsMsEiaezsaV9N4N1ZrD4jEnuWNRvyb396.636635EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 02:53:01.0000966d99a6d480700c10bbccee312980e2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    12
    		3307162372025-04-02 02:18:12.000
    2TdXJqQC9GmvdJJaEqsogHrYn4HvJz8L711QVhu55YAVGsWVxJ8Bg49dw1PrcEBLyQwERmLM...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawHvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK7BZzoP3QB2zK3R7WqRzjS5fpeeErgdy3HGzxXrN97aEY245078.78422WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk2025-04-02 02:22:03.00032a432cf7027b536117599f29d3cf4072025-04-02 04:21:03.6302025-04-02 04:21:03.630
    13
    		3307110202025-04-02 01:43:26.000
    2U1AMMy3o3JxNwcfovWDYcR2qjqbuGuhVg1Bma9pKQKaKZJPYXhzCw1ypcKheXAaViEP5L8e...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawGJLAHPJ2j6nLTuc6ncP2RrkrjBsfxWmPRbygwouoe9aX6NUiVmsNjsi4AfsMsEiaezsaV9N4N1ZrD4jEnuWNRvyb104.237853EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 01:53:00.00092ae52c9b46781f24218078c677d745d2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    14
    		3307147002025-04-02 02:08:01.000
    2Mzbq8W2WtesLB112V2W5QA28BQ2shS1v5E9FmmJDf25w8QUdWDHzSTrRSDXHjG7kZveqDcj...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawH3SsPcVhZWhRyupU87Hn95WrJaYdz4rWNpdaiS4BSwmm5zpyutJu9ee6jFymDGoK7F6S5Kczqtc9FomP3ueKuyA97.163050768So111111111111111111111111111111111111111122025-04-02 02:11:35.000e29626726bebcd276c214b07bd1542b92025-04-02 04:21:03.6302025-04-02 04:21:03.630
    15
    		3307058902025-04-02 01:09:11.000
    2Vw6Vphm9SJp4oU7xcuWZoyF8rWZ5f2BaCRK2nqWaBgoaBfFrTQbqjiarnMPwwFi2gBQJG4i...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdraw8Kj2MoiGtDDLFZMPCCAgGkRQ2RFi2QV2YQ4K1EGvhMTz6NUiVmsNjsi4AfsMsEiaezsaV9N4N1ZrD4jEnuWNRvyb8.4201EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 01:17:43.000fc672f2d0ee750e1e905b82b766840ab2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    16
    		3307039272025-04-02 00:56:02.000
    y3CNa4U2HnjDoZkehaKhV9qdGrvhsam59QTL8dsixxfcPRuR8NEGax8Ds1epScT4EfmLiz9M...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawspifbFp5xfvfP6K74rmowrAdnHifCitBzemtZVUDNWo8Z8uy3xqUZqvpJ9QvJz7muz5aosL2VjGfJcEA99JK3649.738171EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2025-04-02 01:05:30.00087ff3fc623c035ba55f697058399a5212025-04-02 04:21:03.6302025-04-02 04:21:03.630
    17
    		3307072272025-04-02 01:18:03.000
    51cKBzdvwfh8P5spQNSmeW5AG6VdwJj9SDCAVKwH6mSjD65DKiEPKHAAbKRQQ9G1St9ZXAmN...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawa23gHknrH37ZsaoYWUYf44d6rYbsVH1Ny3YubpNQTpxHZsTF6VHdQy2W6cfEEqqpoTFKocx7Ch5c4TnWucXkAYv1.148738614mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So2025-04-02 01:29:07.0007115b272057ea26b52fef3cce409ae662025-04-02 04:21:03.6302025-04-02 04:21:03.630
    18
    		3307296012025-04-02 03:47:24.000
    2aH4U4JS9kLFsSQyuN9KaNCSbYrSMWa8Y56EpxBMcLQE9fjwzZcWBjdGQMzFmUzL7Qqf7XdN...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawr1chM2ABC3VBnZTDrF39kYAHF82RYmi8qE7rNXnyvbJ6a3m2EgFFKfsFuQtP4LJJXPcAe3TQYXNyHUjjZpUxYgd29.40038127G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD42025-04-02 03:53:08.000bdf60652fc25666d15c95bd957770cfa2025-04-02 04:21:03.6302025-04-02 04:21:03.630
    19
    		3306984872025-04-02 00:19:50.000
    j6GerioTcRymqK4XjnenJsBkk99WycWLDL1HVtctC1FLCGmvy1TJBRE3Gv2Ax2dD5ZW6CMjf...
    		FALSEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawCVuzsWwoCf2oC53tpjfqKBRFef794b3AmNsaNwBUCAZw3ne4mWqdYuNiYrYZC9TrA3FcfuFdErghH97vNPbjicr19.977533068So111111111111111111111111111111111111111122025-04-02 00:37:33.0005c6b7b89357476b2c3b68a122cb00b512025-04-02 04:21:03.6302025-04-02 04:21:03.630
    20
    		3307180762025-04-02 02:30:25.000
    2Pe7MuPf437FTBZFhinWFXchiF1GsKDfH9fzTFUdJkFzk6bFdR6xNQ8wodf2xBn8Mo9PRQJ3...
    		TRUEwhirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCcwithdrawkpqUj83k4ieDRZjh7HMqrjkb5tkn84xy642t4Zm1WKe8QaXeHBrShJTdtN1rWCccBxpSVvKksQ2PCu5nufb2zbk43028096.38264DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB2632025-04-02 02:36:13.0000c5c7d708d9e8c15f15bb7e26d65a5872025-04-02 04:21:03.6302025-04-02 04:21:03.630
    100
    45KB
    1s