PREVIEW / futures_1hour / 2016-05-09

all futures 1-hour files

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

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-05-09 00:00:00	ES	Futures	2218.7	2219.78	2218.43	2219.24	1755.0
2016-05-09 01:00:00	ES	Futures	2218.97	2219.51	2217.89	2219.24	2236.0
2016-05-09 02:00:00	ES	Futures	2219.24	2220.86	2218.7	2219.51	12933.0
2016-05-09 03:00:00	ES	Futures	2219.51	2219.51	2212.76	2215.19	34429.0
2016-05-09 04:00:00	ES	Futures	2215.19	2222.48	2213.84	2222.48	31231.0
2016-05-09 05:00:00	ES	Futures	2222.21	2224.1	2221.94	2222.75	17683.0
2016-05-09 06:00:00	ES	Futures	2222.48	2223.29	2221.4	2221.94	16199.0
2016-05-09 07:00:00	ES	Futures	2222.21	2224.37	2221.4	2221.67	22892.0
2016-05-09 08:00:00	ES	Futures	2221.67	2221.67	2216.81	2217.35	32841.0
2016-05-09 09:00:00	ES	Futures	2217.35	2222.48	2212.76	2221.67	210113.0
2016-05-09 10:00:00	ES	Futures	2221.67	2223.29	2214.11	2216.54	225058.0
2016-05-09 11:00:00	ES	Futures	2216.54	2219.24	2211.95	2216.0	164411.0
2016-05-09 12:00:00	ES	Futures	2216.0	2218.7	2213.84	2217.89	108473.0
2016-05-09 13:00:00	ES	Futures	2217.89	2220.86	2217.35	2217.62	98037.0
2016-05-09 14:00:00	ES	Futures	2217.89	2223.29	2215.73	2222.75	120401.0
2016-05-09 15:00:00	ES	Futures	2222.75	2223.02	2216.27	2217.89	165847.0
2016-05-09 16:00:00	ES	Futures	2217.89	2219.51	2217.35	2218.43	56195.0
2016-05-09 18:00:00	ES	Futures	2218.16	2218.16	2211.68	2213.3	11589.0
2016-05-09 19:00:00	ES	Futures	2213.57	2215.19	2213.3	2215.19	4042.0
2016-05-09 20:00:00	ES	Futures	2215.19	2217.08	2214.65	2216.27	8756.0
2016-05-09 21:00:00	ES	Futures	2216.27	2221.4	2214.92	2220.86	12383.0
2016-05-09 22:00:00	ES	Futures	2220.86	2223.02	2220.05	2220.86	8642.0
2016-05-09 23:00:00	ES	Futures	2220.86	2223.83	2219.78	2223.83	6310.0
2016-05-09 00:00:00	NQ	Futures	5149.94	5154.4	5149.94	5153.21	525.0
2016-05-09 01:00:00	NQ	Futures	5152.92	5154.7	5149.94	5154.4	372.0
2016-05-09 02:00:00	NQ	Futures	5155.0	5160.36	5153.81	5158.27	1797.0
2016-05-09 03:00:00	NQ	Futures	5158.27	5158.27	5138.93	5145.48	3688.0
2016-05-09 04:00:00	NQ	Futures	5146.67	5166.6	5143.1	5166.6	3522.0
2016-05-09 05:00:00	NQ	Futures	5166.6	5173.45	5164.82	5167.5	2649.0
2016-05-09 06:00:00	NQ	Futures	5166.9	5169.58	5163.63	5163.63	2877.0
2016-05-09 07:00:00	NQ	Futures	5163.93	5169.58	5163.03	5164.22	2963.0
2016-05-09 08:00:00	NQ	Futures	5163.93	5165.71	5155.89	5156.78	7090.0
2016-05-09 09:00:00	NQ	Futures	5156.78	5175.23	5144.59	5174.93	36787.0
2016-05-09 10:00:00	NQ	Futures	5174.93	5179.4	5152.92	5162.74	39664.0
2016-05-09 11:00:00	NQ	Futures	5162.74	5170.77	5152.62	5164.52	22195.0
2016-05-09 12:00:00	NQ	Futures	5164.22	5171.96	5157.08	5168.98	16274.0
2016-05-09 13:00:00	NQ	Futures	5168.69	5176.72	5167.2	5168.69	10744.0
2016-05-09 14:00:00	NQ	Futures	5168.69	5184.75	5163.63	5181.78	17690.0
2016-05-09 15:00:00	NQ	Futures	5181.78	5182.97	5156.78	5159.46	24949.0
2016-05-09 16:00:00	NQ	Futures	5159.46	5162.74	5156.78	5160.06	5705.0
2016-05-09 18:00:00	NQ	Futures	5158.87	5160.06	5145.78	5152.32	2226.0
2016-05-09 19:00:00	NQ	Futures	5152.02	5156.19	5151.13	5155.59	454.0
2016-05-09 20:00:00	NQ	Futures	5155.3	5159.76	5153.51	5157.08	967.0
2016-05-09 21:00:00	NQ	Futures	5157.08	5170.17	5153.51	5168.39	1604.0
2016-05-09 22:00:00	NQ	Futures	5168.39	5173.74	5165.41	5167.5	1468.0
2016-05-09 23:00:00	NQ	Futures	5167.2	5173.74	5164.22	5173.74	1145.0
2016-05-09 00:00:00	YM	Futures	18926.6	18935.2	18925.6	18932.0	399.0
2016-05-09 01:00:00	YM	Futures	18933.1	18935.2	18922.4	18930.9	474.0
2016-05-09 02:00:00	YM	Futures	18930.9	18943.8	18928.8	18935.2	1668.0
2016-05-09 03:00:00	YM	Futures	18935.2	18935.2	18883.8	18905.2	5664.0

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

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