PREVIEW / futures_1hour / 2016-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-27.parquet
  size:    53 KB
  rows:    1,628

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-04-27 00:00:00	ES	Futures	2250.01	2250.28	2248.39	2248.66	3163.0
2016-04-27 01:00:00	ES	Futures	2248.93	2250.55	2247.04	2249.47	7516.0
2016-04-27 02:00:00	ES	Futures	2249.2	2249.74	2248.39	2249.47	8926.0
2016-04-27 03:00:00	ES	Futures	2249.74	2253.79	2248.39	2252.44	28105.0
2016-04-27 04:00:00	ES	Futures	2252.17	2252.98	2247.58	2251.63	19355.0
2016-04-27 05:00:00	ES	Futures	2251.63	2251.9	2249.2	2249.47	15630.0
2016-04-27 06:00:00	ES	Futures	2249.47	2250.55	2248.12	2249.47	11799.0
2016-04-27 07:00:00	ES	Futures	2249.47	2251.09	2248.39	2250.01	15137.0
2016-04-27 08:00:00	ES	Futures	2250.01	2251.36	2248.66	2248.93	18171.0
2016-04-27 09:00:00	ES	Futures	2248.66	2253.52	2245.96	2249.74	173588.0
2016-04-27 10:00:00	ES	Futures	2250.01	2251.63	2242.18	2243.53	222194.0
2016-04-27 11:00:00	ES	Futures	2243.53	2251.36	2242.45	2250.82	136683.0
2016-04-27 12:00:00	ES	Futures	2250.82	2252.44	2248.66	2250.01	76276.0
2016-04-27 13:00:00	ES	Futures	2250.28	2250.55	2246.77	2247.31	84671.0
2016-04-27 14:00:00	ES	Futures	2247.04	2257.3	2243.53	2253.25	260573.0
2016-04-27 15:00:00	ES	Futures	2253.52	2261.35	2252.98	2256.49	231074.0
2016-04-27 16:00:00	ES	Futures	2256.49	2260.27	2254.6	2260.0	74957.0
2016-04-27 18:00:00	ES	Futures	2259.73	2260.27	2258.38	2260.27	3193.0
2016-04-27 19:00:00	ES	Futures	2260.0	2260.81	2259.19	2259.73	3510.0
2016-04-27 20:00:00	ES	Futures	2259.73	2260.81	2258.65	2260.54	4232.0
2016-04-27 21:00:00	ES	Futures	2260.54	2261.35	2259.19	2261.08	6019.0
2016-04-27 22:00:00	ES	Futures	2261.08	2261.62	2259.73	2261.35	3303.0
2016-04-27 23:00:00	ES	Futures	2261.08	2261.35	2239.75	2247.58	65634.0
2016-04-27 00:00:00	NQ	Futures	5243.07	5244.56	5239.2	5240.99	930.0
2016-04-27 01:00:00	NQ	Futures	5240.69	5246.64	5237.71	5242.47	1275.0
2016-04-27 02:00:00	NQ	Futures	5242.77	5246.94	5240.09	5246.04	1524.0
2016-04-27 03:00:00	NQ	Futures	5246.04	5256.46	5240.69	5253.18	4026.0
2016-04-27 04:00:00	NQ	Futures	5253.18	5254.67	5239.2	5248.42	2478.0
2016-04-27 05:00:00	NQ	Futures	5248.42	5249.02	5239.8	5240.09	2181.0
2016-04-27 06:00:00	NQ	Futures	5240.09	5242.18	5237.42	5240.09	2060.0
2016-04-27 07:00:00	NQ	Futures	5240.39	5244.85	5238.31	5240.69	2770.0
2016-04-27 08:00:00	NQ	Futures	5240.69	5245.45	5239.5	5242.77	3227.0
2016-04-27 09:00:00	NQ	Futures	5242.47	5258.54	5227.0	5228.79	46046.0
2016-04-27 10:00:00	NQ	Futures	5228.79	5233.55	5203.5	5215.1	56231.0
2016-04-27 11:00:00	NQ	Futures	5215.4	5237.42	5212.13	5235.93	25527.0
2016-04-27 12:00:00	NQ	Futures	5235.93	5236.82	5225.22	5229.68	15293.0
2016-04-27 13:00:00	NQ	Futures	5229.38	5230.57	5215.1	5217.78	17191.0
2016-04-27 14:00:00	NQ	Futures	5218.37	5238.9	5207.66	5227.6	51027.0
2016-04-27 15:00:00	NQ	Futures	5227.89	5259.43	5227.0	5247.53	47595.0
2016-04-27 16:00:00	NQ	Futures	5247.53	5276.69	5242.77	5275.8	15901.0
2016-04-27 18:00:00	NQ	Futures	5274.61	5275.8	5270.44	5275.5	935.0
2016-04-27 19:00:00	NQ	Futures	5275.2	5278.18	5274.9	5277.28	894.0
2016-04-27 20:00:00	NQ	Futures	5276.99	5281.45	5273.71	5280.85	796.0
2016-04-27 21:00:00	NQ	Futures	5280.56	5283.53	5278.18	5281.75	1302.0
2016-04-27 22:00:00	NQ	Futures	5281.75	5286.81	5277.58	5285.91	1257.0
2016-04-27 23:00:00	NQ	Futures	5285.32	5285.91	5238.61	5257.35	7559.0
2016-04-27 00:00:00	YM	Futures	19141.8	19143.9	19131.1	19135.4	351.0
2016-04-27 01:00:00	YM	Futures	19134.3	19152.5	19108.6	19135.4	5101.0
2016-04-27 02:00:00	YM	Futures	19134.3	19138.6	19122.5	19136.4	2020.0
2016-04-27 03:00:00	YM	Futures	19135.4	19168.5	19123.6	19158.9	3293.0

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

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