Pinned Loading

1. backblaze_analysis backblaze_analysis Public

   Forked from zachmayer/backblaze_analysis

   R

2. XuniVerse XuniVerse Public

   Forked from Sundar0989/XuniVerse

   xverse (XuniVerse) is collection of transformers for feature engineering and feature selection

   Jupyter Notebook

3. rsi.sql rsi.sql

   1

   WITH CTE_LAG1 AS (

   2

   SELECT *,

   3

           lag(CLOSE, 1) over (partition by Stock_Ticker_Symbol order by Trading_Date) as LAG_CLOSE

   4

   from IOT_DATA

   5

   ) , 

4. summarize_flatlines.sql summarize_flatlines.sql

   1

   WITH CTE_SEQUENCES AS (

   2

     SELECT

   3

       T.*,

   4

       ROW_NUMBER() OVER (PARTITION BY DeviceID,SensorReading ORDER BY SensorTimestamp) AS RN_R97_B42_O,

   5

       ROW_NUMBER() OVER (ORDER BY DeviceID,SensorTimestamp) AS RN_R97_B42_E

5. summarize_islands summarize_islands

   1

   WITH CTE_CONDITION AS (

   2

   SELECT SensorTimestamp AS dtm ,DeviceID FROM IOT_DATA

   3

   WHERE 

   4

   SensorReading > 0 AND SensorTimestamp is not null

   5

   ),

6. entropy_sql.sql entropy_sql.sql

   1

   WITH CTE_AGG AS (

   2

     SELECT POSITION, RACEDESC, COUNT(1) AS C 

   3

     FROM {{ source_data }} 

   4

     GROUP BY POSITION, RACEDESC

   5

   ),