SELECT block_timestamp AS time, 'Bong Bears' AS collection, tx_hash, from_address, value, tx_fee

FROM ethereum.core.fact_transactions

WHERE to_address = '0x1897c001341f81ca72154b75b882ae708e06bf48'

AND origin_function_signature = '0x21eb730b'

AND block_timestamp::date >= '2025-02-06'

UNION ALL

SELECT block_timestamp AS time, 'Bond Bears' AS collection, tx_hash, from_address, value, tx_fee

FROM ethereum.core.fact_transactions

WHERE to_address = '0x6b1c374105467d1fc1090c989bcbbcc172c8a89c'

AND origin_function_signature = '0x21eb730b'

AND block_timestamp::date >= '2025-02-06'

UNION ALL

SELECT block_timestamp AS time, 'Boo Bears' AS collection, tx_hash, from_address, value, tx_fee

FROM ethereum.core.fact_transactions

WHERE to_address = '0x7591992f1a98636c6b7207f30382ca4bec83d9be'

AND origin_function_signature = '0x21eb730b'

AND block_timestamp::date >= '2025-02-06'

UNION ALL

SELECT block_timestamp AS time, 'Baby Bears' AS collection, tx_hash, from_address, value, tx_fee

FROM ethereum.core.fact_transactions

WHERE to_address = '0xc48c54e92d135b356dd0cbf50f803a8c8d38968b'

AND origin_function_signature = '0x21eb730b'

AND block_timestamp::date >= '2025-02-06'

UNION ALL

SELECT block_timestamp AS time, 'Band Bears' AS collection, tx_hash, from_address, value, tx_fee

FROM ethereum.core.fact_transactions

WHERE to_address = '0x392faa1b0ef108ded69897ba5382e909c39fc09e'