select distinct ORIGIN_FROM_ADDRESS as sender

from blast.core.fact_token_transfers t1

where ORIGIN_TO_ADDRESS IN (

'0x5430561b09c627264549fdb3a6154c34f5cabea7',

'0xb0ceff252f18710a3315e735b5e26481840ad286',

'0xdd56a994568e01eb16c69718dae13073098f4003',

'0x99660f7ade18a02f1f88f2bfc7a2515ceff9c9c6',

'0xeb9e8822142fc10c38faab7bb6c635d22eb20ff8',

'0x0e1b878f5eddb7170b0a25ca63cb985291eb53d8',

'0xca9d4fdc71c6866b7a5ba1cc463044271bd799d7',

'0x5d59a8cea43f6729e336cb7278a3210590be6fa9',

'0x99c1ca21a54d5d8d7e2ad52e0b3f7bd2326a92b4',

'0x8cbb731d960c9be0e743cd3984c18245de447113',

'0x379226d215509de2089103e0d5c425e54889830e',

'0xfc37d560b7102ad725193cf1220690740d2601cf',

'0x379226d215509de2089103e0d5c425e54889830e',

'0x8170826fd8bc4314be57f40673413e87453da691',

'0xec3d9ace23d03de91c1f5d553aa426230ab82f5c',

'0x4fde5557d54ed955c7e3da40f2c7900cde5eefe0'

)

, ethereum AS (

SELECT FROM_ADDRESS AS sender

, TO_ADDRESS AS receiver

, COUNT(DISTINCT TX_HASH) as count_

FROM blast.core.fact_transactions bt

INNER JOIN input_addresses ia_sender ON bt.FROM_ADDRESS = ia_sender.sender

INNER JOIN input_addresses ia_receiver ON bt.TO_ADDRESS = ia_receiver.sender

WHERE block_timestamp >= date('2024-01-01')

AND STATUS = 'SUCCESS'

AND FROM_ADDRESS != TO_ADDRESS AND INPUT_DATA = '0x'

GROUP BY bt.FROM_ADDRESS, bt.TO_ADDRESS

SELECT * FROM ethereum