kidaNEAR Contract Visualizer (circle)
    Updated 2024-01-30
    with call_contracts as (
    select
    block_timestamp::date as date,
    lower(trim(project_name)) as project_name,
    count(method_name) as call_contracts,
    count(
    DISTINCT(tx_hash)
    ) as transactions,
    count(
    DISTINCT(signer_id)
    ) as users
    from
    near.core.fact_actions_events_function_call a
    join near.core.dim_address_labels b on a.receiver_id = b.address
    where
    block_timestamp::date >= '2021-01-01'
    and block_timestamp::date <= CURRENT_DATE
    and (lower(trim(project_name)) IN ('usdc') or lower(trim(b.address)) IN ('usdc'))
    group by
    1,2
    ),
    volume as (
    select
    block_timestamp::date as date,
    lower(trim(b.project_name)) as project_name,
    sum(
    deposit / pow(10, 24)
    ) as near_amount,
    avg(
    deposit / pow(10, 24)
    ) as avg_near_amount
    from
    NEAR.core.fact_transfers a
    join near.core.dim_address_labels b on a.tx_receiver = b.address
    where
    block_timestamp::date >= '2021-01-01'
    Last run: over 1 year agoAuto-refreshes every 3 hours
    DATE
    PROJECT_NAME
    USERS
    TRANSACTIONS
    CALL_CONTRACTS
    NEAR_AMOUNT
    AVG_NEAR_AMOUNT
    GAS_AMOUNT
    AVG_GAS_AMOUNT
    CUM_NEAR_AMOUNT
    CUM_TRANSACTIONS
    CUM_CALL_CONTRACTS
    1
    2021-04-23 00:00:00.000usdc122000.00066690159690.0006669015969022
    2
    2021-04-26 00:00:00.000usdc1330.037201274030.018600637020.0020660784820.00068869282750.0372012740355
    3
    2022-09-12 00:00:00.000usdc133000.00063941189510.00063941189510.0372012740388
    4
    2022-09-13 00:00:00.000usdc255000.0012861778890.00064308894440.037201274031313
    5
    2022-09-26 00:00:00.000usdc133000.00064492911460.00064492911460.037201274031616
    6
    2022-10-07 00:00:00.000usdc244000.0012235398610.00061176993050.037201274032020
    7
    2022-10-11 00:00:00.000usdc222000.00061528954110.00061528954110.037201274032222
    8
    2022-10-12 00:00:00.000usdc222000.00061234201080.00061234201080.037201274032424
    9
    2022-10-13 00:00:00.000usdc111000.00061024185160.00061024185160.037201274032525
    10
    2022-10-17 00:00:00.000usdc366000.0018285173040.00060950576790.037201274033131
    11
    2022-10-18 00:00:00.000usdc388000.0024473013710.00061182534290.037201274033939
    12
    2022-10-19 00:00:00.000usdc11100000.037201274034040
    13
    2022-10-20 00:00:00.000usdc111000.00060548302570.00060548302570.037201274034141
    14
    2022-10-22 00:00:00.000usdc111000.00060716138610.00060716138610.037201274034242
    15
    2022-10-23 00:00:00.000usdc11100000.037201274034343
    16
    2022-10-24 00:00:00.000usdc233000.0012222452350.00061112261770.037201274034646
    17
    2022-10-27 00:00:00.000usdc488000.0030713475720.00061426951440.037201274035454
    18
    2022-10-28 00:00:00.000usdc333000.00061797600270.00061797600270.037201274035757
    19
    2022-10-30 00:00:00.000usdc122000.00060226504950.00060226504950.037201274035959
    20
    2022-10-31 00:00:00.000usdc51111000.0036597707790.00060996179650.037201274037070
    ...
    194
    23KB
    336s