PREVIEW / futures_1hour / 2017-04-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-25.parquet
  size:    54 KB
  rows:    1,659

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
2017-04-25 00:00:00	ES	Futures	2592.13	2592.67	2591.85	2592.4	2852.0
2017-04-25 01:00:00	ES	Futures	2592.4	2594.86	2592.13	2593.22	7619.0
2017-04-25 02:00:00	ES	Futures	2593.22	2594.31	2592.95	2593.77	8153.0
2017-04-25 03:00:00	ES	Futures	2593.77	2594.04	2591.03	2591.03	22339.0
2017-04-25 04:00:00	ES	Futures	2591.31	2593.22	2591.03	2592.67	10513.0
2017-04-25 05:00:00	ES	Futures	2592.95	2592.95	2591.85	2592.13	6886.0
2017-04-25 06:00:00	ES	Futures	2592.4	2594.04	2592.13	2593.77	6564.0
2017-04-25 07:00:00	ES	Futures	2593.49	2594.86	2593.49	2594.04	17560.0
2017-04-25 08:00:00	ES	Futures	2594.04	2598.41	2593.49	2597.86	47820.0
2017-04-25 09:00:00	ES	Futures	2597.86	2604.69	2597.59	2603.87	227499.0
2017-04-25 10:00:00	ES	Futures	2603.6	2607.97	2603.33	2603.6	177283.0
2017-04-25 11:00:00	ES	Futures	2603.6	2606.6	2603.33	2605.78	117074.0
2017-04-25 12:00:00	ES	Futures	2606.06	2606.88	2602.78	2603.87	96919.0
2017-04-25 13:00:00	ES	Futures	2604.15	2607.7	2603.6	2606.6	106723.0
2017-04-25 14:00:00	ES	Futures	2606.6	2608.79	2606.06	2606.6	100244.0
2017-04-25 15:00:00	ES	Futures	2606.6	2610.43	2605.51	2605.78	230470.0
2017-04-25 16:00:00	ES	Futures	2605.78	2606.06	2603.87	2604.42	93268.0
2017-04-25 18:00:00	ES	Futures	2603.6	2604.42	2602.78	2603.6	6788.0
2017-04-25 19:00:00	ES	Futures	2603.6	2604.42	2603.6	2603.6	2131.0
2017-04-25 20:00:00	ES	Futures	2603.87	2605.51	2603.6	2604.15	5795.0
2017-04-25 21:00:00	ES	Futures	2604.15	2606.06	2604.15	2605.78	6146.0
2017-04-25 22:00:00	ES	Futures	2606.06	2606.6	2605.24	2606.33	2894.0
2017-04-25 23:00:00	ES	Futures	2606.6	2606.6	2605.51	2606.06	2709.0
2017-04-25 00:00:00	NQ	Futures	6571.9	6573.69	6571.61	6573.4	568.0
2017-04-25 01:00:00	NQ	Futures	6573.4	6580.55	6573.1	6577.57	1524.0
2017-04-25 02:00:00	NQ	Futures	6576.97	6579.36	6575.48	6576.97	1439.0
2017-04-25 03:00:00	NQ	Futures	6576.97	6579.36	6572.8	6572.8	3177.0
2017-04-25 04:00:00	NQ	Futures	6573.1	6574.59	6570.12	6573.4	2018.0
2017-04-25 05:00:00	NQ	Futures	6573.4	6573.99	6570.71	6572.5	983.0
2017-04-25 06:00:00	NQ	Futures	6572.5	6576.38	6572.5	6575.48	1329.0
2017-04-25 07:00:00	NQ	Futures	6575.48	6579.06	6575.48	6577.57	2818.0
2017-04-25 08:00:00	NQ	Futures	6577.57	6587.71	6576.67	6585.92	6144.0
2017-04-25 09:00:00	NQ	Futures	6586.22	6593.97	6583.83	6590.69	26697.0
2017-04-25 10:00:00	NQ	Futures	6590.69	6604.7	6590.09	6598.74	27389.0
2017-04-25 11:00:00	NQ	Futures	6599.04	6611.26	6597.25	6610.66	16144.0
2017-04-25 12:00:00	NQ	Futures	6610.66	6616.33	6607.38	6609.47	15110.0
2017-04-25 13:00:00	NQ	Futures	6609.77	6619.31	6608.87	6615.73	13016.0
2017-04-25 14:00:00	NQ	Futures	6615.43	6620.5	6613.64	6616.33	11705.0
2017-04-25 15:00:00	NQ	Futures	6616.33	6627.36	6614.84	6615.73	26077.0
2017-04-25 16:00:00	NQ	Futures	6615.43	6618.71	6611.56	6615.43	6731.0
2017-04-25 18:00:00	NQ	Futures	6614.84	6615.13	6611.26	6613.94	881.0
2017-04-25 19:00:00	NQ	Futures	6613.64	6616.63	6613.64	6614.84	454.0
2017-04-25 20:00:00	NQ	Futures	6615.13	6618.41	6614.54	6615.13	963.0
2017-04-25 21:00:00	NQ	Futures	6614.84	6618.71	6613.64	6618.41	1367.0
2017-04-25 22:00:00	NQ	Futures	6618.41	6621.1	6616.33	6620.5	716.0
2017-04-25 23:00:00	NQ	Futures	6620.8	6621.4	6617.82	6619.9	1124.0
2017-04-25 00:00:00	YM	Futures	22531.4	22536.8	22530.3	22534.6	591.0
2017-04-25 01:00:00	YM	Futures	22534.6	22568.3	22534.6	22544.4	1760.0
2017-04-25 02:00:00	YM	Futures	22544.4	22556.4	22541.1	22550.9	1479.0
2017-04-25 03:00:00	YM	Futures	22550.9	22556.4	22533.5	22534.6	3381.0

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

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