adriaparcerisasFlowty sales all time
    Updated 2025-01-27

    WITH
    prices AS (
    SELECT
    DATE_TRUNC('week', hour)::date AS week,
    symbol,
    AVG(price) AS price
    FROM flow.price.ez_prices_hourly
    WHERE symbol ='FLOW'
    GROUP BY 1, 2
    ),
    alls AS (
    SELECT
    DATE_TRUNC('week', BLOCK_TIMESTAMP)::date AS date,
    price AS "Flow price",
    event_data:paymentVaultType AS token,
    COUNT(DISTINCT tx_id) AS sales,
    COUNT(DISTINCT CASE
    WHEN EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2')
    AND EVENT_TYPE = 'ListingCompleted'
    THEN event_data:buyer::string
    WHEN EVENT_CONTRACT IN ('A.b8ea91944fd51c43.OffersV2')
    AND EVENT_TYPE = 'OfferCompleted'
    THEN event_data:offerAddress::string
    END) AS "Unique Buyers",
    COUNT(DISTINCT CASE
    WHEN EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2')
    AND EVENT_TYPE = 'ListingCompleted'
    THEN event_data:storefrontAddress::string
    WHEN EVENT_CONTRACT IN ('A.b8ea91944fd51c43.OffersV2')
    AND EVENT_TYPE = 'OfferCompleted'
    THEN event_data:acceptingAddress::string
    END) AS "Unique Sellers",
    SUM(CASE
    WHEN EVENT_CONTRACT IN ('A.3cdbb3d569211ff3.NFTStorefrontV2')
    AND EVENT_TYPE = 'ListingCompleted'
    Last run: 5 days ago
    DATE
    Sales
    Cumulative Sales
    Unique Buyers
    Unique Sellers
    Volume USD
    Total Volume USD
    Avg. NFT Price USD
    Max. Sale Price USD
    1
    2025-04-14 00:00:00.00020248121808712561263119396.970736723547.25936913.6772528245335
    2
    2025-04-07 00:00:00.0002470311978391853169991040.973116604150.28863914.3581785762850
    3
    2025-03-31 00:00:00.0004548611731361184103875198.814316513109.31552910.1569559752700
    4
    2025-03-24 00:00:00.000463591127650118888386872.59916437910.5012199.1306085055000
    5
    2025-03-17 00:00:00.000506371081291127096884812.874926351037.9021198.0228739195400
    6
    2025-03-10 00:00:00.0004133610306541235103492268.419646266225.02719910.6130093635100
    7
    2025-03-03 00:00:00.00029861989318116686569342.755376173956.6075599.7301791963000
    8
    2025-02-24 00:00:00.00025241959457107781673767.86376104613.85218914.5402785873500
    9
    2025-02-17 00:00:00.00026019934216116790369289.326046030845.98848913.0499371134050
    10
    2025-02-10 00:00:00.00024282908197126088972288.665515961556.66244913.5213010414250
    11
    2025-02-03 00:00:00.00022189883915145890563945.0830615889267.9969398.6219472123750
    12
    2025-01-27 00:00:00.00018147861726124696597227.49855825322.91387811.6728808548888
    13
    2025-01-20 00:00:00.00026498843579127991073991.6755985728095.4153789.00016080914999
    14
    2025-01-13 00:00:00.000394828170811043836586295654103.739783.3174535241450
    15
    2025-01-06 00:00:00.00026566777599120987272710.045595474.739789.5257404294300
    16
    2024-12-30 00:00:00.00030296751033116782973150.1145522764.699787.9200408227000
    17
    2024-12-23 00:00:00.00033544720737128084872844.295449614.5857810.551338963250
    18
    2024-12-16 00:00:00.00030917687193145691972949.815376770.295787.4458350344000
    19
    2024-12-09 00:00:00.00022856656276122684957966.665303820.485788.9994375375000
    20
    2024-12-02 00:00:00.00030603633420116085642616.285245853.825782.8424066312000
    ...
    118
    10KB
    95s