PREVIEW / futures_1hour / 2018-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-16.parquet
  size:    55 KB
  rows:    1,704

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-10-16 00:00:00	ES	Futures	2997.96	3000.41	2996.88	2999.87	5260.0
2018-10-16 01:00:00	ES	Futures	2999.87	3003.68	2999.87	3002.59	10039.0
2018-10-16 02:00:00	ES	Futures	3002.59	3003.95	2998.78	3001.5	14339.0
2018-10-16 03:00:00	ES	Futures	3001.5	3005.85	2999.05	3001.77	27263.0
2018-10-16 04:00:00	ES	Futures	3002.04	3005.58	3000.41	3001.5	23359.0
2018-10-16 05:00:00	ES	Futures	3001.77	3002.32	2997.96	3002.04	15808.0
2018-10-16 06:00:00	ES	Futures	3001.77	3006.67	3000.14	3003.4	15390.0
2018-10-16 07:00:00	ES	Futures	3003.4	3007.76	3002.86	3007.48	19754.0
2018-10-16 08:00:00	ES	Futures	3007.48	3015.37	3006.4	3013.74	44564.0
2018-10-16 09:00:00	ES	Futures	3013.74	3022.17	3012.11	3022.17	209220.0
2018-10-16 10:00:00	ES	Futures	3022.17	3034.41	3018.64	3034.14	271509.0
2018-10-16 11:00:00	ES	Futures	3033.87	3040.67	3030.6	3040.4	177062.0
2018-10-16 12:00:00	ES	Futures	3040.4	3044.2	3036.86	3043.93	108875.0
2018-10-16 13:00:00	ES	Futures	3043.93	3052.36	3041.76	3048.28	123081.0
2018-10-16 14:00:00	ES	Futures	3048.28	3055.63	3048.01	3050.19	145529.0
2018-10-16 15:00:00	ES	Futures	3049.92	3064.06	3046.92	3058.35	301854.0
2018-10-16 16:00:00	ES	Futures	3058.35	3067.05	3054.27	3064.33	118959.0
2018-10-16 18:00:00	ES	Futures	3064.06	3065.15	3060.52	3062.7	6256.0
2018-10-16 19:00:00	ES	Futures	3062.7	3064.33	3061.61	3064.33	3916.0
2018-10-16 20:00:00	ES	Futures	3064.33	3065.69	3062.7	3065.15	8631.0
2018-10-16 21:00:00	ES	Futures	3065.42	3067.05	3062.97	3063.79	7556.0
2018-10-16 22:00:00	ES	Futures	3063.52	3066.24	3062.7	3065.69	4826.0
2018-10-16 23:00:00	ES	Futures	3065.69	3067.05	3064.88	3065.15	3776.0
2018-10-16 00:00:00	NQ	Futures	8331.88	8340.09	8325.43	8338.33	3565.0
2018-10-16 01:00:00	NQ	Futures	8338.04	8355.05	8338.04	8346.25	5269.0
2018-10-16 02:00:00	NQ	Futures	8346.25	8353.88	8334.81	8346.84	6356.0
2018-10-16 03:00:00	NQ	Futures	8346.84	8360.04	8334.52	8347.43	8551.0
2018-10-16 04:00:00	NQ	Futures	8347.72	8359.16	8339.8	8350.36	7405.0
2018-10-16 05:00:00	NQ	Futures	8350.65	8352.12	8336.28	8349.19	5702.0
2018-10-16 06:00:00	NQ	Futures	8349.77	8362.39	8343.32	8354.76	5830.0
2018-10-16 07:00:00	NQ	Futures	8354.47	8370.6	8351.53	8368.55	7424.0
2018-10-16 08:00:00	NQ	Futures	8368.84	8392.3	8366.2	8387.61	15303.0
2018-10-16 09:00:00	NQ	Futures	8387.32	8436.3	8384.38	8436.3	86800.0
2018-10-16 10:00:00	NQ	Futures	8435.71	8446.57	8385.26	8444.22	101210.0
2018-10-16 11:00:00	NQ	Futures	8443.93	8487.92	8431.9	8486.16	71075.0
2018-10-16 12:00:00	NQ	Futures	8486.16	8499.66	8470.91	8498.48	41151.0
2018-10-16 13:00:00	NQ	Futures	8498.78	8526.94	8494.38	8515.5	46045.0
2018-10-16 14:00:00	NQ	Futures	8514.91	8536.32	8512.56	8516.96	45520.0
2018-10-16 15:00:00	NQ	Futures	8516.96	8580.61	8508.46	8554.21	79862.0
2018-10-16 16:00:00	NQ	Futures	8554.21	8632.24	8539.84	8612.29	33718.0
2018-10-16 18:00:00	NQ	Futures	8611.41	8620.8	8604.66	8612.58	3113.0
2018-10-16 19:00:00	NQ	Futures	8612.58	8618.74	8609.06	8618.45	2427.0
2018-10-16 20:00:00	NQ	Futures	8618.74	8620.8	8610.53	8619.33	3324.0
2018-10-16 21:00:00	NQ	Futures	8619.33	8622.85	8606.13	8609.36	4151.0
2018-10-16 22:00:00	NQ	Futures	8609.65	8617.28	8605.25	8615.22	2991.0
2018-10-16 23:00:00	NQ	Futures	8615.22	8621.09	8612.0	8614.93	2513.0
2018-10-16 00:00:00	YM	Futures	27422.5	27446.4	27413.8	27441.0	1590.0
2018-10-16 01:00:00	YM	Futures	27439.9	27475.7	27439.9	27459.4	2705.0
2018-10-16 02:00:00	YM	Futures	27459.4	27469.2	27425.7	27448.6	3279.0
2018-10-16 03:00:00	YM	Futures	27449.6	27494.2	27426.8	27460.5	6050.0

> showing 50 of 1,704 rows — these rows as CSV

> unlock the full archive -- $79 one-time