jennifertranCumulative Lifetime Flow Owned by All Flow Users (Percentile)
    Updated 2023-10-26
    with
    inoContracts as (
    select
    event_contract
    from
    flow.core.dim_contract_labels
    where
    contract_name like '%ZeedzINO%'
    ),
    inoItems as (
    select
    event_contract
    from
    flow.core.dim_contract_labels
    where
    contract_name like '%ZeedzMarketplace%'
    ),
    inoOwners as (
    select distinct
    (buyer)
    from
    flow.core.ez_nft_sales sales
    join inoContracts on inoContracts.event_contract = sales.nft_collection
    where
    nft_collection is not null
    group by
    buyer
    ),
    flowOwnersByInoOwners as (
    select
    sum(amount) as cumulative_flow_owned,
    recipient
    from
    flow.core.ez_token_transfers
    where
    token_contract = 'A.1654653399040a61.FlowToken'
    Run a query to Download Data