PREVIEW / futures_1hour / 2016-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-22.parquet
  size:    52 KB
  rows:    1,599

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-03-22 00:00:00	ES	Futures	2202.23	2204.12	2201.15	2204.12	2877.0
2016-03-22 01:00:00	ES	Futures	2204.12	2205.47	2203.58	2203.85	3445.0
2016-03-22 02:00:00	ES	Futures	2204.12	2206.01	2202.5	2203.31	4254.0
2016-03-22 03:00:00	ES	Futures	2203.58	2204.39	2197.1	2197.91	19868.0
2016-03-22 04:00:00	ES	Futures	2197.91	2199.26	2190.89	2196.56	63932.0
2016-03-22 05:00:00	ES	Futures	2196.56	2203.31	2196.02	2200.61	38845.0
2016-03-22 06:00:00	ES	Futures	2200.61	2201.96	2194.4	2197.64	31312.0
2016-03-22 07:00:00	ES	Futures	2197.37	2200.88	2195.21	2196.29	23054.0
2016-03-22 08:00:00	ES	Futures	2196.56	2198.72	2194.67	2197.64	34136.0
2016-03-22 09:00:00	ES	Futures	2197.37	2200.07	2192.78	2199.26	224065.0
2016-03-22 10:00:00	ES	Futures	2199.26	2204.93	2197.91	2203.04	222968.0
2016-03-22 11:00:00	ES	Futures	2203.31	2206.28	2200.61	2201.42	161386.0
2016-03-22 12:00:00	ES	Futures	2201.42	2210.33	2201.15	2209.79	157613.0
2016-03-22 13:00:00	ES	Futures	2209.79	2211.14	2207.9	2208.71	92699.0
2016-03-22 14:00:00	ES	Futures	2208.71	2211.14	2205.74	2205.74	114580.0
2016-03-22 15:00:00	ES	Futures	2205.74	2206.82	2201.15	2204.39	215772.0
2016-03-22 16:00:00	ES	Futures	2204.39	2206.55	2203.58	2206.55	50472.0
2016-03-22 18:00:00	ES	Futures	2206.28	2206.55	2203.58	2203.85	3552.0
2016-03-22 19:00:00	ES	Futures	2204.12	2205.47	2203.04	2205.2	3385.0
2016-03-22 20:00:00	ES	Futures	2205.2	2206.55	2202.77	2203.58	6314.0
2016-03-22 21:00:00	ES	Futures	2203.85	2206.28	2203.31	2204.93	4793.0
2016-03-22 22:00:00	ES	Futures	2204.93	2204.93	2203.31	2204.12	2470.0
2016-03-22 23:00:00	ES	Futures	2204.12	2204.93	2202.77	2203.85	2791.0
2016-03-22 00:00:00	NQ	Futures	5245.15	5249.32	5243.37	5249.32	444.0
2016-03-22 01:00:00	NQ	Futures	5249.61	5254.37	5249.61	5250.51	339.0
2016-03-22 02:00:00	NQ	Futures	5251.1	5255.56	5247.83	5249.61	675.0
2016-03-22 03:00:00	NQ	Futures	5250.21	5253.18	5234.44	5236.52	2870.0
2016-03-22 04:00:00	NQ	Futures	5236.52	5237.42	5217.18	5232.36	7882.0
2016-03-22 05:00:00	NQ	Futures	5230.87	5248.13	5229.68	5240.09	5018.0
2016-03-22 06:00:00	NQ	Futures	5240.09	5243.96	5226.41	5234.44	3581.0
2016-03-22 07:00:00	NQ	Futures	5234.74	5242.47	5228.49	5231.76	2799.0
2016-03-22 08:00:00	NQ	Futures	5232.36	5235.04	5226.7	5231.46	3686.0
2016-03-22 09:00:00	NQ	Futures	5231.17	5255.56	5222.24	5251.1	29103.0
2016-03-22 10:00:00	NQ	Futures	5251.4	5265.98	5247.23	5260.62	28359.0
2016-03-22 11:00:00	NQ	Futures	5260.92	5269.85	5256.16	5257.65	19899.0
2016-03-22 12:00:00	NQ	Futures	5257.65	5279.66	5256.46	5277.88	18752.0
2016-03-22 13:00:00	NQ	Futures	5277.58	5284.72	5274.31	5277.88	12546.0
2016-03-22 14:00:00	NQ	Futures	5277.88	5284.43	5271.04	5271.33	13450.0
2016-03-22 15:00:00	NQ	Futures	5271.33	5274.9	5262.41	5271.63	29799.0
2016-03-22 16:00:00	NQ	Futures	5271.93	5280.56	5270.14	5280.26	6573.0
2016-03-22 18:00:00	NQ	Futures	5277.88	5278.18	5271.93	5271.93	489.0
2016-03-22 19:00:00	NQ	Futures	5271.93	5275.8	5270.14	5275.5	379.0
2016-03-22 20:00:00	NQ	Futures	5275.8	5279.07	5268.66	5271.33	627.0
2016-03-22 21:00:00	NQ	Futures	5270.74	5278.18	5269.25	5273.42	738.0
2016-03-22 22:00:00	NQ	Futures	5272.82	5274.01	5270.14	5272.23	293.0
2016-03-22 23:00:00	NQ	Futures	5272.82	5274.9	5268.95	5271.04	541.0
2016-03-22 00:00:00	YM	Futures	18734.0	18749.0	18729.7	18749.0	460.0
2016-03-22 01:00:00	YM	Futures	18749.0	18760.7	18747.9	18751.1	555.0
2016-03-22 02:00:00	YM	Futures	18751.1	18763.9	18739.3	18746.8	505.0
2016-03-22 03:00:00	YM	Futures	18746.8	18753.2	18705.1	18712.6	2922.0

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

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