PREVIEW / futures_1hour / 2019-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-13.parquet
  size:    60 KB
  rows:    1,842

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
2019-05-13 00:00:00	ES	Futures	3098.97	3099.78	3097.61	3099.24	3506.0
2019-05-13 01:00:00	ES	Futures	3099.24	3099.51	3095.72	3097.07	7062.0
2019-05-13 02:00:00	ES	Futures	3096.8	3099.78	3095.99	3096.26	9116.0
2019-05-13 03:00:00	ES	Futures	3096.53	3097.07	3085.69	3085.96	30779.0
2019-05-13 04:00:00	ES	Futures	3086.23	3094.36	3084.33	3090.57	28146.0
2019-05-13 05:00:00	ES	Futures	3090.29	3095.72	3090.29	3094.63	15067.0
2019-05-13 06:00:00	ES	Futures	3094.63	3095.72	3088.94	3093.01	19178.0
2019-05-13 07:00:00	ES	Futures	3093.01	3093.82	3082.98	3084.06	28931.0
2019-05-13 08:00:00	ES	Futures	3084.06	3085.69	3066.71	3068.61	145745.0
2019-05-13 09:00:00	ES	Futures	3068.34	3077.28	3059.12	3062.64	341632.0
2019-05-13 10:00:00	ES	Futures	3062.64	3066.98	3050.98	3059.39	411320.0
2019-05-13 11:00:00	ES	Futures	3059.39	3062.37	3046.38	3055.59	318133.0
2019-05-13 12:00:00	ES	Futures	3055.32	3055.59	3042.31	3042.58	232379.0
2019-05-13 13:00:00	ES	Futures	3042.31	3052.07	3038.51	3051.53	226068.0
2019-05-13 14:00:00	ES	Futures	3051.26	3063.18	3044.75	3058.58	346418.0
2019-05-13 15:00:00	ES	Futures	3058.3	3063.46	3041.5	3050.17	337205.0
2019-05-13 16:00:00	ES	Futures	3050.44	3051.53	3040.95	3045.29	91950.0
2019-05-13 18:00:00	ES	Futures	3042.85	3045.83	3036.07	3044.48	17193.0
2019-05-13 19:00:00	ES	Futures	3044.48	3045.29	3039.87	3040.41	6708.0
2019-05-13 20:00:00	ES	Futures	3040.41	3050.98	3039.87	3050.44	25227.0
2019-05-13 21:00:00	ES	Futures	3050.44	3059.66	3048.0	3057.49	31162.0
2019-05-13 22:00:00	ES	Futures	3057.76	3059.93	3056.41	3058.58	15591.0
2019-05-13 23:00:00	ES	Futures	3058.58	3060.74	3058.03	3059.93	11085.0
2019-05-13 00:00:00	NQ	Futures	8759.14	8764.09	8756.23	8762.34	1618.0
2019-05-13 01:00:00	NQ	Futures	8762.34	8763.21	8746.62	8754.48	3571.0
2019-05-13 02:00:00	NQ	Futures	8754.77	8760.59	8748.07	8749.53	3776.0
2019-05-13 03:00:00	NQ	Futures	8749.82	8753.02	8709.35	8709.64	12871.0
2019-05-13 04:00:00	NQ	Futures	8710.22	8727.4	8700.03	8714.59	12799.0
2019-05-13 05:00:00	NQ	Futures	8714.3	8730.61	8714.3	8726.24	5871.0
2019-05-13 06:00:00	NQ	Futures	8725.95	8729.73	8705.57	8720.12	7579.0
2019-05-13 07:00:00	NQ	Futures	8720.41	8723.04	8681.98	8686.64	13313.0
2019-05-13 08:00:00	NQ	Futures	8686.35	8693.34	8622.0	8633.36	46087.0
2019-05-13 09:00:00	NQ	Futures	8633.94	8670.63	8589.1	8608.61	101126.0
2019-05-13 10:00:00	NQ	Futures	8608.32	8614.73	8562.32	8591.72	124211.0
2019-05-13 11:00:00	NQ	Futures	8591.72	8603.37	8540.19	8569.89	89827.0
2019-05-13 12:00:00	NQ	Futures	8569.89	8571.34	8541.35	8543.39	55663.0
2019-05-13 13:00:00	NQ	Futures	8543.1	8573.67	8523.3	8570.47	61405.0
2019-05-13 14:00:00	NQ	Futures	8570.47	8601.04	8544.27	8586.19	84691.0
2019-05-13 15:00:00	NQ	Futures	8585.9	8601.91	8516.61	8541.94	78931.0
2019-05-13 16:00:00	NQ	Futures	8542.23	8546.3	8507.58	8518.35	16973.0
2019-05-13 18:00:00	NQ	Futures	8519.52	8521.56	8490.11	8518.64	6101.0
2019-05-13 19:00:00	NQ	Futures	8518.93	8524.18	8506.71	8509.91	3170.0
2019-05-13 20:00:00	NQ	Futures	8509.62	8541.65	8508.45	8537.57	11856.0
2019-05-13 21:00:00	NQ	Futures	8537.28	8578.62	8530.58	8571.93	13221.0
2019-05-13 22:00:00	NQ	Futures	8571.63	8581.53	8564.06	8570.18	7708.0
2019-05-13 23:00:00	NQ	Futures	8570.18	8579.79	8569.01	8576.0	2932.0
2019-05-13 00:00:00	YM	Futures	27973.7	27979.2	27960.7	27973.7	1492.0
2019-05-13 01:00:00	YM	Futures	27974.8	27974.8	27941.1	27950.9	2213.0
2019-05-13 02:00:00	YM	Futures	27950.9	27977.0	27940.0	27949.8	2661.0
2019-05-13 03:00:00	YM	Futures	27950.9	27959.6	27862.8	27869.3	7230.0

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

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