Query editor
WITH deposit_data AS (SELECT"from" AS depositor_address,evt_block_time,CASEWHEN contract_address = 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48THEN value / POWER(10, 6)WHEN contract_address = 0xdac17f958d2ee523a2206206994597c13d831ec7THEN value / POWER(10, 6)ELSE 0END AS deposit_amountFROM erc20_ethereum.evt_TransferWHEREcontract_address IN (0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, 0xdac17f958d2ee523a2206206994597c13d831ec7)AND "to" = 0xb1381900C742B509cF2B23d6b293649EA875654CAND NOT DATE_TRUNC('day', evt_block_time) IS NULL), aggregated_deposits AS (SELECTdepositor_address,MIN(evt_block_time) AS first_deposit_time,SUM(deposit_amount) AS total_depositFROM deposit_dataGROUP BYdepositor_addressHAVINGSUM(deposit_amount) >= 1000 /* Check if the total deposit meets or exceeds $1000 */)SELECTROW_NUMBER() OVER (ORDER BY first_deposit_time) AS "Rank",depositor_address AS "WALLET ADDRESS",total_deposit AS "TOTAL DEPOSITED AMOUNT",first_deposit_time AS "FIRST DEPOSIT TIME"FROM aggregated_depositsORDER BY"Rank"LIMIT 500