bachiGood Vibrations Features1
    Updated 2021-09-02
    select distinct project_name, token_name, to_number(trim(token_name,'good vibrations #')) AS token_number,
    creator_name, created_at_timestamp, replace(token_metadata:traits[1]:value::string,'Surface: ','') AS Surface,
    replace(token_metadata:traits[2]:value::string,'GeoPos: ','') AS GeoPos, replace(token_metadata:traits[3]:value::string,'FrameColor: ','') AS FrameColor,
    replace(token_metadata:traits[4]:value::string,'BgSpecial: ','') AS BgSpecial, replace(token_metadata:traits[5]:value::string,'MelodyNum: ','') AS MelodyNum,
    replace(token_metadata:traits[6]:value::string,'LineNum: ','') AS LineNum, replace(token_metadata:traits[7]:value::string,'SpecialLine: ','') AS SpecialLine,
    replace(token_metadata:traits[8]:value::string,'ColorDots: ','') AS ColorDots, replace(token_metadata:traits[9]:value::string,'ShapeWeight: ','') AS ShapeWeight,
    replace(token_metadata:traits[10]:value::string,'BgObjShape: ','') AS BgObjShape, replace(token_metadata:traits[11]:value::string,'BgObjNum: ','') AS BgObjNum,
    replace(token_metadata:traits[12]:value::string,'OscSine: ','') AS OscSine, replace(token_metadata:traits[13]:value::string,'OscSquare: ','') AS OscSquare,
    replace(token_metadata:traits[14]:value::string,'OscTriangle: ','') AS OscTriangle, replace(token_metadata:traits[15]:value::string,'OscSawtooth: ','') AS OscSawtooth,
    replace(token_metadata:traits[16]:value::string,'Ring: ','') AS Ring
    from ethereum.nft_metadata where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
    and lower(token_name) LIKE 'good vibrations%' and token_number <> 0 order by token_number
    Run a query to Download Data