PREVIEW / futures_1hour / 2015-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-07.parquet
  size:    52 KB
  rows:    1,571

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-12-07 00:00:00	ES	Futures	2234.26	2234.26	2231.86	2232.93	2511.0
2015-12-07 01:00:00	ES	Futures	2232.93	2234.53	2232.66	2234.0	1360.0
2015-12-07 02:00:00	ES	Futures	2234.26	2234.26	2231.32	2232.66	8788.0
2015-12-07 03:00:00	ES	Futures	2232.66	2239.35	2229.98	2238.81	27542.0
2015-12-07 04:00:00	ES	Futures	2238.55	2242.83	2237.74	2239.08	26341.0
2015-12-07 05:00:00	ES	Futures	2239.35	2241.22	2238.28	2240.42	8137.0
2015-12-07 06:00:00	ES	Futures	2240.15	2240.69	2236.94	2239.88	12107.0
2015-12-07 07:00:00	ES	Futures	2239.88	2241.76	2238.28	2238.81	13340.0
2015-12-07 08:00:00	ES	Futures	2238.55	2238.81	2229.98	2231.05	45921.0
2015-12-07 09:00:00	ES	Futures	2230.79	2232.66	2224.63	2225.43	232445.0
2015-12-07 10:00:00	ES	Futures	2225.43	2225.97	2213.13	2216.34	303096.0
2015-12-07 11:00:00	ES	Futures	2216.34	2220.35	2209.65	2219.01	234526.0
2015-12-07 12:00:00	ES	Futures	2219.28	2219.55	2211.25	2212.59	122060.0
2015-12-07 13:00:00	ES	Futures	2212.86	2218.21	2210.72	2216.6	145206.0
2015-12-07 14:00:00	ES	Futures	2216.87	2220.35	2213.66	2213.66	136909.0
2015-12-07 15:00:00	ES	Futures	2213.93	2224.1	2210.99	2221.42	231554.0
2015-12-07 16:00:00	ES	Futures	2221.69	2228.38	2221.15	2227.31	81308.0
2015-12-07 18:00:00	ES	Futures	2226.24	2227.84	2224.63	2224.9	4676.0
2015-12-07 19:00:00	ES	Futures	2224.9	2225.43	2223.56	2223.83	4345.0
2015-12-07 20:00:00	ES	Futures	2224.1	2224.9	2218.48	2220.89	10267.0
2015-12-07 21:00:00	ES	Futures	2220.89	2221.96	2216.87	2217.14	7693.0
2015-12-07 22:00:00	ES	Futures	2217.14	2218.75	2214.73	2217.14	7345.0
2015-12-07 23:00:00	ES	Futures	2217.14	2218.75	2216.87	2217.68	2129.0
2015-12-07 00:00:00	NQ	Futures	5588.56	5589.15	5581.44	5584.41	324.0
2015-12-07 01:00:00	NQ	Futures	5584.11	5588.26	5583.82	5587.67	182.0
2015-12-07 02:00:00	NQ	Futures	5587.97	5587.97	5580.55	5584.41	905.0
2015-12-07 03:00:00	NQ	Futures	5584.7	5600.42	5577.0	5597.75	3304.0
2015-12-07 04:00:00	NQ	Futures	5597.75	5609.61	5595.97	5602.49	3895.0
2015-12-07 05:00:00	NQ	Futures	5602.49	5609.02	5599.23	5606.65	1462.0
2015-12-07 06:00:00	NQ	Futures	5606.35	5606.65	5597.16	5602.79	2506.0
2015-12-07 07:00:00	NQ	Futures	5603.09	5608.13	5599.53	5600.42	2369.0
2015-12-07 08:00:00	NQ	Futures	5600.42	5600.42	5586.78	5589.45	7142.0
2015-12-07 09:00:00	NQ	Futures	5589.75	5598.94	5567.51	5575.81	36068.0
2015-12-07 10:00:00	NQ	Futures	5575.81	5579.37	5549.42	5556.54	40753.0
2015-12-07 11:00:00	NQ	Futures	5556.24	5567.21	5539.64	5563.95	27920.0
2015-12-07 12:00:00	NQ	Futures	5563.65	5564.25	5541.71	5543.79	15784.0
2015-12-07 13:00:00	NQ	Futures	5543.79	5559.21	5539.05	5556.83	19630.0
2015-12-07 14:00:00	NQ	Futures	5556.83	5568.69	5544.68	5544.98	19892.0
2015-12-07 15:00:00	NQ	Futures	5545.27	5572.25	5539.64	5564.84	26279.0
2015-12-07 16:00:00	NQ	Futures	5564.84	5580.26	5564.54	5576.4	7343.0
2015-12-07 18:00:00	NQ	Futures	5573.73	5578.78	5569.29	5569.29	656.0
2015-12-07 19:00:00	NQ	Futures	5569.29	5571.66	5565.14	5566.32	897.0
2015-12-07 20:00:00	NQ	Futures	5566.92	5568.99	5552.98	5558.61	2200.0
2015-12-07 21:00:00	NQ	Futures	5558.32	5562.76	5549.42	5549.72	1855.0
2015-12-07 22:00:00	NQ	Futures	5549.42	5552.39	5543.2	5548.53	1102.0
2015-12-07 23:00:00	NQ	Futures	5548.24	5552.39	5547.64	5549.72	451.0
2015-12-07 00:00:00	YM	Futures	18867.4	18867.4	18846.2	18854.7	329.0
2015-12-07 01:00:00	YM	Futures	18854.7	18865.3	18851.5	18864.2	242.0
2015-12-07 02:00:00	YM	Futures	18864.2	18866.4	18844.1	18855.8	1367.0
2015-12-07 03:00:00	YM	Futures	18856.8	18907.7	18834.6	18901.3	3657.0

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

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