![team-cover](https://res.cloudinary.com/dsr37ut2z/image/upload/v1699045634/x3nt1l6gdmvwezovityf.png)
Query |
---|
Live Query - From Query |
PIVOT |
piper test evm |
2023-11-01 11:02 PM |
FUND |
FLATTEN |
COUNT IF + SUM IF |
Curated-DataDelay oracle mkr |
Arrays evm |
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 evm |
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 l2 evm |
CASE |
DataDelay |
select 1 from bsc.core.fact_blocks limit 1 evm binance |
select * from ethereum.core.ez_dex_swaps - 30 DAYS uniswap kyberswap hashflow maverick dodo |
Log Splitting evm |
select * from ethereum.core.ez_dex_swaps uniswap kyberswap hashflow maverick dodo |
2023-11-01 11:02 PM copy evm |