PREVIEW / futures_1hour / 2016-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-31.parquet
  size:    52 KB
  rows:    1,605

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-05-31 00:00:00	ES	Futures	2270.53	2270.53	2268.91	2269.18	2229.0
2016-05-31 01:00:00	ES	Futures	2269.45	2270.26	2268.91	2269.18	3939.0
2016-05-31 02:00:00	ES	Futures	2269.18	2269.45	2267.29	2267.56	7102.0
2016-05-31 03:00:00	ES	Futures	2267.56	2268.64	2264.86	2265.4	20738.0
2016-05-31 04:00:00	ES	Futures	2265.13	2265.94	2263.51	2264.05	20457.0
2016-05-31 05:00:00	ES	Futures	2264.05	2265.94	2264.05	2265.94	11726.0
2016-05-31 06:00:00	ES	Futures	2265.94	2266.75	2264.32	2265.13	10437.0
2016-05-31 07:00:00	ES	Futures	2265.4	2268.64	2264.86	2268.37	18325.0
2016-05-31 08:00:00	ES	Futures	2268.64	2268.91	2267.02	2267.56	14975.0
2016-05-31 09:00:00	ES	Futures	2267.56	2268.91	2265.13	2266.48	130082.0
2016-05-31 10:00:00	ES	Futures	2266.21	2269.45	2262.97	2264.86	217296.0
2016-05-31 11:00:00	ES	Futures	2264.59	2264.59	2259.46	2260.0	177571.0
2016-05-31 12:00:00	ES	Futures	2260.0	2260.54	2257.84	2258.92	84289.0
2016-05-31 13:00:00	ES	Futures	2259.19	2262.16	2257.84	2259.46	96517.0
2016-05-31 14:00:00	ES	Futures	2259.46	2259.46	2253.25	2254.06	180645.0
2016-05-31 15:00:00	ES	Futures	2254.06	2264.86	2252.71	2260.27	356317.0
2016-05-31 16:00:00	ES	Futures	2260.54	2262.97	2257.57	2261.89	143216.0
2016-05-31 18:00:00	ES	Futures	2261.35	2263.24	2260.54	2262.43	5662.0
2016-05-31 19:00:00	ES	Futures	2262.43	2263.24	2261.62	2262.7	1932.0
2016-05-31 20:00:00	ES	Futures	2262.43	2263.24	2261.62	2261.89	4398.0
2016-05-31 21:00:00	ES	Futures	2261.62	2264.05	2261.08	2263.78	8536.0
2016-05-31 22:00:00	ES	Futures	2264.05	2267.02	2263.78	2265.67	8777.0
2016-05-31 23:00:00	ES	Futures	2265.4	2265.94	2262.7	2263.51	6094.0
2016-05-31 00:00:00	NQ	Futures	5388.56	5388.56	5385.59	5386.78	359.0
2016-05-31 01:00:00	NQ	Futures	5387.07	5389.16	5386.48	5386.48	659.0
2016-05-31 02:00:00	NQ	Futures	5386.78	5387.37	5382.61	5382.91	899.0
2016-05-31 03:00:00	NQ	Futures	5383.2	5386.18	5376.06	5376.36	2451.0
2016-05-31 04:00:00	NQ	Futures	5376.36	5378.74	5371.3	5373.98	2061.0
2016-05-31 05:00:00	NQ	Futures	5373.98	5378.15	5372.79	5376.36	841.0
2016-05-31 06:00:00	NQ	Futures	5376.66	5378.44	5371.9	5373.68	1475.0
2016-05-31 07:00:00	NQ	Futures	5373.98	5376.36	5370.11	5376.36	2667.0
2016-05-31 08:00:00	NQ	Futures	5376.36	5378.15	5374.28	5376.96	2405.0
2016-05-31 09:00:00	NQ	Futures	5376.66	5384.1	5371.9	5378.74	22301.0
2016-05-31 10:00:00	NQ	Futures	5378.44	5387.67	5371.3	5378.74	29093.0
2016-05-31 11:00:00	NQ	Futures	5378.44	5379.34	5369.52	5372.49	19080.0
2016-05-31 12:00:00	NQ	Futures	5372.2	5372.2	5364.16	5368.33	13393.0
2016-05-31 13:00:00	NQ	Futures	5368.03	5379.93	5365.95	5373.98	12669.0
2016-05-31 14:00:00	NQ	Futures	5373.68	5373.68	5354.94	5357.32	22135.0
2016-05-31 15:00:00	NQ	Futures	5357.32	5387.97	5352.56	5380.82	35354.0
2016-05-31 16:00:00	NQ	Futures	5380.53	5386.18	5374.58	5383.5	13794.0
2016-05-31 18:00:00	NQ	Futures	5381.72	5385.59	5379.34	5384.1	890.0
2016-05-31 19:00:00	NQ	Futures	5383.8	5385.59	5382.31	5384.1	425.0
2016-05-31 20:00:00	NQ	Futures	5384.4	5385.88	5383.5	5384.69	871.0
2016-05-31 21:00:00	NQ	Futures	5384.99	5393.02	5383.5	5392.43	1701.0
2016-05-31 22:00:00	NQ	Futures	5392.73	5400.16	5392.73	5396.0	1613.0
2016-05-31 23:00:00	NQ	Futures	5396.0	5397.49	5390.94	5393.02	1370.0
2016-05-31 00:00:00	YM	Futures	19167.5	19168.5	19155.7	19158.9	483.0
2016-05-31 01:00:00	YM	Futures	19160.0	19164.3	19156.8	19156.8	355.0
2016-05-31 02:00:00	YM	Futures	19157.8	19160.0	19142.9	19142.9	1241.0
2016-05-31 03:00:00	YM	Futures	19142.9	19152.5	19121.4	19122.5	2729.0

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

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