PREVIEW / futures_1hour / 2016-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-09-13.parquet
  size:    53 KB
  rows:    1,591

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-09-13 00:00:00	ES	Futures	2334.37	2336.27	2334.37	2335.73	1318.0
2016-09-13 01:00:00	ES	Futures	2335.73	2335.73	2332.47	2332.47	1988.0
2016-09-13 02:00:00	ES	Futures	2332.47	2333.02	2329.22	2329.49	8432.0
2016-09-13 03:00:00	ES	Futures	2329.49	2331.12	2325.15	2327.86	14142.0
2016-09-13 04:00:00	ES	Futures	2327.86	2327.86	2324.07	2325.97	6076.0
2016-09-13 05:00:00	ES	Futures	2325.69	2327.59	2325.42	2326.78	5009.0
2016-09-13 06:00:00	ES	Futures	2326.78	2329.49	2326.51	2328.95	5992.0
2016-09-13 07:00:00	ES	Futures	2328.95	2329.22	2324.07	2326.24	8102.0
2016-09-13 08:00:00	ES	Futures	2325.97	2327.59	2322.44	2323.8	12454.0
2016-09-13 09:00:00	ES	Futures	2323.53	2327.59	2315.66	2315.93	73986.0
2016-09-13 10:00:00	ES	Futures	2315.66	2317.56	2308.61	2309.69	78133.0
2016-09-13 11:00:00	ES	Futures	2309.69	2310.78	2302.37	2306.71	54189.0
2016-09-13 12:00:00	ES	Futures	2306.44	2312.41	2300.2	2302.37	44910.0
2016-09-13 13:00:00	ES	Futures	2302.1	2317.02	2298.58	2306.44	58446.0
2016-09-13 14:00:00	ES	Futures	2306.44	2309.69	2300.2	2304.0	27485.0
2016-09-13 15:00:00	ES	Futures	2303.73	2313.49	2299.93	2306.17	61847.0
2016-09-13 16:00:00	ES	Futures	2306.17	2313.49	2305.9	2312.68	21949.0
2016-09-13 18:00:00	ES	Futures	2312.41	2312.68	2309.97	2311.86	1174.0
2016-09-13 19:00:00	ES	Futures	2311.86	2312.41	2309.42	2309.69	893.0
2016-09-13 20:00:00	ES	Futures	2309.69	2314.58	2309.15	2313.76	1556.0
2016-09-13 21:00:00	ES	Futures	2313.76	2316.47	2313.49	2316.47	1725.0
2016-09-13 22:00:00	ES	Futures	2316.2	2317.83	2314.3	2315.12	1779.0
2016-09-13 23:00:00	ES	Futures	2315.12	2316.2	2313.76	2314.58	683.0
2016-09-13 00:00:00	NQ	Futures	5666.26	5670.43	5665.66	5669.83	126.0
2016-09-13 01:00:00	NQ	Futures	5669.83	5669.83	5660.89	5660.89	281.0
2016-09-13 02:00:00	NQ	Futures	5662.09	5662.09	5654.93	5655.83	979.0
2016-09-13 03:00:00	NQ	Futures	5656.12	5660.0	5644.8	5651.06	1010.0
2016-09-13 04:00:00	NQ	Futures	5650.76	5650.76	5641.52	5644.8	861.0
2016-09-13 05:00:00	NQ	Futures	5644.5	5648.97	5643.61	5648.38	585.0
2016-09-13 06:00:00	NQ	Futures	5647.48	5656.12	5647.48	5653.44	499.0
2016-09-13 07:00:00	NQ	Futures	5653.44	5654.93	5644.8	5654.34	469.0
2016-09-13 08:00:00	NQ	Futures	5654.63	5656.12	5644.8	5649.87	773.0
2016-09-13 09:00:00	NQ	Futures	5649.57	5669.24	5637.65	5639.14	10825.0
2016-09-13 10:00:00	NQ	Futures	5638.54	5646.29	5622.44	5624.23	13762.0
2016-09-13 11:00:00	NQ	Futures	5623.93	5626.92	5611.12	5618.57	8794.0
2016-09-13 12:00:00	NQ	Futures	5617.68	5632.58	5607.24	5612.31	5991.0
2016-09-13 13:00:00	NQ	Futures	5611.71	5641.82	5602.48	5623.34	8561.0
2016-09-13 14:00:00	NQ	Futures	5622.74	5629.9	5607.54	5614.7	4943.0
2016-09-13 15:00:00	NQ	Futures	5615.29	5643.31	5606.05	5629.6	9531.0
2016-09-13 16:00:00	NQ	Futures	5629.0	5645.69	5628.41	5644.8	1731.0
2016-09-13 18:00:00	NQ	Futures	5642.41	5645.1	5636.75	5640.63	141.0
2016-09-13 19:00:00	NQ	Futures	5641.82	5642.41	5635.26	5635.56	117.0
2016-09-13 20:00:00	NQ	Futures	5635.86	5647.78	5632.58	5644.8	125.0
2016-09-13 21:00:00	NQ	Futures	5645.69	5655.53	5644.2	5654.93	149.0
2016-09-13 22:00:00	NQ	Futures	5654.93	5657.02	5648.97	5650.16	224.0
2016-09-13 23:00:00	NQ	Futures	5650.16	5652.85	5646.59	5648.38	113.0
2016-09-13 00:00:00	YM	Futures	19653.7	19665.6	19651.5	19664.5	434.0
2016-09-13 01:00:00	YM	Futures	19663.4	19664.5	19640.7	19641.8	987.0
2016-09-13 02:00:00	YM	Futures	19641.8	19642.9	19613.7	19615.8	3558.0
2016-09-13 03:00:00	YM	Futures	19615.8	19628.8	19579.1	19602.9	5397.0

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

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