PREVIEW / futures_1hour / 2019-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-26.parquet
  size:    56 KB
  rows:    1,830

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-26 00:00:00	ES	Futures	3405.98	3407.07	3404.08	3404.35	7529.0
2019-11-26 01:00:00	ES	Futures	3404.35	3405.44	3402.45	3404.35	5875.0
2019-11-26 02:00:00	ES	Futures	3404.08	3405.71	3403.81	3404.89	8392.0
2019-11-26 03:00:00	ES	Futures	3404.62	3405.17	3401.09	3402.45	16424.0
2019-11-26 04:00:00	ES	Futures	3402.72	3402.72	3398.65	3401.63	17907.0
2019-11-26 05:00:00	ES	Futures	3401.36	3403.81	3400.28	3402.99	8934.0
2019-11-26 06:00:00	ES	Futures	3402.99	3404.62	3401.91	3402.45	9495.0
2019-11-26 07:00:00	ES	Futures	3402.45	3404.62	3401.63	3403.26	7978.0
2019-11-26 08:00:00	ES	Futures	3403.26	3406.52	3402.99	3404.62	20088.0
2019-11-26 09:00:00	ES	Futures	3404.62	3408.97	3400.55	3408.15	135643.0
2019-11-26 10:00:00	ES	Futures	3408.15	3409.78	3404.62	3407.61	138520.0
2019-11-26 11:00:00	ES	Futures	3407.88	3410.6	3405.98	3409.78	107314.0
2019-11-26 12:00:00	ES	Futures	3410.06	3412.77	3408.7	3411.14	59200.0
2019-11-26 13:00:00	ES	Futures	3411.41	3411.96	3405.71	3407.34	63376.0
2019-11-26 14:00:00	ES	Futures	3407.34	3409.51	3406.8	3408.7	52570.0
2019-11-26 15:00:00	ES	Futures	3408.43	3413.86	3405.17	3411.14	188310.0
2019-11-26 16:00:00	ES	Futures	3411.41	3416.57	3410.33	3416.03	75243.0
2019-11-26 18:00:00	ES	Futures	3415.76	3416.03	3414.4	3414.94	6174.0
2019-11-26 19:00:00	ES	Futures	3415.22	3417.93	3413.59	3415.49	13005.0
2019-11-26 20:00:00	ES	Futures	3415.22	3416.85	3413.86	3414.94	8161.0
2019-11-26 21:00:00	ES	Futures	3415.22	3416.85	3414.67	3416.57	4047.0
2019-11-26 22:00:00	ES	Futures	3416.85	3418.75	3416.57	3417.93	4821.0
2019-11-26 23:00:00	ES	Futures	3417.66	3418.75	3417.12	3418.2	3582.0
2019-11-26 00:00:00	NQ	Futures	9744.56	9749.79	9737.88	9739.63	2329.0
2019-11-26 01:00:00	NQ	Futures	9739.63	9742.24	9732.07	9740.21	2588.0
2019-11-26 02:00:00	NQ	Futures	9739.92	9744.56	9738.46	9741.37	2949.0
2019-11-26 03:00:00	NQ	Futures	9741.66	9742.24	9728.3	9733.24	6369.0
2019-11-26 04:00:00	NQ	Futures	9733.24	9735.56	9721.33	9729.46	6667.0
2019-11-26 05:00:00	NQ	Futures	9729.46	9735.56	9723.94	9733.53	3312.0
2019-11-26 06:00:00	NQ	Futures	9733.53	9739.05	9730.33	9730.62	3580.0
2019-11-26 07:00:00	NQ	Futures	9730.33	9737.88	9728.01	9733.24	3126.0
2019-11-26 08:00:00	NQ	Futures	9733.53	9741.95	9730.33	9735.56	7309.0
2019-11-26 09:00:00	NQ	Futures	9735.27	9748.92	9724.23	9744.56	48915.0
2019-11-26 10:00:00	NQ	Futures	9745.73	9752.7	9730.04	9748.34	44205.0
2019-11-26 11:00:00	NQ	Futures	9748.63	9757.35	9739.05	9751.54	30553.0
2019-11-26 12:00:00	NQ	Futures	9751.83	9763.45	9747.18	9761.41	18032.0
2019-11-26 13:00:00	NQ	Futures	9761.41	9763.45	9748.92	9752.7	15854.0
2019-11-26 14:00:00	NQ	Futures	9752.7	9757.35	9747.47	9752.99	13809.0
2019-11-26 15:00:00	NQ	Futures	9752.99	9761.99	9741.95	9751.25	32355.0
2019-11-26 16:00:00	NQ	Futures	9751.25	9766.06	9750.37	9763.45	10122.0
2019-11-26 18:00:00	NQ	Futures	9763.74	9765.19	9757.06	9762.28	1888.0
2019-11-26 19:00:00	NQ	Futures	9761.99	9771.29	9757.35	9763.16	4391.0
2019-11-26 20:00:00	NQ	Futures	9763.16	9768.09	9757.35	9761.41	3276.0
2019-11-26 21:00:00	NQ	Futures	9761.7	9769.55	9760.54	9769.26	2339.0
2019-11-26 22:00:00	NQ	Futures	9768.97	9775.36	9768.97	9772.74	2440.0
2019-11-26 23:00:00	NQ	Futures	9773.03	9777.68	9771.29	9775.36	1550.0
2019-11-26 00:00:00	YM	Futures	30543.5	30552.2	30525.0	30529.4	1258.0
2019-11-26 01:00:00	YM	Futures	30528.3	30541.3	30516.3	30527.2	1102.0
2019-11-26 02:00:00	YM	Futures	30528.3	30543.5	30523.9	30529.4	1718.0
2019-11-26 03:00:00	YM	Futures	30530.5	30537.0	30501.1	30514.1	3621.0

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

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