flipside

    Circulation
    libruaryCirculation
    Updated 2025-02-11
    WITH MintEvents AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS event_week,
    COUNT(*) AS moments_minted
    FROM flow.core.fact_events
    WHERE event_contract = 'A.0b2a3299cc857e29.TopShot'
    AND event_type = 'MomentMinted'
    GROUP BY event_week
    ),
    BurnEvents AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS event_week,
    COUNT(*) AS moments_burned
    FROM flow.core.fact_events
    WHERE event_contract = 'A.0b2a3299cc857e29.TopShot'
    AND event_type = 'MomentDestroyed'
    GROUP BY event_week
    ),
    NewCollectors AS (
    SELECT
    DATE_TRUNC('week', MIN(block_timestamp)) AS first_collection_week,
    event_data:to AS wallet_address
    FROM flow.core.fact_events
    WHERE event_contract = 'A.0b2a3299cc857e29.TopShot'
    AND event_type = 'Deposit'
    GROUP BY event_data:to
    ),
    DailyNewCollectors AS (
    SELECT
    first_collection_week AS event_week,
    COUNT(DISTINCT wallet_address) AS new_collectors
    FROM NewCollectors
    GROUP BY first_collection_week
    ),
    LockEvents AS (
    SELECT
    Last run: 2 months ago
    EVENT_WEEK
    MOMENTS_MINTED
    MOMENTS_BURNED
    NEW_COLLECTORS
    MOMENTS_LOCKED
    MOMENTS_UNLOCKED
    MOMENTS_DEPOSITED
    MOMENTS_WITHDRAWN
    RUNNING_TOTAL_MINTED
    RUNNING_TOTAL_BURNED
    RUNNING_TOTAL_COLLECTORS
    RUNNING_TOTAL_LOCKED
    RUNNING_TOTAL_IN_LOCKEROOM
    RUNNING_TOTAL_CIRCULATING
    1
    		2020-08-17 00:00:00.00000259000000259000
    2
    		2020-08-24 00:00:00.00016008014600001600804050016008
    3
    		2020-08-31 00:00:00.000150010700001615805120016158
    4
    		2020-09-07 00:00:00.00022766014800003892406600038924
    5
    		2020-09-14 00:00:00.00021047012500005997107850059971
    6
    		2020-09-21 00:00:00.0001500379000060121011640060121
    7
    		2020-09-28 00:00:00.000145237071600002053580188000205358
    8
    		2020-10-05 00:00:00.000150036600002055080224600205508
    9
    		2020-10-12 00:00:00.000101816017500003073240242100307324
    10
    		2020-10-19 00:00:00.00050921031800003582450273900358245
    11
    		2020-10-26 00:00:00.000286012700003585310286600358531
    12
    		2020-11-02 00:00:00.00016088011800003746190298400374619
    13
    		2020-11-09 00:00:00.0001500607300003896250305700389625
    14
    		2020-11-16 00:00:00.00042747012900004323720318600432372
    15
    		2020-11-23 00:00:00.000117507300004335470325900433547
    16
    		2020-11-30 00:00:00.0001178011800004347250337700434725
    17
    		2020-12-07 00:00:00.00052389016900004871140354600487114
    18
    		2020-12-14 00:00:00.0007291020500004944050375100494405
    19
    		2020-12-21 00:00:00.00048416029500005428210404600542821
    20
    		2020-12-28 00:00:00.000135120043200006779410447800677941
    ...
    235
    23KB
    140s