Query editor
SELECTDATE_TRUNC('week', block_time) AS week,CASE WHEN "to" = 0x673a039f6a959fa9db65d16781e6defde30375d9 THEN 'IN' ELSE 'OUT' END AS direction,COUNT(*) AS txn_count,SUM(amount) AS total_flay,SUM(amount_usd) AS total_usdFROM tokens.transfersWHERE blockchain = 'base'AND contract_address = 0xf1a7000000950c7ad8aff13118bb7ab561a448eeAND ("to" = 0x673a039f6a959fa9db65d16781e6defde30375d9 OR "from" = 0x673a039f6a959fa9db65d16781e6defde30375d9)GROUP BY 1, 2ORDER BY 1 DESC