-- base data processing

WITH arb AS (

-- Generate a list of dates from the transaction data

WITH dates AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date

FROM base.core.fact_transactions

WHERE date >= '2024-05-06'

AND date <= CURRENT_DATE

GROUP BY 1

),

-- Extract buy and sell transactions on base

buy_sell_table AS (

(

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

to_address AS address,

amount

FROM base.core.ez_token_transfers

WHERE 1=1

AND block_timestamp >= '2024-05-06' -- From April 3, 2024

AND contract_address = LOWER('0xeb6d78148f001f3aa2f588997c5e102e489ad341')

)

UNION ALL

(

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

from_address AS address,

-amount

FROM base.core.ez_token_transfers

WHERE 1=1

AND block_timestamp >= '2024-05-06' -- From April 3, 2024