SELECT

from_address,

to_address,

tx_hash,

raw_amount/1000000000000000000 as amount,

block_timestamp,

'first_layer' AS layer

FROM

ethereum.core.fact_token_transfers

WHERE

block_timestamp >= '2023-10-01'

AND contract_address = '0x826180541412d574cf1336d22c0c0a287822678a'

AND from_address IN ('0x34d4735350a0072e098688ab71147546bc63d7d9'

, '0x71b7a813ae58b3c2ed3a8d9cdbe6f59bb52fc71b'

, '0x7a5068ecd79b7b82d6146c52e092aceb46f69ebf'

, '0x87aba8c6ce4b23660cba31d41bb7db28aa0eeb05'

, '0x0300a77772640d81843dc33198bde8798857b03f'

, '0x05f7393d0bb54b2421483732449a5704c0aaf65e'

, '0x6a52a4306c54818b8fc2124ad57612047643e66a'

, '0x3aca5e839ff1ea1f0693472a47aec4fadb5cc966'

, '0x8c3c5f48eb3377c4337d07ff5469c6b907d46c4d'

, '0xd80a4a24ab2df822c16cc6220ca0627547828f10'

, '0x84bc9532282d9a6b1886586e6979184edbba74be'

, '0x6995ab7c4d7f4b03f467cf4c8e920427d9621dbd'

, '0x5df5e9f92bec15c786029e1f5d1f1ae0ba2b3773'

, '0x26f9dc5eef5465f84425a8c048e29d32102998a5'

, second_layer AS (

SELECT

from_address,

to_address,

tx_hash,

raw_amount/1000000000000000000 as amount,