flipside

    Crafting - Budget: $500
    AephiaCrafting - Budget: $500
    Updated 22 hours 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: about 22 hours 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.0035840.00277
    2
    		0.0089140.012309
    3
    		0.0035840.001516
    4
    		0.00340.001516
    5
    		0.0074310.00531
    6
    		0.002050.002501
    7
    		0.0018650.00205
    8
    		0.013980.01991
    9
    		0.0007210.000716
    10
    		0.002190.001516
    11
    		0.0031020.002429
    12
    		0.0016480.001792
    13
    		0.00340.00277
    14
    		0.0032160.004752
    15
    		0.0055370.006906
    16
    		0.0257570.032046
    17
    		0.0009360.001193
    18
    		0.001040.001444
    19
    		0.0048560.007047
    20
    		0.0007160.000811
    29
    2KB
    126s