Wallets count by action

flyingfishWallets count by action

Updated 2023-11-02

-- forked from Stake Unstake on fliptables copy @ https://flipsidecrypto.xyz/edit/queries/41407410-dced-41c6-b41a-88c785f37f6e

-- forked from Stake Unstake on fliptables @ https://flipsidecrypto.xyz/edit/queries/3f0127e3-ee46-4467-a35a-8d4ecf593c87

-- SELECT

-- address

-- , action

-- , count(DISTINCT tx_id)

-- , sum(amount) / pow(10, 9) AS total

-- , max(tx_id) AS sampleTx

-- FROM solana.defi.fact_stake_pool_actions

-- WHERE block_timestamp > '2022-05-07'

-- --AND address = 'GpVtbNtHYm3VTGjn3dwNt9vm1fQsLho6QXCwukf8xYRv'

-- and stake_pool_name like 'blazestake'

-- AND succeeded

-- GROUP BY 1, 2

-- ORDER by 1

SELECT

DISTINCT action

, count(1)

, sum(amount) / pow(10, 9) AS total

, max(tx_id)

FROM solana.defi.fact_stake_pool_actions

WHERE block_timestamp > '2022-05-07'

--AND address = 'GpVtbNtHYm3VTGjn3dwNt9vm1fQsLho6QXCwukf8xYRv'

and stake_pool_name like 'blazestake'

AND succeeded

GROUP by 1

-- SELECT min(block_timestamp)

-- FROM solana.defi.fact_stake_pool_actions

-- WHERE stake_pool_name like 'blazestake'

-- AND succeeded

-- SELECT

-- amount / pow(10, 9) AS amount1

Run a query to Download Data