How to get the total cost of approve() function calls on Ethereum blockchain

bigquery.sql

--  Web3.utils.keccak256("approve(address,uint256)").slice(0, 10);
-- '0x095ea7b3'
WITH txdata as (
    SELECT tx.hash as txid, cast(tx.receipt_gas_used as numeric) * cast(tx.gas_price as numeric) as cost FROM
        bigquery-public-data.crypto_ethereum.transactions as tx
    where 
        tx.input 
    LIKE  "0x095ea7b3%") 
SELECT (SUM(cost) / POWER(10, 18)) as eth_cost from txdata;