PREVIEW / futures_1hour / 2016-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-02.parquet
  size:    51 KB
  rows:    1,600

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-06-02 00:00:00	ES	Futures	2260.54	2260.81	2259.46	2260.81	3356.0
2016-06-02 01:00:00	ES	Futures	2260.81	2261.35	2258.38	2259.73	6290.0
2016-06-02 02:00:00	ES	Futures	2259.73	2261.08	2259.19	2260.54	7650.0
2016-06-02 03:00:00	ES	Futures	2260.27	2262.97	2259.46	2260.54	25927.0
2016-06-02 04:00:00	ES	Futures	2260.54	2263.24	2258.92	2262.7	14974.0
2016-06-02 05:00:00	ES	Futures	2262.43	2264.59	2261.89	2264.05	11123.0
2016-06-02 06:00:00	ES	Futures	2264.32	2264.86	2262.43	2264.59	10181.0
2016-06-02 07:00:00	ES	Futures	2264.59	2264.86	2262.97	2263.51	9723.0
2016-06-02 08:00:00	ES	Futures	2263.78	2263.78	2258.92	2259.73	38445.0
2016-06-02 09:00:00	ES	Futures	2259.73	2260.81	2253.52	2255.41	203275.0
2016-06-02 10:00:00	ES	Futures	2255.14	2260.81	2254.6	2259.73	193484.0
2016-06-02 11:00:00	ES	Futures	2259.46	2263.78	2258.92	2262.97	178031.0
2016-06-02 12:00:00	ES	Futures	2263.24	2264.05	2259.19	2263.51	87435.0
2016-06-02 13:00:00	ES	Futures	2263.78	2266.21	2262.97	2265.94	87138.0
2016-06-02 14:00:00	ES	Futures	2266.21	2269.18	2265.94	2268.1	112685.0
2016-06-02 15:00:00	ES	Futures	2267.83	2271.61	2266.21	2271.34	172106.0
2016-06-02 16:00:00	ES	Futures	2271.34	2272.96	2270.53	2271.61	76323.0
2016-06-02 18:00:00	ES	Futures	2271.61	2271.61	2270.8	2270.8	3191.0
2016-06-02 19:00:00	ES	Futures	2271.07	2273.23	2270.8	2272.96	3756.0
2016-06-02 20:00:00	ES	Futures	2272.69	2272.96	2271.61	2271.88	4381.0
2016-06-02 21:00:00	ES	Futures	2271.88	2272.96	2270.53	2271.07	4658.0
2016-06-02 22:00:00	ES	Futures	2271.07	2271.88	2270.26	2271.07	4092.0
2016-06-02 23:00:00	ES	Futures	2271.34	2271.88	2270.8	2271.07	1961.0
2016-06-02 00:00:00	NQ	Futures	5370.71	5371.3	5366.25	5370.11	531.0
2016-06-02 01:00:00	NQ	Futures	5370.71	5372.49	5365.35	5368.92	736.0
2016-06-02 02:00:00	NQ	Futures	5368.33	5372.2	5366.54	5370.11	674.0
2016-06-02 03:00:00	NQ	Futures	5370.71	5376.96	5366.54	5371.9	2809.0
2016-06-02 04:00:00	NQ	Futures	5371.6	5377.25	5367.44	5376.36	1468.0
2016-06-02 05:00:00	NQ	Futures	5376.06	5380.23	5373.68	5378.15	1236.0
2016-06-02 06:00:00	NQ	Futures	5377.85	5380.82	5375.47	5378.74	1192.0
2016-06-02 07:00:00	NQ	Futures	5379.04	5379.93	5377.25	5377.25	1266.0
2016-06-02 08:00:00	NQ	Futures	5377.55	5377.55	5368.33	5371.01	4074.0
2016-06-02 09:00:00	NQ	Futures	5370.41	5371.9	5339.17	5346.91	36216.0
2016-06-02 10:00:00	NQ	Futures	5346.91	5371.3	5345.12	5365.35	30552.0
2016-06-02 11:00:00	NQ	Futures	5365.65	5376.96	5363.57	5368.03	22639.0
2016-06-02 12:00:00	NQ	Futures	5368.03	5371.3	5356.13	5370.41	13632.0
2016-06-02 13:00:00	NQ	Futures	5370.71	5378.15	5367.44	5376.66	12332.0
2016-06-02 14:00:00	NQ	Futures	5376.96	5384.99	5376.96	5383.5	14811.0
2016-06-02 15:00:00	NQ	Futures	5383.5	5391.24	5380.23	5390.64	21320.0
2016-06-02 16:00:00	NQ	Futures	5390.94	5394.81	5390.35	5393.02	7855.0
2016-06-02 18:00:00	NQ	Futures	5391.54	5392.73	5389.45	5389.75	725.0
2016-06-02 19:00:00	NQ	Futures	5390.05	5393.62	5389.45	5392.73	1007.0
2016-06-02 20:00:00	NQ	Futures	5392.73	5393.32	5390.05	5390.94	693.0
2016-06-02 21:00:00	NQ	Futures	5391.54	5394.51	5388.26	5389.75	742.0
2016-06-02 22:00:00	NQ	Futures	5389.45	5391.54	5387.37	5390.35	465.0
2016-06-02 23:00:00	NQ	Futures	5390.35	5390.64	5389.16	5390.05	104.0
2016-06-02 00:00:00	YM	Futures	18994.1	18998.4	18987.6	18998.4	450.0
2016-06-02 01:00:00	YM	Futures	18997.3	19002.6	18979.1	18989.8	933.0
2016-06-02 02:00:00	YM	Futures	18988.7	19000.5	18981.2	18996.2	1056.0
2016-06-02 03:00:00	YM	Futures	18997.3	19017.6	18987.6	18996.2	3565.0

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

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