Query editor
SELECTdep.evt_tx_hash AS tx_hash,dep.evt_block_time AS block_time,dep.sender,'deposit' AS event_type,'ETH' AS symbol,dep.amount/POW(10,18) AS token_amount,dep.amount/POW(10,18) * pri.price AS amount_usdFROMlido_ethereum.steth_evt_Submitted depLEFT JOINprices.hour priON pri.blockchain = 'ethereum'AND pri.contract_address = 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2 -- WETHAND DATE_TRUNC('hour', dep.evt_block_time) = DATE_TRUNC('hour', pri.timestamp)-- ContractsLEFT JOIN contracts.contract_mapping cm -- Contract flagON dep.sender = cm.contract_addressWHEREcm.contract_address IS NULLORDER BY dep.evt_block_time DESC