SELECT

date_trunc('day', block_timestamp) as day1,

count(*) as Alammex_swaps,

count(DISTINCT sender) as Alammex_user

FROM flipside_prod_db.algorand.asset_transfer_transaction

WHERE asset_RECEIVER LIKE 'H5T5FHYHVC2GFEZS6YQP27QVNCSMSNXCVMALDONJXFCL3L5NN4BKDMISGA'

GROUP BY 1

), tab2 as (

SELECT

date_trunc('day', block_timestamp) as day2,

count(*) as swaps

FROM flipside_prod_db.algorand.swaps

GROUP BY 1

SELECT

*,

(Alammex_swaps / swaps) * 100 as Alammex_swap_percent

from tab1 JOIN tab2

on day1 = day2

where day1 > '2022-06-27'