PREVIEW / futures_1hour / 2019-11-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-11.parquet
  size:    57 KB
  rows:    1,840

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-11-11 00:00:00	ES	Futures	3349.48	3349.48	3347.58	3348.67	6822.0
2019-11-11 01:00:00	ES	Futures	3348.4	3348.67	3344.32	3345.14	12759.0
2019-11-11 02:00:00	ES	Futures	3345.14	3346.22	3342.96	3345.95	13346.0
2019-11-11 03:00:00	ES	Futures	3345.68	3350.02	3344.86	3349.75	19789.0
2019-11-11 04:00:00	ES	Futures	3349.75	3349.75	3344.86	3346.49	17330.0
2019-11-11 05:00:00	ES	Futures	3346.49	3346.77	3343.23	3344.86	12457.0
2019-11-11 06:00:00	ES	Futures	3345.14	3347.31	3343.23	3346.22	18562.0
2019-11-11 07:00:00	ES	Futures	3346.22	3346.77	3344.05	3345.41	17013.0
2019-11-11 08:00:00	ES	Futures	3345.41	3345.95	3343.78	3344.32	16807.0
2019-11-11 09:00:00	ES	Futures	3344.32	3348.67	3340.52	3348.67	147511.0
2019-11-11 10:00:00	ES	Futures	3348.67	3350.57	3347.04	3347.31	107757.0
2019-11-11 11:00:00	ES	Futures	3347.58	3349.75	3346.49	3349.48	71476.0
2019-11-11 12:00:00	ES	Futures	3349.48	3352.47	3348.67	3351.93	62727.0
2019-11-11 13:00:00	ES	Futures	3351.93	3354.37	3351.65	3354.1	39770.0
2019-11-11 14:00:00	ES	Futures	3354.1	3354.1	3351.65	3352.74	36361.0
2019-11-11 15:00:00	ES	Futures	3352.74	3354.1	3349.75	3352.74	111725.0
2019-11-11 16:00:00	ES	Futures	3353.01	3355.19	3351.93	3354.64	48644.0
2019-11-11 18:00:00	ES	Futures	3354.91	3355.46	3351.65	3351.93	6565.0
2019-11-11 19:00:00	ES	Futures	3352.2	3353.56	3349.75	3353.56	7670.0
2019-11-11 20:00:00	ES	Futures	3353.56	3353.56	3348.94	3349.21	8809.0
2019-11-11 21:00:00	ES	Futures	3349.21	3350.57	3348.12	3348.67	5125.0
2019-11-11 22:00:00	ES	Futures	3348.67	3350.57	3347.85	3349.75	4652.0
2019-11-11 23:00:00	ES	Futures	3350.02	3352.2	3349.21	3351.93	2905.0
2019-11-11 00:00:00	NQ	Futures	9570.85	9571.14	9564.17	9568.53	2314.0
2019-11-11 01:00:00	NQ	Futures	9568.53	9568.53	9552.84	9556.33	4859.0
2019-11-11 02:00:00	NQ	Futures	9556.03	9561.26	9552.84	9558.36	4016.0
2019-11-11 03:00:00	NQ	Futures	9558.65	9569.69	9555.16	9565.62	7011.0
2019-11-11 04:00:00	NQ	Futures	9565.04	9565.04	9544.12	9552.55	8054.0
2019-11-11 05:00:00	NQ	Futures	9552.55	9555.45	9545.58	9551.39	3743.0
2019-11-11 06:00:00	NQ	Futures	9551.39	9556.91	9545.87	9553.42	5688.0
2019-11-11 07:00:00	NQ	Futures	9553.42	9556.91	9549.35	9554.29	4538.0
2019-11-11 08:00:00	NQ	Futures	9554.58	9560.39	9549.64	9555.74	5688.0
2019-11-11 09:00:00	NQ	Futures	9556.03	9561.55	9535.7	9561.26	45184.0
2019-11-11 10:00:00	NQ	Futures	9561.26	9577.82	9553.42	9566.49	31134.0
2019-11-11 11:00:00	NQ	Futures	9566.78	9574.05	9563.59	9572.01	19937.0
2019-11-11 12:00:00	NQ	Futures	9572.01	9581.02	9566.49	9579.56	16084.0
2019-11-11 13:00:00	NQ	Futures	9579.56	9588.57	9577.82	9587.41	11654.0
2019-11-11 14:00:00	NQ	Futures	9587.12	9587.41	9578.98	9583.63	10383.0
2019-11-11 15:00:00	NQ	Futures	9583.92	9588.28	9574.34	9585.08	23978.0
2019-11-11 16:00:00	NQ	Futures	9585.08	9591.47	9581.31	9590.6	7937.0
2019-11-11 18:00:00	NQ	Futures	9590.02	9597.28	9577.82	9579.27	2253.0
2019-11-11 19:00:00	NQ	Futures	9579.56	9583.92	9572.01	9583.63	2994.0
2019-11-11 20:00:00	NQ	Futures	9583.63	9583.63	9566.78	9567.95	3431.0
2019-11-11 21:00:00	NQ	Futures	9567.95	9572.01	9563.59	9565.04	2623.0
2019-11-11 22:00:00	NQ	Futures	9564.75	9571.43	9561.26	9569.11	2192.0
2019-11-11 23:00:00	NQ	Futures	9569.4	9580.15	9568.53	9578.98	1682.0
2019-11-11 00:00:00	YM	Futures	29989.5	29989.5	29970.0	29983.0	1579.0
2019-11-11 01:00:00	YM	Futures	29984.1	29984.1	29930.8	29946.0	2468.0
2019-11-11 02:00:00	YM	Futures	29944.9	29959.1	29926.4	29953.6	2726.0
2019-11-11 03:00:00	YM	Futures	29954.7	30000.4	29949.3	29997.2	3492.0

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

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