PREVIEW / futures_1hour / 2010-09-07

all futures 1-hour files

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

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-07 00:00:00	ES	Futures	1085.31	1085.31	1082.86	1083.11	3438.0
2010-09-07 01:00:00	ES	Futures	1083.11	1083.6	1082.37	1083.11	3332.0
2010-09-07 02:00:00	ES	Futures	1083.35	1083.35	1079.67	1081.14	17821.0
2010-09-07 03:00:00	ES	Futures	1081.39	1081.39	1076.97	1078.44	43777.0
2010-09-07 04:00:00	ES	Futures	1078.44	1078.69	1075.01	1078.44	33748.0
2010-09-07 05:00:00	ES	Futures	1078.44	1078.69	1076.48	1077.22	14602.0
2010-09-07 06:00:00	ES	Futures	1076.97	1077.71	1075.25	1077.46	16500.0
2010-09-07 07:00:00	ES	Futures	1077.22	1078.44	1074.76	1077.71	29249.0
2010-09-07 08:00:00	ES	Futures	1077.95	1077.95	1075.74	1076.48	36163.0
2010-09-07 09:00:00	ES	Futures	1076.73	1079.18	1072.55	1072.8	243832.0
2010-09-07 10:00:00	ES	Futures	1072.8	1075.25	1071.57	1074.52	245434.0
2010-09-07 11:00:00	ES	Futures	1074.52	1075.99	1072.31	1075.74	186743.0
2010-09-07 12:00:00	ES	Futures	1075.5	1076.48	1072.8	1074.03	108212.0
2010-09-07 13:00:00	ES	Futures	1074.03	1075.74	1072.55	1075.5	105127.0
2010-09-07 14:00:00	ES	Futures	1075.5	1076.48	1070.35	1071.33	125198.0
2010-09-07 15:00:00	ES	Futures	1071.33	1073.54	1069.61	1071.08	207533.0
2010-09-07 16:00:00	ES	Futures	1071.08	1072.31	1070.35	1071.08	68389.0
2010-09-07 17:00:00	ES	Futures	1071.08	1071.57	1070.59	1071.33	850.0
2010-09-07 18:00:00	ES	Futures	1071.33	1071.57	1070.35	1070.84	1398.0
2010-09-07 19:00:00	ES	Futures	1070.84	1071.57	1070.84	1070.84	2162.0
2010-09-07 20:00:00	ES	Futures	1070.84	1072.8	1070.84	1072.31	4963.0
2010-09-07 21:00:00	ES	Futures	1072.31	1072.55	1069.61	1070.59	6630.0
2010-09-07 22:00:00	ES	Futures	1070.59	1070.84	1068.63	1068.87	4653.0
2010-09-07 23:00:00	ES	Futures	1069.12	1069.85	1068.38	1068.63	5184.0
2010-09-07 00:00:00	NQ	Futures	2144.95	2145.23	2141.22	2141.51	309.0
2010-09-07 01:00:00	NQ	Futures	2141.79	2142.37	2140.65	2141.79	107.0
2010-09-07 02:00:00	NQ	Futures	2141.79	2141.79	2136.64	2139.79	1087.0
2010-09-07 03:00:00	NQ	Futures	2139.79	2139.79	2134.06	2134.92	2681.0
2010-09-07 04:00:00	NQ	Futures	2134.92	2136.92	2130.9	2136.64	3025.0
2010-09-07 05:00:00	NQ	Futures	2136.35	2136.35	2132.91	2133.48	936.0
2010-09-07 06:00:00	NQ	Futures	2133.48	2133.48	2129.19	2132.91	1389.0
2010-09-07 07:00:00	NQ	Futures	2132.62	2134.06	2126.61	2131.76	2806.0
2010-09-07 08:00:00	NQ	Futures	2132.05	2133.2	2128.04	2132.05	4465.0
2010-09-07 09:00:00	NQ	Futures	2132.05	2144.09	2130.33	2130.33	45483.0
2010-09-07 10:00:00	NQ	Futures	2130.62	2135.49	2127.18	2134.63	45617.0
2010-09-07 11:00:00	NQ	Futures	2134.34	2136.64	2129.76	2135.49	30730.0
2010-09-07 12:00:00	NQ	Futures	2135.2	2136.92	2128.61	2131.19	21500.0
2010-09-07 13:00:00	NQ	Futures	2131.19	2135.49	2128.33	2135.49	21998.0
2010-09-07 14:00:00	NQ	Futures	2135.2	2137.5	2126.32	2127.75	22453.0
2010-09-07 15:00:00	NQ	Futures	2127.75	2132.05	2124.89	2128.9	42370.0
2010-09-07 16:00:00	NQ	Futures	2128.9	2131.48	2128.04	2130.05	7305.0
2010-09-07 17:00:00	NQ	Futures	2130.05	2131.19	2129.47	2130.9	158.0
2010-09-07 18:00:00	NQ	Futures	2130.33	2130.9	2129.19	2130.62	256.0
2010-09-07 19:00:00	NQ	Futures	2130.05	2130.9	2129.47	2129.47	132.0
2010-09-07 20:00:00	NQ	Futures	2130.33	2133.48	2130.05	2132.62	364.0
2010-09-07 21:00:00	NQ	Futures	2132.62	2132.62	2127.47	2129.19	380.0
2010-09-07 22:00:00	NQ	Futures	2129.76	2129.76	2125.75	2126.03	282.0
2010-09-07 23:00:00	NQ	Futures	2126.61	2128.04	2125.17	2125.75	337.0
2010-09-07 00:00:00	YM	Futures	9901.5	9901.5	9882.6	9883.5	226.0
2010-09-07 01:00:00	YM	Futures	9885.4	9886.4	9877.8	9879.7	211.0

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

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