PREVIEW / futures_1hour / 2016-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-29.parquet
  size:    54 KB
  rows:    1,611

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-29 00:00:00	ES	Futures	2192.78	2194.13	2192.78	2193.32	2459.0
2016-03-29 01:00:00	ES	Futures	2193.59	2195.21	2193.05	2194.13	3800.0
2016-03-29 02:00:00	ES	Futures	2194.13	2194.67	2191.7	2191.97	9348.0
2016-03-29 03:00:00	ES	Futures	2191.7	2196.02	2191.7	2194.4	26524.0
2016-03-29 04:00:00	ES	Futures	2194.4	2194.67	2190.35	2193.32	19463.0
2016-03-29 05:00:00	ES	Futures	2193.32	2193.59	2185.22	2186.57	22877.0
2016-03-29 06:00:00	ES	Futures	2186.3	2187.92	2183.87	2184.68	29003.0
2016-03-29 07:00:00	ES	Futures	2184.68	2185.49	2182.25	2184.95	24349.0
2016-03-29 08:00:00	ES	Futures	2185.22	2186.03	2182.25	2184.14	37596.0
2016-03-29 09:00:00	ES	Futures	2184.14	2186.03	2180.63	2184.95	188796.0
2016-03-29 10:00:00	ES	Futures	2185.22	2188.73	2184.95	2186.84	185334.0
2016-03-29 11:00:00	ES	Futures	2186.84	2190.08	2185.49	2188.46	146366.0
2016-03-29 12:00:00	ES	Futures	2188.46	2202.77	2187.38	2199.53	225706.0
2016-03-29 13:00:00	ES	Futures	2199.26	2202.23	2196.02	2201.15	135339.0
2016-03-29 14:00:00	ES	Futures	2201.15	2209.79	2200.88	2207.63	177888.0
2016-03-29 15:00:00	ES	Futures	2207.9	2211.14	2206.82	2210.87	191218.0
2016-03-29 16:00:00	ES	Futures	2210.6	2213.03	2210.06	2212.49	88911.0
2016-03-29 18:00:00	ES	Futures	2212.22	2213.03	2210.33	2211.95	6451.0
2016-03-29 19:00:00	ES	Futures	2211.68	2216.27	2211.68	2214.38	10240.0
2016-03-29 20:00:00	ES	Futures	2214.38	2214.65	2212.76	2213.3	5597.0
2016-03-29 21:00:00	ES	Futures	2213.3	2215.46	2212.49	2213.84	6286.0
2016-03-29 22:00:00	ES	Futures	2214.38	2214.65	2213.3	2213.3	2907.0
2016-03-29 23:00:00	ES	Futures	2213.3	2213.57	2211.95	2212.49	3244.0
2016-03-29 00:00:00	NQ	Futures	5230.57	5236.23	5230.57	5234.74	505.0
2016-03-29 01:00:00	NQ	Futures	5234.74	5238.9	5232.36	5235.04	677.0
2016-03-29 02:00:00	NQ	Futures	5235.33	5236.82	5229.38	5229.98	891.0
2016-03-29 03:00:00	NQ	Futures	5229.98	5241.28	5229.68	5235.63	2978.0
2016-03-29 04:00:00	NQ	Futures	5235.93	5238.01	5225.51	5234.44	2061.0
2016-03-29 05:00:00	NQ	Futures	5234.44	5235.33	5213.02	5218.08	3670.0
2016-03-29 06:00:00	NQ	Futures	5217.18	5222.54	5213.91	5215.7	3016.0
2016-03-29 07:00:00	NQ	Futures	5215.99	5216.29	5207.66	5215.7	2342.0
2016-03-29 08:00:00	NQ	Futures	5215.4	5217.78	5209.75	5212.42	3280.0
2016-03-29 09:00:00	NQ	Futures	5212.72	5220.75	5205.58	5217.48	25991.0
2016-03-29 10:00:00	NQ	Futures	5217.78	5242.18	5217.78	5239.2	33247.0
2016-03-29 11:00:00	NQ	Futures	5239.5	5254.08	5238.01	5249.32	25547.0
2016-03-29 12:00:00	NQ	Futures	5249.02	5285.02	5246.04	5277.28	37837.0
2016-03-29 13:00:00	NQ	Futures	5277.58	5290.38	5271.63	5287.1	20175.0
2016-03-29 14:00:00	NQ	Futures	5287.1	5312.1	5286.21	5301.68	26396.0
2016-03-29 15:00:00	NQ	Futures	5301.68	5311.5	5299.3	5307.33	24446.0
2016-03-29 16:00:00	NQ	Futures	5307.33	5312.1	5303.17	5308.82	7086.0
2016-03-29 18:00:00	NQ	Futures	5308.82	5310.61	5304.95	5307.04	719.0
2016-03-29 19:00:00	NQ	Futures	5307.33	5315.67	5307.04	5313.29	1109.0
2016-03-29 20:00:00	NQ	Futures	5312.39	5313.29	5308.82	5310.01	491.0
2016-03-29 21:00:00	NQ	Futures	5310.31	5316.56	5307.93	5313.58	1153.0
2016-03-29 22:00:00	NQ	Futures	5313.88	5314.48	5309.72	5310.61	787.0
2016-03-29 23:00:00	NQ	Futures	5311.5	5311.5	5306.44	5307.93	351.0
2016-03-29 00:00:00	YM	Futures	18689.0	18697.6	18689.0	18692.2	452.0
2016-03-29 01:00:00	YM	Futures	18694.4	18705.1	18687.9	18692.2	900.0
2016-03-29 02:00:00	YM	Futures	18695.4	18696.5	18674.0	18675.1	1154.0
2016-03-29 03:00:00	YM	Futures	18675.1	18709.3	18675.1	18691.1	2854.0

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

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