satsihProjects Summary Stats Transactions
Updated 2023-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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,