2.4 KiB
| description |
|---|
| Query & Remix All of Crypto With a Single, Real-time Interface |
Get Started
LiveQuery enables you to query any API directly within a Flipside SQL Query, from nodes to your favorite crypto data providers.
This gives you the power to remix data and generate unique insights beyond Flipside's curated data sets as well as leverage real-time updates directly from blockchain nodes.
SELECT * FROM table(ethereum_mainnet.latest_contract_events_decoded(<address>))
If you're already writing SQL at Flipside you already have access to the power of LiveQuery.
Examples
| Seaport: Real-time Orders | Retrieve the latest Seaport Orders directly from an Ethereum Node. | seaport-real-time-orders.md | |
| WETH Pool Balances | Retrieve the real-time WETH balance for the top WETH pools by volume over the past 1 week. | weth-pool-balances.md | |
| Query TheGraph | Retrieve the TVL for the top 500 UniswapV3 Pools on Polygon using LiveQuery and TheGraph | query-thegraph.md |
Add-On Setup Guides
{% hint style="info" %} Add-Ons provide a secure means of incorporating your API keys for third-party data sources like blockchain nodes or cryptocurrency data APIs. This functionality enables you to run and share your queries while ensuring your API secrets remain undisclosed to other users. {% endhint %}
{% content-ref url="add-ons/quicknode-setup-guide.md" %} quicknode-setup-guide.md {% endcontent-ref %}
We're excited to announce that additional third-party cryptocurrency data add-ons are on the horizon! Until then, explore our detailed, step-by-step examples or link your QuickNode account to use LiveQuery for querying blockchain nodes.
{% hint style="danger" %} Note if you publish a dashboard that contains LiveQuery-powered queries users that refresh your dashboard will trigger queries against the Add-ons you have integrated. {% endhint %}