Flipside TeamDIP4 Logs - token_diff Count Metrics
    Updated 58 minutes ago
    with dip4_logs as (
    select
    block_timestamp,
    tx_hash,
    receipt_object_id AS receipt_id,
    predecessor_id,
    signer_id,
    receiver_id,
    coalesce(
    try_parse_json(clean_log) :data[0] :account_id :: string,
    try_parse_json(clean_log) :data :account_id :: string
    ) as participant_address,
    coalesce(
    try_parse_json(clean_log) :data[0] :diff :: VARIANT,
    try_parse_json(clean_log) :data :diff :: VARIANT
    ) as token_diff
    from
    near.core.fact_logs
    where
    receiver_id = 'intents.near'
    and block_timestamp >= '2024-11-01'
    and try_parse_json(clean_log) :standard :: STRING = 'dip4'
    and try_parse_json(clean_log) :event :: STRING = 'token_diff'
    ),
    count_agg as (
    select
    date_trunc('day', block_timestamp) :: date as date,
    count(distinct tx_hash) as tx_ct,
    count(distinct receipt_id) as receipt_ct,
    count(distinct participant_address) as participants_ct
    from
    dip4_logs
    group by
    1
    )
    select
    Last run: about 1 hour agoAuto-refreshes every 24 hours
    DATE
    TX_CT
    TX_CT_CUM
    RECEIPT_CT
    RECEIPT_CT_CUM
    PARTICIPANTS_CT
    PARTICIPANTS_CT_CUM
    TX_CT_MA7
    RECEIPT_CT_MA7
    PARTICIPANTS_CT_MA7
    1
    2024-11-05 00:00:00.000101010106610106
    2
    2024-11-06 00:00:00.00041514151172325.525.511.5
    3
    2024-11-07 00:00:00.000321372321372254812412416
    4
    2024-11-08 00:00:00.0002896612896611664165.25165.2516
    5
    2024-11-09 00:00:00.00055716557161276143.2143.215.2
    6
    2024-11-10 00:00:00.00074790747902197131.666131.66616.166
    7
    2024-11-11 00:00:00.00043833438332412111911917.285
    8
    2024-11-12 00:00:00.000558885588822143125.428125.42819.571
    9
    2024-11-13 00:00:00.00012900129008151121.285121.28518.285
    10
    2024-11-14 00:00:00.00042942429422117281.42881.42817.714
    11
    2024-11-15 00:00:00.00051993519931418647.42847.42817.428
    12
    2024-11-16 00:00:00.000161009161009919541.85741.85717
    13
    2024-11-17 00:00:00.0004101341013520031.85731.85714.714
    14
    2024-11-18 00:00:00.0002910422910421521529.85729.85713.428
    15
    2024-11-19 00:00:00.0002710692710691823325.85725.85712.857
    16
    2024-11-20 00:00:00.0003311023311021224528.85728.85713.428
    17
    2024-11-21 00:00:00.0001611181611181225725.14225.14212.142
    18
    2024-11-22 00:00:00.0003811563811562828523.28523.28514.142
    19
    2024-11-23 00:00:00.0005712135712133632129.14229.14218
    20
    2024-11-24 00:00:00.0001312261312261433530.42830.42819.285
    ...
    103
    7KB
    245s