Decoded Logs
The
ethereum.decoded.logs table includes additional decoded columns on top of what is in the raw logs table. select
date(block_timestamp) as date,
params:token::varchar as token,
sum(params:amount::varchar) / pow(10, 18) as weth_loan,
sum(weth_loan) over (order by date) as total_weth_loan
from ethereum.decoded.logs logs
where
logs.address = '0xba12222222228d8ba445958a75a0704d566bf2c8' -- Balancer Vault
and topic0 = '0x0d7d75e01ab95780d3cd1c8ec0dd6c2ce19e3a20427eec8bf53283b6fb8e95f0' -- FlashLoan Topic0
and token = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' -- WETH token contract
group by date, token
order by date desc
Additional Columns in Decoded Logs.
Column Name | Description | Example |
|---|---|---|
transaction_hash | Unique identifier of the transaction that this log belongs to. | 0x23a0d241e8232def857793cf28cd6d92e6b97e755b81565f9e12ee8ec3c80c9a |
transaction_index | The position of this transaction in the block that it belongs to. The first transaction has index 0. | 1 |
address | The address of the contract that emitted this log. | 0xba12222222228d8ba445958a75a0704d566bf2c8 |
data | Unindexed data containing further information of the event, encoded in hex. | 0x0000000000000000000000000000000000000000000000000000000ee6b27ffc0000000000000000000000000000000000000000000000000000000000000000 |
topic0 | The keccak256 hash of a flattened event signature string. | 0x0d7d75e01ab95780d3cd1c8ec0dd6c2ce19e3a20427eec8bf53283b6fb8e95f0 |
topic1 | First indexed topic of the event. | 0x0000000000000000000000001c073d5045b1abb6924d5f0f8b2f667b1653a4c3 |
topic2 | Second indexed topic of the event | 0x000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
topic3 | Third indexed topic of the event. | |
block_timestamp | The time when the block that contains this log was included on the blockchain. | 2022-10-11 19:02:47 |
block_number | The length of the chain, in blocks. | 15,726,828 |
block_hash | Unique identifier of the block that includes this log. | 0x41a67fb5f7e03c5b0e76222e3df8072a5fcaf9b37c04ac6fcc5769fc7276dfe1 |
name | Name of the decoded event. | FlashLoan |
params | Parameters of the decoded event log, in JSON format. | { "amount": "63999999996", "feeAmount": "0", "recipient": "0x1c073d5045b1abb6924d5f0f8b2f667b1653a4c3", "token": "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48" } |
_signature | Signature of the event. | FlashLoan(address,address,uint256,uint256) |
_error | Error message for event data that cannot be decoded from contract ABI. | |
_materialized_at | The timestamp of the data materialization. | 2023-02-14 18:06:35.693 +0000 |
_metadata_updated_at | The timestamp of the metadata update. | 2023-02-12 10:09:42 |
Last modified 3mo ago