PREVIEW / futures_1hour / 2015-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-27.parquet
  size:    51 KB
  rows:    1,558

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
2015-05-27 00:00:00	ES	Futures	2222.02	2223.08	2221.49	2221.49	2906.0
2015-05-27 01:00:00	ES	Futures	2221.49	2222.55	2220.44	2222.02	3126.0
2015-05-27 02:00:00	ES	Futures	2221.76	2224.14	2221.49	2222.82	7014.0
2015-05-27 03:00:00	ES	Futures	2222.82	2224.66	2220.17	2221.23	20583.0
2015-05-27 04:00:00	ES	Futures	2221.23	2223.61	2219.91	2223.61	10771.0
2015-05-27 05:00:00	ES	Futures	2223.61	2226.78	2223.08	2225.72	17585.0
2015-05-27 06:00:00	ES	Futures	2225.46	2226.25	2223.87	2225.46	15067.0
2015-05-27 07:00:00	ES	Futures	2225.46	2226.51	2224.93	2225.98	12734.0
2015-05-27 08:00:00	ES	Futures	2225.98	2228.89	2225.46	2225.98	35049.0
2015-05-27 09:00:00	ES	Futures	2225.72	2235.23	2221.23	2232.06	275445.0
2015-05-27 10:00:00	ES	Futures	2232.06	2233.64	2229.15	2233.38	183731.0
2015-05-27 11:00:00	ES	Futures	2233.38	2237.34	2232.06	2236.02	129880.0
2015-05-27 12:00:00	ES	Futures	2236.02	2237.34	2234.44	2235.23	68022.0
2015-05-27 13:00:00	ES	Futures	2235.49	2238.93	2235.23	2238.93	71709.0
2015-05-27 14:00:00	ES	Futures	2238.93	2241.3	2238.66	2240.25	96530.0
2015-05-27 15:00:00	ES	Futures	2240.51	2244.21	2239.98	2241.04	225771.0
2015-05-27 16:00:00	ES	Futures	2241.04	2241.57	2239.45	2239.45	86761.0
2015-05-27 17:00:00	ES	Futures	2239.45	2240.25	2239.45	2239.98	928.0
2015-05-27 18:00:00	ES	Futures	2239.72	2241.3	2239.45	2240.51	3722.0
2015-05-27 19:00:00	ES	Futures	2240.78	2241.04	2239.72	2240.25	1751.0
2015-05-27 20:00:00	ES	Futures	2240.25	2241.3	2239.72	2241.3	3053.0
2015-05-27 21:00:00	ES	Futures	2241.04	2241.57	2240.25	2240.25	3357.0
2015-05-27 22:00:00	ES	Futures	2240.25	2240.78	2239.72	2239.98	3868.0
2015-05-27 23:00:00	ES	Futures	2239.98	2240.25	2238.93	2239.72	3479.0
2015-05-27 00:00:00	NQ	Futures	5264.91	5267.27	5263.74	5263.74	323.0
2015-05-27 01:00:00	NQ	Futures	5263.74	5266.38	5261.97	5265.5	305.0
2015-05-27 02:00:00	NQ	Futures	5265.21	5269.91	5263.74	5266.68	662.0
2015-05-27 03:00:00	NQ	Futures	5266.68	5272.27	5261.38	5264.03	2029.0
2015-05-27 04:00:00	NQ	Futures	5263.74	5269.91	5262.27	5269.62	1595.0
2015-05-27 05:00:00	NQ	Futures	5269.91	5277.85	5269.91	5275.79	2099.0
2015-05-27 06:00:00	NQ	Futures	5275.5	5276.09	5270.21	5273.74	1697.0
2015-05-27 07:00:00	NQ	Futures	5273.74	5275.79	5271.97	5273.44	1538.0
2015-05-27 08:00:00	NQ	Futures	5274.03	5281.97	5274.03	5275.5	4566.0
2015-05-27 09:00:00	NQ	Futures	5275.79	5310.49	5266.09	5302.55	44612.0
2015-05-27 10:00:00	NQ	Futures	5302.85	5316.08	5298.44	5315.2	31825.0
2015-05-27 11:00:00	NQ	Futures	5315.2	5324.31	5310.79	5320.79	22695.0
2015-05-27 12:00:00	NQ	Futures	5321.08	5322.26	5314.32	5318.14	10156.0
2015-05-27 13:00:00	NQ	Futures	5318.43	5334.61	5317.55	5332.84	12970.0
2015-05-27 14:00:00	NQ	Futures	5333.14	5344.02	5332.25	5343.72	17676.0
2015-05-27 15:00:00	NQ	Futures	5344.02	5353.13	5342.55	5346.96	32316.0
2015-05-27 16:00:00	NQ	Futures	5347.25	5347.84	5340.19	5340.19	8882.0
2015-05-27 17:00:00	NQ	Futures	5340.49	5343.13	5340.19	5342.25	387.0
2015-05-27 18:00:00	NQ	Futures	5340.78	5344.6	5340.19	5342.25	614.0
2015-05-27 19:00:00	NQ	Futures	5342.55	5343.13	5340.78	5341.96	421.0
2015-05-27 20:00:00	NQ	Futures	5341.96	5343.72	5341.37	5343.72	330.0
2015-05-27 21:00:00	NQ	Futures	5344.02	5344.6	5341.66	5341.96	259.0
2015-05-27 22:00:00	NQ	Futures	5341.66	5343.43	5341.66	5342.25	455.0
2015-05-27 23:00:00	NQ	Futures	5342.25	5342.84	5340.49	5342.25	814.0
2015-05-27 00:00:00	YM	Futures	18914.8	18923.2	18912.7	18912.7	403.0
2015-05-27 01:00:00	YM	Futures	18912.7	18919.0	18903.3	18913.8	443.0

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

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