PREVIEW / futures_1hour / 2016-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-06.parquet
  size:    55 KB
  rows:    1,615

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-07-06 00:00:00	ES	Futures	2248.41	2248.68	2246.51	2248.41	4713.0
2016-07-06 01:00:00	ES	Futures	2248.68	2255.46	2247.32	2253.83	13653.0
2016-07-06 02:00:00	ES	Futures	2253.83	2254.37	2249.22	2250.03	18222.0
2016-07-06 03:00:00	ES	Futures	2250.03	2262.51	2248.95	2253.02	50445.0
2016-07-06 04:00:00	ES	Futures	2252.75	2255.73	2247.05	2248.95	30823.0
2016-07-06 05:00:00	ES	Futures	2249.22	2251.12	2245.69	2250.3	33220.0
2016-07-06 06:00:00	ES	Futures	2250.3	2250.58	2242.71	2243.8	40387.0
2016-07-06 07:00:00	ES	Futures	2243.8	2248.95	2241.9	2245.15	41569.0
2016-07-06 08:00:00	ES	Futures	2245.42	2247.05	2244.61	2247.05	38176.0
2016-07-06 09:00:00	ES	Futures	2247.32	2251.93	2243.25	2247.32	240581.0
2016-07-06 10:00:00	ES	Futures	2247.59	2254.64	2240.81	2252.47	410126.0
2016-07-06 11:00:00	ES	Futures	2252.75	2259.8	2252.47	2258.98	255683.0
2016-07-06 12:00:00	ES	Futures	2259.25	2265.49	2258.98	2265.49	170714.0
2016-07-06 13:00:00	ES	Futures	2265.22	2267.12	2261.69	2263.05	112699.0
2016-07-06 14:00:00	ES	Futures	2263.05	2269.02	2259.25	2268.75	193469.0
2016-07-06 15:00:00	ES	Futures	2268.75	2271.19	2263.86	2270.37	235721.0
2016-07-06 16:00:00	ES	Futures	2270.64	2272.0	2267.66	2270.37	81111.0
2016-07-06 18:00:00	ES	Futures	2269.29	2269.56	2265.49	2267.12	7507.0
2016-07-06 19:00:00	ES	Futures	2267.39	2269.83	2266.58	2269.02	5147.0
2016-07-06 20:00:00	ES	Futures	2269.02	2272.0	2267.39	2268.2	10337.0
2016-07-06 21:00:00	ES	Futures	2268.47	2271.46	2266.03	2269.56	9254.0
2016-07-06 22:00:00	ES	Futures	2269.56	2271.19	2267.93	2270.92	4192.0
2016-07-06 23:00:00	ES	Futures	2270.92	2271.19	2268.75	2268.75	2850.0
2016-07-06 00:00:00	NQ	Futures	5220.37	5221.27	5215.31	5220.67	844.0
2016-07-06 01:00:00	NQ	Futures	5220.67	5237.66	5218.88	5233.79	1844.0
2016-07-06 02:00:00	NQ	Futures	5234.38	5235.57	5223.65	5225.44	2440.0
2016-07-06 03:00:00	NQ	Futures	5226.04	5256.44	5223.06	5232.0	5888.0
2016-07-06 04:00:00	NQ	Futures	5232.0	5238.85	5217.09	5223.35	3433.0
2016-07-06 05:00:00	NQ	Futures	5223.95	5226.04	5213.52	5224.84	3201.0
2016-07-06 06:00:00	NQ	Futures	5224.55	5225.14	5205.77	5210.24	4155.0
2016-07-06 07:00:00	NQ	Futures	5210.24	5220.97	5204.87	5212.62	5667.0
2016-07-06 08:00:00	NQ	Futures	5212.33	5218.29	5212.03	5217.69	3374.0
2016-07-06 09:00:00	NQ	Futures	5217.99	5232.0	5206.36	5228.42	33354.0
2016-07-06 10:00:00	NQ	Futures	5229.02	5255.54	5217.69	5255.25	52031.0
2016-07-06 11:00:00	NQ	Futures	5255.25	5275.21	5254.65	5269.25	32906.0
2016-07-06 12:00:00	NQ	Futures	5269.25	5286.84	5268.96	5285.65	20842.0
2016-07-06 13:00:00	NQ	Futures	5285.94	5290.42	5271.94	5274.32	12632.0
2016-07-06 14:00:00	NQ	Futures	5274.32	5291.61	5264.48	5288.92	26545.0
2016-07-06 15:00:00	NQ	Futures	5289.22	5293.99	5274.02	5291.91	26900.0
2016-07-06 16:00:00	NQ	Futures	5291.91	5293.69	5286.54	5290.42	7608.0
2016-07-06 18:00:00	NQ	Futures	5287.14	5289.82	5278.49	5282.37	1075.0
2016-07-06 19:00:00	NQ	Futures	5282.96	5288.63	5280.58	5287.73	610.0
2016-07-06 20:00:00	NQ	Futures	5288.33	5295.48	5283.26	5288.63	1274.0
2016-07-06 21:00:00	NQ	Futures	5288.33	5296.08	5281.18	5291.01	1563.0
2016-07-06 22:00:00	NQ	Futures	5290.12	5294.89	5286.84	5294.29	416.0
2016-07-06 23:00:00	NQ	Futures	5294.29	5295.48	5286.54	5287.43	616.0
2016-07-06 00:00:00	YM	Futures	19029.5	19031.6	19014.4	19030.5	628.0
2016-07-06 01:00:00	YM	Futures	19030.5	19089.7	19024.1	19073.6	2721.0
2016-07-06 02:00:00	YM	Futures	19073.6	19073.6	19034.8	19041.3	2116.0
2016-07-06 03:00:00	YM	Futures	19043.4	19133.8	19032.7	19061.7	6870.0

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

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