KaskoazulParas TVL
    Updated 2022-08-06
    with raw as (
    select ft.block_timestamp,
    ft.tx_signer,
    ft.tx_hash,
    ft.transaction_fee / pow (10,24) as fee_near,
    ftf.deposit / pow (10,24) as deposit_transfer,
    e.deposit / pow (10,24) as deposit_event,
    e.method_name
    from near.core.fact_transactions ft
    left join near.core.fact_transfers ftf
    on ft.tx_hash = ftf.tx_hash
    left join near.core.fact_actions_events_function_call e
    on ft.tx_hash = e.tx_hash
    where ft.tx_receiver = 'marketplace.paras.near'
    )

    select method_name,
    sum (deposit_event),
    count (distinct tx_hash)
    from raw
    group by 1
    order by 2 desc

    Run a query to Download Data