PREVIEW / futures_1hour / 2010-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-14.parquet
  size:    44 KB
  rows:    1,310

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
2010-06-14 00:00:00	ES	Futures	1069.61	1069.61	1067.89	1068.14	3505.0
2010-06-14 01:00:00	ES	Futures	1068.14	1071.57	1068.14	1071.08	4077.0
2010-06-14 02:00:00	ES	Futures	1071.08	1071.82	1070.35	1070.84	5914.0
2010-06-14 03:00:00	ES	Futures	1070.84	1072.06	1069.61	1070.35	27736.0
2010-06-14 04:00:00	ES	Futures	1070.59	1075.25	1069.36	1074.52	29058.0
2010-06-14 05:00:00	ES	Futures	1074.52	1075.99	1073.54	1074.52	21085.0
2010-06-14 06:00:00	ES	Futures	1074.27	1074.76	1072.8	1073.04	12868.0
2010-06-14 07:00:00	ES	Futures	1072.8	1074.03	1071.57	1073.78	15871.0
2010-06-14 08:00:00	ES	Futures	1073.54	1075.5	1073.29	1074.27	41117.0
2010-06-14 09:00:00	ES	Futures	1074.03	1075.99	1071.33	1072.8	266378.0
2010-06-14 10:00:00	ES	Futures	1072.8	1077.71	1072.31	1077.22	277169.0
2010-06-14 11:00:00	ES	Futures	1077.22	1081.39	1076.48	1077.71	247166.0
2010-06-14 12:00:00	ES	Futures	1077.71	1079.42	1074.27	1074.52	132221.0
2010-06-14 13:00:00	ES	Futures	1074.52	1076.97	1070.35	1070.59	192669.0
2010-06-14 14:00:00	ES	Futures	1070.59	1073.04	1067.89	1072.31	244351.0
2010-06-14 15:00:00	ES	Futures	1072.55	1074.03	1064.21	1065.44	316628.0
2010-06-14 16:00:00	ES	Futures	1065.68	1066.42	1065.19	1065.68	68625.0
2010-06-14 17:00:00	ES	Futures	1065.68	1066.42	1065.19	1065.93	1483.0
2010-06-14 18:00:00	ES	Futures	1065.93	1067.16	1064.95	1065.44	3147.0
2010-06-14 19:00:00	ES	Futures	1065.44	1066.42	1065.19	1065.68	957.0
2010-06-14 20:00:00	ES	Futures	1065.68	1069.36	1065.19	1067.65	7514.0
2010-06-14 21:00:00	ES	Futures	1067.89	1068.14	1065.68	1067.16	5544.0
2010-06-14 22:00:00	ES	Futures	1067.4	1068.87	1066.66	1067.89	3381.0
2010-06-14 23:00:00	ES	Futures	1068.14	1070.1	1067.89	1069.36	3715.0
2010-06-14 00:00:00	NQ	Futures	2121.16	2121.16	2118.87	2119.16	211.0
2010-06-14 01:00:00	NQ	Futures	2119.73	2124.6	2119.73	2123.45	297.0
2010-06-14 02:00:00	NQ	Futures	2123.17	2125.46	2122.31	2124.31	510.0
2010-06-14 03:00:00	NQ	Futures	2124.03	2125.46	2120.88	2122.88	2419.0
2010-06-14 04:00:00	NQ	Futures	2122.88	2130.05	2120.3	2128.9	2073.0
2010-06-14 05:00:00	NQ	Futures	2128.9	2131.76	2126.89	2128.61	1345.0
2010-06-14 06:00:00	NQ	Futures	2128.61	2129.19	2125.17	2125.17	1095.0
2010-06-14 07:00:00	NQ	Futures	2125.17	2128.9	2124.03	2128.04	1227.0
2010-06-14 08:00:00	NQ	Futures	2128.04	2133.2	2127.75	2131.76	4040.0
2010-06-14 09:00:00	NQ	Futures	2132.05	2141.22	2129.19	2136.06	41996.0
2010-06-14 10:00:00	NQ	Futures	2135.78	2146.95	2134.92	2144.09	38585.0
2010-06-14 11:00:00	NQ	Futures	2144.09	2150.39	2141.79	2142.94	28971.0
2010-06-14 12:00:00	NQ	Futures	2142.94	2146.95	2135.2	2135.49	22205.0
2010-06-14 13:00:00	NQ	Futures	2135.78	2140.36	2125.75	2126.03	32110.0
2010-06-14 14:00:00	NQ	Futures	2126.32	2130.05	2119.16	2128.61	35412.0
2010-06-14 15:00:00	NQ	Futures	2128.61	2132.34	2112.28	2115.14	48992.0
2010-06-14 16:00:00	NQ	Futures	2115.14	2117.15	2112.28	2116.0	10343.0
2010-06-14 17:00:00	NQ	Futures	2116.58	2117.72	2115.72	2116.86	124.0
2010-06-14 18:00:00	NQ	Futures	2116.86	2118.58	2115.14	2116.0	225.0
2010-06-14 19:00:00	NQ	Futures	2115.43	2117.72	2115.43	2117.15	147.0
2010-06-14 20:00:00	NQ	Futures	2117.15	2123.45	2116.0	2121.45	677.0
2010-06-14 21:00:00	NQ	Futures	2121.45	2121.73	2116.58	2119.73	347.0
2010-06-14 22:00:00	NQ	Futures	2119.73	2122.59	2119.16	2121.16	91.0
2010-06-14 23:00:00	NQ	Futures	2121.16	2124.6	2120.88	2123.45	164.0
2010-06-14 00:00:00	YM	Futures	9630.8	9631.7	9618.5	9622.3	179.0
2010-06-14 01:00:00	YM	Futures	9623.2	9647.8	9623.2	9643.1	292.0

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

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