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