PREVIEW / futures_1hour / 2018-11-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	2981.37	2986.81	2977.29	2983.82	18498.0
2018-11-13 01:00:00	ES	Futures	2983.55	2984.36	2974.03	2975.39	7482.0
2018-11-13 02:00:00	ES	Futures	2975.66	2984.36	2974.3	2981.92	19380.0
2018-11-13 03:00:00	ES	Futures	2981.92	2992.25	2981.92	2983.28	32950.0
2018-11-13 04:00:00	ES	Futures	2983.28	2985.18	2975.93	2976.48	21906.0
2018-11-13 05:00:00	ES	Futures	2976.2	2983.0	2974.03	2982.46	21885.0
2018-11-13 06:00:00	ES	Futures	2982.73	2987.36	2981.92	2984.91	18038.0
2018-11-13 07:00:00	ES	Futures	2984.91	2991.16	2983.28	2984.64	25901.0
2018-11-13 08:00:00	ES	Futures	2984.64	2986.0	2975.93	2978.92	35316.0
2018-11-13 09:00:00	ES	Futures	2979.2	2985.45	2972.12	2975.93	227117.0
2018-11-13 10:00:00	ES	Futures	2975.66	2981.92	2958.8	2977.02	349372.0
2018-11-13 11:00:00	ES	Futures	2977.02	2998.24	2975.93	2986.27	255209.0
2018-11-13 12:00:00	ES	Futures	2986.54	2990.89	2972.12	2974.3	197960.0
2018-11-13 13:00:00	ES	Futures	2974.3	2981.92	2967.77	2973.76	172534.0
2018-11-13 14:00:00	ES	Futures	2974.03	2975.39	2954.99	2962.33	189303.0
2018-11-13 15:00:00	ES	Futures	2962.33	2971.58	2953.36	2962.06	308406.0
2018-11-13 16:00:00	ES	Futures	2962.33	2971.85	2957.44	2968.86	58754.0
2018-11-13 18:00:00	ES	Futures	2971.58	2985.18	2968.59	2976.48	15498.0
2018-11-13 19:00:00	ES	Futures	2976.48	2981.92	2975.93	2978.11	12580.0
2018-11-13 20:00:00	ES	Futures	2978.11	2979.2	2972.67	2973.21	8832.0
2018-11-13 21:00:00	ES	Futures	2973.21	2975.12	2964.78	2969.95	14843.0
2018-11-13 22:00:00	ES	Futures	2969.95	2973.21	2967.77	2971.58	7149.0
2018-11-13 23:00:00	ES	Futures	2971.58	2971.85	2965.32	2965.6	4421.0
2018-11-13 00:00:00	NQ	Futures	8053.82	8070.25	8034.75	8057.63	5264.0
2018-11-13 01:00:00	NQ	Futures	8057.63	8061.45	8025.08	8035.34	3496.0
2018-11-13 02:00:00	NQ	Futures	8036.22	8081.68	8031.23	8073.18	9515.0
2018-11-13 03:00:00	NQ	Futures	8072.89	8100.46	8069.95	8076.7	14121.0
2018-11-13 04:00:00	NQ	Futures	8076.7	8088.14	8054.99	8056.75	9104.0
2018-11-13 05:00:00	NQ	Futures	8056.46	8081.98	8047.66	8080.51	9421.0
2018-11-13 06:00:00	NQ	Futures	8080.51	8096.35	8076.99	8085.2	8617.0
2018-11-13 07:00:00	NQ	Futures	8085.5	8106.32	8073.77	8077.87	13635.0
2018-11-13 08:00:00	NQ	Futures	8078.46	8085.79	8049.42	8059.69	19800.0
2018-11-13 09:00:00	NQ	Futures	8059.39	8119.52	8043.26	8050.3	90891.0
2018-11-13 10:00:00	NQ	Futures	8050.3	8106.32	8018.62	8099.58	121214.0
2018-11-13 11:00:00	NQ	Futures	8099.58	8168.21	8095.76	8105.15	99466.0
2018-11-13 12:00:00	NQ	Futures	8105.15	8119.23	8052.65	8065.55	62864.0
2018-11-13 13:00:00	NQ	Futures	8064.97	8098.4	8048.25	8064.09	53234.0
2018-11-13 14:00:00	NQ	Futures	8063.21	8068.78	8004.54	8029.18	57903.0
2018-11-13 15:00:00	NQ	Futures	8028.59	8058.22	7999.56	8023.32	75986.0
2018-11-13 16:00:00	NQ	Futures	8023.32	8054.7	8008.06	8043.55	9889.0
2018-11-13 18:00:00	NQ	Futures	8050.59	8094.0	8042.67	8072.3	4457.0
2018-11-13 19:00:00	NQ	Futures	8071.71	8090.19	8068.49	8078.75	5006.0
2018-11-13 20:00:00	NQ	Futures	8079.34	8083.74	8056.17	8062.33	5248.0
2018-11-13 21:00:00	NQ	Futures	8061.45	8068.19	8030.94	8047.95	6035.0
2018-11-13 22:00:00	NQ	Futures	8047.95	8056.46	8038.27	8051.47	4981.0
2018-11-13 23:00:00	NQ	Futures	8052.06	8052.06	8031.23	8032.11	2840.0
2018-11-13 00:00:00	YM	Futures	27696.3	27746.3	27658.3	27716.9	4430.0
2018-11-13 01:00:00	YM	Futures	27714.8	27722.4	27623.5	27638.7	2261.0
2018-11-13 02:00:00	YM	Futures	27639.8	27709.3	27630.0	27693.0	4005.0
2018-11-13 03:00:00	YM	Futures	27691.9	27776.7	27682.2	27690.9	6781.0

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

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