RayyykShapeShift Cosmos Validator Rev
    Updated 14 hours ago
    with old_wallet as (select date_trunc('{{granularity}}', block_timestamp) as date,
    sum(amount/1e6) as atom_received
    from cosmos.core.fact_transfers
    where receiver = 'cosmos1qgmqsmytnwm6mhyxwjeur966lv9jacfexgfzxs' --Old wallet
    and sender = 'cosmos199mlc7fr6ll5t54w7tts7f4s0cvnqgc5q80f26' --ShapeShift DAO
    group by 1),

    new_wallet as (select date_trunc('{{granularity}}', block_timestamp) as date,
    sum(amount/1e6) as atom_received
    from cosmos.core.fact_transfers
    where receiver = 'cosmos173g2xx98e3fs0t4fnmgfl69g5l3qu4vndgtsel' --New wallet
    and sender = 'cosmos199mlc7fr6ll5t54w7tts7f4s0cvnqgc5q80f26' --ShapeShift DAO
    group by 1),

    price as (select date_trunc('{{granularity}}', hour) as date,
    avg(price) as atom_price
    from crosschain.price.ez_prices_hourly
    where symbol = 'ATOM'
    and blockchain = 'cosmos'
    and name = 'Cosmos Hub'
    and token_address = 'uatom'
    --and date >= '2023-10-01'
    group by 1),

    final as (select a.date,
    atom_received,
    atom_received * atom_price as usd_received
    from old_wallet a
    join price b on a.date = b.date

    union

    select a.date,
    atom_received,
    atom_received * atom_price as usd_received
    from new_wallet a
    Last run: about 15 hours agoAuto-refreshes every 24 hours
    DATE
    ATOM_RECEIVED
    USD_RECEIVED
    CUMU_ATOM_RECEIVED
    CUMU_USD_RECEIVED
    START_DATE
    END_DATE
    1
    2025-02-01 00:00:00.000231.21117.66066206920173.337182056.53300859901/01/20232025-02-12 00:00:00.000
    2
    2025-01-01 00:00:00.000497.63216.82348387119942.137180938.8723465301/01/20232025-02-12 00:00:00.000
    3
    2024-12-01 00:00:00.000494.14013.51984274219444.537177722.04886265901/01/20232025-02-12 00:00:00.000
    4
    2024-11-01 00:00:00.000470.9872817.20219901418950.437173708.52901991801/01/20232025-02-12 00:00:00.000
    5
    2024-10-01 00:00:00.000479.092148.58342298418479.45170891.32682090401/01/20232025-02-12 00:00:00.000
    6
    2024-09-01 00:00:00.000744.123248.61088518000.36168742.7433979201/01/20232025-02-12 00:00:00.000
    7
    2024-08-01 00:00:00.000655.43213.40681989217256.24165494.1325129201/01/20232025-02-12 00:00:00.000
    8
    2024-07-01 00:00:00.000839.045224.09535483916600.84162280.72569302701/01/20232025-02-12 00:00:00.000
    9
    2024-06-01 00:00:00.000657.844884.41631666715761.8157056.63033818901/01/20232025-02-12 00:00:00.000
    10
    2024-05-01 00:00:00.000665.685756.03872892815103.96152172.21402152201/01/20232025-02-12 00:00:00.000
    11
    2024-04-01 00:00:00.000837.997906.41332060614438.28146416.17529259401/01/20232025-02-12 00:00:00.000
    12
    2024-03-01 00:00:00.000628.177804.80615137813600.29138509.76197198701/01/20232025-02-12 00:00:00.000
    13
    2024-02-01 00:00:00.000597.965996.54398875312972.12130704.95582060901/01/20232025-02-12 00:00:00.000
    14
    2024-01-01 00:00:00.000636.146297.64475865312374.16124708.41183185601/01/20232025-02-12 00:00:00.000
    15
    2023-12-01 00:00:00.000734.47892.6529647211738.02118410.76707320301/01/20232025-02-12 00:00:00.000
    16
    2023-11-01 00:00:00.000901.68054.0453485711003.62110518.11410848301/01/20232025-02-12 00:00:00.000
    17
    2023-10-01 00:00:00.000222.61531.35017044510102.02102464.06875991301/01/20232025-02-12 00:00:00.000
    18
    2023-10-01 00:00:00.000869.155979.21383936510102.02102464.06875991301/01/20232025-02-12 00:00:00.000
    19
    2023-09-01 00:00:00.000852.765916.5375277279010.2794953.50475010301/01/20232025-02-12 00:00:00.000
    20
    2023-08-01 00:00:00.000810.746458.8016378368157.5189036.96722237601/01/20232025-02-12 00:00:00.000
    27
    3KB
    36s