PREVIEW / futures_1hour / 2015-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-09.parquet
  size:    52 KB
  rows:    1,535

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
2015-09-09 00:00:00	ES	Futures	2108.15	2108.69	2106.02	2107.36	4707.0
2015-09-09 01:00:00	ES	Futures	2107.62	2113.75	2106.56	2113.48	12902.0
2015-09-09 02:00:00	ES	Futures	2113.48	2116.67	2111.88	2116.14	27383.0
2015-09-09 03:00:00	ES	Futures	2116.41	2121.47	2113.75	2118.54	40991.0
2015-09-09 04:00:00	ES	Futures	2118.27	2118.54	2112.68	2114.54	23493.0
2015-09-09 05:00:00	ES	Futures	2114.54	2117.74	2113.75	2114.54	19141.0
2015-09-09 06:00:00	ES	Futures	2114.54	2116.14	2111.08	2112.95	17096.0
2015-09-09 07:00:00	ES	Futures	2112.95	2116.94	2112.68	2115.08	22892.0
2015-09-09 08:00:00	ES	Futures	2115.08	2116.94	2112.15	2116.94	31474.0
2015-09-09 09:00:00	ES	Futures	2116.67	2117.74	2107.62	2109.22	209629.0
2015-09-09 10:00:00	ES	Futures	2108.95	2110.82	2095.37	2097.24	287172.0
2015-09-09 11:00:00	ES	Futures	2096.97	2102.03	2093.24	2097.24	186911.0
2015-09-09 12:00:00	ES	Futures	2097.24	2102.3	2095.37	2097.77	120137.0
2015-09-09 13:00:00	ES	Futures	2097.77	2100.97	2082.59	2083.66	191114.0
2015-09-09 14:00:00	ES	Futures	2083.66	2087.65	2076.47	2081.0	223123.0
2015-09-09 15:00:00	ES	Futures	2081.0	2086.85	2061.29	2065.82	401309.0
2015-09-09 16:00:00	ES	Futures	2066.35	2069.81	2064.76	2068.75	86214.0
2015-09-09 17:00:00	ES	Futures	2068.48	2070.61	2068.48	2070.08	2148.0
2015-09-09 18:00:00	ES	Futures	2070.08	2070.35	2058.63	2061.83	12136.0
2015-09-09 19:00:00	ES	Futures	2061.56	2065.02	2059.7	2062.89	6190.0
2015-09-09 20:00:00	ES	Futures	2062.89	2066.09	2061.03	2062.89	9085.0
2015-09-09 21:00:00	ES	Futures	2062.89	2066.09	2060.76	2065.82	12705.0
2015-09-09 22:00:00	ES	Futures	2065.82	2068.48	2065.02	2066.89	9298.0
2015-09-09 23:00:00	ES	Futures	2066.89	2070.61	2065.55	2069.02	6597.0
2015-09-09 00:00:00	NQ	Futures	5129.88	5132.83	5124.55	5129.88	1028.0
2015-09-09 01:00:00	NQ	Futures	5130.17	5142.59	5127.51	5140.82	2214.0
2015-09-09 02:00:00	NQ	Futures	5140.82	5151.17	5137.27	5149.69	3006.0
2015-09-09 03:00:00	NQ	Futures	5150.29	5169.81	5149.4	5160.05	7923.0
2015-09-09 04:00:00	NQ	Futures	5159.75	5160.05	5144.07	5149.1	3128.0
2015-09-09 05:00:00	NQ	Futures	5149.4	5157.09	5144.96	5146.44	2094.0
2015-09-09 06:00:00	NQ	Futures	5146.74	5149.99	5137.57	5142.59	2477.0
2015-09-09 07:00:00	NQ	Futures	5142.89	5151.17	5142.0	5147.62	3375.0
2015-09-09 08:00:00	NQ	Futures	5147.62	5152.95	5140.82	5152.06	5689.0
2015-09-09 09:00:00	NQ	Futures	5151.76	5154.13	5119.52	5126.33	43750.0
2015-09-09 10:00:00	NQ	Futures	5126.62	5131.35	5091.72	5098.52	45959.0
2015-09-09 11:00:00	NQ	Futures	5097.93	5111.24	5088.17	5101.18	29695.0
2015-09-09 12:00:00	NQ	Futures	5101.78	5121.0	5097.04	5109.76	17625.0
2015-09-09 13:00:00	NQ	Futures	5109.76	5126.92	5077.23	5080.18	37803.0
2015-09-09 14:00:00	NQ	Futures	5080.48	5095.56	5055.93	5068.65	37941.0
2015-09-09 15:00:00	NQ	Futures	5068.35	5083.14	5016.88	5031.08	63869.0
2015-09-09 16:00:00	NQ	Futures	5031.38	5036.41	5025.46	5034.34	9390.0
2015-09-09 17:00:00	NQ	Futures	5034.63	5039.07	5033.74	5038.48	231.0
2015-09-09 18:00:00	NQ	Futures	5039.07	5039.07	5006.53	5016.0	2261.0
2015-09-09 19:00:00	NQ	Futures	5017.48	5022.8	5008.9	5015.11	1224.0
2015-09-09 20:00:00	NQ	Futures	5016.0	5024.57	5010.67	5016.29	1999.0
2015-09-09 21:00:00	NQ	Futures	5016.29	5026.94	5009.79	5026.05	1565.0
2015-09-09 22:00:00	NQ	Futures	5026.05	5031.38	5021.32	5024.57	1510.0
2015-09-09 23:00:00	NQ	Futures	5024.28	5037.29	5021.03	5032.27	1100.0
2015-09-09 00:00:00	YM	Futures	17459.0	17466.4	17448.5	17459.0	946.0
2015-09-09 01:00:00	YM	Futures	17457.9	17507.5	17449.5	17507.5	2585.0

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

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