marquTensorians Traits - [sales] fp and vol by faction
    Updated 2024-12-16
    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
    No Data to Display
    0
    2B
    20s