Query editor
WITH exchange_addresses AS (SELECT address, nameFROM labels.addressesWHERE blockchain = '{{blockchain}}'AND category = 'institution'),outflows AS (SELECTt.block_date,e.name AS exchange_name,SUM(t.amount_usd) AS outflow_usd,COUNT(*) AS num_transfersFROM tokens.transfers tJOIN exchange_addresses eON e.address = t."from"WHERE t.contract_address = {{token_address}}AND t.blockchain = '{{blockchain}}'AND t.block_date >= CURRENT_DATE - INTERVAL '{{lookback_days}}' DAYGROUP BY t.block_date, e.name)SELECTblock_date,exchange_name,outflow_usd,num_transfersFROM outflowsORDER BY outflow_usd DESCLIMIT 100