flipside

    Kaito Details
    freemartianKaito Details
    Updated 2 hours ago
    with summery_datas AS(
    SELECT livequery.live.udf_api(
    'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/summery.json'
    ) AS response
    )

    SELECT
    value,
    value:total:average_price AS average_price,
    value:total:floor_price AS floor_price,
    value:total:market_cap AS market_cap,
    value:total:volume AS volume,
    value:total:num_owners AS owners,
    FROM summery_datas, LATERAL FLATTEN (input => response:data)



    Last run: about 2 hours agoAuto-refreshes every 1 hour
    VALUE
    AVERAGE_PRICE
    FLOOR_PRICE
    MARKET_CAP
    VOLUME
    OWNERS
    1
    {"intervals":[{"average_price":6.859999999999999,"interval":"one_day","s...
    4.011979972478671
    7.2
    10473.77104285714
    5339.9453433691115
    918
    1
    759B
    3s