PREVIEW / futures_1hour / 2015-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-09.parquet
  size:    52 KB
  rows:    1,602

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-11-09 00:00:00	ES	Futures	2242.83	2243.9	2241.22	2242.83	4236.0
2015-11-09 01:00:00	ES	Futures	2242.83	2243.09	2240.42	2240.42	2048.0
2015-11-09 02:00:00	ES	Futures	2240.69	2240.69	2237.74	2238.01	6615.0
2015-11-09 03:00:00	ES	Futures	2237.74	2239.35	2233.19	2234.8	21618.0
2015-11-09 04:00:00	ES	Futures	2234.53	2237.74	2234.53	2235.87	15210.0
2015-11-09 05:00:00	ES	Futures	2235.6	2236.41	2232.66	2232.93	12269.0
2015-11-09 06:00:00	ES	Futures	2233.19	2235.34	2232.93	2233.73	9221.0
2015-11-09 07:00:00	ES	Futures	2234.0	2235.34	2233.19	2234.26	11537.0
2015-11-09 08:00:00	ES	Futures	2234.53	2236.41	2234.0	2234.0	23877.0
2015-11-09 09:00:00	ES	Futures	2234.0	2234.8	2224.9	2225.17	299569.0
2015-11-09 10:00:00	ES	Futures	2225.43	2226.77	2217.41	2220.89	342567.0
2015-11-09 11:00:00	ES	Futures	2220.89	2220.89	2209.11	2209.38	286950.0
2015-11-09 12:00:00	ES	Futures	2209.65	2215.53	2206.97	2215.27	148594.0
2015-11-09 13:00:00	ES	Futures	2215.27	2216.34	2209.65	2214.73	123466.0
2015-11-09 14:00:00	ES	Futures	2214.73	2217.94	2211.79	2214.2	143753.0
2015-11-09 15:00:00	ES	Futures	2214.2	2223.56	2210.45	2219.01	288430.0
2015-11-09 16:00:00	ES	Futures	2219.01	2220.89	2217.14	2217.94	75816.0
2015-11-09 18:00:00	ES	Futures	2217.94	2219.01	2215.27	2218.21	4859.0
2015-11-09 19:00:00	ES	Futures	2218.48	2220.89	2217.94	2219.01	5924.0
2015-11-09 20:00:00	ES	Futures	2219.28	2221.69	2216.6	2220.62	7832.0
2015-11-09 21:00:00	ES	Futures	2220.62	2221.69	2219.28	2221.42	3917.0
2015-11-09 22:00:00	ES	Futures	2221.69	2222.76	2221.15	2221.96	4319.0
2015-11-09 23:00:00	ES	Futures	2221.96	2224.9	2221.96	2223.29	5384.0
2015-11-09 00:00:00	NQ	Futures	5585.59	5587.37	5580.85	5584.11	738.0
2015-11-09 01:00:00	NQ	Futures	5583.82	5584.11	5580.85	5580.85	464.0
2015-11-09 02:00:00	NQ	Futures	5580.85	5580.85	5573.73	5574.03	1122.0
2015-11-09 03:00:00	NQ	Futures	5573.73	5577.29	5560.99	5564.25	3063.0
2015-11-09 04:00:00	NQ	Futures	5564.25	5571.96	5563.95	5568.69	1629.0
2015-11-09 05:00:00	NQ	Futures	5568.1	5569.88	5560.69	5561.58	1498.0
2015-11-09 06:00:00	NQ	Futures	5561.58	5567.8	5561.28	5563.95	1203.0
2015-11-09 07:00:00	NQ	Futures	5564.25	5565.14	5555.35	5556.24	2569.0
2015-11-09 08:00:00	NQ	Futures	5556.24	5562.76	5554.46	5557.72	3342.0
2015-11-09 09:00:00	NQ	Futures	5557.43	5561.58	5543.79	5544.09	33604.0
2015-11-09 10:00:00	NQ	Futures	5544.09	5546.75	5516.22	5525.7	47772.0
2015-11-09 11:00:00	NQ	Futures	5525.7	5526.3	5483.6	5485.08	48702.0
2015-11-09 12:00:00	NQ	Futures	5485.08	5502.58	5481.53	5501.39	20234.0
2015-11-09 13:00:00	NQ	Futures	5501.39	5508.51	5492.5	5500.5	15346.0
2015-11-09 14:00:00	NQ	Futures	5500.5	5506.13	5493.68	5500.5	17709.0
2015-11-09 15:00:00	NQ	Futures	5500.8	5524.81	5495.46	5516.51	37807.0
2015-11-09 16:00:00	NQ	Futures	5516.51	5523.03	5511.18	5513.55	6351.0
2015-11-09 18:00:00	NQ	Futures	5514.73	5514.73	5505.84	5511.77	614.0
2015-11-09 19:00:00	NQ	Futures	5511.47	5519.18	5511.18	5514.14	943.0
2015-11-09 20:00:00	NQ	Futures	5514.44	5519.77	5509.1	5516.81	1481.0
2015-11-09 21:00:00	NQ	Futures	5516.81	5520.66	5515.03	5520.66	794.0
2015-11-09 22:00:00	NQ	Futures	5520.66	5524.22	5519.48	5522.44	867.0
2015-11-09 23:00:00	NQ	Futures	5522.74	5529.26	5522.44	5525.7	965.0
2015-11-09 00:00:00	YM	Futures	18913.0	18920.4	18902.4	18911.9	768.0
2015-11-09 01:00:00	YM	Futures	18911.9	18915.1	18895.0	18895.0	352.0
2015-11-09 02:00:00	YM	Futures	18893.9	18893.9	18875.9	18877.0	1119.0
2015-11-09 03:00:00	YM	Futures	18878.0	18888.6	18839.9	18853.7	2971.0

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

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