PREVIEW / futures_1hour / 2016-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-14.parquet
  size:    52 KB
  rows:    1,586

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-03-14 00:00:00	ES	Futures	2169.02	2170.37	2167.67	2168.48	2474.0
2016-03-14 01:00:00	ES	Futures	2168.48	2169.56	2167.4	2168.21	2737.0
2016-03-14 02:00:00	ES	Futures	2168.21	2168.48	2167.4	2167.94	2537.0
2016-03-14 03:00:00	ES	Futures	2168.21	2170.1	2166.32	2168.75	13267.0
2016-03-14 04:00:00	ES	Futures	2169.02	2172.26	2166.86	2167.4	29009.0
2016-03-14 05:00:00	ES	Futures	2167.4	2171.72	2166.59	2167.67	16789.0
2016-03-14 06:00:00	ES	Futures	2167.4	2169.29	2165.51	2167.67	13281.0
2016-03-14 07:00:00	ES	Futures	2167.67	2167.94	2164.43	2165.51	14831.0
2016-03-14 08:00:00	ES	Futures	2165.51	2166.86	2164.97	2165.24	19856.0
2016-03-14 09:00:00	ES	Futures	2165.51	2169.29	2162.54	2163.08	162822.0
2016-03-14 10:00:00	ES	Futures	2163.08	2170.37	2162.0	2166.86	190752.0
2016-03-14 11:00:00	ES	Futures	2166.86	2169.56	2165.24	2165.78	130704.0
2016-03-14 12:00:00	ES	Futures	2166.05	2171.72	2164.7	2171.45	109384.0
2016-03-14 13:00:00	ES	Futures	2171.18	2172.8	2170.37	2170.91	69673.0
2016-03-14 14:00:00	ES	Futures	2171.18	2174.69	2168.75	2173.88	93076.0
2016-03-14 15:00:00	ES	Futures	2173.88	2176.04	2169.83	2170.1	148759.0
2016-03-14 16:00:00	ES	Futures	2170.37	2171.72	2169.29	2169.83	49460.0
2016-03-14 18:00:00	ES	Futures	2169.83	2170.64	2169.29	2170.1	1983.0
2016-03-14 19:00:00	ES	Futures	2170.1	2170.64	2169.56	2170.1	1700.0
2016-03-14 20:00:00	ES	Futures	2170.37	2170.64	2169.56	2169.83	2540.0
2016-03-14 21:00:00	ES	Futures	2169.83	2170.37	2167.4	2167.67	4040.0
2016-03-14 22:00:00	ES	Futures	2167.67	2168.21	2166.59	2167.4	2573.0
2016-03-14 23:00:00	ES	Futures	2167.4	2169.56	2163.62	2165.51	11749.0
2016-03-14 00:00:00	NQ	Futures	5167.5	5171.07	5163.63	5165.41	288.0
2016-03-14 01:00:00	NQ	Futures	5165.41	5169.28	5163.93	5165.41	487.0
2016-03-14 02:00:00	NQ	Futures	5165.12	5165.41	5160.95	5164.52	681.0
2016-03-14 03:00:00	NQ	Futures	5164.82	5170.47	5160.65	5168.69	1550.0
2016-03-14 04:00:00	NQ	Futures	5168.98	5177.91	5163.63	5165.41	2868.0
2016-03-14 05:00:00	NQ	Futures	5165.71	5176.72	5163.33	5165.71	1518.0
2016-03-14 06:00:00	NQ	Futures	5166.01	5169.88	5161.25	5166.31	1195.0
2016-03-14 07:00:00	NQ	Futures	5166.01	5166.9	5155.0	5156.49	2899.0
2016-03-14 08:00:00	NQ	Futures	5156.78	5159.46	5155.3	5157.68	3211.0
2016-03-14 09:00:00	NQ	Futures	5158.27	5175.23	5156.19	5164.82	24603.0
2016-03-14 10:00:00	NQ	Futures	5164.82	5189.51	5163.93	5180.59	26435.0
2016-03-14 11:00:00	NQ	Futures	5180.29	5192.49	5177.91	5182.67	19713.0
2016-03-14 12:00:00	NQ	Futures	5182.37	5196.36	5180.59	5194.87	14754.0
2016-03-14 13:00:00	NQ	Futures	5194.87	5196.95	5190.41	5190.7	8131.0
2016-03-14 14:00:00	NQ	Futures	5191.0	5195.46	5182.37	5195.17	12627.0
2016-03-14 15:00:00	NQ	Futures	5195.17	5201.12	5186.24	5186.84	20359.0
2016-03-14 16:00:00	NQ	Futures	5187.13	5191.0	5183.56	5186.24	3938.0
2016-03-14 18:00:00	NQ	Futures	5183.86	5187.43	5182.97	5187.13	293.0
2016-03-14 19:00:00	NQ	Futures	5187.43	5188.03	5185.05	5186.54	195.0
2016-03-14 20:00:00	NQ	Futures	5186.24	5187.43	5183.86	5184.46	383.0
2016-03-14 21:00:00	NQ	Futures	5184.16	5185.35	5176.72	5177.91	625.0
2016-03-14 22:00:00	NQ	Futures	5177.91	5179.1	5175.83	5176.72	374.0
2016-03-14 23:00:00	NQ	Futures	5177.02	5184.46	5166.6	5172.26	1477.0
2016-03-14 00:00:00	YM	Futures	18287.6	18297.2	18273.7	18280.1	343.0
2016-03-14 01:00:00	YM	Futures	18282.3	18289.8	18272.6	18276.9	209.0
2016-03-14 02:00:00	YM	Futures	18278.0	18279.0	18268.3	18279.0	525.0
2016-03-14 03:00:00	YM	Futures	18280.1	18296.2	18266.2	18288.7	1261.0

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

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