pietrektthorwallet staking deposits
    Updated 2024-02-05
    select to_date(block_timestamp) as day, coalesce(sum(amount),0) as amount, coalesce(sum(amount_usd),0) as amount_usd from ethereum.core.ez_token_transfers
    where CONTRACT_ADDRESS = '0x108a850856db3f85d0269a2693d896b394c80325' and TO_ADDRESS = '0x77f400a7af20d22f387503dba3979ba28d8af48b' group by day order by day DESC

    Last run: about 1 year ago
    DAY
    AMOUNT
    AMOUNT_USD
    1
    2024-02-04 00:00:00.00083875.341602451105.327753466
    2
    2024-02-03 00:00:00.00019743.82203964265.106419111
    3
    2024-02-02 00:00:00.000195819.589099672631.323473272
    4
    2024-02-01 00:00:00.00035547.01235471470.704631497
    5
    2024-01-31 00:00:00.000492051.588880246725.494792379
    6
    2024-01-29 00:00:00.000315.497224184.459597433
    7
    2024-01-28 00:00:00.00047778.63507786667.015280397
    8
    2024-01-26 00:00:00.000480.737335177.385370578
    9
    2024-01-25 00:00:00.00033016.89058171442.626837564
    10
    2024-01-24 00:00:00.0001354636.0747758617890.475444154
    11
    2024-01-23 00:00:00.00081684.581217921077.249296413
    12
    2024-01-20 00:00:00.00080045.171881751155.045201466
    13
    2024-01-19 00:00:00.000124786.6449272006.334651534
    14
    2024-01-18 00:00:00.000879276.3414032214139.778349251
    15
    2024-01-17 00:00:00.00037583.48030295727.435844813
    16
    2024-01-15 00:00:00.0009229.80240509173.851514867
    17
    2024-01-14 00:00:00.0003000005829.435
    18
    2024-01-13 00:00:00.000272752.963184955122.914669881
    19
    2024-01-12 00:00:00.0002444004956.769272
    20
    2024-01-11 00:00:00.00069782.095702741341.114885637
    ...
    755
    43KB
    9s