PREVIEW / futures_1hour / 2010-07-15

all futures 1-hour files

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

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-15 00:00:00	ES	Futures	1074.03	1074.27	1071.82	1072.31	3346.0
2010-07-15 01:00:00	ES	Futures	1072.31	1073.04	1071.33	1071.82	3146.0
2010-07-15 02:00:00	ES	Futures	1071.57	1072.31	1069.12	1069.36	12570.0
2010-07-15 03:00:00	ES	Futures	1069.36	1070.59	1066.91	1069.12	31159.0
2010-07-15 04:00:00	ES	Futures	1068.87	1072.8	1067.4	1071.57	21138.0
2010-07-15 05:00:00	ES	Futures	1071.82	1072.06	1069.85	1071.08	11199.0
2010-07-15 06:00:00	ES	Futures	1071.08	1075.74	1070.84	1075.01	46120.0
2010-07-15 07:00:00	ES	Futures	1075.25	1075.5	1073.29	1074.52	31127.0
2010-07-15 08:00:00	ES	Futures	1074.52	1078.93	1071.33	1071.82	125771.0
2010-07-15 09:00:00	ES	Futures	1072.06	1074.03	1066.66	1068.87	250004.0
2010-07-15 10:00:00	ES	Futures	1068.87	1068.87	1056.36	1060.78	499279.0
2010-07-15 11:00:00	ES	Futures	1061.02	1063.23	1058.81	1061.27	188906.0
2010-07-15 12:00:00	ES	Futures	1061.27	1062.0	1059.3	1061.27	90693.0
2010-07-15 13:00:00	ES	Futures	1061.27	1067.16	1061.02	1065.44	158020.0
2010-07-15 14:00:00	ES	Futures	1065.19	1068.38	1063.72	1065.93	193553.0
2010-07-15 15:00:00	ES	Futures	1066.17	1075.25	1061.27	1071.57	557094.0
2010-07-15 16:00:00	ES	Futures	1071.82	1074.27	1069.61	1072.55	155642.0
2010-07-15 17:00:00	ES	Futures	1072.8	1073.78	1072.55	1073.54	3933.0
2010-07-15 18:00:00	ES	Futures	1073.54	1074.27	1073.04	1073.78	3951.0
2010-07-15 19:00:00	ES	Futures	1073.54	1074.03	1073.04	1073.54	2245.0
2010-07-15 20:00:00	ES	Futures	1073.54	1074.03	1072.55	1073.29	3730.0
2010-07-15 21:00:00	ES	Futures	1073.29	1073.29	1070.1	1070.84	6836.0
2010-07-15 22:00:00	ES	Futures	1070.59	1072.31	1070.1	1070.59	3321.0
2010-07-15 23:00:00	ES	Futures	1070.84	1070.84	1067.89	1069.36	4980.0
2010-07-15 00:00:00	NQ	Futures	2128.04	2128.04	2125.17	2126.03	282.0
2010-07-15 01:00:00	NQ	Futures	2126.03	2127.18	2124.6	2125.17	264.0
2010-07-15 02:00:00	NQ	Futures	2124.89	2125.46	2120.88	2121.16	1032.0
2010-07-15 03:00:00	NQ	Futures	2121.16	2122.88	2117.44	2120.88	2853.0
2010-07-15 04:00:00	NQ	Futures	2121.16	2128.33	2118.3	2126.32	1814.0
2010-07-15 05:00:00	NQ	Futures	2126.61	2126.89	2123.17	2125.46	1173.0
2010-07-15 06:00:00	NQ	Futures	2125.17	2133.2	2124.89	2132.05	4772.0
2010-07-15 07:00:00	NQ	Futures	2132.05	2133.2	2129.19	2129.47	3371.0
2010-07-15 08:00:00	NQ	Futures	2129.76	2136.92	2122.88	2123.45	12089.0
2010-07-15 09:00:00	NQ	Futures	2123.45	2127.18	2111.99	2119.44	50491.0
2010-07-15 10:00:00	NQ	Futures	2120.02	2120.3	2095.94	2104.54	69888.0
2010-07-15 11:00:00	NQ	Futures	2104.54	2111.71	2099.67	2107.41	34888.0
2010-07-15 12:00:00	NQ	Futures	2107.41	2110.27	2101.68	2106.26	19835.0
2010-07-15 13:00:00	NQ	Futures	2106.26	2117.15	2106.26	2112.56	24782.0
2010-07-15 14:00:00	NQ	Futures	2112.28	2120.3	2109.7	2115.14	32876.0
2010-07-15 15:00:00	NQ	Futures	2115.14	2130.62	2106.26	2124.31	79699.0
2010-07-15 16:00:00	NQ	Futures	2124.31	2127.75	2115.14	2123.17	24237.0
2010-07-15 17:00:00	NQ	Futures	2122.88	2126.03	2122.88	2125.75	821.0
2010-07-15 18:00:00	NQ	Futures	2125.46	2127.47	2125.46	2126.89	322.0
2010-07-15 19:00:00	NQ	Futures	2126.89	2127.18	2125.46	2125.46	178.0
2010-07-15 20:00:00	NQ	Futures	2125.75	2126.32	2124.6	2125.75	334.0
2010-07-15 21:00:00	NQ	Futures	2125.46	2125.75	2120.88	2122.31	571.0
2010-07-15 22:00:00	NQ	Futures	2122.02	2124.6	2120.59	2122.02	293.0
2010-07-15 23:00:00	NQ	Futures	2121.73	2122.02	2118.3	2120.02	317.0
2010-07-15 00:00:00	YM	Futures	9780.3	9780.3	9763.3	9766.1	268.0
2010-07-15 01:00:00	YM	Futures	9766.1	9771.8	9757.6	9760.5	301.0

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

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