SELECT

MIN(DATE_TRUNC('day', TO_DATE('2024-03-01', 'YYYY-MM-DD'))) AS start_date,

MAX(DATE_TRUNC('day', CURRENT_TIMESTAMP())) AS end_date

FROM kaia.core.fact_traces

),

all_dates AS (

SELECT

DATEADD(day, seq4(), (SELECT start_date FROM date_range)) AS date

FROM table(generator(rowcount => 10000)) -- 임의로 충분히 큰 숫자를 사용하여 생성된 날짜 범위가 포함되도록 합니다.

WHERE DATEADD(day, seq4(), (SELECT start_date FROM date_range)) <= (SELECT end_date FROM date_range)

),

projects AS (

SELECT 'Capybara' AS project

UNION ALL

SELECT 'Dragonswap'

UNION ALL

SELECT 'Kaiaswap'

),

date_project_combinations AS (

SELECT ad.date, p.project

FROM all_dates ad

CROSS JOIN projects p

),

total AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS date,

SUM(value) AS value,

'Capybara' AS project

FROM kaia.core.fact_traces

WHERE from_address = '0x14ba0d857c496c03a8c8d5fcc6c92d30df804775'

AND to_address = '0x000000000000000000000000000000000000dead'

GROUP BY 1, 3

UNION ALL