PREVIEW / futures_1hour / 2019-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-24.parquet
  size:    49 KB
  rows:    1,489

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-24 00:00:00	ES	Futures	3066.71	3067.79	3066.17	3067.25	4138.0
2019-05-24 01:00:00	ES	Futures	3067.25	3069.42	3066.98	3069.15	7805.0
2019-05-24 02:00:00	ES	Futures	3068.88	3072.67	3067.25	3071.05	14136.0
2019-05-24 03:00:00	ES	Futures	3071.05	3074.84	3068.61	3074.03	25410.0
2019-05-24 04:00:00	ES	Futures	3073.76	3078.1	3073.49	3075.93	20961.0
2019-05-24 05:00:00	ES	Futures	3075.66	3078.1	3072.94	3075.93	16107.0
2019-05-24 06:00:00	ES	Futures	3075.93	3079.18	3075.93	3076.74	20123.0
2019-05-24 07:00:00	ES	Futures	3076.74	3078.91	3071.32	3071.59	39633.0
2019-05-24 08:00:00	ES	Futures	3071.59	3073.76	3069.69	3073.49	35758.0
2019-05-24 09:00:00	ES	Futures	3073.49	3081.89	3072.4	3075.38	175072.0
2019-05-24 10:00:00	ES	Futures	3075.38	3077.82	3061.02	3061.83	192413.0
2019-05-24 11:00:00	ES	Futures	3061.56	3068.34	3058.85	3066.17	139426.0
2019-05-24 12:00:00	ES	Futures	3066.44	3072.94	3063.18	3072.94	86505.0
2019-05-24 13:00:00	ES	Futures	3072.94	3074.3	3068.88	3069.96	58857.0
2019-05-24 14:00:00	ES	Futures	3069.96	3070.5	3065.35	3068.34	61574.0
2019-05-24 15:00:00	ES	Futures	3068.34	3070.78	3063.73	3066.71	139817.0
2019-05-24 16:00:00	ES	Futures	3066.71	3071.32	3065.9	3069.96	51627.0
2019-05-24 00:00:00	NQ	Futures	8543.68	8550.67	8543.1	8547.76	1326.0
2019-05-24 01:00:00	NQ	Futures	8548.34	8556.79	8546.89	8553.87	2477.0
2019-05-24 02:00:00	NQ	Futures	8553.87	8562.32	8544.27	8558.24	6273.0
2019-05-24 03:00:00	NQ	Futures	8557.95	8566.39	8544.85	8564.06	9012.0
2019-05-24 04:00:00	NQ	Futures	8564.06	8573.96	8562.61	8564.36	8589.0
2019-05-24 05:00:00	NQ	Futures	8563.77	8572.51	8556.49	8562.32	5073.0
2019-05-24 06:00:00	NQ	Futures	8562.32	8571.63	8560.57	8563.48	5697.0
2019-05-24 07:00:00	NQ	Futures	8563.48	8568.14	8540.48	8544.56	10646.0
2019-05-24 08:00:00	NQ	Futures	8544.56	8554.46	8535.82	8553.87	14528.0
2019-05-24 09:00:00	NQ	Futures	8554.16	8594.64	8549.22	8576.87	66920.0
2019-05-24 10:00:00	NQ	Futures	8576.29	8586.19	8519.81	8525.63	68145.0
2019-05-24 11:00:00	NQ	Futures	8525.05	8547.18	8514.28	8539.02	48118.0
2019-05-24 12:00:00	NQ	Futures	8538.73	8556.79	8525.92	8554.46	30792.0
2019-05-24 13:00:00	NQ	Futures	8554.46	8558.82	8532.33	8538.15	25125.0
2019-05-24 14:00:00	NQ	Futures	8537.86	8539.32	8518.64	8527.96	27002.0
2019-05-24 15:00:00	NQ	Futures	8527.96	8534.07	8502.34	8511.95	39164.0
2019-05-24 16:00:00	NQ	Futures	8511.66	8522.43	8506.12	8516.31	8813.0
2019-05-24 00:00:00	YM	Futures	27773.6	27779.0	27768.1	27774.7	1001.0
2019-05-24 01:00:00	YM	Futures	27776.8	27796.4	27771.4	27794.2	1644.0
2019-05-24 02:00:00	YM	Futures	27794.2	27830.1	27777.9	27820.4	3742.0
2019-05-24 03:00:00	YM	Futures	27819.3	27836.7	27795.3	27825.8	5771.0
2019-05-24 04:00:00	YM	Futures	27826.9	27875.8	27824.7	27857.3	5278.0
2019-05-24 05:00:00	YM	Futures	27856.2	27872.6	27831.2	27855.2	3468.0
2019-05-24 06:00:00	YM	Futures	27855.2	27894.3	27855.2	27870.4	4180.0
2019-05-24 07:00:00	YM	Futures	27870.4	27887.8	27826.9	27826.9	6542.0
2019-05-24 08:00:00	YM	Futures	27828.0	27842.1	27809.5	27834.5	5896.0
2019-05-24 09:00:00	YM	Futures	27834.5	27913.9	27824.7	27875.8	25964.0
2019-05-24 10:00:00	YM	Futures	27875.8	27890.0	27730.1	27736.6	30976.0
2019-05-24 11:00:00	YM	Futures	27735.5	27807.3	27734.4	27791.0	23062.0
2019-05-24 12:00:00	YM	Futures	27791.0	27863.9	27760.5	27863.9	19093.0
2019-05-24 13:00:00	YM	Futures	27863.9	27873.6	27812.7	27833.4	11943.0
2019-05-24 14:00:00	YM	Futures	27833.4	27849.7	27794.2	27831.2	11187.0
2019-05-24 15:00:00	YM	Futures	27831.2	27859.5	27813.8	27837.8	16069.0

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

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