winnie-fsCurrent lowest sell price 08.10.2024 copy
    Updated 2024-10-08
    -- forked from csp88g / Current lowest sell price 08.10.2024 @ https://flipsidecrypto.xyz/csp88g/q/inWCB2vMtGby/current-lowest-sell-price-08.10.2024

    with relic_actions_db as (select
    TX_HASH,
    BLOCK_TIMESTAMP,
    METHOD_NAME,
    RECEIVER_ID,
    PREDECESSOR_ID,
    SIGNER_ID,
    ARGS,
    LOGS,
    RECEIPT_SUCCEEDED
    from near.core.fact_actions_events_function_call
    where block_timestamp::date >= '2024-06-06'
    /*and tx_hash = 'Xc8EbEZwLTRYymMt5neEsBmsNoxpe1DmZK1d5XHoXWr'*/
    /*and RECEIVER_ID = 'aa-harvest-moon-relics.near'*/
    /*and method_name = 'nft_approve'*/
    /*and RECEIPT_SUCCEEDED = 'true'*/
    ),

    bad_tx as(
    select * from relic_actions_db
    where RECEIPT_SUCCEEDED = 'false'
    /*and METHOD_NAME = 'nft_on_approve'*/
    ),

    relic_actions_db_without_bad_chain_txs as(
    SELECT
    *
    FROM relic_actions_db
    WHERE
    TX_HASH
    NOT IN
    (
    SELECT TX_HASH FROM bad_tx
    )
    QueryRunArchived: QueryRun has been archived