-- Generate a list of all days from 2025-02-06 to today

SELECT DATEADD(day, row_num - 1, '2025-02-06'::date) AS day

FROM (

SELECT ROW_NUMBER() OVER (ORDER BY 1 ASC) AS row_num

FROM TABLE(GENERATOR(ROWCOUNT => 1000))

)

WHERE DATEADD(day, row_num - 1, '2025-02-06'::date) <= CURRENT_DATE

),

collections AS (

-- List of all possible collections

SELECT 'Bong Bears' AS collection UNION ALL

SELECT 'Bond Bears' UNION ALL

SELECT 'Boo Bears' UNION ALL

SELECT 'Baby Bears' UNION ALL

SELECT 'Band Bears' UNION ALL

SELECT 'Bit Bears'

),

date_collection_series AS (

-- Create all possible (day, collection) combinations

SELECT d.day, c.collection

FROM daily_series d

CROSS JOIN collections c

),

all_bridges AS (

-- Combine all bridge transactions

SELECT block_timestamp::date AS date, '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