PREVIEW / futures_1hour / 2015-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-31.parquet
  size:    44 KB
  rows:    1,270

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-07-31 00:00:00	ES	Futures	2238.62	2239.68	2238.35	2239.68	1026.0
2015-07-31 01:00:00	ES	Futures	2239.41	2240.48	2239.15	2240.48	2879.0
2015-07-31 02:00:00	ES	Futures	2240.21	2241.01	2238.62	2240.21	5773.0
2015-07-31 03:00:00	ES	Futures	2239.95	2243.94	2238.08	2240.21	22048.0
2015-07-31 04:00:00	ES	Futures	2240.48	2242.08	2238.62	2241.01	10101.0
2015-07-31 05:00:00	ES	Futures	2241.01	2241.01	2237.02	2237.28	10693.0
2015-07-31 06:00:00	ES	Futures	2237.28	2239.15	2237.02	2238.08	8385.0
2015-07-31 07:00:00	ES	Futures	2238.08	2238.35	2235.15	2236.49	11718.0
2015-07-31 08:00:00	ES	Futures	2236.49	2245.01	2234.09	2243.94	73761.0
2015-07-31 09:00:00	ES	Futures	2243.94	2246.34	2235.15	2236.22	211597.0
2015-07-31 10:00:00	ES	Futures	2236.22	2243.94	2235.42	2242.61	209132.0
2015-07-31 11:00:00	ES	Futures	2242.61	2243.94	2240.48	2242.61	111523.0
2015-07-31 12:00:00	ES	Futures	2242.61	2244.74	2240.75	2241.01	73166.0
2015-07-31 13:00:00	ES	Futures	2241.01	2242.34	2236.22	2236.75	101175.0
2015-07-31 14:00:00	ES	Futures	2237.02	2238.88	2232.76	2235.69	195073.0
2015-07-31 15:00:00	ES	Futures	2235.42	2236.75	2231.43	2234.89	388342.0
2015-07-31 16:00:00	ES	Futures	2234.89	2237.82	2234.09	2237.02	149645.0
2015-07-31 17:00:00	ES	Futures	2236.75	2237.28	2235.69	2235.69	1673.0
2015-07-31 00:00:00	NQ	Futures	5429.81	5433.65	5429.51	5433.06	149.0
2015-07-31 01:00:00	NQ	Futures	5432.47	5434.83	5430.4	5434.83	561.0
2015-07-31 02:00:00	NQ	Futures	5433.95	5436.02	5429.81	5434.24	1018.0
2015-07-31 03:00:00	NQ	Futures	5434.54	5444.6	5427.44	5436.02	3348.0
2015-07-31 04:00:00	NQ	Futures	5436.31	5442.53	5431.58	5438.38	966.0
2015-07-31 05:00:00	NQ	Futures	5437.79	5438.98	5427.44	5429.21	1099.0
2015-07-31 06:00:00	NQ	Futures	5429.51	5434.83	5427.14	5432.47	1469.0
2015-07-31 07:00:00	NQ	Futures	5432.17	5432.47	5424.78	5427.74	1492.0
2015-07-31 08:00:00	NQ	Futures	5428.03	5452.58	5422.71	5451.99	12387.0
2015-07-31 09:00:00	NQ	Futures	5451.99	5452.88	5423.0	5423.89	39851.0
2015-07-31 10:00:00	NQ	Futures	5424.19	5450.51	5421.52	5446.67	35533.0
2015-07-31 11:00:00	NQ	Futures	5446.67	5446.96	5433.95	5438.68	17980.0
2015-07-31 12:00:00	NQ	Futures	5439.27	5446.67	5436.02	5436.31	10000.0
2015-07-31 13:00:00	NQ	Futures	5436.31	5439.27	5424.19	5425.96	14522.0
2015-07-31 14:00:00	NQ	Futures	5426.26	5431.58	5415.9	5422.12	24323.0
2015-07-31 15:00:00	NQ	Futures	5422.41	5426.85	5414.43	5425.37	34059.0
2015-07-31 16:00:00	NQ	Futures	5425.67	5430.4	5421.23	5423.59	12032.0
2015-07-31 17:00:00	NQ	Futures	5423.59	5425.96	5422.12	5422.71	435.0
2015-07-31 00:00:00	YM	Futures	18617.8	18624.1	18617.8	18624.1	81.0
2015-07-31 01:00:00	YM	Futures	18623.1	18631.5	18619.9	18631.5	465.0
2015-07-31 02:00:00	YM	Futures	18631.5	18635.7	18614.6	18630.4	799.0
2015-07-31 03:00:00	YM	Futures	18631.5	18654.7	18610.4	18630.4	2550.0
2015-07-31 04:00:00	YM	Futures	18631.5	18642.0	18614.6	18628.3	1314.0
2015-07-31 05:00:00	YM	Futures	18628.3	18631.5	18600.9	18605.2	1353.0
2015-07-31 06:00:00	YM	Futures	18607.3	18621.0	18603.1	18615.7	733.0
2015-07-31 07:00:00	YM	Futures	18614.6	18616.7	18594.6	18602.0	1394.0
2015-07-31 08:00:00	YM	Futures	18600.9	18638.9	18577.8	18632.5	7876.0
2015-07-31 09:00:00	YM	Futures	18631.5	18668.4	18534.6	18550.4	24347.0
2015-07-31 10:00:00	YM	Futures	18549.3	18633.6	18547.2	18618.9	17303.0
2015-07-31 11:00:00	YM	Futures	18617.8	18631.5	18606.2	18619.9	8427.0
2015-07-31 12:00:00	YM	Futures	18621.0	18639.9	18604.1	18608.3	5494.0
2015-07-31 13:00:00	YM	Futures	18607.3	18619.9	18566.2	18572.5	6928.0

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

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