PREVIEW / futures_1hour / 2017-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-15.parquet
  size:    52 KB
  rows:    1,650

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-05-15 00:00:00	ES	Futures	2613.16	2613.43	2612.34	2612.34	1865.0
2017-05-15 01:00:00	ES	Futures	2612.34	2612.89	2611.79	2612.07	1629.0
2017-05-15 02:00:00	ES	Futures	2612.07	2616.16	2612.07	2615.89	11951.0
2017-05-15 03:00:00	ES	Futures	2615.89	2616.16	2614.25	2614.52	18726.0
2017-05-15 04:00:00	ES	Futures	2614.8	2614.8	2612.34	2612.61	14057.0
2017-05-15 05:00:00	ES	Futures	2612.89	2613.43	2609.88	2610.97	15594.0
2017-05-15 06:00:00	ES	Futures	2610.7	2612.89	2610.43	2612.61	9246.0
2017-05-15 07:00:00	ES	Futures	2612.61	2613.71	2611.79	2612.89	11509.0
2017-05-15 08:00:00	ES	Futures	2612.89	2615.07	2612.89	2613.98	17434.0
2017-05-15 09:00:00	ES	Futures	2613.71	2620.26	2613.43	2619.99	138427.0
2017-05-15 10:00:00	ES	Futures	2619.99	2624.08	2619.71	2622.99	164337.0
2017-05-15 11:00:00	ES	Futures	2623.27	2624.63	2620.81	2621.63	113990.0
2017-05-15 12:00:00	ES	Futures	2621.63	2622.17	2620.53	2620.81	52971.0
2017-05-15 13:00:00	ES	Futures	2621.08	2623.27	2620.26	2622.99	56003.0
2017-05-15 14:00:00	ES	Futures	2622.72	2622.99	2618.89	2619.71	93352.0
2017-05-15 15:00:00	ES	Futures	2619.71	2623.27	2619.17	2622.45	165957.0
2017-05-15 16:00:00	ES	Futures	2622.45	2622.72	2619.71	2622.17	106228.0
2017-05-15 18:00:00	ES	Futures	2621.9	2622.17	2619.17	2620.26	8202.0
2017-05-15 19:00:00	ES	Futures	2620.26	2621.08	2619.71	2621.08	1901.0
2017-05-15 20:00:00	ES	Futures	2620.81	2621.63	2620.53	2620.53	6916.0
2017-05-15 21:00:00	ES	Futures	2620.81	2621.08	2619.17	2619.44	5787.0
2017-05-15 22:00:00	ES	Futures	2619.17	2619.71	2618.35	2618.35	4660.0
2017-05-15 23:00:00	ES	Futures	2618.35	2619.17	2618.08	2618.35	2889.0
2017-05-15 00:00:00	NQ	Futures	6792.83	6793.12	6789.25	6789.25	726.0
2017-05-15 01:00:00	NQ	Futures	6789.84	6790.44	6787.76	6788.95	464.0
2017-05-15 02:00:00	NQ	Futures	6788.95	6797.6	6788.95	6796.11	2079.0
2017-05-15 03:00:00	NQ	Futures	6796.11	6797.89	6791.63	6791.93	3959.0
2017-05-15 04:00:00	NQ	Futures	6791.93	6792.23	6785.97	6787.16	2683.0
2017-05-15 05:00:00	NQ	Futures	6787.16	6787.76	6777.92	6780.01	2924.0
2017-05-15 06:00:00	NQ	Futures	6780.01	6784.48	6779.11	6784.18	1933.0
2017-05-15 07:00:00	NQ	Futures	6783.88	6785.07	6780.3	6781.8	1715.0
2017-05-15 08:00:00	NQ	Futures	6781.8	6785.67	6780.6	6782.69	3895.0
2017-05-15 09:00:00	NQ	Futures	6782.69	6797.0	6776.73	6795.21	31958.0
2017-05-15 10:00:00	NQ	Futures	6795.21	6805.35	6786.86	6802.07	32536.0
2017-05-15 11:00:00	NQ	Futures	6802.37	6804.75	6786.86	6789.84	21385.0
2017-05-15 12:00:00	NQ	Futures	6789.55	6792.53	6785.37	6788.35	12103.0
2017-05-15 13:00:00	NQ	Futures	6788.35	6799.39	6787.76	6798.49	11552.0
2017-05-15 14:00:00	NQ	Futures	6798.19	6798.79	6790.14	6796.11	12552.0
2017-05-15 15:00:00	NQ	Futures	6796.4	6801.77	6792.53	6801.77	23259.0
2017-05-15 16:00:00	NQ	Futures	6801.77	6804.16	6795.81	6803.26	7013.0
2017-05-15 18:00:00	NQ	Futures	6803.56	6803.56	6797.89	6801.17	985.0
2017-05-15 19:00:00	NQ	Futures	6801.47	6802.66	6799.98	6802.66	472.0
2017-05-15 20:00:00	NQ	Futures	6802.66	6804.16	6800.28	6800.58	1049.0
2017-05-15 21:00:00	NQ	Futures	6800.88	6802.07	6797.0	6798.19	1796.0
2017-05-15 22:00:00	NQ	Futures	6798.19	6798.19	6793.72	6794.32	1147.0
2017-05-15 23:00:00	NQ	Futures	6794.32	6796.7	6793.12	6795.81	565.0
2017-05-15 00:00:00	YM	Futures	22690.0	22691.1	22679.2	22680.2	346.0
2017-05-15 01:00:00	YM	Futures	22680.2	22685.7	22680.2	22683.5	302.0
2017-05-15 02:00:00	YM	Futures	22684.6	22719.4	22683.5	22716.1	2800.0
2017-05-15 03:00:00	YM	Futures	22716.1	22730.2	22706.3	22719.4	4278.0

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

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