PREVIEW / futures_1hour / 2016-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-26.parquet
  size:    52 KB
  rows:    1,590

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-26 00:00:00	ES	Futures	2347.39	2347.93	2345.49	2345.76	4723.0
2016-07-26 01:00:00	ES	Futures	2346.03	2348.47	2345.49	2347.12	5759.0
2016-07-26 02:00:00	ES	Futures	2347.39	2348.2	2345.49	2345.76	7925.0
2016-07-26 03:00:00	ES	Futures	2346.03	2347.39	2341.15	2343.32	33423.0
2016-07-26 04:00:00	ES	Futures	2343.05	2345.22	2341.69	2343.86	17894.0
2016-07-26 05:00:00	ES	Futures	2343.86	2345.76	2342.24	2342.51	16894.0
2016-07-26 06:00:00	ES	Futures	2342.51	2345.22	2342.24	2344.68	13777.0
2016-07-26 07:00:00	ES	Futures	2344.41	2345.76	2343.32	2343.59	23854.0
2016-07-26 08:00:00	ES	Futures	2343.59	2346.3	2343.59	2344.95	29741.0
2016-07-26 09:00:00	ES	Futures	2344.95	2351.73	2344.41	2349.56	186958.0
2016-07-26 10:00:00	ES	Futures	2349.29	2350.92	2337.63	2337.63	283921.0
2016-07-26 11:00:00	ES	Futures	2337.63	2345.22	2336.27	2344.14	267779.0
2016-07-26 12:00:00	ES	Futures	2344.41	2347.39	2343.32	2344.68	127365.0
2016-07-26 13:00:00	ES	Futures	2344.41	2345.22	2339.8	2341.15	134376.0
2016-07-26 14:00:00	ES	Futures	2341.15	2345.22	2338.98	2342.78	155954.0
2016-07-26 15:00:00	ES	Futures	2342.51	2347.12	2342.51	2347.12	185527.0
2016-07-26 16:00:00	ES	Futures	2346.85	2350.1	2344.68	2349.56	72379.0
2016-07-26 18:00:00	ES	Futures	2349.56	2349.83	2347.12	2347.93	5920.0
2016-07-26 19:00:00	ES	Futures	2347.93	2350.64	2347.93	2350.1	3197.0
2016-07-26 20:00:00	ES	Futures	2350.37	2351.19	2348.2	2348.75	9536.0
2016-07-26 21:00:00	ES	Futures	2348.75	2350.1	2348.2	2349.29	5648.0
2016-07-26 22:00:00	ES	Futures	2349.56	2351.73	2348.2	2350.92	9121.0
2016-07-26 23:00:00	ES	Futures	2351.19	2352.54	2350.64	2350.92	14189.0
2016-07-26 00:00:00	NQ	Futures	5555.38	5555.98	5550.32	5550.91	918.0
2016-07-26 01:00:00	NQ	Futures	5550.91	5558.07	5550.91	5555.68	1084.0
2016-07-26 02:00:00	NQ	Futures	5555.68	5557.17	5551.81	5552.4	1346.0
2016-07-26 03:00:00	NQ	Futures	5552.4	5556.28	5541.97	5546.74	3992.0
2016-07-26 04:00:00	NQ	Futures	5546.74	5550.32	5543.16	5547.63	1536.0
2016-07-26 05:00:00	NQ	Futures	5547.93	5553.89	5544.36	5544.95	1318.0
2016-07-26 06:00:00	NQ	Futures	5545.25	5551.81	5544.36	5550.32	1192.0
2016-07-26 07:00:00	NQ	Futures	5550.02	5553.59	5548.83	5553.3	2183.0
2016-07-26 08:00:00	NQ	Futures	5553.59	5558.96	5553.59	5554.49	3126.0
2016-07-26 09:00:00	NQ	Futures	5554.19	5577.74	5552.7	5577.14	27827.0
2016-07-26 10:00:00	NQ	Futures	5577.44	5581.91	5536.61	5537.2	40915.0
2016-07-26 11:00:00	NQ	Futures	5536.61	5556.58	5533.03	5554.49	33574.0
2016-07-26 12:00:00	NQ	Futures	5554.79	5563.43	5551.81	5556.87	14243.0
2016-07-26 13:00:00	NQ	Futures	5556.58	5558.66	5541.67	5547.04	14688.0
2016-07-26 14:00:00	NQ	Futures	5547.04	5563.73	5539.88	5556.28	20388.0
2016-07-26 15:00:00	NQ	Futures	5556.58	5564.92	5554.49	5561.94	19522.0
2016-07-26 16:00:00	NQ	Futures	5561.94	5589.36	5555.09	5587.57	12675.0
2016-07-26 18:00:00	NQ	Futures	5592.94	5594.43	5587.57	5591.15	1623.0
2016-07-26 19:00:00	NQ	Futures	5590.85	5596.81	5590.55	5595.32	737.0
2016-07-26 20:00:00	NQ	Futures	5595.02	5598.0	5592.34	5593.83	1539.0
2016-07-26 21:00:00	NQ	Futures	5593.83	5597.41	5591.45	5593.53	1021.0
2016-07-26 22:00:00	NQ	Futures	5593.83	5598.9	5590.85	5597.41	1102.0
2016-07-26 23:00:00	NQ	Futures	5597.71	5602.48	5596.22	5596.81	2287.0
2016-07-26 00:00:00	YM	Futures	19840.9	19843.1	19830.2	19831.2	960.0
2016-07-26 01:00:00	YM	Futures	19832.3	19852.8	19830.2	19844.1	1416.0
2016-07-26 02:00:00	YM	Futures	19845.2	19849.5	19828.0	19830.2	1522.0
2016-07-26 03:00:00	YM	Futures	19830.2	19846.3	19794.6	19815.1	5565.0

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

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