PREVIEW / futures_1hour / 2017-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-01.parquet
  size:    53 KB
  rows:    1,615

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
2017-08-01 00:00:00	ES	Futures	2703.87	2705.24	2703.6	2704.69	3680.0
2017-08-01 01:00:00	ES	Futures	2704.42	2705.24	2703.05	2703.6	4601.0
2017-08-01 02:00:00	ES	Futures	2703.87	2706.06	2703.6	2706.06	8993.0
2017-08-01 03:00:00	ES	Futures	2706.06	2706.61	2703.33	2706.33	26075.0
2017-08-01 04:00:00	ES	Futures	2706.06	2708.52	2705.51	2708.25	24227.0
2017-08-01 05:00:00	ES	Futures	2707.97	2708.52	2705.51	2706.33	18463.0
2017-08-01 06:00:00	ES	Futures	2706.33	2706.61	2703.6	2704.69	18216.0
2017-08-01 07:00:00	ES	Futures	2704.69	2704.69	2701.96	2703.87	20947.0
2017-08-01 08:00:00	ES	Futures	2703.87	2706.06	2703.05	2705.79	22564.0
2017-08-01 09:00:00	ES	Futures	2706.06	2707.15	2699.77	2700.32	168219.0
2017-08-01 10:00:00	ES	Futures	2700.59	2704.15	2698.68	2703.33	176961.0
2017-08-01 11:00:00	ES	Futures	2703.33	2704.15	2698.4	2703.6	137351.0
2017-08-01 12:00:00	ES	Futures	2703.6	2704.97	2703.05	2703.6	53748.0
2017-08-01 13:00:00	ES	Futures	2703.6	2704.97	2703.05	2704.42	34813.0
2017-08-01 14:00:00	ES	Futures	2704.42	2704.69	2703.05	2704.42	37136.0
2017-08-01 15:00:00	ES	Futures	2704.42	2704.69	2702.23	2703.87	153284.0
2017-08-01 16:00:00	ES	Futures	2703.87	2705.79	2701.96	2704.69	85568.0
2017-08-01 18:00:00	ES	Futures	2704.97	2706.61	2704.69	2704.97	8275.0
2017-08-01 19:00:00	ES	Futures	2704.97	2706.61	2704.97	2706.33	1670.0
2017-08-01 20:00:00	ES	Futures	2706.06	2706.33	2704.69	2704.97	3174.0
2017-08-01 21:00:00	ES	Futures	2704.97	2705.79	2704.15	2704.69	3199.0
2017-08-01 22:00:00	ES	Futures	2704.97	2705.79	2704.69	2705.79	1683.0
2017-08-01 23:00:00	ES	Futures	2705.79	2706.06	2705.24	2705.79	1409.0
2017-08-01 00:00:00	NQ	Futures	7033.18	7035.56	7031.1	7035.56	572.0
2017-08-01 01:00:00	NQ	Futures	7035.27	7036.76	7030.8	7030.8	656.0
2017-08-01 02:00:00	NQ	Futures	7031.1	7034.67	7028.72	7034.08	1675.0
2017-08-01 03:00:00	NQ	Futures	7034.08	7037.65	7028.72	7035.56	3330.0
2017-08-01 04:00:00	NQ	Futures	7035.56	7045.39	7033.78	7043.31	2662.0
2017-08-01 05:00:00	NQ	Futures	7043.31	7043.6	7036.76	7037.95	1822.0
2017-08-01 06:00:00	NQ	Futures	7038.24	7039.43	7029.01	7031.99	3603.0
2017-08-01 07:00:00	NQ	Futures	7031.99	7031.99	7021.27	7027.82	6174.0
2017-08-01 08:00:00	NQ	Futures	7027.82	7031.69	7023.06	7028.72	5050.0
2017-08-01 09:00:00	NQ	Futures	7028.72	7034.37	7010.85	7016.51	44142.0
2017-08-01 10:00:00	NQ	Futures	7016.81	7031.1	7001.32	7026.04	48206.0
2017-08-01 11:00:00	NQ	Futures	7025.74	7028.12	7005.79	7019.19	27778.0
2017-08-01 12:00:00	NQ	Futures	7019.19	7020.68	7010.55	7015.61	13816.0
2017-08-01 13:00:00	NQ	Futures	7015.32	7022.46	7012.64	7019.19	10896.0
2017-08-01 14:00:00	NQ	Futures	7019.19	7023.06	7012.64	7016.21	10661.0
2017-08-01 15:00:00	NQ	Futures	7016.81	7022.17	7009.66	7020.38	23554.0
2017-08-01 16:00:00	NQ	Futures	7020.68	7064.15	7009.96	7063.26	14367.0
2017-08-01 18:00:00	NQ	Futures	7066.23	7070.7	7059.38	7061.17	3716.0
2017-08-01 19:00:00	NQ	Futures	7060.87	7068.02	7060.87	7067.72	1168.0
2017-08-01 20:00:00	NQ	Futures	7068.02	7070.7	7064.45	7064.45	1571.0
2017-08-01 21:00:00	NQ	Futures	7064.74	7066.83	7061.77	7064.45	1125.0
2017-08-01 22:00:00	NQ	Futures	7064.74	7065.93	7062.36	7065.34	799.0
2017-08-01 23:00:00	NQ	Futures	7065.34	7066.53	7064.74	7066.23	570.0
2017-08-01 00:00:00	YM	Futures	23856.3	23873.7	23851.9	23863.9	2564.0
2017-08-01 01:00:00	YM	Futures	23862.8	23876.9	23847.5	23857.3	2359.0
2017-08-01 02:00:00	YM	Futures	23857.3	23884.6	23855.2	23883.5	2204.0
2017-08-01 03:00:00	YM	Futures	23884.6	23884.6	23861.7	23882.4	3143.0

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

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