flipside

    Wayfinder Deposit & Increase Time
    freemartianWayfinder Deposit & Increase Time
    Updated 19 minutes ago
    WITH prices AS(
    SELECT
    hour::date AS price_day,
    AVG(price) AS price
    FROM ethereum.price.ez_prices_hourly
    WHERE token_address = '0xb23d80f5fefcddaa212212f028021b41ded428cf'
    AND hour::date >= '2024-06-01'
    GROUP BY 1
    ),

    deposits AS (
    SELECT
    block_timestamp,
    tx_hash,
    decoded_log:user AS user,
    decoded_log:amount / pow(10,18) AS amount,
    to_timestamp(decoded_log:createdTimestamp) AS createdTimestamp,
    to_timestamp(decoded_log:endTimestamp) AS endTimestamp,
    DATEDIFF(DAY, createdTimestamp, endTimestamp) AS difference_in_days,
    decoded_log:depositIndex AS depositIndex,
    decoded_log
    FROM ethereum.core.ez_decoded_event_logs
    WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
    AND event_name = 'DepositCreated'
    AND block_timestamp::date >= '2024-06-01'

    ),

    addtime AS (
    SELECT
    block_timestamp,
    tx_hash,
    decoded_log:user AS user,
    -- decoded_log:amount / pow(10,18) AS amount,
    to_timestamp(decoded_log:createdTimestamp) AS createdTimestamp,
    to_timestamp(decoded_log:endTimestamp) AS newTimestamp,
    Last run: 19 minutes agoAuto-refreshes every 1 hour
    LABEL
    USERS
    $PRIME Amount
    1
    		8 Months3091774655
    2
    		14 Months385903
    3
    		13 Months8370944
    4
    		19 Months265136
    5
    		18 Months202709397
    6
    		25 Months437588
    7
    		16 Months217858
    8
    		12 Months12362265972
    9
    		5 Months3682113842
    10
    		32 Months241274931
    11
    		Less Than 1 Month199468820
    12
    		3 Months25097942312
    13
    		22 Months94763
    14
    		11 Months1381735679
    15
    		6 Months20836175602
    16
    		1 Months24776793381
    17
    		27 Months34621240168
    18
    		35 Months244612964
    19
    		31 Months1582210949
    20
    		36 Months21019668060
    37
    917B
    43s