PREVIEW / futures_1hour / 2010-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-17.parquet
  size:    45 KB
  rows:    1,362

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-08-17 00:00:00	ES	Futures	1060.28	1061.02	1059.55	1060.53	2219.0
2010-08-17 01:00:00	ES	Futures	1060.53	1061.51	1059.79	1060.04	4645.0
2010-08-17 02:00:00	ES	Futures	1060.28	1061.51	1058.57	1059.3	9042.0
2010-08-17 03:00:00	ES	Futures	1059.06	1062.74	1058.32	1061.27	25297.0
2010-08-17 04:00:00	ES	Futures	1061.27	1064.7	1061.02	1064.7	23401.0
2010-08-17 05:00:00	ES	Futures	1064.21	1064.7	1062.0	1063.72	20148.0
2010-08-17 06:00:00	ES	Futures	1063.97	1065.68	1063.23	1064.46	22446.0
2010-08-17 07:00:00	ES	Futures	1064.46	1064.95	1063.23	1063.72	19260.0
2010-08-17 08:00:00	ES	Futures	1063.72	1066.91	1062.25	1064.95	62073.0
2010-08-17 09:00:00	ES	Futures	1064.95	1067.4	1063.23	1065.44	253024.0
2010-08-17 10:00:00	ES	Futures	1065.19	1069.36	1063.47	1068.63	280543.0
2010-08-17 11:00:00	ES	Futures	1068.63	1075.25	1068.63	1074.76	284489.0
2010-08-17 12:00:00	ES	Futures	1074.52	1074.76	1072.8	1073.29	85318.0
2010-08-17 13:00:00	ES	Futures	1073.54	1078.2	1073.29	1076.23	182466.0
2010-08-17 14:00:00	ES	Futures	1076.48	1077.22	1075.25	1075.74	82867.0
2010-08-17 15:00:00	ES	Futures	1075.74	1075.74	1069.85	1070.59	286078.0
2010-08-17 16:00:00	ES	Futures	1070.59	1070.84	1068.38	1069.61	104744.0
2010-08-17 17:00:00	ES	Futures	1069.61	1069.61	1068.63	1068.87	1050.0
2010-08-17 18:00:00	ES	Futures	1068.87	1070.35	1068.63	1069.36	3501.0
2010-08-17 19:00:00	ES	Futures	1069.61	1069.85	1068.87	1069.61	2379.0
2010-08-17 20:00:00	ES	Futures	1069.61	1070.35	1067.89	1067.89	7706.0
2010-08-17 21:00:00	ES	Futures	1067.89	1068.87	1067.4	1068.87	5887.0
2010-08-17 22:00:00	ES	Futures	1068.63	1069.12	1066.91	1067.65	3084.0
2010-08-17 23:00:00	ES	Futures	1067.4	1067.89	1066.42	1067.16	2870.0
2010-08-17 00:00:00	NQ	Futures	2093.08	2093.94	2091.07	2093.08	212.0
2010-08-17 01:00:00	NQ	Futures	2093.65	2095.08	2092.51	2093.36	341.0
2010-08-17 02:00:00	NQ	Futures	2093.36	2095.37	2090.21	2091.65	664.0
2010-08-17 03:00:00	NQ	Futures	2091.65	2097.38	2089.07	2094.51	1693.0
2010-08-17 04:00:00	NQ	Futures	2094.8	2100.24	2094.51	2099.96	1496.0
2010-08-17 05:00:00	NQ	Futures	2099.67	2099.96	2095.66	2097.38	2126.0
2010-08-17 06:00:00	NQ	Futures	2097.38	2100.82	2096.8	2098.24	1922.0
2010-08-17 07:00:00	NQ	Futures	2097.95	2098.81	2095.94	2096.8	1269.0
2010-08-17 08:00:00	NQ	Futures	2096.8	2102.53	2093.36	2099.1	5342.0
2010-08-17 09:00:00	NQ	Futures	2099.1	2107.98	2097.66	2105.11	44992.0
2010-08-17 10:00:00	NQ	Futures	2104.83	2113.14	2101.96	2111.99	41365.0
2010-08-17 11:00:00	NQ	Futures	2112.28	2126.03	2111.71	2124.89	49695.0
2010-08-17 12:00:00	NQ	Futures	2124.6	2125.46	2121.45	2123.45	19608.0
2010-08-17 13:00:00	NQ	Futures	2123.74	2132.62	2123.74	2127.18	29658.0
2010-08-17 14:00:00	NQ	Futures	2127.18	2129.76	2123.45	2124.6	17960.0
2010-08-17 15:00:00	NQ	Futures	2124.31	2124.89	2112.85	2114.0	40365.0
2010-08-17 16:00:00	NQ	Futures	2114.0	2114.86	2107.98	2111.13	10901.0
2010-08-17 17:00:00	NQ	Futures	2111.13	2111.42	2109.13	2109.41	143.0
2010-08-17 18:00:00	NQ	Futures	2109.99	2111.42	2107.98	2110.85	331.0
2010-08-17 19:00:00	NQ	Futures	2110.56	2110.85	2109.41	2110.27	123.0
2010-08-17 20:00:00	NQ	Futures	2109.7	2111.42	2106.83	2107.41	511.0
2010-08-17 21:00:00	NQ	Futures	2107.41	2109.7	2106.26	2109.7	309.0
2010-08-17 22:00:00	NQ	Futures	2109.41	2110.27	2106.26	2107.12	277.0
2010-08-17 23:00:00	NQ	Futures	2106.83	2107.98	2104.83	2105.69	341.0
2010-08-17 00:00:00	YM	Futures	9747.2	9751.9	9741.5	9748.2	239.0
2010-08-17 01:00:00	YM	Futures	9749.1	9752.9	9742.5	9744.4	396.0

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

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