flipside

    NFT
    0xHaM-dNFT
    Updated 2024-12-21
    WITH nft_contracts AS (
    SELECT
    cm.contract_address,
    cm.name,
    cm.tokens,
    nm.tx_hash,
    nm.block_timestamp,
    nm.token_id,
    nm.method_name,
    nm.deposit,
    nm.implied_price,
    nm.tx_receiver,
    nm.receiver_id,
    nm.signer_id,
    nm.owner_id,
    nm.owner_per_tx,
    nm.mint_per_tx,
    nm.transaction_fee,
    nm.tx_status
    FROM near.nft.dim_nft_contract_metadata AS cm
    INNER JOIN near.nft.fact_nft_mints AS nm
    ON cm.contract_address = nm.tx_receiver
    AND cm.contract_address = nm.receiver_id
    AND nm.block_timestamp::DATE >= '2023-01-01'
    WHERE nm.tx_status = 'Success'
    ),
    prices AS (
    SELECT
    AVG(price) AS price
    FROM near.price.ez_prices_hourly
    WHERE symbol = 'NEAR'
    AND hour::DATE >= CURRENT_DATE() - INTERVAL '24 hour'
    )
    SELECT
    date_trunc('quarter', block_timestamp) as "Date",
    case
    Last run: 3 months ago
    Date
    Quarter
    YEAR
    Sales Vol(NEAR)
    Change in Sales Vol(NEAR) in Percent
    N_SALES
    Change in # Sales in Percent
    N_HOLDERS
    Change in # Holders in Percent
    1
    		2023-01-01 00:00:00.000Q1-Months [1 To 3]-23y.2023270700.6385556536036523037
    2
    		2023-04-01 00:00:00.000Q2-Months [4 To 6]-23y.2023124660.659136436-541117528547866108
    3
    		2023-07-01 00:00:00.000Q3-Months [7 To 9]-23y.2023613637.593041793392158817426795642
    4
    		2023-10-01 00:00:00.000Q4-Months [10 To 12]-23y.202348776.035694423-9287852-4528797-58
    5
    		2024-01-01 00:00:00.000Q1-Months [1 To 3]-24y.202425653.652778627-47492037460287067897
    6
    		2024-04-01 00:00:00.000Q2-Months [4 To 6]-24y.202478276.69983073320581790-8362822-78
    7
    		2024-07-01 00:00:00.000Q3-Months [7 To 9]-24y.202423001.215304761-7132885-6022105-65
    8
    		2024-10-01 00:00:00.000Q4-Months [10 To 12]-24y.202461540.15812752216811305124455758152
    8
    821B
    3s