PREVIEW / futures_1hour / 2016-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-31.parquet
  size:    15 KB
  rows:    290

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-31 18:00:00	ES	Futures	2358.24	2358.78	2356.34	2356.34	9215.0
2016-07-31 19:00:00	ES	Futures	2356.61	2356.61	2354.71	2354.98	3743.0
2016-07-31 20:00:00	ES	Futures	2355.25	2356.88	2353.9	2356.61	7358.0
2016-07-31 21:00:00	ES	Futures	2356.61	2359.05	2355.8	2358.78	9173.0
2016-07-31 22:00:00	ES	Futures	2358.78	2362.03	2358.51	2361.49	11776.0
2016-07-31 23:00:00	ES	Futures	2361.22	2361.76	2360.95	2361.49	3419.0
2016-07-31 18:00:00	NQ	Futures	5648.08	5649.87	5641.82	5642.12	921.0
2016-07-31 19:00:00	NQ	Futures	5642.12	5642.12	5638.84	5639.43	533.0
2016-07-31 20:00:00	NQ	Futures	5639.73	5643.9	5637.05	5642.12	1049.0
2016-07-31 21:00:00	NQ	Futures	5642.12	5646.59	5638.84	5645.99	2488.0
2016-07-31 22:00:00	NQ	Futures	5645.99	5655.83	5645.39	5654.63	2284.0
2016-07-31 23:00:00	NQ	Futures	5655.23	5655.53	5653.14	5654.34	604.0
2016-07-31 18:00:00	YM	Futures	19811.9	19842.0	19797.9	19800.0	1927.0
2016-07-31 19:00:00	YM	Futures	19801.1	19801.1	19790.3	19791.4	595.0
2016-07-31 20:00:00	YM	Futures	19791.4	19807.6	19785.0	19807.6	1033.0
2016-07-31 21:00:00	YM	Futures	19806.5	19829.1	19798.9	19826.9	1902.0
2016-07-31 22:00:00	YM	Futures	19826.9	19853.8	19824.8	19850.6	1950.0
2016-07-31 23:00:00	YM	Futures	19850.6	19851.7	19844.1	19849.5	799.0
2016-07-31 18:00:00	CL	Futures	42.64	42.75	42.51	42.66	1986.0
2016-07-31 19:00:00	CL	Futures	42.66	42.66	42.57	42.63	1390.0
2016-07-31 20:00:00	CL	Futures	42.63	42.78	42.62	42.74	3426.0
2016-07-31 21:00:00	CL	Futures	42.74	42.93	42.73	42.89	5980.0
2016-07-31 22:00:00	CL	Futures	42.89	43.14	42.84	43.0	5300.0
2016-07-31 23:00:00	CL	Futures	43.0	43.11	42.99	43.06	2484.0
2016-07-31 18:00:00	GC	Futures	1836.2	1837.6	1832.2	1835.7	1246.0
2016-07-31 19:00:00	GC	Futures	1835.7	1836.0	1833.7	1834.7	1309.0
2016-07-31 20:00:00	GC	Futures	1834.7	1834.9	1831.0	1831.8	4458.0
2016-07-31 21:00:00	GC	Futures	1831.8	1838.4	1831.5	1836.8	7583.0
2016-07-31 22:00:00	GC	Futures	1836.9	1837.9	1833.9	1835.0	3650.0
2016-07-31 23:00:00	GC	Futures	1835.0	1836.6	1833.1	1836.0	2866.0
2016-07-31 18:00:00	ZN	Futures	129.633777	129.633777	129.557701	129.572916	4768.0
2016-07-31 19:00:00	ZN	Futures	129.572916	129.603347	129.542486	129.557701	5811.0
2016-07-31 20:00:00	ZN	Futures	129.557701	129.557701	129.451194	129.481625	15982.0
2016-07-31 21:00:00	ZN	Futures	129.49684	129.49684	129.390333	129.405548	16751.0
2016-07-31 22:00:00	ZN	Futures	129.405548	129.420764	129.390333	129.405548	4268.0
2016-07-31 23:00:00	ZN	Futures	129.405548	129.466409	129.359903	129.390333	15083.0

> showing 36 of 290 rows — these rows as CSV

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