PREVIEW / futures_1hour / 2010-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-22.parquet
  size:    46 KB
  rows:    1,373

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-22 00:00:00	ES	Futures	1042.13	1043.6	1041.64	1042.37	3572.0
2010-07-22 01:00:00	ES	Futures	1042.37	1045.56	1042.13	1045.32	5740.0
2010-07-22 02:00:00	ES	Futures	1045.56	1046.54	1043.6	1046.54	11533.0
2010-07-22 03:00:00	ES	Futures	1046.3	1049.73	1045.32	1049.24	39556.0
2010-07-22 04:00:00	ES	Futures	1049.0	1055.38	1047.03	1054.89	57662.0
2010-07-22 05:00:00	ES	Futures	1054.64	1057.83	1053.91	1057.34	39971.0
2010-07-22 06:00:00	ES	Futures	1057.34	1059.06	1055.62	1057.34	30302.0
2010-07-22 07:00:00	ES	Futures	1057.59	1057.83	1055.87	1056.6	43912.0
2010-07-22 08:00:00	ES	Futures	1056.6	1058.81	1053.66	1058.57	87129.0
2010-07-22 09:00:00	ES	Futures	1058.57	1065.93	1057.59	1065.68	339426.0
2010-07-22 10:00:00	ES	Futures	1065.68	1073.29	1065.44	1071.08	452389.0
2010-07-22 11:00:00	ES	Futures	1071.33	1073.04	1067.16	1068.63	241911.0
2010-07-22 12:00:00	ES	Futures	1068.63	1070.59	1067.89	1070.35	122791.0
2010-07-22 13:00:00	ES	Futures	1070.35	1072.31	1069.12	1070.1	85278.0
2010-07-22 14:00:00	ES	Futures	1070.1	1074.27	1070.1	1072.55	123256.0
2010-07-22 15:00:00	ES	Futures	1072.55	1074.03	1065.44	1069.36	361435.0
2010-07-22 16:00:00	ES	Futures	1069.36	1069.85	1065.68	1066.66	107578.0
2010-07-22 17:00:00	ES	Futures	1066.42	1068.14	1066.42	1067.65	1530.0
2010-07-22 18:00:00	ES	Futures	1067.65	1068.87	1067.4	1068.87	2745.0
2010-07-22 19:00:00	ES	Futures	1068.63	1071.57	1067.89	1071.33	5739.0
2010-07-22 20:00:00	ES	Futures	1071.08	1071.33	1068.63	1069.85	6378.0
2010-07-22 21:00:00	ES	Futures	1069.61	1069.85	1068.38	1068.87	3538.0
2010-07-22 22:00:00	ES	Futures	1069.12	1069.12	1066.91	1068.87	3635.0
2010-07-22 23:00:00	ES	Futures	1068.87	1069.36	1067.89	1068.38	1369.0
2010-07-22 00:00:00	NQ	Futures	2079.32	2081.9	2078.18	2079.32	221.0
2010-07-22 01:00:00	NQ	Futures	2079.32	2084.77	2078.46	2084.48	456.0
2010-07-22 02:00:00	NQ	Futures	2084.77	2087.06	2081.33	2086.77	771.0
2010-07-22 03:00:00	NQ	Futures	2086.77	2093.94	2085.05	2093.36	1860.0
2010-07-22 04:00:00	NQ	Futures	2093.36	2104.83	2089.07	2103.68	3050.0
2010-07-22 05:00:00	NQ	Futures	2103.68	2107.41	2099.67	2106.55	3320.0
2010-07-22 06:00:00	NQ	Futures	2106.55	2106.55	2101.39	2103.39	2587.0
2010-07-22 07:00:00	NQ	Futures	2103.68	2105.97	2102.25	2103.11	3753.0
2010-07-22 08:00:00	NQ	Futures	2102.82	2106.26	2096.8	2105.97	9357.0
2010-07-22 09:00:00	NQ	Futures	2106.26	2120.59	2104.25	2119.44	58725.0
2010-07-22 10:00:00	NQ	Futures	2119.16	2142.65	2119.16	2137.78	79151.0
2010-07-22 11:00:00	NQ	Futures	2138.07	2140.65	2126.61	2129.76	40664.0
2010-07-22 12:00:00	NQ	Futures	2129.47	2133.77	2127.18	2132.05	28004.0
2010-07-22 13:00:00	NQ	Futures	2132.05	2136.35	2129.47	2130.62	16075.0
2010-07-22 14:00:00	NQ	Futures	2130.9	2139.5	2130.9	2137.5	22590.0
2010-07-22 15:00:00	NQ	Futures	2137.21	2141.79	2125.17	2132.05	59371.0
2010-07-22 16:00:00	NQ	Futures	2132.05	2133.2	2117.72	2119.16	15775.0
2010-07-22 17:00:00	NQ	Futures	2119.73	2122.59	2119.44	2121.73	208.0
2010-07-22 18:00:00	NQ	Futures	2121.16	2124.6	2120.3	2124.03	544.0
2010-07-22 19:00:00	NQ	Futures	2124.31	2130.62	2123.45	2128.9	386.0
2010-07-22 20:00:00	NQ	Futures	2128.61	2128.61	2124.03	2126.32	366.0
2010-07-22 21:00:00	NQ	Futures	2126.03	2126.32	2123.45	2124.6	224.0
2010-07-22 22:00:00	NQ	Futures	2124.6	2124.6	2120.88	2124.31	252.0
2010-07-22 23:00:00	NQ	Futures	2124.31	2124.89	2123.17	2123.45	155.0
2010-07-22 00:00:00	YM	Futures	9507.7	9514.3	9499.2	9503.9	204.0
2010-07-22 01:00:00	YM	Futures	9504.9	9525.7	9502.0	9525.7	319.0

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

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