Pine Analyticsconvenient-green
    Updated 2025-03-19
    select
    date(block_timestamp) as date,
    count(distinct tx_id) as transactions,
    count(distinct tx_from) as senders,
    sum(amount / power(10, 9)) as volume_eth

    from eclipse.core.fact_transfers
    where tx_to like 'AsSKqK7CkxFUf3KaoQzzr8ZLPm5fFguUtVE5QwGALQQn'
    and mint like 'Eth1111111111111111111111111111111111111111'
    ---limit 100
    group by 1


    Last run: about 1 month ago
    DATE
    TRANSACTIONS
    SENDERS
    VOLUME_ETH
    1
    2025-01-24 00:00:00.000269218221.2643
    2
    2025-01-15 00:00:00.000438034652.28114
    3
    2025-01-08 00:00:00.000282921971.32008
    4
    2024-12-26 00:00:00.000465032712.34378
    5
    2025-03-10 00:00:00.000226612241.051409875
    6
    2024-12-15 00:00:00.000216713161.16528
    7
    2025-02-20 00:00:00.000229410140.81208
    8
    2024-12-12 00:00:00.000337518651.771165
    9
    2025-01-14 00:00:00.000294318881.50626
    10
    2024-12-23 00:00:00.000272418131.30964
    11
    2025-02-18 00:00:00.0006094360.26928
    12
    2024-12-29 00:00:00.000451828671.64314
    13
    2024-12-24 00:00:00.000483031512.41048
    14
    2025-02-21 00:00:00.000501418421.72346
    15
    2025-03-12 00:00:00.00015326890.879564577
    16
    2025-02-03 00:00:00.00010277750.4667
    17
    2024-10-23 00:00:00.000171891482614.0657587
    18
    2024-12-07 00:00:00.0005873820.089850695
    19
    2025-01-13 00:00:00.000229316081.1194
    20
    2025-03-09 00:00:00.00013815940.5364
    ...
    127
    6KB
    3s