PREVIEW / futures_1hour / 2015-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-04.parquet
  size:    51 KB
  rows:    1,596

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-04 00:00:00	ES	Futures	2253.0	2253.0	2249.25	2250.85	6673.0
2015-11-04 01:00:00	ES	Futures	2250.85	2252.19	2249.78	2251.12	3333.0
2015-11-04 02:00:00	ES	Futures	2251.12	2252.73	2250.05	2251.12	7040.0
2015-11-04 03:00:00	ES	Futures	2251.12	2255.4	2249.52	2254.87	19941.0
2015-11-04 04:00:00	ES	Futures	2254.87	2256.47	2252.19	2253.26	17795.0
2015-11-04 05:00:00	ES	Futures	2253.26	2253.26	2250.05	2251.66	13385.0
2015-11-04 06:00:00	ES	Futures	2251.92	2254.33	2251.66	2253.53	8290.0
2015-11-04 07:00:00	ES	Futures	2253.53	2255.4	2253.0	2255.14	12774.0
2015-11-04 08:00:00	ES	Futures	2255.14	2258.08	2254.33	2257.28	25485.0
2015-11-04 09:00:00	ES	Futures	2257.28	2257.54	2244.97	2247.64	245293.0
2015-11-04 10:00:00	ES	Futures	2247.64	2253.26	2244.17	2246.31	299622.0
2015-11-04 11:00:00	ES	Futures	2246.31	2246.31	2240.69	2243.36	211773.0
2015-11-04 12:00:00	ES	Futures	2243.09	2248.18	2241.76	2244.17	112348.0
2015-11-04 13:00:00	ES	Futures	2244.17	2244.43	2237.48	2241.49	124923.0
2015-11-04 14:00:00	ES	Futures	2241.49	2247.64	2240.42	2244.97	133512.0
2015-11-04 15:00:00	ES	Futures	2244.97	2245.77	2239.62	2244.17	197171.0
2015-11-04 16:00:00	ES	Futures	2244.43	2244.97	2241.76	2243.63	68848.0
2015-11-04 18:00:00	ES	Futures	2242.83	2243.36	2239.88	2240.95	3300.0
2015-11-04 19:00:00	ES	Futures	2240.69	2242.02	2239.88	2241.22	3949.0
2015-11-04 20:00:00	ES	Futures	2240.95	2241.22	2238.55	2240.69	5657.0
2015-11-04 21:00:00	ES	Futures	2240.42	2243.36	2240.42	2240.69	5126.0
2015-11-04 22:00:00	ES	Futures	2240.69	2243.9	2240.42	2243.36	4289.0
2015-11-04 23:00:00	ES	Futures	2243.63	2244.17	2242.83	2243.63	2133.0
2015-11-04 00:00:00	NQ	Futures	5596.86	5597.16	5589.15	5592.12	1138.0
2015-11-04 01:00:00	NQ	Futures	5592.71	5595.38	5590.63	5593.6	604.0
2015-11-04 02:00:00	NQ	Futures	5593.3	5597.45	5590.93	5592.12	1289.0
2015-11-04 03:00:00	NQ	Futures	5591.82	5601.01	5588.26	5599.53	2769.0
2015-11-04 04:00:00	NQ	Futures	5599.53	5604.27	5594.49	5597.45	1927.0
2015-11-04 05:00:00	NQ	Futures	5597.75	5599.83	5591.82	5597.16	2072.0
2015-11-04 06:00:00	NQ	Futures	5597.16	5602.49	5597.16	5600.12	1252.0
2015-11-04 07:00:00	NQ	Futures	5600.42	5604.27	5600.12	5603.68	2407.0
2015-11-04 08:00:00	NQ	Futures	5603.38	5609.31	5602.2	5608.13	3909.0
2015-11-04 09:00:00	NQ	Futures	5608.72	5609.02	5581.15	5586.48	37972.0
2015-11-04 10:00:00	NQ	Futures	5586.48	5598.64	5574.03	5574.62	45458.0
2015-11-04 11:00:00	NQ	Futures	5574.62	5582.33	5563.65	5576.4	32315.0
2015-11-04 12:00:00	NQ	Futures	5576.4	5590.34	5572.55	5583.52	15600.0
2015-11-04 13:00:00	NQ	Futures	5583.82	5584.41	5564.84	5577.59	17631.0
2015-11-04 14:00:00	NQ	Futures	5577.59	5596.86	5574.92	5588.56	19341.0
2015-11-04 15:00:00	NQ	Futures	5588.26	5589.75	5575.51	5587.08	27679.0
2015-11-04 16:00:00	NQ	Futures	5586.78	5594.19	5577.59	5587.37	10153.0
2015-11-04 18:00:00	NQ	Futures	5583.82	5585.0	5578.48	5580.85	801.0
2015-11-04 19:00:00	NQ	Futures	5581.15	5584.11	5579.66	5581.44	1041.0
2015-11-04 20:00:00	NQ	Futures	5581.44	5582.04	5574.33	5579.96	880.0
2015-11-04 21:00:00	NQ	Futures	5580.26	5586.48	5578.78	5578.78	713.0
2015-11-04 22:00:00	NQ	Futures	5579.66	5587.67	5578.48	5586.48	577.0
2015-11-04 23:00:00	NQ	Futures	5586.78	5588.26	5585.3	5587.37	237.0
2015-11-04 00:00:00	YM	Futures	18919.3	18919.3	18892.8	18901.3	961.0
2015-11-04 01:00:00	YM	Futures	18901.3	18914.0	18896.0	18906.6	557.0
2015-11-04 02:00:00	YM	Futures	18905.6	18919.3	18895.0	18907.7	1671.0
2015-11-04 03:00:00	YM	Futures	18906.6	18944.7	18896.0	18939.5	2651.0

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

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