KaskoazulMeta Pool
    Updated 2022-08-07
    with raw_to as (
    select t.tx_hash,
    t.block_timestamp,
    t.tx_signer,
    try_parse_json (t.tx) as p_tx,
    t.transaction_fee / pow(10,24) as fee,
    e.action_name, --if function_call table, all are FunctionCall
    e.method_name,
    e.deposit / pow(10,24) as e_deposit,
    p_tx:actions[0]:FunctionCall:args as args,
    p_tx:actions[0]:FunctionCall:deposit as deposit,
    p_tx:actions[0]:FunctionCall:method_name as p_method_name,
    --base64_decode_string (r.receipt_object_id) as d_1,
    --base64_decode_string (r.receipt_outcome_id[0]) as d_2,
    r.receipt_object_id as d_1,
    r.receipt_outcome_id as d_3,
    r.status_value,
    r.logs
    from near.core.fact_transactions t
    left join near.core.fact_actions_events_function_call e
    on t.tx_hash = e.tx_hash
    left join near.core.fact_receipts r
    on t.tx_hash = r.tx_hash
    where t.tx_receiver = 'meta-pool.near'
    )

    select method_name, count (tx_hash) from raw_to group by 1

    Run a query to Download Data