How to write a query to find out the monthly $ gas spent for your wallet
gas.fees
. This table facilitates an effortless aggregation of gas expenses across eight EVM chains specifically for your wallet.
tx_fee_usd
column to track USD gas expenditures. To specify the wallet you’re examining, use the tx_sender
field. For demonstration purposes, we’ll be using Vitalik’s wallet (0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045).
block_date
to month and applying the SUM()
function, then group by each month go derive the results.
tx_sender = \{\{Your Wallet Address}} -- default is vitalik.eth
. This denotes the use of the parameter feature, enhancing the query’s flexibility. To mark a field as a parameter, wrap it in "". Alternatively, activate the “Add Parameter” button.