SELECT from_address, MIN(block_timestamp) AS min_timestamp

FROM ethereum.core.fact_transactions

WHERE from_address IN (

SELECT trader

FROM crosschain.defi.ez_dex_swaps

WHERE block_timestamp > CURRENT_TIMESTAMP() - INTERVAL '7 day'

)

GROUP BY 1

HAVING MIN(block_timestamp) > CURRENT_TIMESTAMP() - INTERVAL '7 day'

),

fresh_wallet_buys AS (

SELECT

amount_out_usd AS buy,

block_timestamp,

trader,

tx_hash

FROM crosschain.defi.ez_dex_swaps

WHERE trader IN (SELECT from_address FROM fresh_wallet_traders)

AND amount_out_usd IS NOT NULL

AND blockchain = 'ethereum'

AND block_timestamp > CURRENT_TIMESTAMP() - INTERVAL '1 day'

AND token_out = '0x514910771af9ca656af840dff83e8264ecf986ca'

ORDER BY 1 DESC

SELECT DISTINCT

TO_VARCHAR(buy, '$999,999,999') AS "Amount Bought",

block_timestamp AS "Time",

trader AS "Trader",

tx_hash AS "Hash"

FROM fresh_wallet_buys

ORDER BY 1 DESC

LIMIT 250;