PREVIEW / futures_1hour / 2019-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-29.parquet
  size:    41 KB
  rows:    1,198

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-29 00:00:00	ES	Futures	3417.12	3417.66	3414.4	3415.49	7537.0
2019-11-29 01:00:00	ES	Futures	3415.76	3416.85	3413.86	3416.3	6628.0
2019-11-29 02:00:00	ES	Futures	3416.3	3416.85	3414.94	3416.3	8448.0
2019-11-29 03:00:00	ES	Futures	3416.3	3418.2	3413.59	3418.2	22129.0
2019-11-29 04:00:00	ES	Futures	3418.2	3420.92	3417.93	3419.29	15368.0
2019-11-29 05:00:00	ES	Futures	3419.29	3420.11	3417.93	3418.75	8225.0
2019-11-29 06:00:00	ES	Futures	3418.75	3420.38	3417.93	3419.56	7958.0
2019-11-29 07:00:00	ES	Futures	3419.29	3421.46	3419.29	3420.92	12628.0
2019-11-29 08:00:00	ES	Futures	3420.92	3422.01	3419.83	3420.11	13367.0
2019-11-29 09:00:00	ES	Futures	3420.11	3422.55	3416.85	3421.19	111432.0
2019-11-29 10:00:00	ES	Futures	3421.19	3422.82	3419.02	3419.83	101204.0
2019-11-29 11:00:00	ES	Futures	3420.11	3420.11	3415.22	3418.75	97760.0
2019-11-29 12:00:00	ES	Futures	3418.75	3419.56	3411.14	3413.59	199493.0
2019-11-29 13:00:00	ES	Futures	3413.86	3417.12	3413.31	3415.76	60127.0
2019-11-29 00:00:00	NQ	Futures	9788.14	9788.72	9777.39	9782.62	3720.0
2019-11-29 01:00:00	NQ	Futures	9782.33	9787.85	9770.42	9784.36	4468.0
2019-11-29 02:00:00	NQ	Futures	9784.36	9789.01	9780.0	9787.27	3631.0
2019-11-29 03:00:00	NQ	Futures	9787.56	9794.53	9777.68	9793.95	6039.0
2019-11-29 04:00:00	NQ	Futures	9793.95	9799.18	9791.91	9795.11	4631.0
2019-11-29 05:00:00	NQ	Futures	9795.11	9798.89	9791.33	9794.24	2657.0
2019-11-29 06:00:00	NQ	Futures	9794.53	9802.66	9791.91	9800.63	2333.0
2019-11-29 07:00:00	NQ	Futures	9800.34	9807.6	9798.31	9801.21	3425.0
2019-11-29 08:00:00	NQ	Futures	9800.92	9802.66	9793.66	9793.95	4663.0
2019-11-29 09:00:00	NQ	Futures	9793.95	9805.86	9785.52	9804.7	34636.0
2019-11-29 10:00:00	NQ	Futures	9804.41	9807.6	9789.01	9795.98	31506.0
2019-11-29 11:00:00	NQ	Futures	9796.27	9796.56	9778.55	9793.66	24647.0
2019-11-29 12:00:00	NQ	Futures	9793.37	9793.66	9768.09	9771.29	27568.0
2019-11-29 13:00:00	NQ	Futures	9771.58	9788.14	9770.71	9786.69	7642.0
2019-11-29 00:00:00	YM	Futures	30546.8	30549.0	30528.3	30537.0	1632.0
2019-11-29 01:00:00	YM	Futures	30535.9	30550.0	30526.1	30540.3	1225.0
2019-11-29 02:00:00	YM	Futures	30542.4	30546.8	30532.6	30542.4	1550.0
2019-11-29 03:00:00	YM	Futures	30543.5	30562.0	30519.6	30560.9	3413.0
2019-11-29 04:00:00	YM	Futures	30562.0	30581.6	30559.8	30574.0	2961.0
2019-11-29 05:00:00	YM	Futures	30574.0	30578.3	30564.2	30571.8	1502.0
2019-11-29 06:00:00	YM	Futures	30572.9	30582.7	30565.3	30579.4	1260.0
2019-11-29 07:00:00	YM	Futures	30578.3	30594.7	30575.1	30588.1	2009.0
2019-11-29 08:00:00	YM	Futures	30587.1	30589.2	30567.5	30572.9	2501.0
2019-11-29 09:00:00	YM	Futures	30572.9	30580.5	30539.2	30570.7	11841.0
2019-11-29 10:00:00	YM	Futures	30569.6	30597.9	30565.3	30575.1	10222.0
2019-11-29 11:00:00	YM	Futures	30575.1	30580.5	30537.0	30563.1	8578.0
2019-11-29 12:00:00	YM	Futures	30563.1	30577.3	30519.6	30535.9	10515.0
2019-11-29 13:00:00	YM	Futures	30537.0	30564.2	30537.0	30544.6	3842.0
2019-11-29 00:00:00	CL	Futures	51.42	51.44	51.37	51.42	2304.0
2019-11-29 01:00:00	CL	Futures	51.42	51.53	51.38	51.53	3394.0
2019-11-29 02:00:00	CL	Futures	51.53	51.59	51.49	51.53	5261.0
2019-11-29 03:00:00	CL	Futures	51.53	51.59	51.36	51.41	11955.0
2019-11-29 04:00:00	CL	Futures	51.41	51.5	51.32	51.42	13609.0
2019-11-29 05:00:00	CL	Futures	51.42	51.55	51.36	51.51	9999.0
2019-11-29 06:00:00	CL	Futures	51.51	51.53	51.43	51.49	5688.0
2019-11-29 07:00:00	CL	Futures	51.48	51.52	51.43	51.48	5399.0

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

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