PREVIEW / futures_1hour / 2019-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-13.parquet
  size:    53 KB
  rows:    1,712

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-06-13 00:00:00	ES	Futures	3119.84	3120.93	3117.41	3119.57	5805.0
2019-06-13 01:00:00	ES	Futures	3119.57	3122.01	3116.05	3120.66	10098.0
2019-06-13 02:00:00	ES	Futures	3120.93	3123.1	3118.76	3121.2	12941.0
2019-06-13 03:00:00	ES	Futures	3121.2	3133.13	3118.76	3130.15	35162.0
2019-06-13 04:00:00	ES	Futures	3130.15	3136.92	3128.52	3134.48	25703.0
2019-06-13 05:00:00	ES	Futures	3134.48	3136.38	3132.32	3132.32	17937.0
2019-06-13 06:00:00	ES	Futures	3132.59	3138.82	3131.23	3138.55	20545.0
2019-06-13 07:00:00	ES	Futures	3138.28	3138.82	3132.86	3134.48	15394.0
2019-06-13 08:00:00	ES	Futures	3134.48	3136.11	3130.96	3134.76	25618.0
2019-06-13 09:00:00	ES	Futures	3134.76	3140.99	3131.77	3138.01	124121.0
2019-06-13 10:00:00	ES	Futures	3138.01	3139.36	3128.79	3129.33	163384.0
2019-06-13 11:00:00	ES	Futures	3129.33	3134.21	3126.08	3133.13	104402.0
2019-06-13 12:00:00	ES	Futures	3133.4	3138.01	3130.15	3137.74	91920.0
2019-06-13 13:00:00	ES	Futures	3138.01	3139.91	3134.21	3136.38	62363.0
2019-06-13 14:00:00	ES	Futures	3136.38	3136.65	3129.33	3132.32	78483.0
2019-06-13 15:00:00	ES	Futures	3132.32	3138.55	3126.35	3137.47	186787.0
2019-06-13 16:00:00	ES	Futures	3137.47	3139.91	3136.38	3138.82	50641.0
2019-06-13 18:00:00	ES	Futures	3138.01	3138.28	3133.94	3136.65	4905.0
2019-06-13 19:00:00	ES	Futures	3136.38	3138.28	3135.03	3135.3	4062.0
2019-06-13 20:00:00	ES	Futures	3135.3	3138.82	3132.86	3136.65	9493.0
2019-06-13 21:00:00	ES	Futures	3136.92	3143.43	3136.11	3140.18	15894.0
2019-06-13 22:00:00	ES	Futures	3140.18	3142.35	3138.55	3142.08	6398.0
2019-06-13 23:00:00	ES	Futures	3142.35	3142.35	3140.45	3140.99	2559.0
2019-06-13 00:00:00	NQ	Futures	8685.77	8688.97	8676.45	8683.73	2552.0
2019-06-13 01:00:00	NQ	Futures	8683.44	8691.3	8671.79	8687.22	4608.0
2019-06-13 02:00:00	NQ	Futures	8687.51	8695.96	8679.65	8688.97	5513.0
2019-06-13 03:00:00	NQ	Futures	8689.26	8741.38	8679.36	8727.11	13551.0
2019-06-13 04:00:00	NQ	Futures	8727.11	8754.48	8721.58	8746.04	8765.0
2019-06-13 05:00:00	NQ	Futures	8745.75	8752.73	8738.47	8739.05	5505.0
2019-06-13 06:00:00	NQ	Futures	8739.34	8762.34	8733.52	8761.76	5878.0
2019-06-13 07:00:00	NQ	Futures	8761.47	8762.63	8737.88	8745.45	5536.0
2019-06-13 08:00:00	NQ	Futures	8745.45	8748.07	8727.11	8743.71	9050.0
2019-06-13 09:00:00	NQ	Futures	8743.71	8775.15	8731.77	8770.2	47705.0
2019-06-13 10:00:00	NQ	Futures	8770.78	8776.61	8738.76	8739.63	66108.0
2019-06-13 11:00:00	NQ	Futures	8739.92	8754.77	8725.07	8750.7	43884.0
2019-06-13 12:00:00	NQ	Futures	8750.7	8758.85	8733.81	8755.35	27052.0
2019-06-13 13:00:00	NQ	Futures	8755.64	8760.59	8744.87	8755.35	17284.0
2019-06-13 14:00:00	NQ	Futures	8755.06	8756.23	8727.69	8739.92	22845.0
2019-06-13 15:00:00	NQ	Futures	8739.63	8757.97	8722.45	8756.52	39430.0
2019-06-13 16:00:00	NQ	Futures	8756.23	8767.0	8746.62	8748.07	9786.0
2019-06-13 18:00:00	NQ	Futures	8738.47	8738.47	8725.95	8734.68	1877.0
2019-06-13 19:00:00	NQ	Futures	8735.26	8740.21	8728.86	8729.44	1682.0
2019-06-13 20:00:00	NQ	Futures	8729.44	8733.52	8718.09	8726.82	4685.0
2019-06-13 21:00:00	NQ	Futures	8727.11	8758.85	8725.07	8746.62	6481.0
2019-06-13 22:00:00	NQ	Futures	8746.33	8756.52	8739.92	8756.23	3142.0
2019-06-13 23:00:00	NQ	Futures	8755.64	8757.39	8748.07	8750.99	1150.0
2019-06-13 00:00:00	YM	Futures	28255.4	28255.4	28225.0	28247.8	73.0
2019-06-13 01:00:00	YM	Futures	28245.6	28268.5	28219.5	28256.5	154.0
2019-06-13 02:00:00	YM	Futures	28262.0	28281.5	28242.4	28264.1	132.0
2019-06-13 03:00:00	YM	Futures	28269.6	28370.7	28246.7	28337.0	523.0

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

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