PREVIEW / futures_1hour / 2016-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-01.parquet
  size:    54 KB
  rows:    1,620

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-03-01 00:00:00	ES	Futures	2072.02	2072.28	2066.64	2070.4	7520.0
2016-03-01 01:00:00	ES	Futures	2070.94	2074.43	2070.67	2073.63	7253.0
2016-03-01 02:00:00	ES	Futures	2073.63	2081.69	2073.63	2081.42	23231.0
2016-03-01 03:00:00	ES	Futures	2081.15	2091.36	2076.85	2085.99	57054.0
2016-03-01 04:00:00	ES	Futures	2085.99	2086.79	2081.15	2084.11	23614.0
2016-03-01 05:00:00	ES	Futures	2083.84	2091.9	2083.57	2090.02	23264.0
2016-03-01 06:00:00	ES	Futures	2090.02	2093.51	2087.33	2089.21	25403.0
2016-03-01 07:00:00	ES	Futures	2089.21	2092.44	2088.68	2090.02	23519.0
2016-03-01 08:00:00	ES	Futures	2090.02	2091.36	2086.26	2088.94	40689.0
2016-03-01 09:00:00	ES	Futures	2088.94	2092.17	2083.3	2088.68	244220.0
2016-03-01 10:00:00	ES	Futures	2088.94	2102.38	2088.68	2097.81	359210.0
2016-03-01 11:00:00	ES	Futures	2097.54	2111.25	2097.27	2110.44	225834.0
2016-03-01 12:00:00	ES	Futures	2110.44	2115.55	2110.17	2115.01	199308.0
2016-03-01 13:00:00	ES	Futures	2115.01	2119.04	2112.32	2115.81	161156.0
2016-03-01 14:00:00	ES	Futures	2115.81	2121.46	2113.4	2121.46	162961.0
2016-03-01 15:00:00	ES	Futures	2121.19	2123.61	2117.43	2123.34	249181.0
2016-03-01 16:00:00	ES	Futures	2123.34	2126.56	2122.0	2125.49	119832.0
2016-03-01 18:00:00	ES	Futures	2124.14	2125.22	2123.07	2123.61	8463.0
2016-03-01 19:00:00	ES	Futures	2123.61	2124.41	2121.73	2123.61	10432.0
2016-03-01 20:00:00	ES	Futures	2123.34	2126.83	2123.07	2126.03	12146.0
2016-03-01 21:00:00	ES	Futures	2125.76	2127.91	2124.68	2126.83	6820.0
2016-03-01 22:00:00	ES	Futures	2126.83	2128.18	2125.76	2127.37	4421.0
2016-03-01 23:00:00	ES	Futures	2127.37	2130.06	2126.83	2128.71	7616.0
2016-03-01 00:00:00	NQ	Futures	4984.88	4984.88	4970.33	4982.51	1238.0
2016-03-01 01:00:00	NQ	Futures	4982.51	4991.42	4981.91	4988.45	980.0
2016-03-01 02:00:00	NQ	Futures	4989.34	5012.5	4989.34	5011.31	3453.0
2016-03-01 03:00:00	NQ	Futures	5011.61	5037.74	4998.54	5024.67	8024.0
2016-03-01 04:00:00	NQ	Futures	5024.67	5026.45	5011.01	5018.73	3760.0
2016-03-01 05:00:00	NQ	Futures	5018.73	5038.92	5017.25	5031.5	3723.0
2016-03-01 06:00:00	NQ	Futures	5031.5	5038.92	5024.08	5026.45	4511.0
2016-03-01 07:00:00	NQ	Futures	5025.86	5033.58	5025.86	5026.45	2882.0
2016-03-01 08:00:00	NQ	Futures	5026.45	5029.13	5016.95	5026.16	5934.0
2016-03-01 09:00:00	NQ	Futures	5025.86	5038.92	5016.95	5034.77	39381.0
2016-03-01 10:00:00	NQ	Futures	5035.66	5083.17	5035.66	5071.88	58182.0
2016-03-01 11:00:00	NQ	Futures	5072.18	5108.7	5071.29	5106.03	31228.0
2016-03-01 12:00:00	NQ	Futures	5105.73	5119.99	5105.73	5115.53	29379.0
2016-03-01 13:00:00	NQ	Futures	5115.53	5127.41	5107.52	5121.77	21251.0
2016-03-01 14:00:00	NQ	Futures	5121.77	5136.62	5119.1	5136.32	22141.0
2016-03-01 15:00:00	NQ	Futures	5136.02	5145.52	5125.33	5145.52	33938.0
2016-03-01 16:00:00	NQ	Futures	5145.23	5153.24	5141.66	5151.76	12193.0
2016-03-01 18:00:00	NQ	Futures	5148.2	5151.76	5146.12	5147.9	955.0
2016-03-01 19:00:00	NQ	Futures	5147.9	5149.98	5143.15	5147.6	1015.0
2016-03-01 20:00:00	NQ	Futures	5148.79	5160.07	5148.2	5158.29	2583.0
2016-03-01 21:00:00	NQ	Futures	5157.7	5163.93	5155.32	5161.26	1207.0
2016-03-01 22:00:00	NQ	Futures	5160.67	5164.82	5156.81	5163.04	772.0
2016-03-01 23:00:00	NQ	Futures	5163.04	5169.28	5161.26	5164.82	871.0
2016-03-01 00:00:00	YM	Futures	17553.2	17554.3	17510.7	17544.7	973.0
2016-03-01 01:00:00	YM	Futures	17546.9	17572.4	17544.7	17566.0	1386.0
2016-03-01 02:00:00	YM	Futures	17571.3	17631.0	17571.3	17628.8	2962.0
2016-03-01 03:00:00	YM	Futures	17627.8	17705.5	17591.6	17667.1	8387.0

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

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