flipside

    magic L by amount power
    Spectermagic L by amount power
    Updated 1 day ago

    WITH staking_p AS (
    SELECT
    TRUNC(block_timestamp, 'day') AS day, -- Staking date
    block_timestamp,
    tx_id,
    signers[0] AS owner,
    utils.udf_hex_to_int(
    TO_CHAR(REVERSE(TO_BINARY(SUBSTR(utils.udf_base58_to_hex(instruction:data), 19, 16))))
    ) / POW(10, 6) AS amount_staked, -- Amount staked in human-readable format
    TO_TIMESTAMP(
    utils.udf_hex_to_int(
    TO_CHAR(REVERSE(TO_BINARY(SUBSTR(utils.udf_base58_to_hex(instruction:data), 35, 8))))
    )
    ) AS lockup_end, -- Lockup period end timestamp
    DATEDIFF(
    'day',
    block_timestamp, -- Staking start date
    TO_TIMESTAMP(
    utils.udf_hex_to_int(
    TO_CHAR(REVERSE(TO_BINARY(SUBSTR(utils.udf_base58_to_hex(instruction:data), 35, 8))))
    )
    )
    ) AS lockup_days, -- Duration in days
    -- Calculate the linear multiplier:
    1 + ((DATEDIFF(
    'day',
    block_timestamp,
    TO_TIMESTAMP(
    utils.udf_hex_to_int(
    TO_CHAR(REVERSE(TO_BINARY(SUBSTR(utils.udf_base58_to_hex(instruction:data), 35, 8))))
    )
    )
    ) - 1) / (1460 - 1)) * (20 - 1) AS multiplier,
    -- Calculate staking power:
    (utils.udf_hex_to_int(
    Last run: 1 day ago
    OWNER
    STAKING_POWER
    LOCKUP_DAYS
    TOTAL_$ME_STAKED
    1
    DacS8RDKw8TW3vAepdBZnW2nkjhZ7F4Jen8zCVX2QBif
    		125522233.8015282199585096.3
    2
    FyvheU2DJKM8R2La2Vkgig3Z8pk5dSSsSUoQnvrS2cVN
    		46160170.78269312136621918.79
    3
    FQ7GqeTvCcrC6rMkdyNv3AExK24V6yZPF9zAcdszCDVd
    		25813427.57012342120479500.663352
    4
    CQv91Qc5XcJLom1rKK7MA4iiKhYEZYxTWU6993de6cYv
    		19795191.47147822115704835.623632
    5
    28x3ZrnQxhtmy2aBfgMCrNwJwirTYWg4okRhpzitAf7p
    		16941499.35971442113440812.787567
    6
    56KXi5P5Nuz8mBhZHsjhqckCE1XGXVKnTptxb1AzX1Ej
    		16678441.84555622113232111.85
    7
    hUc6Va4UZSLud7Xh9dDxCBzp99sg6WEhGhRMcZEUeat
    		15812310.98723752112544952.911525
    8
    6eEEaqsASzNbrLBRgMCS9z7zrREukegooSi5wazR8nWF
    		157556502112500000
    9
    6YXpqkJwhibXPmQLtesgHBJMicKGqmG7ypLhLyxWBoym
    		15404880.95897312112221711.702606
    10
    Fko4bWKFf6WfKXPXMSkyKss6EnS6p74F9iAo4Lkh5FUo
    		14795363.1506232111738140.881702
    11
    37J83icQt28vxLAjaLQCou4ZJ12joBrtx797sm7w5Lja
    		13686271.71460832110858225.235557
    12
    FCudY8ZJwQDVdtziVcphNHrPweJXSdQPuzaGSfa1a8QT
    		13525072.01785112110730334.846429
    13
    5pUaPDkPsS5rDXbC7tWD1oeFZCHDc7Vp9wEEiCuJ1LCP
    		12443300.7131075219872094.068721
    14
    7UVGx6SLLRoWgnF4q6mnqNAfKh8bcnNc9uWAwX1fvUME
    		12230891.0957079219703575.46
    15
    7UVGx6SLLRoWgnF4q6mnqNAfKh8bcnNc9uWAwX1fvUME
    		10993763.3314142218722080.12
    16
    7UVGx6SLLRoWgnF4q6mnqNAfKh8bcnNc9uWAwX1fvUME
    		10767997.8999879218542965.46
    17
    4GXd72dX76aAfBVdb91LspdWPtvarQjvgnZ4dqu6rEoJ
    		10753775.1026396218531681.573467
    18
    5RPL9MhTwq39b3bJCd7FtDNRjrAAbnFhSShJZEP2wHWU
    		8968646.90501381217115421.217955
    19
    9c9LuNLtJTKWCq4mmhMuuy3oWTnPquDUjw5q7nbCMjio
    		8081780.28192917216411811.224806
    20
    GqS5HKaukRfv6o8ieMug6GRB6qE3trk5DaacUzphSTX
    		7772125.54910082216166141.629432
    100
    8KB
    125s