PREVIEW / futures_1hour / 2016-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-16.parquet
  size:    50 KB
  rows:    1,546

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-05-16 00:00:00	ES	Futures	2212.22	2212.22	2208.44	2209.25	4292.0
2016-05-16 01:00:00	ES	Futures	2208.98	2209.79	2206.55	2209.52	5183.0
2016-05-16 02:00:00	ES	Futures	2209.52	2210.87	2207.63	2208.98	11277.0
2016-05-16 03:00:00	ES	Futures	2208.98	2209.79	2206.28	2209.25	14199.0
2016-05-16 04:00:00	ES	Futures	2209.52	2209.79	2206.82	2209.52	10418.0
2016-05-16 05:00:00	ES	Futures	2209.52	2210.06	2207.9	2209.25	6897.0
2016-05-16 06:00:00	ES	Futures	2208.98	2209.79	2205.47	2206.82	7791.0
2016-05-16 07:00:00	ES	Futures	2206.82	2210.87	2206.55	2209.79	14348.0
2016-05-16 08:00:00	ES	Futures	2209.79	2210.87	2205.2	2207.09	24964.0
2016-05-16 09:00:00	ES	Futures	2207.09	2215.73	2206.55	2213.57	197738.0
2016-05-16 10:00:00	ES	Futures	2213.57	2220.59	2212.49	2219.78	222415.0
2016-05-16 11:00:00	ES	Futures	2220.05	2225.98	2219.78	2225.98	181234.0
2016-05-16 12:00:00	ES	Futures	2225.98	2226.25	2221.94	2225.45	105290.0
2016-05-16 13:00:00	ES	Futures	2225.72	2227.33	2224.1	2225.98	92185.0
2016-05-16 14:00:00	ES	Futures	2225.98	2232.46	2225.98	2232.19	145574.0
2016-05-16 15:00:00	ES	Futures	2231.92	2233.81	2226.52	2227.6	226461.0
2016-05-16 16:00:00	ES	Futures	2227.33	2228.95	2225.72	2226.52	73197.0
2016-05-16 18:00:00	ES	Futures	2226.79	2226.79	2224.91	2226.52	4817.0
2016-05-16 19:00:00	ES	Futures	2226.25	2227.33	2225.18	2226.25	2472.0
2016-05-16 20:00:00	ES	Futures	2226.25	2226.25	2224.64	2224.91	7019.0
2016-05-16 21:00:00	ES	Futures	2224.91	2227.6	2224.91	2226.52	7151.0
2016-05-16 22:00:00	ES	Futures	2226.25	2228.14	2225.98	2227.6	4684.0
2016-05-16 23:00:00	ES	Futures	2227.6	2227.87	2226.52	2227.33	4035.0
2016-05-16 00:00:00	NQ	Futures	5159.76	5159.76	5149.05	5151.13	941.0
2016-05-16 01:00:00	NQ	Futures	5151.13	5152.32	5146.37	5152.32	834.0
2016-05-16 02:00:00	NQ	Futures	5152.02	5156.19	5147.86	5149.05	1034.0
2016-05-16 03:00:00	NQ	Futures	5149.35	5151.43	5140.42	5150.54	3092.0
2016-05-16 04:00:00	NQ	Futures	5150.83	5151.43	5142.8	5151.43	1894.0
2016-05-16 05:00:00	NQ	Futures	5151.43	5152.02	5146.67	5148.16	965.0
2016-05-16 06:00:00	NQ	Futures	5148.45	5149.94	5138.34	5143.1	1369.0
2016-05-16 07:00:00	NQ	Futures	5143.4	5163.33	5141.91	5159.76	5161.0
2016-05-16 08:00:00	NQ	Futures	5160.06	5161.55	5147.56	5151.73	3400.0
2016-05-16 09:00:00	NQ	Futures	5151.73	5170.47	5145.48	5168.69	32006.0
2016-05-16 10:00:00	NQ	Futures	5168.98	5182.97	5157.68	5180.88	31399.0
2016-05-16 11:00:00	NQ	Futures	5181.18	5202.9	5181.18	5201.41	26113.0
2016-05-16 12:00:00	NQ	Futures	5201.41	5202.6	5192.49	5199.93	14240.0
2016-05-16 13:00:00	NQ	Futures	5200.22	5208.85	5199.33	5206.47	14297.0
2016-05-16 14:00:00	NQ	Futures	5206.77	5225.22	5206.17	5222.54	20709.0
2016-05-16 15:00:00	NQ	Futures	5222.84	5227.0	5205.58	5207.96	25288.0
2016-05-16 16:00:00	NQ	Futures	5207.66	5208.85	5200.52	5205.88	6773.0
2016-05-16 18:00:00	NQ	Futures	5204.09	5206.17	5202.31	5205.58	370.0
2016-05-16 19:00:00	NQ	Futures	5205.88	5207.07	5202.9	5204.69	375.0
2016-05-16 20:00:00	NQ	Futures	5204.39	5205.58	5201.12	5202.9	1127.0
2016-05-16 21:00:00	NQ	Futures	5203.5	5207.96	5203.2	5204.39	805.0
2016-05-16 22:00:00	NQ	Futures	5204.39	5208.56	5203.5	5206.77	383.0
2016-05-16 23:00:00	NQ	Futures	5206.77	5210.94	5205.88	5209.75	844.0
2016-05-16 00:00:00	YM	Futures	18768.2	18770.4	18736.1	18742.5	918.0
2016-05-16 01:00:00	YM	Futures	18741.5	18750.0	18722.2	18749.0	1514.0
2016-05-16 02:00:00	YM	Futures	18747.9	18761.8	18731.8	18734.0	1854.0
2016-05-16 03:00:00	YM	Futures	18736.1	18745.7	18716.8	18740.4	2411.0

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

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