PREVIEW / futures_1hour / 2016-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-05.parquet
  size:    36 KB
  rows:    1,099

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
2016-09-05 00:00:00	ES	Futures	2365.83	2366.92	2365.83	2366.37	1546.0
2016-09-05 01:00:00	ES	Futures	2366.64	2366.92	2366.37	2366.64	2067.0
2016-09-05 02:00:00	ES	Futures	2366.92	2367.19	2365.56	2365.56	5017.0
2016-09-05 03:00:00	ES	Futures	2365.56	2367.19	2364.47	2365.29	21642.0
2016-09-05 04:00:00	ES	Futures	2365.29	2366.92	2364.75	2366.1	12766.0
2016-09-05 05:00:00	ES	Futures	2366.1	2366.92	2364.75	2364.75	12948.0
2016-09-05 06:00:00	ES	Futures	2365.02	2365.29	2363.93	2365.02	6788.0
2016-09-05 07:00:00	ES	Futures	2365.02	2365.29	2363.93	2364.47	6672.0
2016-09-05 08:00:00	ES	Futures	2364.47	2364.75	2363.66	2363.66	6239.0
2016-09-05 09:00:00	ES	Futures	2363.66	2364.75	2361.76	2362.03	10292.0
2016-09-05 10:00:00	ES	Futures	2361.76	2362.03	2359.32	2360.41	12734.0
2016-09-05 11:00:00	ES	Futures	2360.41	2362.03	2360.14	2361.76	8584.0
2016-09-05 12:00:00	ES	Futures	2361.49	2363.93	2361.49	2363.39	5613.0
2016-09-05 18:00:00	ES	Futures	2363.39	2363.66	2361.49	2362.03	1706.0
2016-09-05 19:00:00	ES	Futures	2362.03	2362.58	2361.76	2362.58	853.0
2016-09-05 20:00:00	ES	Futures	2362.85	2363.66	2362.03	2362.85	2817.0
2016-09-05 21:00:00	ES	Futures	2362.85	2364.2	2362.58	2362.85	3570.0
2016-09-05 22:00:00	ES	Futures	2362.85	2363.93	2362.58	2363.93	1999.0
2016-09-05 23:00:00	ES	Futures	2363.93	2365.02	2363.66	2364.75	2392.0
2016-09-05 00:00:00	NQ	Futures	5725.87	5729.45	5725.87	5727.95	495.0
2016-09-05 01:00:00	NQ	Futures	5728.25	5729.74	5727.06	5728.55	413.0
2016-09-05 02:00:00	NQ	Futures	5728.85	5729.45	5725.57	5727.06	1097.0
2016-09-05 03:00:00	NQ	Futures	5727.06	5728.85	5719.91	5722.29	3265.0
2016-09-05 04:00:00	NQ	Futures	5722.59	5725.57	5720.8	5722.89	1319.0
2016-09-05 05:00:00	NQ	Futures	5722.89	5724.08	5719.01	5720.21	1800.0
2016-09-05 06:00:00	NQ	Futures	5720.21	5721.1	5718.12	5720.21	759.0
2016-09-05 07:00:00	NQ	Futures	5720.5	5721.4	5719.01	5720.5	525.0
2016-09-05 08:00:00	NQ	Futures	5720.5	5721.1	5718.42	5718.72	647.0
2016-09-05 09:00:00	NQ	Futures	5718.72	5719.61	5707.39	5708.28	3059.0
2016-09-05 10:00:00	NQ	Futures	5707.99	5708.58	5701.43	5705.0	3255.0
2016-09-05 11:00:00	NQ	Futures	5705.3	5710.37	5705.0	5708.28	1402.0
2016-09-05 12:00:00	NQ	Futures	5708.88	5714.24	5707.99	5713.65	1290.0
2016-09-05 18:00:00	NQ	Futures	5714.24	5716.33	5709.77	5711.26	444.0
2016-09-05 19:00:00	NQ	Futures	5711.56	5712.46	5710.97	5712.46	118.0
2016-09-05 20:00:00	NQ	Futures	5712.75	5715.14	5711.26	5713.95	425.0
2016-09-05 21:00:00	NQ	Futures	5713.95	5718.72	5713.05	5714.24	1032.0
2016-09-05 22:00:00	NQ	Futures	5714.54	5716.93	5713.65	5716.33	321.0
2016-09-05 23:00:00	NQ	Futures	5716.33	5719.61	5716.03	5718.12	426.0
2016-09-05 00:00:00	YM	Futures	19919.5	19927.0	19919.5	19922.7	240.0
2016-09-05 01:00:00	YM	Futures	19921.6	19928.1	19920.6	19925.9	495.0
2016-09-05 02:00:00	YM	Futures	19927.0	19929.2	19916.2	19920.6	969.0
2016-09-05 03:00:00	YM	Futures	19919.5	19929.2	19905.5	19911.9	2688.0
2016-09-05 04:00:00	YM	Futures	19911.9	19919.5	19907.6	19913.0	1652.0
2016-09-05 05:00:00	YM	Futures	19914.1	19918.4	19901.2	19906.6	1687.0
2016-09-05 06:00:00	YM	Futures	19907.6	19908.7	19899.0	19905.5	794.0
2016-09-05 07:00:00	YM	Futures	19906.6	19908.7	19896.9	19901.2	719.0
2016-09-05 08:00:00	YM	Futures	19902.3	19904.4	19896.9	19896.9	718.0
2016-09-05 09:00:00	YM	Futures	19899.0	19901.2	19880.7	19882.9	2261.0
2016-09-05 10:00:00	YM	Futures	19884.0	19885.0	19870.0	19879.7	2211.0
2016-09-05 11:00:00	YM	Futures	19879.7	19890.4	19876.4	19887.2	1197.0

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

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