flipside

    Crafting - Budget: $500
    AephiaCrafting - Budget: $500
    Updated 1 day ago
    WITH token_prices AS (
    SELECT
    *

    FROM $query('21b1f230-5365-41ed-9d66-3f14153bec8b')

    )

    ,crafting_txs_fees AS (
    SELECT
    sol_craft_txs

    FROM $query('cd138309-a854-4909-83c7-b5c9a74687b3')
    WHERE date = current_date-1
    )

    ,gecko_call_data as (
    select live.udf_api('https://api.coingecko.com/api/v3/nfts/star-atlas-crew')
    as response
    )

    ,gecko_flattened_data as (
    select * from
    gecko_call_data, lateral flatten(input => parse_json(response:data))
    )

    ,crew AS (
    SELECT
    case when key = 'floor_price' then value:usd end as fp_crew
    FROM gecko_flattened_data
    ),



    sage_volumes AS (
    Last run: 1 day ago
    NAME
    BUDGET
    FLOOR_PRICE_CREW
    CREW
    CRAFTING_TIME
    VALUE_INGREDIENTS
    PRICE_ATLAS
    ENTRY_LIQUIDITY
    EXIT_LIQUIDITY
    CRAFTS_PER_DAY
    NET_PROFIT
    ROI
    NET_PROFIT_PER_CREW
    1
    		0.0106070.0098
    2
    		0.0017610.002331
    3
    		0.0008750.00107
    4
    		0.007290.005311
    5
    		0.0148550.017439
    6
    		0.0009490.001211
    7
    		0.0032060.004428
    8
    		0.0057050.006998
    9
    		0.0103910.011805
    10
    		0.001840.001562
    11
    		0.001750.001625
    12
    		0.0021720.002809
    13
    		0.0080140.007857
    14
    		0.0131680.019461
    15
    		0.0007650.000875
    16
    		0.006180.007788
    17
    		0.0216050.035168
    18
    		0.0031290.002628
    19
    		0.0028090.002812
    20
    		0.0018840.001761
    29
    2KB
    230s