table0 AS (

SELECT

TIMESTAMP AS date

, TX_HASH AS hash

, CASE CONTRACT

WHEN '0x00811d8da5dc8a2206ea7fd0b28627c2d77280a515126e62baa4d78e22714c4a' THEN 'zUSDT'

WHEN '0x062fa7afe1ca2992f8d8015385a279f49fad36299754fb1e9866f4f052289376' THEN 'zDAI'

WHEN '0x02b9ea3acdb23da566cee8e8beae3125a1458e720dea68c4a9a7a2d8eb5bbb4a' THEN 'zWBTC'

WHEN '0x01b5bd713e72fdc5d63ffd83762f81297f6175a5e0a4771cdadbc1dd5fe72cb1' THEN 'zETH'

WHEN '0x047ad51726d891f972e74e4ad858a261b43869f7126ce7436ee0b2529a98f486' THEN 'zUSDC'

END AS tokenSymbol

, CASE CONTRACT

WHEN '0x00811d8da5dc8a2206ea7fd0b28627c2d77280a515126e62baa4d78e22714c4a' THEN PARAMETERS[2]:value[0]:value/POW(10,6)

WHEN '0x062fa7afe1ca2992f8d8015385a279f49fad36299754fb1e9866f4f052289376' THEN PARAMETERS[2]:value[0]:value/POW(10,18)

WHEN '0x02b9ea3acdb23da566cee8e8beae3125a1458e720dea68c4a9a7a2d8eb5bbb4a' THEN PARAMETERS[2]:value[0]:value/POW(10,8)

WHEN '0x01b5bd713e72fdc5d63ffd83762f81297f6175a5e0a4771cdadbc1dd5fe72cb1' THEN PARAMETERS[2]:value[0]:value/POW(10,18)

WHEN '0x047ad51726d891f972e74e4ad858a261b43869f7126ce7436ee0b2529a98f486' THEN PARAMETERS[2]:value[0]:value/POW(10,6)

END AS tokenAmount

, PARAMETERS[1]:value AS userAddress

FROM external.tokenflow_starknet.decoded_events

WHERE CHAIN_ID = 'mainnet'

AND TIMESTAMP BETWEEN '2023-07-30 15:59:00' AND '2023-08-01 18:01:00'

AND NAME = 'Transfer'

AND PARAMETERS[0]:value = '0'

AND CONTRACT IN (

'0x00811d8da5dc8a2206ea7fd0b28627c2d77280a515126e62baa4d78e22714c4a' --zUSDT

, '0x062fa7afe1ca2992f8d8015385a279f49fad36299754fb1e9866f4f052289376' --zDAI

, '0x02b9ea3acdb23da566cee8e8beae3125a1458e720dea68c4a9a7a2d8eb5bbb4a' --zWBTC

, '0x01b5bd713e72fdc5d63ffd83762f81297f6175a5e0a4771cdadbc1dd5fe72cb1' --zETH

, '0x047ad51726d891f972e74e4ad858a261b43869f7126ce7436ee0b2529a98f486' --zUSDC

)

AND PARAMETERS[1]:value != '0x439d7ec4abbb69aaa8fa5acd9a682f118823f49f2542bc7673a9792ddff9fc2'

, prices AS (