PREVIEW / futures_1hour / 2018-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-12.parquet
  size:    57 KB
  rows:    1,718

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-11-12 00:00:00	ES	Futures	3036.86	3037.95	3034.41	3037.68	4228.0
2018-11-12 01:00:00	ES	Futures	3037.68	3037.95	3033.6	3034.14	4031.0
2018-11-12 02:00:00	ES	Futures	3034.14	3035.5	3031.15	3033.6	9496.0
2018-11-12 03:00:00	ES	Futures	3033.32	3033.6	3022.44	3023.26	25136.0
2018-11-12 04:00:00	ES	Futures	3023.26	3027.61	3021.9	3024.62	20792.0
2018-11-12 05:00:00	ES	Futures	3024.62	3027.61	3020.54	3024.89	16076.0
2018-11-12 06:00:00	ES	Futures	3024.89	3025.44	3020.0	3021.08	14809.0
2018-11-12 07:00:00	ES	Futures	3021.08	3024.62	3018.36	3019.72	14590.0
2018-11-12 08:00:00	ES	Futures	3020.0	3020.54	3012.11	3018.09	35873.0
2018-11-12 09:00:00	ES	Futures	3018.09	3021.9	3000.96	3001.77	206838.0
2018-11-12 10:00:00	ES	Futures	3001.5	3005.31	2988.44	2989.26	260689.0
2018-11-12 11:00:00	ES	Futures	2989.53	2990.35	2974.03	2984.64	281261.0
2018-11-12 12:00:00	ES	Futures	2984.64	2990.89	2980.28	2980.56	136152.0
2018-11-12 13:00:00	ES	Futures	2980.28	2987.9	2972.94	2983.28	142352.0
2018-11-12 14:00:00	ES	Futures	2983.28	2994.16	2979.74	2980.28	181717.0
2018-11-12 15:00:00	ES	Futures	2980.01	2985.72	2961.79	2967.77	372127.0
2018-11-12 16:00:00	ES	Futures	2967.77	2973.76	2966.68	2970.76	90225.0
2018-11-12 18:00:00	ES	Futures	2972.4	2976.2	2968.04	2969.13	10893.0
2018-11-12 19:00:00	ES	Futures	2969.13	2971.85	2959.88	2962.33	33599.0
2018-11-12 20:00:00	ES	Futures	2962.33	2967.77	2958.25	2966.68	16685.0
2018-11-12 21:00:00	ES	Futures	2966.68	2971.31	2965.05	2966.41	13413.0
2018-11-12 22:00:00	ES	Futures	2966.68	2981.92	2965.05	2981.1	21949.0
2018-11-12 23:00:00	ES	Futures	2981.1	2985.72	2979.47	2981.37	13995.0
2018-11-12 00:00:00	NQ	Futures	8314.28	8320.74	8304.6	8320.15	2504.0
2018-11-12 01:00:00	NQ	Futures	8319.27	8322.79	8300.2	8302.84	2433.0
2018-11-12 02:00:00	NQ	Futures	8302.55	8310.18	8291.7	8302.26	4175.0
2018-11-12 03:00:00	NQ	Futures	8301.96	8304.6	8268.23	8271.17	8066.0
2018-11-12 04:00:00	NQ	Futures	8271.46	8288.18	8266.77	8274.98	7634.0
2018-11-12 05:00:00	NQ	Futures	8275.27	8283.78	8252.39	8273.81	7832.0
2018-11-12 06:00:00	NQ	Futures	8274.1	8275.86	8249.46	8253.57	6615.0
2018-11-12 07:00:00	NQ	Futures	8253.86	8266.18	8239.49	8242.42	7291.0
2018-11-12 08:00:00	NQ	Futures	8243.01	8245.06	8196.08	8209.57	22927.0
2018-11-12 09:00:00	NQ	Futures	8209.57	8223.36	8123.34	8130.67	87051.0
2018-11-12 10:00:00	NQ	Futures	8130.37	8140.35	8061.74	8065.55	107017.0
2018-11-12 11:00:00	NQ	Futures	8065.55	8067.31	8008.36	8061.74	108377.0
2018-11-12 12:00:00	NQ	Futures	8061.45	8092.83	8053.82	8054.7	65058.0
2018-11-12 13:00:00	NQ	Futures	8054.99	8076.11	8023.61	8063.79	64538.0
2018-11-12 14:00:00	NQ	Futures	8063.21	8104.27	8052.35	8057.63	70917.0
2018-11-12 15:00:00	NQ	Futures	8057.93	8076.7	8010.12	8023.02	82049.0
2018-11-12 16:00:00	NQ	Futures	8023.02	8042.09	8011.58	8026.54	18417.0
2018-11-12 18:00:00	NQ	Futures	8033.29	8042.09	8016.57	8018.92	3303.0
2018-11-12 19:00:00	NQ	Futures	8018.62	8033.58	7982.84	7994.86	9734.0
2018-11-12 20:00:00	NQ	Futures	7994.28	8014.22	7979.61	8010.41	6639.0
2018-11-12 21:00:00	NQ	Futures	8010.7	8025.08	8000.73	8006.01	5050.0
2018-11-12 22:00:00	NQ	Futures	8005.72	8061.74	7999.85	8057.93	8674.0
2018-11-12 23:00:00	NQ	Futures	8058.22	8082.86	8045.31	8053.53	8013.0
2018-11-12 00:00:00	YM	Futures	28311.3	28326.5	28292.8	28324.3	1634.0
2018-11-12 01:00:00	YM	Futures	28324.3	28328.6	28288.4	28292.8	1480.0
2018-11-12 02:00:00	YM	Futures	28293.9	28301.5	28264.5	28284.1	2706.0
2018-11-12 03:00:00	YM	Futures	28281.9	28288.4	28187.4	28197.2	5112.0

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

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