satsihProjects Summary Stats Fees
    Updated 2023-05-16
    with
    near_prices as (
    SELECT
    date_trunc('hour', timestamp) as timestamp,
    symbol,
    avg(price_usd) as price_usd
    FROM
    near.core.fact_prices
    WHERE
    symbol = 'wNEAR'
    GROUP BY
    1,
    2
    ),
    near_transactions as (
    SELECT
    v.path as action,
    tx_hash,
    block_id,
    block_timestamp,
    nonce,
    tx_receiver,
    label_type,
    project_name,
    tx_signer,
    tx,
    gas_used,
    gas_used * price_usd as gas_used_usd,
    transaction_fee,
    transaction_fee * price_usd as transaction_fee_usd,
    price_usd
    FROM
    (
    SELECT
    tx_hash,
    block_id,
    Run a query to Download Data