SELECT

'Ethereum' AS blockchain,

CASE

WHEN from_address LIKE '0x0000000ff1ce%' OR from_address LIKE '0x00bab10c%' OR

from_address LIKE '0xabadbabe%' OR from_address LIKE '0xace0fba5e%' OR

from_address LIKE '0xbad22222%' OR from_address LIKE '0xbeefbabe%' OR

from_address LIKE '0xdeadbabe%' OR from_address LIKE '0xf00dbabe%' OR

from_address LIKE '0xfee1dead%' OR from_address LIKE '0xdead10cc%' THEN from_address

ELSE to_address

END AS address,

MIN(block_timestamp) AS first_transaction_date

FROM

ethereum.core.fact_transactions

WHERE

(from_address LIKE '0x0000000ff1ce%' OR from_address LIKE '0x00bab10c%' OR

from_address LIKE '0xabadbabe%' OR from_address LIKE '0xace0fba5e%' OR

from_address LIKE '0xbad22222%' OR from_address LIKE '0xbeefbabe%' OR

from_address LIKE '0xdeadbabe%' OR from_address LIKE '0xf00dbabe%' OR

from_address LIKE '0xfee1dead%' OR from_address LIKE '0xdead10cc%' OR

to_address LIKE '0x0000000ff1ce%' OR to_address LIKE '0x00bab10c%' OR

to_address LIKE '0xabadbabe%' OR to_address LIKE '0xace0fba5e%' OR

to_address LIKE '0xbad22222%' OR to_address LIKE '0xbeefbabe%' OR

to_address LIKE '0xdeadbabe%' OR to_address LIKE '0xf00dbabe%' OR

to_address LIKE '0xfee1dead%' OR to_address LIKE '0xdead10cc%')

AND block_timestamp BETWEEN '2019-01-01' AND '2022-12-31'

GROUP BY

CASE

WHEN from_address LIKE '0x0000000ff1ce%' OR from_address LIKE '0x00bab10c%' OR

from_address LIKE '0xabadbabe%' OR from_address LIKE '0xace0fba5e%' OR

from_address LIKE '0xbad22222%' OR from_address LIKE '0xbeefbabe%' OR

from_address LIKE '0xdeadbabe%' OR from_address LIKE '0xf00dbabe%' OR

from_address LIKE '0xfee1dead%' OR from_address LIKE '0xdead10cc%' THEN from_address

ELSE to_address

END

),