PREVIEW / futures_1hour / 2010-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-14.parquet
  size:    45 KB
  rows:    1,349

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-07-14 00:00:00	ES	Futures	1077.46	1077.71	1076.73	1077.22	1526.0
2010-07-14 01:00:00	ES	Futures	1077.22	1077.95	1076.48	1076.48	3314.0
2010-07-14 02:00:00	ES	Futures	1076.73	1077.46	1075.99	1076.48	8005.0
2010-07-14 03:00:00	ES	Futures	1076.48	1077.71	1075.25	1077.22	21297.0
2010-07-14 04:00:00	ES	Futures	1077.46	1077.71	1075.74	1075.99	16111.0
2010-07-14 05:00:00	ES	Futures	1075.99	1076.73	1072.55	1072.55	28275.0
2010-07-14 06:00:00	ES	Futures	1072.8	1074.76	1072.31	1073.54	15093.0
2010-07-14 07:00:00	ES	Futures	1073.54	1073.78	1071.08	1072.55	33674.0
2010-07-14 08:00:00	ES	Futures	1072.55	1073.04	1068.38	1068.63	98944.0
2010-07-14 09:00:00	ES	Futures	1068.87	1069.36	1065.68	1066.91	270367.0
2010-07-14 10:00:00	ES	Futures	1066.91	1071.57	1064.46	1070.84	305027.0
2010-07-14 11:00:00	ES	Futures	1070.84	1075.25	1069.61	1073.78	212857.0
2010-07-14 12:00:00	ES	Futures	1073.54	1074.27	1071.33	1072.06	96816.0
2010-07-14 13:00:00	ES	Futures	1071.82	1073.04	1068.38	1069.12	125029.0
2010-07-14 14:00:00	ES	Futures	1069.12	1069.61	1063.47	1067.65	269328.0
2010-07-14 15:00:00	ES	Futures	1067.65	1071.57	1066.17	1071.33	278428.0
2010-07-14 16:00:00	ES	Futures	1071.33	1072.06	1070.35	1071.57	84835.0
2010-07-14 17:00:00	ES	Futures	1071.33	1071.82	1071.08	1071.82	1353.0
2010-07-14 18:00:00	ES	Futures	1071.33	1072.31	1071.33	1071.57	2434.0
2010-07-14 19:00:00	ES	Futures	1071.33	1071.82	1071.08	1071.33	1655.0
2010-07-14 20:00:00	ES	Futures	1071.33	1071.57	1068.38	1069.12	6072.0
2010-07-14 21:00:00	ES	Futures	1069.36	1070.1	1068.63	1069.61	4780.0
2010-07-14 22:00:00	ES	Futures	1069.61	1078.2	1069.12	1074.27	26476.0
2010-07-14 23:00:00	ES	Futures	1074.27	1074.52	1072.55	1074.27	3457.0
2010-07-14 00:00:00	NQ	Futures	2137.21	2137.5	2136.35	2136.92	207.0
2010-07-14 01:00:00	NQ	Futures	2136.92	2139.22	2135.78	2136.06	406.0
2010-07-14 02:00:00	NQ	Futures	2135.78	2135.78	2132.34	2132.91	1753.0
2010-07-14 03:00:00	NQ	Futures	2133.2	2134.06	2130.33	2133.2	1758.0
2010-07-14 04:00:00	NQ	Futures	2133.2	2134.63	2131.48	2132.62	1055.0
2010-07-14 05:00:00	NQ	Futures	2132.62	2132.91	2127.75	2127.75	2041.0
2010-07-14 06:00:00	NQ	Futures	2127.75	2131.19	2127.47	2129.76	1623.0
2010-07-14 07:00:00	NQ	Futures	2130.05	2130.33	2125.17	2128.33	3165.0
2010-07-14 08:00:00	NQ	Futures	2128.33	2128.61	2117.44	2117.72	12950.0
2010-07-14 09:00:00	NQ	Futures	2117.72	2122.88	2113.14	2114.86	49913.0
2010-07-14 10:00:00	NQ	Futures	2114.86	2124.6	2109.7	2120.3	52424.0
2010-07-14 11:00:00	NQ	Futures	2120.3	2134.34	2117.72	2131.48	46177.0
2010-07-14 12:00:00	NQ	Futures	2131.76	2132.62	2126.89	2127.47	20325.0
2010-07-14 13:00:00	NQ	Futures	2127.47	2128.33	2115.14	2118.01	28850.0
2010-07-14 14:00:00	NQ	Futures	2117.72	2119.44	2106.83	2118.87	49594.0
2010-07-14 15:00:00	NQ	Futures	2118.87	2124.03	2112.28	2122.02	42744.0
2010-07-14 16:00:00	NQ	Futures	2122.02	2124.6	2120.88	2122.31	7495.0
2010-07-14 17:00:00	NQ	Futures	2122.31	2124.31	2122.31	2124.31	58.0
2010-07-14 18:00:00	NQ	Futures	2124.31	2126.03	2122.59	2123.45	348.0
2010-07-14 19:00:00	NQ	Futures	2123.45	2123.74	2122.02	2122.31	102.0
2010-07-14 20:00:00	NQ	Futures	2122.31	2122.31	2116.86	2118.3	516.0
2010-07-14 21:00:00	NQ	Futures	2118.87	2119.44	2116.86	2119.16	317.0
2010-07-14 22:00:00	NQ	Futures	2119.16	2137.21	2117.72	2128.61	1766.0
2010-07-14 23:00:00	NQ	Futures	2128.61	2129.47	2125.75	2128.04	478.0
2010-07-14 00:00:00	YM	Futures	9798.3	9799.3	9793.6	9798.3	152.0
2010-07-14 01:00:00	YM	Futures	9797.4	9802.1	9793.6	9793.6	189.0

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

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