dannyamahLinear Staking
    Updated 2025-05-14
    select
    block_timestamp,
    tx_hash,
    tx_signer,
    action_data:deposit / pow(10, 24) as near_staked
    from near.core.ez_actions
    where 1 = 1
    -- and tx_hash = 'C6nvnDHUGjexPyGfgkW8WesZYMZ6f3TycPBoFLaBacE7'
    and tx_receiver = 'linear-protocol.near'
    and receipt_receiver_id = 'linear-protocol.near'
    and action_name = 'FunctionCall'
    and action_data:method_name like '%deposit_and_stake' -- and action_data:method_name like '%stake'
    and receipt_succeeded
    and block_timestamp >= '2025-01-01'
    order by 1 desc
    Last run: about 1 month ago
    BLOCK_TIMESTAMP
    TX_HASH
    TX_SIGNER
    NEAR_STAKED
    1
    2025-05-13 07:52:55.7685WmFDrKq6UZhYqQR6uzxXMB12dCckRwrfF1ghAhu63Ajf3d2e647ab072b9077d6e9c86e4a0074803cfc17d2e491ee7103a197e47d3f0b14
    2
    2025-05-13 07:52:53.300BDckLikGKdzXnE3nAgmzSEk54SnM4bZbWPqoM9Ea88Tg59a564e3ad79dd91709c08480445186bcedb9fbc30dd3de7c7411b6d46ec309c14
    3
    2025-05-13 07:52:50.78589bZ7sRMcNR9bQ6PxosZ3Q4sPgxxjL4gaoVKtNKfNVFu53d1cdd2c6f31031ce4b77b06efc32b5facff6dd41d5867defed0ae332d7cb9c14
    4
    2025-05-13 07:52:48.2976RjdFe4HX4CrXk2GRavgSoRWqS6VVXQknoC6GHmxzmyn591a2c293c4a280c4745e2c45c5c332e6a3d011a0a85866890eb61af64d6839c14
    5
    2025-05-13 07:52:45.9962gaTHPHfckwKsVSQnKFcE6ooDiB8GehngozKt9xQHBqC2879de449011968bf54b3164bf5874c4bf834965e04792d5ec20c0fd1c638cd114
    6
    2025-05-13 07:52:36.652BLwiZTCnoLd7jKW3nnzBrhA2iWmPc1po2YTx2znSFMv9c650ab6a3fed1ca183328ad1f725ae7a6cfda4f92fbfb2143fd740448c2590b614
    7
    2025-05-13 07:52:32.548Gg2R4UVCWdXCUQEwXeTKkjyv2Lw27r4haNtDSoYKX7N91307d31fd673a540e6e11769c6d8176df8807f040b9079af0bbf11ea5b8f43f214
    8
    2025-05-13 07:52:29.3586z7xKvLFCbMDRd2T1x9nFCL5x2dRUoxFr7MGAbPKnJP8ae879bdf0260a56d5243c1f42908e150a75c6d07e3cde218b3d6fa4e5b112af214
    9
    2025-05-13 07:52:28.051DNqpe2AYYweCmEztsd3YDF7Hi5dSmkAWaVP7qagVcWX1406cd19fb42478dd71f183be0bcf020a38a46fea233c77770fe01326af4b962114
    10
    2025-05-13 07:52:23.7734f9fWg4EDmRwX9FjpiswASdbo2M49i2FgCmy3VRxVPbtf5d6b0fe407c698f2d8c7fe2872a8a6458e70fed4724153f32ef0de63d0428fa14
    11
    2025-05-13 07:35:07.7797d2BhUdW1d5jcSvaFmZjUMjLhgk9aXFB6WeWXDnVkeja8cffd3ff733b74deedeecdf9441acc1ff385dbf73837fe61010977563a432d6c14
    12
    2025-05-13 07:35:03.4774FaRiJUK6k1zVnr5i3b4fZ43uM7CG8FvgAMYBCMU1bAE7a0e0fa8947d0d60063b01e3ffeb11e1523658e4b5aa505461b05eeb2b03ca3a14
    13
    2025-05-13 07:35:02.439HefSH5qje7upt9BiiH1UBnphpdzuV6mkWFgCDkE43gBGf250af1ad5e4ae72bea30a7696e29f32d35379d62a769021a261447971c47da114
    14
    2025-05-13 07:34:59.016HRiqNB15f4QWWMtohAkxw5r3z1MLrbDE7oGZqFcs6pH21dea4f4c7d095ced18f684040f2ee98557fed3b55b09bd7b3ad7349f242d9bf414
    15
    2025-05-13 07:34:56.5525yv6ccM1N9YyShKSoCzDmX8afG7dhU14YwTFFxnMuLzq645ecd660b0f321bc486d698a451d1f614f0afe540515a2fe8a9df641cc9a5ba14
    16
    2025-05-13 07:34:52.7078xETxU4H9P6BbYH6tHZAMeuXp7iwWWA5zN385o1UZLsm03773544c1dc78304e41342f4be8bc18794b6352b8ad3b2066e84ddfd74a2ef614
    17
    2025-05-13 07:34:51.7485TuVmPWBcJs9DrdEbQLaAGFkY4qXFnKFzEakdTcwBR8B5107e4df94728fc43f5dc26dfd0f2f259e7ce0d3ac8296c6d31a8637a9d729d514
    18
    2025-05-13 07:34:48.393JBBank9UbzWuSLjSpePsfaDpZTpTCegwJ9t2GzXjaQrud949b489343a56312617cd6f9bffe1d65682783369191cad58ddf0520453304214
    19
    2025-05-13 07:34:45.6352aas1Y4YTGo1XWezdBASgTupLB99N8oLC6ESs7zVT4YE64e2465ad1d165a632502b9e168369d7c78a6ddc100335e9ee5025e444b6d4c114
    20
    2025-05-13 07:34:45.384sQNAbBLiPy8ksnqR8pos9jpoNYAyqAB1RRqQQAR3iabf9a9dc8d8cd1b7f827fb61739f1097f902226d4ec1d9aa26e94b8e9b869e06a914
    ...
    47737
    5MB
    20s