PREVIEW / futures_1hour / 2010-09-08

all futures 1-hour files

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

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-09-08 00:00:00	ES	Futures	1068.63	1069.61	1068.14	1068.87	5674.0
2010-09-08 01:00:00	ES	Futures	1068.87	1070.35	1067.4	1070.1	7215.0
2010-09-08 02:00:00	ES	Futures	1070.1	1071.57	1069.36	1070.84	10688.0
2010-09-08 03:00:00	ES	Futures	1070.84	1073.54	1067.65	1069.36	41882.0
2010-09-08 04:00:00	ES	Futures	1069.36	1070.35	1067.65	1069.61	23213.0
2010-09-08 05:00:00	ES	Futures	1069.61	1070.1	1066.17	1068.14	19008.0
2010-09-08 06:00:00	ES	Futures	1068.14	1074.52	1067.4	1073.78	40014.0
2010-09-08 07:00:00	ES	Futures	1073.78	1075.99	1072.8	1073.78	36844.0
2010-09-08 08:00:00	ES	Futures	1074.03	1076.48	1072.8	1073.78	81309.0
2010-09-08 09:00:00	ES	Futures	1073.78	1077.71	1071.82	1076.97	256776.0
2010-09-08 10:00:00	ES	Futures	1076.97	1080.9	1076.73	1079.18	287752.0
2010-09-08 11:00:00	ES	Futures	1079.42	1081.63	1078.93	1079.67	150502.0
2010-09-08 12:00:00	ES	Futures	1079.92	1082.61	1079.42	1081.39	104532.0
2010-09-08 13:00:00	ES	Futures	1081.63	1081.88	1076.23	1077.46	141405.0
2010-09-08 14:00:00	ES	Futures	1077.71	1080.65	1075.01	1079.18	187290.0
2010-09-08 15:00:00	ES	Futures	1079.18	1081.39	1076.23	1077.95	212817.0
2010-09-08 16:00:00	ES	Futures	1077.95	1079.67	1077.46	1079.42	76890.0
2010-09-08 17:00:00	ES	Futures	1079.18	1081.39	1078.93	1080.9	2422.0
2010-09-08 18:00:00	ES	Futures	1080.65	1080.65	1079.67	1079.92	1367.0
2010-09-08 19:00:00	ES	Futures	1079.92	1080.9	1079.67	1080.65	1116.0
2010-09-08 20:00:00	ES	Futures	1080.65	1082.37	1079.67	1079.67	5737.0
2010-09-08 21:00:00	ES	Futures	1079.67	1080.16	1077.95	1077.95	7623.0
2010-09-08 22:00:00	ES	Futures	1078.2	1078.93	1077.71	1078.69	2840.0
2010-09-08 23:00:00	ES	Futures	1078.69	1079.18	1076.97	1076.97	4198.0
2010-09-08 00:00:00	NQ	Futures	2126.03	2127.47	2124.89	2126.32	272.0
2010-09-08 01:00:00	NQ	Futures	2126.32	2128.9	2124.03	2128.61	385.0
2010-09-08 02:00:00	NQ	Futures	2128.04	2130.9	2126.61	2129.19	667.0
2010-09-08 03:00:00	NQ	Futures	2129.76	2134.63	2124.6	2127.75	4552.0
2010-09-08 04:00:00	NQ	Futures	2128.04	2129.47	2124.6	2128.9	2469.0
2010-09-08 05:00:00	NQ	Futures	2129.19	2129.76	2123.17	2127.18	2471.0
2010-09-08 06:00:00	NQ	Futures	2127.18	2138.64	2125.75	2136.35	2687.0
2010-09-08 07:00:00	NQ	Futures	2136.64	2141.22	2135.78	2137.21	2217.0
2010-09-08 08:00:00	NQ	Futures	2136.92	2142.37	2134.92	2136.92	6833.0
2010-09-08 09:00:00	NQ	Futures	2136.92	2146.67	2134.06	2144.66	44136.0
2010-09-08 10:00:00	NQ	Futures	2144.95	2154.12	2144.09	2150.68	51922.0
2010-09-08 11:00:00	NQ	Futures	2150.39	2156.98	2150.39	2154.12	33740.0
2010-09-08 12:00:00	NQ	Futures	2153.83	2164.15	2153.54	2161.28	27396.0
2010-09-08 13:00:00	NQ	Futures	2161.28	2161.57	2151.82	2154.12	26160.0
2010-09-08 14:00:00	NQ	Futures	2153.83	2159.28	2149.25	2155.84	33245.0
2010-09-08 15:00:00	NQ	Futures	2155.84	2160.99	2151.25	2154.69	42441.0
2010-09-08 16:00:00	NQ	Futures	2154.69	2155.55	2152.68	2153.83	10213.0
2010-09-08 17:00:00	NQ	Futures	2154.12	2158.7	2153.83	2157.84	183.0
2010-09-08 18:00:00	NQ	Futures	2156.98	2157.27	2154.98	2156.41	106.0
2010-09-08 19:00:00	NQ	Futures	2156.12	2157.84	2155.55	2157.56	115.0
2010-09-08 20:00:00	NQ	Futures	2157.27	2160.13	2155.55	2155.55	339.0
2010-09-08 21:00:00	NQ	Futures	2155.55	2155.55	2151.25	2151.54	714.0
2010-09-08 22:00:00	NQ	Futures	2151.54	2153.83	2150.96	2153.26	222.0
2010-09-08 23:00:00	NQ	Futures	2152.97	2153.54	2149.82	2149.82	411.0
2010-09-08 00:00:00	YM	Futures	9762.4	9772.8	9761.4	9769.0	180.0
2010-09-08 01:00:00	YM	Futures	9767.1	9778.4	9754.8	9777.5	354.0

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

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