PREVIEW / futures_1hour / 2015-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-18.parquet
  size:    48 KB
  rows:    1,525

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-08-18 00:00:00	ES	Futures	2237.02	2237.28	2235.95	2237.28	2488.0
2015-08-18 01:00:00	ES	Futures	2237.28	2237.28	2234.89	2235.42	2970.0
2015-08-18 02:00:00	ES	Futures	2235.42	2236.49	2231.43	2232.23	13768.0
2015-08-18 03:00:00	ES	Futures	2232.23	2236.75	2229.56	2230.1	29618.0
2015-08-18 04:00:00	ES	Futures	2230.1	2233.02	2229.3	2231.69	23804.0
2015-08-18 05:00:00	ES	Futures	2231.96	2234.09	2229.83	2230.36	14985.0
2015-08-18 06:00:00	ES	Futures	2230.36	2233.02	2229.56	2232.76	10266.0
2015-08-18 07:00:00	ES	Futures	2232.76	2233.02	2228.76	2230.1	18953.0
2015-08-18 08:00:00	ES	Futures	2230.1	2233.56	2228.23	2233.02	30535.0
2015-08-18 09:00:00	ES	Futures	2233.02	2234.09	2228.76	2231.43	182067.0
2015-08-18 10:00:00	ES	Futures	2231.69	2236.75	2229.83	2236.22	189994.0
2015-08-18 11:00:00	ES	Futures	2236.49	2236.49	2229.03	2231.16	135697.0
2015-08-18 12:00:00	ES	Futures	2231.16	2232.76	2228.76	2229.03	71175.0
2015-08-18 13:00:00	ES	Futures	2229.3	2229.83	2226.1	2228.23	83337.0
2015-08-18 14:00:00	ES	Futures	2228.5	2231.16	2226.37	2226.9	89326.0
2015-08-18 15:00:00	ES	Futures	2226.9	2230.63	2226.63	2229.03	151113.0
2015-08-18 16:00:00	ES	Futures	2229.03	2230.89	2228.5	2229.03	58388.0
2015-08-18 17:00:00	ES	Futures	2229.3	2229.56	2229.03	2229.3	612.0
2015-08-18 18:00:00	ES	Futures	2229.3	2230.36	2229.03	2229.83	1669.0
2015-08-18 19:00:00	ES	Futures	2229.83	2230.1	2229.03	2229.56	856.0
2015-08-18 20:00:00	ES	Futures	2229.3	2234.36	2229.3	2233.56	6457.0
2015-08-18 21:00:00	ES	Futures	2233.56	2233.56	2230.63	2231.43	4498.0
2015-08-18 22:00:00	ES	Futures	2231.43	2232.23	2230.1	2230.36	3546.0
2015-08-18 23:00:00	ES	Futures	2230.63	2230.89	2226.9	2227.17	8630.0
2015-08-18 00:00:00	NQ	Futures	5402.89	5403.78	5399.34	5403.48	293.0
2015-08-18 01:00:00	NQ	Futures	5402.89	5403.19	5396.68	5398.16	507.0
2015-08-18 02:00:00	NQ	Futures	5397.57	5401.41	5388.4	5392.54	1341.0
2015-08-18 03:00:00	NQ	Futures	5392.54	5402.59	5380.71	5383.37	4535.0
2015-08-18 04:00:00	NQ	Futures	5383.07	5392.54	5380.71	5388.69	3133.0
2015-08-18 05:00:00	NQ	Futures	5388.4	5395.79	5383.37	5385.73	1468.0
2015-08-18 06:00:00	NQ	Futures	5385.44	5391.35	5383.96	5390.47	1287.0
2015-08-18 07:00:00	NQ	Futures	5390.76	5391.35	5381.59	5384.55	2308.0
2015-08-18 08:00:00	NQ	Futures	5384.55	5393.42	5379.52	5391.95	3729.0
2015-08-18 09:00:00	NQ	Futures	5392.24	5393.72	5374.49	5382.18	34130.0
2015-08-18 10:00:00	NQ	Futures	5382.48	5396.68	5376.27	5395.49	26341.0
2015-08-18 11:00:00	NQ	Futures	5395.2	5396.38	5377.16	5386.03	17691.0
2015-08-18 12:00:00	NQ	Futures	5386.03	5390.76	5377.16	5378.34	10371.0
2015-08-18 13:00:00	NQ	Futures	5377.75	5381.0	5364.14	5372.13	15418.0
2015-08-18 14:00:00	NQ	Futures	5371.54	5380.41	5365.92	5368.28	12995.0
2015-08-18 15:00:00	NQ	Futures	5368.28	5374.2	5365.32	5371.54	21106.0
2015-08-18 16:00:00	NQ	Futures	5371.54	5378.34	5369.47	5374.2	4640.0
2015-08-18 17:00:00	NQ	Futures	5374.49	5375.68	5374.49	5374.79	88.0
2015-08-18 18:00:00	NQ	Futures	5375.09	5376.86	5373.9	5374.79	258.0
2015-08-18 19:00:00	NQ	Futures	5374.49	5375.68	5373.61	5374.49	97.0
2015-08-18 20:00:00	NQ	Futures	5374.49	5386.03	5374.49	5383.37	994.0
2015-08-18 21:00:00	NQ	Futures	5383.96	5383.96	5375.09	5378.34	745.0
2015-08-18 22:00:00	NQ	Futures	5378.63	5380.41	5375.09	5375.68	593.0
2015-08-18 23:00:00	NQ	Futures	5375.97	5376.56	5365.62	5365.92	1275.0
2015-08-18 00:00:00	YM	Futures	18449.2	18449.2	18436.6	18448.2	296.0
2015-08-18 01:00:00	YM	Futures	18447.1	18448.2	18427.1	18434.5	781.0

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

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