| Query |
|---|
| Live Query - From Query |
| PIVOT |
piper test polygonevm |
| 2023-11-01 11:02 PM |
| FUND |
| FLATTEN |
| COUNT IF + SUM IF |
Curated-DataDelay aave maker uniswapv3oracle mkr |
Arrays avalancheevm |
| UNPIVOT |
| Row Numbers for Traces |
| LEAD&LAG |
| Negative Numbers - int256 |
| Smooth Charts |
| Top 3 Daily Example |
| select * from ethereum.core.ez_dex_swaps - Daily Sum uniswap kyberswap hashflow maverick dodo |
Date Manipulation ethereumevm |
| JSON Manipulation |
| Heart Chart 3 |
| try_hex_decode_string |
| Sliding Windows |
| Live Query Example |
select * from arbitrum.core.fact_blocks where block_timestamp > current_date() - 7 limit 10 arbitruml2 evm |
| CASE |
DataDelay terra thorchain cosmos gnosis flow |
select 1 from bsc.core.fact_blocks limit 1 bscevm binance |
| select * from ethereum.core.ez_dex_swaps - 30 DAYS uniswap kyberswap hashflow maverick dodo |
| Log Splittingavalanche evm |
| select * from ethereum.core.ez_dex_swaps uniswap kyberswap hashflow maverick dodo |
| 2023-11-01 11:02 PM copyethereum evm |