WITH open_sea AS(
SELECT
BLOCK_TIMESTAMP,
event_inputs:value::number / pow(10,18) as fee,
tx_id
FROM polygon.events_emitted
WHERE
(tx_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
AND event_inputs:from = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
AND event_inputs:to = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')
AND TX_SUCCEEDED = 'TRUE'
AND CONTRACT_NAME = 'weth'
AND BLOCK_TIMESTAMP::DATE > CURRENT_DATE - (30 * 6)
)
SELECT
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) as daily,
sum(fee) as sum_fees,
COUNT(DISTINCT tx_id) as transaction_count
from open_sea
group by daily
order by daily