PREVIEW / futures_1hour / 2010-07-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1055.87	1057.09	1054.64	1054.89	4185.0
2010-07-13 01:00:00	ES	Futures	1054.89	1055.38	1053.91	1054.64	4243.0
2010-07-13 02:00:00	ES	Futures	1054.64	1055.13	1053.17	1054.4	10007.0
2010-07-13 03:00:00	ES	Futures	1054.4	1057.83	1053.41	1055.13	43372.0
2010-07-13 04:00:00	ES	Futures	1055.38	1061.76	1054.4	1060.78	38136.0
2010-07-13 05:00:00	ES	Futures	1060.78	1064.21	1059.79	1063.72	33573.0
2010-07-13 06:00:00	ES	Futures	1063.72	1063.97	1062.49	1062.98	18184.0
2010-07-13 07:00:00	ES	Futures	1062.98	1065.44	1062.25	1064.7	32181.0
2010-07-13 08:00:00	ES	Futures	1064.7	1066.66	1064.46	1065.93	47966.0
2010-07-13 09:00:00	ES	Futures	1066.17	1068.63	1064.21	1066.66	290109.0
2010-07-13 10:00:00	ES	Futures	1066.66	1070.84	1065.93	1067.16	316970.0
2010-07-13 11:00:00	ES	Futures	1067.16	1073.78	1066.91	1070.59	248424.0
2010-07-13 12:00:00	ES	Futures	1070.59	1073.04	1070.35	1070.59	115732.0
2010-07-13 13:00:00	ES	Futures	1070.84	1072.55	1067.65	1068.38	157620.0
2010-07-13 14:00:00	ES	Futures	1068.63	1072.31	1068.38	1072.31	155194.0
2010-07-13 15:00:00	ES	Futures	1072.31	1075.74	1070.59	1071.33	331478.0
2010-07-13 16:00:00	ES	Futures	1071.33	1077.95	1069.12	1076.73	152907.0
2010-07-13 17:00:00	ES	Futures	1076.73	1078.69	1076.48	1077.46	7293.0
2010-07-13 18:00:00	ES	Futures	1077.71	1078.44	1076.73	1076.97	6828.0
2010-07-13 19:00:00	ES	Futures	1076.97	1077.71	1076.73	1077.46	2115.0
2010-07-13 20:00:00	ES	Futures	1077.71	1078.2	1076.97	1077.46	5248.0
2010-07-13 21:00:00	ES	Futures	1077.46	1077.71	1076.97	1077.22	2629.0
2010-07-13 22:00:00	ES	Futures	1077.22	1077.71	1076.73	1077.46	1468.0
2010-07-13 23:00:00	ES	Futures	1077.46	1077.95	1076.73	1077.46	2360.0
2010-07-13 00:00:00	NQ	Futures	2087.06	2089.35	2085.63	2086.2	266.0
2010-07-13 01:00:00	NQ	Futures	2086.2	2087.06	2084.48	2085.34	362.0
2010-07-13 02:00:00	NQ	Futures	2085.34	2086.77	2083.91	2085.05	839.0
2010-07-13 03:00:00	NQ	Futures	2085.05	2091.93	2084.19	2087.92	2881.0
2010-07-13 04:00:00	NQ	Futures	2087.63	2099.67	2086.77	2097.95	2420.0
2010-07-13 05:00:00	NQ	Futures	2097.95	2104.54	2096.52	2103.97	2182.0
2010-07-13 06:00:00	NQ	Futures	2103.97	2104.25	2101.1	2102.25	1186.0
2010-07-13 07:00:00	NQ	Futures	2102.25	2104.83	2100.82	2102.53	2207.0
2010-07-13 08:00:00	NQ	Futures	2102.82	2107.12	2102.53	2105.4	5058.0
2010-07-13 09:00:00	NQ	Futures	2105.4	2108.55	2086.77	2094.8	63929.0
2010-07-13 10:00:00	NQ	Futures	2095.08	2103.11	2090.21	2093.94	52405.0
2010-07-13 11:00:00	NQ	Futures	2094.22	2113.42	2093.65	2105.97	43217.0
2010-07-13 12:00:00	NQ	Futures	2105.97	2110.85	2104.25	2105.69	23060.0
2010-07-13 13:00:00	NQ	Futures	2105.69	2109.13	2098.81	2101.68	23603.0
2010-07-13 14:00:00	NQ	Futures	2101.39	2114.57	2101.39	2114.28	22466.0
2010-07-13 15:00:00	NQ	Futures	2114.28	2120.02	2110.85	2111.71	46606.0
2010-07-13 16:00:00	NQ	Futures	2111.71	2134.34	2107.98	2128.9	20864.0
2010-07-13 17:00:00	NQ	Futures	2128.61	2134.92	2128.04	2134.34	3219.0
2010-07-13 18:00:00	NQ	Futures	2134.92	2137.78	2134.92	2136.06	1966.0
2010-07-13 19:00:00	NQ	Futures	2136.06	2136.35	2134.92	2136.06	390.0
2010-07-13 20:00:00	NQ	Futures	2136.06	2137.21	2135.49	2136.35	689.0
2010-07-13 21:00:00	NQ	Futures	2136.35	2137.78	2135.49	2136.35	518.0
2010-07-13 22:00:00	NQ	Futures	2136.06	2137.78	2135.49	2137.5	419.0
2010-07-13 23:00:00	NQ	Futures	2137.5	2137.78	2135.49	2136.92	461.0
2010-07-13 00:00:00	YM	Futures	9622.3	9635.5	9621.3	9623.2	331.0
2010-07-13 01:00:00	YM	Futures	9624.1	9627.9	9617.5	9625.1	408.0

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

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