pnl AS (

SELECT

DATE_TRUNC({{ duration }}, block_timestamp) AS time,

symbol,

SUM(amount) AS amount,

SUM(amount_usd) AS amount_usd,

-- to_address,

-- from_address,

CASE

WHEN to_address = LOWER('{{ address }}') THEN 'in'

ELSE 'out'

END AS direction

FROM

polygon.core.ez_token_transfers

WHERE

SYMBOL IN ('WETH', 'ZED')

AND (

(

from_address = LOWER('{{ address }}')

AND to_address IN (

'0x03344de035f5923f87c54743e3915262064eee17',

'0x157a268dc31bb12056a5b760240c6fef004ec522',

'0x250de0a3cad8d2cd1c0c19896e8a8b83b1b98020',

'0x26d6c8c9ca72af49d4e63e517a1cf0af5435c78c',

'0x31746ace8add91b8e48f80d09c97cee0c20d0dda',

'0x5ec03c1f7fa7ff05ec476d19e34a22eddb48acdc',

'0x5f6d76c849d394bc7b9cc459f88b55a5ffa109a0',

'0x67f4732266c7300cca593c814d46bee72e40659f',

'0x6e45cfba3fedec1693e72783c1179f3c73253fc1',

'0x6f9f251551f92cec48c43ba59598fd7b07387f95',

'0x77ceea82e4362dd3b2e0d7f76d0a71a628cad300',

'0x7adbced399630dd11a97f2e2dc206911167071ae',

'0x7c5a4b9108be6771161175c512344b3060327a9f',

'0x7ee486098de195a5bb0ed2df5a7838e660b9f9e6',

'0x7f4b395c5508cf8263a62a7daf0227a503390032',