This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| toStartOfHour(block_timestamp) as hour, | |
| SUM(arraySum( | |
| arrayMap( | |
| x -> max2(toDecimal128(x.after, 9) - toDecimal128(x.before, 9), 0), | |
| arrayFilter(x -> x.account IN [ | |
| '96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5', | |
| 'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe', | |
| 'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY', | |
| 'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49', |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. 5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1 Raydium Authority V4. Swaping assets. | |
| 2. ChGA1Wbh9WN8MDiQ4ggA5PzBspS2Z6QheyaxdVo3XdW6 $IMG. Sending rewards. | |
| 3. 4VztozdDL8yFPLdpUpMNT3Hf7xMZ2qPGAMretExTvZ78 Kamino. Lending assets. | |
| 4. Dx8iy2o46sK1DzWbEcznqSKeLbLVeu7otkibA3WohGAj Kamino. Reserve account. | |
| 5. 62qc2CNXwrYqQScmEdiZFFAnJR262PxWEuNQtxfafNgV pump.fun. Collecting fees. | |
| 6. 7LCZckF6XXGQ1hDY6HFXBKWAtiUgL9QY5vj1C4Bn1Qjj Jito Staking. | |
| 7. GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL Raydium Vault | |
| 8. 5XFdrMqisKzNBvx68GYR8ULuXkaDefLAHTojVYyrhKt9 Fluxbeam. | |
| 9. MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa Wintermute. Trading. | |
| 10. 28KqHiudrpzfVkVWQ1jztQ2Aarf4W3CvTitjWEqTCkpA Pool? |