No Data to Display
marquTensorians Traits - [sales] fp and vol by faction
Updated 2024-12-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
tensorians_dim_nft_metadata_call as (
select
f.value[12] as faction
, f.value[16] as leaf_index
, f.value[17] as merkle_tree
from ( -- tensorians.helius_das.dim_nft_metadata
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/queries/0800c2d3-c3f2-4b58-ad3a-7dad9638b676/latest-run'
) :data :data as data
) response
inner join lateral flatten (input => response.data) f
where f.value[15] ::boolean -- compressed
and not f.value[12] in ('Unrevealed', 'n/a')
),
tensor_cnft_txs as (
select
block_timestamp
, tx_id
, signers[0] as user_address
, iff((post_balances[0] + fee) < pre_balances[0], 'buy', 'sell') as label_action
, abs(post_balances[0] - pre_balances[0] + iff(label_action = 'buy', +fee, -fee)) / pow(10,9) as amount
, merkle_tree
, leaf_index
, faction
from solana.core.fact_events
inner join solana.core.fact_transactions
using(tx_id, block_timestamp, succeeded)
Last run: 2 months ago
0
2B
20s