-- forked from Xmetrics - table @ https://flipsidecrypto.xyz/edit/queries/fd25d9fd-84b5-4dce-880e-c0be15e848cc

SELECT date_trunc('day',block_timestamp) as date,

raw_amount/pow(10,18) as Amount,

tx_hash as tx_id

FROM polygon.core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000'

AND contract_address = '0x15848c9672e99be386807b9101f83a16eb017bb5'

and to_address = lower('{{my_polygon_wallet}}')

ORDER by date desc