LiveQuerying Flipside Queries

    An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.

    The base query aggregates daily activity on the Uniswap V3 router.

    Router address: 0xe592427a0aece92de3edee1f18e0157c05861564

    Base Query

    Instead of duplicating the Base Query to get the Totals, with LiveQuery we fetch the Base Query results and calculate the totals of interest.

    This avoids the re-run of the Base Query.

    livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/{query_id}/data/latest') as response
    

    The query_id can be taken directly from the browser address bar when editing your target query

    The example shown here is meant as basic how-to, as there is no gains by using LiveQuery in this example.

    For long and resource consuming queries there will be efficiency gains by not running the same query multiple times.

    Loading...
    Loading...
    Query #2

    This is a rough example and i'm certain there will be more efficient ways to fetch and format the data.

    Loading...