PREVIEW / futures_1hour / 2010-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-24.parquet
  size:    45 KB
  rows:    1,347

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-24 00:00:00	ES	Futures	1069.61	1069.85	1068.38	1069.36	3003.0
2010-06-24 01:00:00	ES	Futures	1069.12	1070.35	1067.4	1067.4	8274.0
2010-06-24 02:00:00	ES	Futures	1067.89	1070.84	1067.65	1068.38	8124.0
2010-06-24 03:00:00	ES	Futures	1068.14	1068.63	1060.78	1061.76	49601.0
2010-06-24 04:00:00	ES	Futures	1061.76	1062.49	1057.09	1059.06	53433.0
2010-06-24 05:00:00	ES	Futures	1058.81	1061.02	1058.08	1060.04	17327.0
2010-06-24 06:00:00	ES	Futures	1059.79	1062.0	1059.79	1060.53	10807.0
2010-06-24 07:00:00	ES	Futures	1060.78	1062.25	1058.08	1059.3	36535.0
2010-06-24 08:00:00	ES	Futures	1059.3	1063.97	1057.34	1061.51	109684.0
2010-06-24 09:00:00	ES	Futures	1061.51	1063.72	1054.15	1055.62	294487.0
2010-06-24 10:00:00	ES	Futures	1055.38	1061.27	1052.68	1055.38	392553.0
2010-06-24 11:00:00	ES	Futures	1055.38	1055.62	1049.73	1054.89	337157.0
2010-06-24 12:00:00	ES	Futures	1054.89	1058.08	1052.19	1055.62	167458.0
2010-06-24 13:00:00	ES	Futures	1055.62	1061.76	1053.91	1061.02	186784.0
2010-06-24 14:00:00	ES	Futures	1061.02	1061.27	1051.21	1052.43	214422.0
2010-06-24 15:00:00	ES	Futures	1052.68	1054.4	1046.79	1049.98	527262.0
2010-06-24 16:00:00	ES	Futures	1049.73	1053.66	1049.49	1053.41	113172.0
2010-06-24 17:00:00	ES	Futures	1053.17	1053.66	1052.68	1052.92	1594.0
2010-06-24 18:00:00	ES	Futures	1053.17	1053.66	1051.94	1052.43	4215.0
2010-06-24 19:00:00	ES	Futures	1052.19	1053.17	1051.94	1053.17	3657.0
2010-06-24 20:00:00	ES	Futures	1053.17	1053.66	1050.96	1050.96	8214.0
2010-06-24 21:00:00	ES	Futures	1051.21	1054.89	1050.72	1054.64	8068.0
2010-06-24 22:00:00	ES	Futures	1054.4	1055.13	1053.41	1053.66	6165.0
2010-06-24 23:00:00	ES	Futures	1053.66	1053.91	1051.45	1052.19	2659.0
2010-06-24 00:00:00	NQ	Futures	2147.24	2148.67	2146.67	2146.95	357.0
2010-06-24 01:00:00	NQ	Futures	2146.95	2148.67	2144.66	2144.95	388.0
2010-06-24 02:00:00	NQ	Futures	2144.95	2149.53	2144.95	2145.81	1030.0
2010-06-24 03:00:00	NQ	Futures	2146.09	2146.67	2129.47	2131.48	4318.0
2010-06-24 04:00:00	NQ	Futures	2131.48	2133.48	2123.74	2126.32	4029.0
2010-06-24 05:00:00	NQ	Futures	2126.32	2131.19	2125.17	2129.19	1470.0
2010-06-24 06:00:00	NQ	Futures	2129.19	2132.91	2128.9	2130.62	1113.0
2010-06-24 07:00:00	NQ	Futures	2130.62	2132.91	2126.32	2128.33	2202.0
2010-06-24 08:00:00	NQ	Futures	2128.61	2138.07	2126.61	2134.34	9275.0
2010-06-24 09:00:00	NQ	Futures	2134.34	2143.51	2119.16	2121.73	47957.0
2010-06-24 10:00:00	NQ	Futures	2121.73	2135.78	2116.29	2122.88	56733.0
2010-06-24 11:00:00	NQ	Futures	2122.59	2126.32	2111.42	2123.17	44233.0
2010-06-24 12:00:00	NQ	Futures	2123.45	2129.76	2116.58	2123.17	24550.0
2010-06-24 13:00:00	NQ	Futures	2123.17	2140.93	2120.3	2139.5	30059.0
2010-06-24 14:00:00	NQ	Futures	2139.22	2139.79	2116.58	2119.44	29587.0
2010-06-24 15:00:00	NQ	Futures	2119.44	2123.17	2105.97	2113.14	68348.0
2010-06-24 16:00:00	NQ	Futures	2113.14	2120.02	2110.85	2120.02	12109.0
2010-06-24 17:00:00	NQ	Futures	2119.44	2120.02	2118.58	2119.16	102.0
2010-06-24 18:00:00	NQ	Futures	2118.58	2120.3	2118.01	2118.01	187.0
2010-06-24 19:00:00	NQ	Futures	2118.01	2120.02	2117.72	2119.73	119.0
2010-06-24 20:00:00	NQ	Futures	2119.44	2120.3	2115.43	2116.0	524.0
2010-06-24 21:00:00	NQ	Futures	2115.72	2124.03	2115.43	2122.59	902.0
2010-06-24 22:00:00	NQ	Futures	2122.59	2124.03	2120.59	2121.45	470.0
2010-06-24 23:00:00	NQ	Futures	2121.45	2121.45	2114.86	2116.29	714.0
2010-06-24 00:00:00	YM	Futures	9708.4	9712.2	9703.7	9708.4	161.0
2010-06-24 01:00:00	YM	Futures	9710.3	9715.0	9698.0	9698.0	311.0

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

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