select
date_trunc('day',block_timestamp) as block_day,
2*sum(amount) as LP_liquidity,
count(*) as transaction_count
from algorand.transfers
where receiver = 'FPOU46NBKTWUZCNMNQNXRWNW3SMPOOK4ZJIN5WSILCWP662ANJLTXVRUKA'
and block_day > '2022-02-01'
and asset_id = '31566704' --or asset_id = '312769')
group by block_day, asset_id
order by block_day