PREVIEW / futures_1hour / 2016-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-24.parquet
  size:    50 KB
  rows:    1,588

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-08-24 00:00:00	ES	Futures	2369.36	2369.63	2368.81	2369.36	1604.0
2016-08-24 01:00:00	ES	Futures	2369.36	2369.9	2368.81	2369.36	2436.0
2016-08-24 02:00:00	ES	Futures	2369.08	2369.9	2367.73	2368.0	8510.0
2016-08-24 03:00:00	ES	Futures	2367.73	2371.53	2365.56	2370.71	37379.0
2016-08-24 04:00:00	ES	Futures	2370.44	2372.34	2369.08	2371.8	21289.0
2016-08-24 05:00:00	ES	Futures	2371.8	2373.15	2370.71	2372.07	16750.0
2016-08-24 06:00:00	ES	Futures	2372.07	2372.88	2371.25	2372.61	12948.0
2016-08-24 07:00:00	ES	Futures	2372.34	2372.88	2370.44	2371.25	17909.0
2016-08-24 08:00:00	ES	Futures	2371.25	2372.07	2370.71	2371.25	13137.0
2016-08-24 09:00:00	ES	Futures	2371.53	2371.8	2366.37	2368.0	165496.0
2016-08-24 10:00:00	ES	Futures	2368.0	2369.08	2362.85	2365.02	219754.0
2016-08-24 11:00:00	ES	Futures	2365.02	2366.1	2363.39	2364.75	114691.0
2016-08-24 12:00:00	ES	Futures	2364.47	2368.27	2364.2	2367.73	75879.0
2016-08-24 13:00:00	ES	Futures	2367.73	2368.0	2365.02	2365.29	75373.0
2016-08-24 14:00:00	ES	Futures	2365.02	2365.29	2360.14	2362.03	177561.0
2016-08-24 15:00:00	ES	Futures	2362.3	2362.3	2352.54	2358.51	410625.0
2016-08-24 16:00:00	ES	Futures	2358.78	2360.41	2357.97	2359.59	99310.0
2016-08-24 18:00:00	ES	Futures	2359.32	2359.59	2357.69	2358.78	4404.0
2016-08-24 19:00:00	ES	Futures	2359.05	2359.32	2358.51	2358.78	2024.0
2016-08-24 20:00:00	ES	Futures	2358.78	2359.05	2356.88	2358.51	5999.0
2016-08-24 21:00:00	ES	Futures	2358.78	2359.86	2357.15	2357.42	6248.0
2016-08-24 22:00:00	ES	Futures	2357.42	2360.68	2357.42	2359.59	5540.0
2016-08-24 23:00:00	ES	Futures	2359.59	2360.41	2359.59	2359.59	2623.0
2016-08-24 00:00:00	NQ	Futures	5738.09	5739.28	5737.79	5738.98	278.0
2016-08-24 01:00:00	NQ	Futures	5738.68	5738.98	5737.19	5738.68	458.0
2016-08-24 02:00:00	NQ	Futures	5738.09	5739.88	5735.11	5736.6	1570.0
2016-08-24 03:00:00	NQ	Futures	5735.7	5745.24	5728.85	5742.56	5062.0
2016-08-24 04:00:00	NQ	Futures	5742.86	5749.12	5740.18	5747.92	2820.0
2016-08-24 05:00:00	NQ	Futures	5748.22	5750.61	5745.54	5748.22	1798.0
2016-08-24 06:00:00	NQ	Futures	5747.92	5749.71	5745.84	5747.63	1197.0
2016-08-24 07:00:00	NQ	Futures	5747.63	5748.52	5744.35	5747.33	1438.0
2016-08-24 08:00:00	NQ	Futures	5747.63	5749.12	5745.84	5746.73	1802.0
2016-08-24 09:00:00	NQ	Futures	5746.73	5747.92	5736.3	5742.56	24466.0
2016-08-24 10:00:00	NQ	Futures	5742.86	5745.54	5729.45	5733.02	28667.0
2016-08-24 11:00:00	NQ	Futures	5733.62	5736.0	5727.36	5730.94	15186.0
2016-08-24 12:00:00	NQ	Futures	5730.64	5739.58	5729.45	5737.79	10860.0
2016-08-24 13:00:00	NQ	Futures	5738.09	5738.98	5729.15	5729.74	8075.0
2016-08-24 14:00:00	NQ	Futures	5729.74	5729.74	5709.18	5717.82	29062.0
2016-08-24 15:00:00	NQ	Futures	5717.52	5717.82	5687.72	5705.0	44984.0
2016-08-24 16:00:00	NQ	Futures	5705.0	5708.28	5703.81	5706.5	7660.0
2016-08-24 18:00:00	NQ	Futures	5706.5	5707.39	5703.22	5705.6	848.0
2016-08-24 19:00:00	NQ	Futures	5705.9	5707.09	5704.41	5705.3	350.0
2016-08-24 20:00:00	NQ	Futures	5705.0	5705.3	5699.64	5704.41	1035.0
2016-08-24 21:00:00	NQ	Futures	5703.81	5707.69	5700.83	5701.43	878.0
2016-08-24 22:00:00	NQ	Futures	5701.43	5713.05	5701.13	5709.77	1258.0
2016-08-24 23:00:00	NQ	Futures	5709.77	5711.86	5708.28	5708.58	486.0
2016-08-24 00:00:00	YM	Futures	19925.9	19929.2	19921.6	19925.9	302.0
2016-08-24 01:00:00	YM	Futures	19924.9	19927.0	19919.5	19923.8	523.0
2016-08-24 02:00:00	YM	Futures	19922.7	19927.0	19910.9	19911.9	1133.0
2016-08-24 03:00:00	YM	Futures	19910.9	19939.9	19890.4	19934.5	5760.0

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

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