PREVIEW / futures_1hour / 2016-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-28.parquet
  size:    53 KB
  rows:    1,621

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-28 00:00:00	ES	Futures	2337.97	2339.88	2337.43	2339.61	2149.0
2016-09-28 01:00:00	ES	Futures	2339.61	2340.97	2338.79	2340.7	3353.0
2016-09-28 02:00:00	ES	Futures	2340.97	2342.33	2339.61	2342.33	7599.0
2016-09-28 03:00:00	ES	Futures	2342.06	2347.5	2341.78	2346.41	36128.0
2016-09-28 04:00:00	ES	Futures	2346.68	2348.59	2344.78	2345.87	23365.0
2016-09-28 05:00:00	ES	Futures	2345.59	2346.41	2337.7	2339.61	34523.0
2016-09-28 06:00:00	ES	Futures	2339.61	2343.69	2339.06	2342.6	15140.0
2016-09-28 07:00:00	ES	Futures	2342.6	2344.78	2341.51	2342.87	15667.0
2016-09-28 08:00:00	ES	Futures	2342.87	2344.5	2342.06	2342.33	27470.0
2016-09-28 09:00:00	ES	Futures	2342.33	2347.77	2342.33	2345.32	170879.0
2016-09-28 10:00:00	ES	Futures	2345.32	2347.5	2336.07	2337.43	243035.0
2016-09-28 11:00:00	ES	Futures	2337.43	2339.61	2333.35	2339.06	202903.0
2016-09-28 12:00:00	ES	Futures	2339.06	2340.97	2336.07	2339.34	139557.0
2016-09-28 13:00:00	ES	Futures	2339.06	2343.96	2336.89	2342.6	102263.0
2016-09-28 14:00:00	ES	Futures	2342.6	2354.3	2341.51	2352.67	317819.0
2016-09-28 15:00:00	ES	Futures	2352.67	2356.48	2349.13	2354.84	260035.0
2016-09-28 16:00:00	ES	Futures	2355.12	2355.39	2352.94	2353.76	89380.0
2016-09-28 18:00:00	ES	Futures	2353.21	2353.76	2352.4	2353.21	3757.0
2016-09-28 19:00:00	ES	Futures	2353.21	2356.2	2352.94	2355.12	4188.0
2016-09-28 20:00:00	ES	Futures	2355.12	2357.29	2354.03	2356.75	6170.0
2016-09-28 21:00:00	ES	Futures	2356.75	2358.11	2356.2	2357.29	7027.0
2016-09-28 22:00:00	ES	Futures	2357.56	2357.84	2356.48	2357.02	3147.0
2016-09-28 23:00:00	ES	Futures	2357.02	2357.56	2356.2	2357.56	2116.0
2016-09-28 00:00:00	NQ	Futures	5788.0	5795.16	5787.1	5794.26	653.0
2016-09-28 01:00:00	NQ	Futures	5794.56	5797.24	5792.47	5796.65	487.0
2016-09-28 02:00:00	NQ	Futures	5796.65	5800.53	5793.37	5799.93	1230.0
2016-09-28 03:00:00	NQ	Futures	5800.53	5813.06	5799.63	5811.27	5591.0
2016-09-28 04:00:00	NQ	Futures	5811.27	5815.44	5805.9	5808.28	3473.0
2016-09-28 05:00:00	NQ	Futures	5808.58	5810.07	5790.08	5795.16	4553.0
2016-09-28 06:00:00	NQ	Futures	5795.45	5804.7	5794.26	5802.61	2832.0
2016-09-28 07:00:00	NQ	Futures	5802.32	5808.28	5800.53	5804.11	2483.0
2016-09-28 08:00:00	NQ	Futures	5804.11	5808.28	5801.12	5802.61	3398.0
2016-09-28 09:00:00	NQ	Futures	5802.61	5810.07	5801.42	5805.0	23720.0
2016-09-28 10:00:00	NQ	Futures	5805.3	5812.76	5788.89	5790.98	33238.0
2016-09-28 11:00:00	NQ	Futures	5790.98	5796.05	5781.43	5794.86	29988.0
2016-09-28 12:00:00	NQ	Futures	5794.56	5797.84	5786.21	5794.56	16625.0
2016-09-28 13:00:00	NQ	Futures	5794.56	5804.4	5788.0	5800.23	13016.0
2016-09-28 14:00:00	NQ	Futures	5800.23	5811.56	5796.05	5808.28	32526.0
2016-09-28 15:00:00	NQ	Futures	5808.28	5815.14	5799.93	5812.16	23365.0
2016-09-28 16:00:00	NQ	Futures	5812.16	5812.76	5807.69	5809.18	5420.0
2016-09-28 18:00:00	NQ	Futures	5807.69	5809.18	5806.19	5807.69	465.0
2016-09-28 19:00:00	NQ	Futures	5807.69	5813.95	5807.69	5810.97	477.0
2016-09-28 20:00:00	NQ	Futures	5810.97	5816.04	5810.07	5814.25	731.0
2016-09-28 21:00:00	NQ	Futures	5814.55	5819.32	5812.76	5816.34	1152.0
2016-09-28 22:00:00	NQ	Futures	5816.64	5818.13	5814.55	5816.04	352.0
2016-09-28 23:00:00	NQ	Futures	5816.64	5818.13	5815.44	5817.23	279.0
2016-09-28 00:00:00	YM	Futures	19565.0	19582.3	19561.8	19579.1	419.0
2016-09-28 01:00:00	YM	Futures	19579.1	19586.7	19571.5	19584.5	616.0
2016-09-28 02:00:00	YM	Futures	19584.5	19604.0	19576.9	19604.0	1409.0
2016-09-28 03:00:00	YM	Futures	19604.0	19641.8	19601.8	19633.1	4643.0

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

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