date_trunc('week',BLOCK_TIMESTAMP)::date as "date(in)",

sum(amount) as "volume of usdt(in)",

sum("volume of usdt(in)") over (order by "date(in)") as "cumulative volume of usdt(in)"

from solana.core.fact_transfers a ,solana.core.dim_labels b

where a.tx_from = b.address and mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

group by 1

),usdt_out as (select

date_trunc('week',BLOCK_TIMESTAMP)::date as "date(out)",

sum(amount) as "volume of usdt(out)",

sum("volume of usdt(out)") over (order by "date(out)") as "cumulative volume of usdt(out)"

from solana.core.fact_transfers a , solana.core.dim_labels b

where a.tx_to = b.address and mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

group by 1

select

"date(in)",

"volume of usdt(in)",

"volume of usdt(out)",

"volume of usdt(in)" - "volume of usdt(out)" as "net flow",

sum("net flow") over (order by "date(in)") as "cumulative net flow"

from usdt_in inner join usdt_out on "date(in)"="date(out)"