PREVIEW / futures_1hour / 2015-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-28.parquet
  size:    50 KB
  rows:    1,555

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-28 00:00:00	ES	Futures	2239.45	2239.98	2238.93	2238.93	1435.0
2015-05-28 01:00:00	ES	Futures	2239.19	2239.45	2237.61	2238.13	3277.0
2015-05-28 02:00:00	ES	Futures	2238.13	2238.93	2236.02	2236.29	9383.0
2015-05-28 03:00:00	ES	Futures	2236.02	2237.34	2234.7	2236.29	17481.0
2015-05-28 04:00:00	ES	Futures	2236.02	2238.93	2235.23	2238.4	10158.0
2015-05-28 05:00:00	ES	Futures	2238.66	2239.19	2236.29	2238.66	10856.0
2015-05-28 06:00:00	ES	Futures	2238.93	2239.72	2237.34	2238.4	7966.0
2015-05-28 07:00:00	ES	Futures	2238.4	2239.45	2234.7	2235.76	16194.0
2015-05-28 08:00:00	ES	Futures	2235.76	2237.34	2234.7	2236.02	18206.0
2015-05-28 09:00:00	ES	Futures	2235.76	2239.98	2231.53	2232.32	173430.0
2015-05-28 10:00:00	ES	Futures	2232.32	2235.76	2229.68	2232.06	207739.0
2015-05-28 11:00:00	ES	Futures	2232.06	2237.34	2229.95	2232.06	160172.0
2015-05-28 12:00:00	ES	Futures	2231.8	2235.23	2230.47	2232.59	83091.0
2015-05-28 13:00:00	ES	Futures	2232.32	2236.29	2231.8	2234.7	76858.0
2015-05-28 14:00:00	ES	Futures	2234.44	2239.19	2233.64	2238.66	67556.0
2015-05-28 15:00:00	ES	Futures	2238.4	2239.72	2236.81	2238.66	115083.0
2015-05-28 16:00:00	ES	Futures	2238.93	2242.62	2237.61	2242.36	62245.0
2015-05-28 17:00:00	ES	Futures	2242.1	2242.62	2241.57	2242.36	2655.0
2015-05-28 18:00:00	ES	Futures	2241.57	2241.83	2241.04	2241.3	1705.0
2015-05-28 19:00:00	ES	Futures	2241.57	2241.83	2240.78	2241.3	1236.0
2015-05-28 20:00:00	ES	Futures	2241.57	2242.62	2241.3	2242.36	2927.0
2015-05-28 21:00:00	ES	Futures	2242.62	2242.62	2240.25	2240.78	3955.0
2015-05-28 22:00:00	ES	Futures	2240.78	2240.78	2240.25	2240.51	1979.0
2015-05-28 23:00:00	ES	Futures	2240.51	2241.04	2240.25	2241.04	2290.0
2015-05-28 00:00:00	NQ	Futures	5342.25	5344.02	5340.78	5341.66	291.0
2015-05-28 01:00:00	NQ	Futures	5341.66	5342.25	5336.67	5338.43	679.0
2015-05-28 02:00:00	NQ	Futures	5338.14	5341.37	5334.61	5334.61	1030.0
2015-05-28 03:00:00	NQ	Futures	5334.61	5337.25	5330.78	5334.61	2186.0
2015-05-28 04:00:00	NQ	Futures	5334.61	5341.37	5332.55	5340.49	1317.0
2015-05-28 05:00:00	NQ	Futures	5340.78	5342.25	5329.9	5335.78	2061.0
2015-05-28 06:00:00	NQ	Futures	5335.78	5339.31	5334.02	5337.84	1536.0
2015-05-28 07:00:00	NQ	Futures	5338.14	5341.37	5331.08	5335.49	2761.0
2015-05-28 08:00:00	NQ	Futures	5335.49	5337.55	5330.2	5335.49	3097.0
2015-05-28 09:00:00	NQ	Futures	5335.49	5349.02	5321.96	5324.02	33486.0
2015-05-28 10:00:00	NQ	Futures	5324.31	5334.31	5318.73	5329.31	32589.0
2015-05-28 11:00:00	NQ	Futures	5329.61	5339.9	5321.08	5326.37	21075.0
2015-05-28 12:00:00	NQ	Futures	5326.37	5334.9	5323.43	5325.78	10208.0
2015-05-28 13:00:00	NQ	Futures	5325.49	5333.72	5324.31	5329.02	9242.0
2015-05-28 14:00:00	NQ	Futures	5329.02	5339.31	5327.55	5335.19	9111.0
2015-05-28 15:00:00	NQ	Futures	5335.49	5339.02	5330.2	5335.19	13576.0
2015-05-28 16:00:00	NQ	Futures	5335.49	5345.49	5333.14	5344.31	4621.0
2015-05-28 17:00:00	NQ	Futures	5344.6	5345.19	5342.55	5342.84	167.0
2015-05-28 18:00:00	NQ	Futures	5342.55	5342.84	5340.78	5342.55	189.0
2015-05-28 19:00:00	NQ	Futures	5342.55	5342.84	5341.08	5341.96	146.0
2015-05-28 20:00:00	NQ	Futures	5342.25	5346.37	5341.96	5345.78	386.0
2015-05-28 21:00:00	NQ	Futures	5345.49	5346.37	5340.78	5342.25	304.0
2015-05-28 22:00:00	NQ	Futures	5341.66	5342.55	5341.37	5342.25	202.0
2015-05-28 23:00:00	NQ	Futures	5342.25	5343.72	5341.96	5343.72	267.0
2015-05-28 00:00:00	YM	Futures	19013.4	19014.4	19007.1	19008.1	302.0
2015-05-28 01:00:00	YM	Futures	19008.1	19009.2	18998.7	19000.8	542.0

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

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