greyswantrading share of NFTfi
    Updated 2023-08-31
    with NFT_fi_users as (
    select
    distinct date_trunc('month', block_timestamp) as week,
    signers [0] as user
    from
    solana.core.fact_events
    where
    program_id in (
    'SHARKobtfF1bHhxD2eqftjHBdVSCbKo9JtgK71FhELP',
    'A66HabVL3DzNzeJgcHYtRRNW1ZRMKwBfrdSR4kLsZ9DJ',
    '4tdmkuY6EStxbS6Y8s5ueznL3VPMSugrvQuDeAHGZhSt',
    'JCFRaPv7852ESRwJJGRy2mysUMydXZgVVhrMLmExvmVp',
    'RainEraPU5yDoJmTrHdYynK9739GkEfDsE4ffqce2BR'
    ) --sharky, frakt_old, frakt_bonds, citrus, rain
    and block_timestamp > CURRENT_DATE - 90
    AND succeeded = 'TRUE'
    ),
    weekly_volumes as (
    select
    date_trunc('month', block_timestamp) as week,
    sum(sales_amount) as total_volume
    from
    solana.nft.fact_nft_sales
    where
    succeeded = 'TRUE'
    and marketplace='tensorswap'
    group by
    date_trunc('month', block_timestamp)
    ),
    volumes_by_nftfi as (
    select
    week,
    sum (sales_amount) as nftfi_volume
    from
    NFT_fi_users
    left join solana.nft.fact_nft_sales on user = seller
    Run a query to Download Data