BLOCK_TIMESTAMP | TX_ID | MSOL_ACTION | MSOL_AMOUNT | MSOL_MINTED | MSOL_BURNED | CLAIM_AMOUNT | CLAIM_AMOUNT_USD | DEX_ACTION | DEX_AMOUNT | DEX_TOKEN | STAKE_POOL_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-01-20 09:05:12.000 | 5K9KYwPwZeGBbozLxAW5Z2mP7jNV39cB4yCkKjV5s8siQgrwzXNEVBpHEzTNGcM4CghaGopP... | deposit | 0.491863951 | 0.391302556 | deposit | 491863951 | SOL | marinade | |||
2 | 2025-01-20 13:42:51.000 | 2yKB1BURNTjZVHtDqwB1Jgb18YUHR8xmW21NDrsLrxQE8sxm79NjG3vcwpiUtqbEdoJhi8RH... | deposit | 0.471759648 | 0.375308569 | deposit | 471759648 | SOL | marinade | |||
3 | 2025-01-20 14:26:34.000 | 4ECHdEqzx71dFtvL1knaD44BsxJ2vV3BKJ5iZKBnh9B3yitxTzZZgWnX8cUAuoQSorS9quqC... | deposit | 0.1 | 0.079555038 | deposit | 100000000 | SOL | marinade | |||
4 | 2025-01-20 14:32:23.000 | LF1tE9tRujSLia9wmwH4UxMP9RNtXRbv5wUuEFEtYvvi4yPA1qHiecSSyNH36FMk1WpAG9Ur... | deposit | 0.07 | 0.055688527 | deposit | 70000000 | SOL | marinade | |||
5 | 2025-01-20 16:52:20.000 | 4DbdMn1HmcqhNTwEuAtLeLCqY3fBgZKq5jMTFKuFY7ZdMgXdktDdjfTEGJtQUychJjiPQ18s... | deposit | 0.173946291 | 0.138383038 | deposit | 173946291 | SOL | marinade | |||
6 | 2025-01-20 16:57:49.000 | 3ex8694posg8bdJhCnRdKEtU59c1yewSCsgr5iSjUeBqDJY6pYVjPtLJwkBDeUd166uGbJpJ... | deposit | 0.00752524 | 0.005986707 | deposit | 7525240 | SOL | marinade | |||
7 | 2025-01-20 18:19:37.000 | 3awDa24BjH29J3LFCU5SW1vxo3WYvJihXrvzSxKsgqqPmXuBhdcGULoAiF3QqmAxWeZjsDVj... | deposit | 0.2 | 0.159110077 | deposit | 200000000 | SOL | marinade | |||
8 | 2025-01-20 20:41:03.000 | 66c5kyDrGWgA46byYFBKJSwWAk1H6zTRrZww8R4VqiBUdwQiz9kxjCqgp6uRJXyPewRQJCtF... | deposit | 0.055078799 | 0.043817959 | deposit | 55078799 | SOL | marinade | |||
9 | 2025-01-21 01:43:50.000 | 4TiNicAHEgVXhtkb1XmnGYC7ygAqQmufT8C85c6tNfesPCUzEcXjasft3tVNy75ZwajrhNiL... | deposit | 0.459705437 | 0.365718837 | deposit | 459705437 | SOL | marinade | |||
10 | 2025-01-21 03:05:49.000 | 2pmdGGhSswF7xDnp5Ny1TeEJXfeCjo93CE5wzgvhUKDdpaAZMCdaPqwEpzoFy9XpTYg3M7WQ... | deposit | 0.478649664 | 0.380789924 | deposit | 478649664 | SOL | marinade | |||
11 | 2025-01-21 18:38:47.000 | 56DKFVaxnVWQZuT8b7Py1YHpecPnfNHz3DN4iJx591d2GKtxncVDn2eCPY45o7x5W2DrrWaZ... | deposit | 0.03 | 0.023851091 | deposit | 30000000 | SOL | marinade | |||
12 | 2025-01-22 02:27:05.000 | 55fEjQGwgApWE4JDrATVEsd95Hkx3pkvBy64WinEughK6idhp1c9uoK8uoUWFwDYctKgSTU4... | deposit | 0.596128559 | 0.473943885 | deposit | 596128559 | SOL | marinade | |||
13 | 2025-01-22 02:46:56.000 | 3GmtHJwikDHk6X8yFfsYy1Y5y3Kia79Sw3nXzZY6PW5uJszAHXekmYeUVNzv6bfCqNCuzqKk... | deposit | 0.004766035 | 0.003789171 | deposit | 4766035 | SOL | marinade | |||
14 | 2025-01-22 02:59:41.000 | 55debzkcu8CXf7SGsQNgwN1Z1ZmDjHbvyZr4Ev5996NXxt4n3fiZvKn2ufKn2HxbXBBmnkzm... | deposit | 0.12633341 | 0.100439655 | deposit | 126333410 | SOL | marinade | |||
15 | 2025-01-22 16:57:24.000 | 2Q92Gy3jPNVMLcbHytVBiKQxxDtjzAWL3XYiyYVCpvsSPUQw5118LGUNpAWH6QEB69m3Mz2Z... | deposit | 0.024064 | 0.019131755 | deposit | 24064000 | SOL | marinade | |||
16 | 2025-01-23 06:15:23.000 | zpG54hgGpTc3wTW1voBHXw96puxiCbRnTPbs3YAxpm5jhJWX9quFvbM62XNLYVAE8UQxVRGh... | deposit | 9.8 | 6.755412518 | deposit | 8503908544 | SOL | marinade | |||
17 | 2025-01-23 06:15:23.000 | zpG54hgGpTc3wTW1voBHXw96puxiCbRnTPbs3YAxpm5jhJWX9quFvbM62XNLYVAE8UQxVRGh... | deposit | 9.8 | 6.755412518 | deposit | 1296091456 | SOL | marinade | |||
18 | 2025-01-23 07:42:32.000 | 61GRiCtg1GL6tBW2JT59QndVcDTfxFrd2eUsqWSZ5NdjvN47mQtaaKa8Wz8nk1oD6AZseo6b... | deposit | 0.261925652 | 0.208070891 | deposit | 261925652 | SOL | marinade | |||
19 | 2025-01-23 07:56:56.000 | 5UYk4T2niN7h2uWD159AcurTg9yeeUAczaxKtHZ7GtvDAjF8baRrwzCqBW8biqrVJYRVSRwa... | deposit | 5 | 3.971945655 | deposit | 5000000000 | SOL | marinade | |||
20 | 2025-01-23 13:51:57.000 | 3ebUB1P4GLNT8YNRXDkP9PdoxBqMpJvav2KZtxeSqygTq2rcze21kjQjrtYCJphmZL6w5zmK... | deposit | 10 | 7.94389131 | deposit | 10000000000 | SOL | marinade |
gigiokobaminor-maroon
Updated 2025-02-18
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 msol_activity AS (
SELECT
BLOCK_TIMESTAMP,
TX_ID,
ACTION_TYPE,
DEPOSIT_AMOUNT AS AMOUNT,
MSOL_MINTED,
MSOL_BURNED,
CLAIM_AMOUNT,
CLAIM_AMOUNT_USD
FROM solana.marinade.ez_liquid_staking_actions
WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
),
dex_trading AS (
SELECT
BLOCK_TIMESTAMP,
TX_ID,
ACTION,
AMOUNT,
TOKEN,
STAKE_POOL_NAME
FROM solana.defi.fact_stake_pool_actions
WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)
)
SELECT
m.BLOCK_TIMESTAMP,
m.TX_ID,
m.ACTION_TYPE AS MSOL_ACTION,
m.AMOUNT AS MSOL_AMOUNT,
m.MSOL_MINTED,
m.MSOL_BURNED,
m.CLAIM_AMOUNT,
m.CLAIM_AMOUNT_USD,
d.ACTION AS DEX_ACTION,
d.AMOUNT AS DEX_AMOUNT,
d.TOKEN AS DEX_TOKEN,
Last run: 26 days ago
...
187
37KB
4s