Updated 2022-10-07
    with tbl1 as (select sum(t.amount) as outflow_amount, tx_to
    from solana.core.fact_transfers t,solana.core.dim_labels l
    where t.TX_TO = l.address
    and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    group by 2
    order by 1 DESC
    limit 9)

    select sum(t.amount) as outflow_amount, tx_to , date_trunc(week,BLOCK_TIMESTAMP)::date as outflow_date
    from solana.core.fact_transfers t,solana.core.dim_labels l
    where t.TX_TO = l.address
    and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' and tx_to in (select tx_to from tbl1)
    group by 2 , 3
    Run a query to Download Data