jennifertranCumulative Lifetime Flow Owned by All Pre-Sale Zeedz Owners
    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 transfers
    join inoOwners on inoOwners.buyer = transfers.recipient
    where