lending.flashloans table contains all flash loan transactions across DeFi lending protocols.
Table Schema
| Column | Type | Description |
|---|---|---|
blockchain | VARCHAR | Blockchain name |
project | VARCHAR | Lending protocol name |
version | VARCHAR | Protocol contract version |
token_address | VARBINARY | Token contract address |
symbol | VARCHAR | Token symbol |
recipient | VARBINARY | Flashloan recipient address |
amount | DOUBLE | Token amount in display units |
amount_raw | UINT256 | Raw token amount |
amount_usd | DOUBLE | Token amount in USD |
fee | DOUBLE | Flashloan fee amount |
project_contract_address | VARBINARY | Protocol contract address |
block_month | TIMESTAMP | Block month (partition key) |
block_time | TIMESTAMP | Block timestamp in UTC |
block_number | BIGINT | Block number |
tx_hash | VARBINARY | Transaction hash |
evt_index | INTEGER | Event index |
Table sample
Query performance
Partition keys:blockchain, project. Always include blockchain in your filter.