PREVIEW / futures_1hour / 2010-08-11

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-11.parquet
  size:    47 KB
  rows:    1,373

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-11 00:00:00	ES	Futures	1092.43	1092.67	1091.45	1091.45	3829.0
2010-08-11 01:00:00	ES	Futures	1091.69	1091.69	1089.73	1090.47	9708.0
2010-08-11 02:00:00	ES	Futures	1090.71	1090.71	1086.79	1088.75	23256.0
2010-08-11 03:00:00	ES	Futures	1088.75	1088.99	1085.8	1088.26	42778.0
2010-08-11 04:00:00	ES	Futures	1088.5	1088.75	1086.05	1087.77	19063.0
2010-08-11 05:00:00	ES	Futures	1087.77	1088.75	1083.35	1083.84	31788.0
2010-08-11 06:00:00	ES	Futures	1083.84	1084.09	1080.9	1083.84	41301.0
2010-08-11 07:00:00	ES	Futures	1083.6	1084.58	1082.37	1083.6	36066.0
2010-08-11 08:00:00	ES	Futures	1083.35	1084.33	1080.9	1081.88	71454.0
2010-08-11 09:00:00	ES	Futures	1081.88	1082.12	1073.54	1075.99	414022.0
2010-08-11 10:00:00	ES	Futures	1075.74	1077.46	1071.82	1071.82	395177.0
2010-08-11 11:00:00	ES	Futures	1071.82	1072.55	1068.14	1070.59	377413.0
2010-08-11 12:00:00	ES	Futures	1070.59	1070.84	1066.66	1067.16	170887.0
2010-08-11 13:00:00	ES	Futures	1067.16	1070.59	1067.16	1068.63	143449.0
2010-08-11 14:00:00	ES	Futures	1068.38	1071.57	1065.68	1067.4	224682.0
2010-08-11 15:00:00	ES	Futures	1067.16	1070.35	1065.93	1067.4	414375.0
2010-08-11 16:00:00	ES	Futures	1067.65	1068.14	1061.27	1061.51	178326.0
2010-08-11 17:00:00	ES	Futures	1061.51	1061.76	1053.41	1055.87	27741.0
2010-08-11 18:00:00	ES	Futures	1056.85	1058.08	1056.11	1057.83	7739.0
2010-08-11 19:00:00	ES	Futures	1057.59	1059.3	1057.09	1059.06	9809.0
2010-08-11 20:00:00	ES	Futures	1058.81	1062.25	1058.81	1061.76	15187.0
2010-08-11 21:00:00	ES	Futures	1061.76	1062.74	1058.81	1060.53	10458.0
2010-08-11 22:00:00	ES	Futures	1060.78	1062.98	1060.04	1060.04	7382.0
2010-08-11 23:00:00	ES	Futures	1060.28	1061.02	1058.08	1060.53	6484.0
2010-08-11 00:00:00	NQ	Futures	2161.85	2161.85	2159.28	2159.28	334.0
2010-08-11 01:00:00	NQ	Futures	2159.56	2159.56	2156.7	2158.42	420.0
2010-08-11 02:00:00	NQ	Futures	2158.13	2158.42	2150.68	2154.12	1672.0
2010-08-11 03:00:00	NQ	Futures	2154.4	2154.69	2146.09	2151.25	4351.0
2010-08-11 04:00:00	NQ	Futures	2151.82	2152.4	2146.67	2150.39	1221.0
2010-08-11 05:00:00	NQ	Futures	2150.68	2152.11	2142.37	2142.94	1822.0
2010-08-11 06:00:00	NQ	Futures	2142.37	2143.23	2136.92	2142.94	2881.0
2010-08-11 07:00:00	NQ	Futures	2142.65	2144.09	2140.65	2142.65	2194.0
2010-08-11 08:00:00	NQ	Futures	2142.37	2144.66	2139.5	2140.65	8935.0
2010-08-11 09:00:00	NQ	Futures	2140.65	2140.65	2117.44	2124.31	91967.0
2010-08-11 10:00:00	NQ	Futures	2124.31	2127.47	2112.56	2113.71	63114.0
2010-08-11 11:00:00	NQ	Futures	2114.0	2116.29	2107.41	2113.42	53397.0
2010-08-11 12:00:00	NQ	Futures	2113.14	2115.14	2105.69	2107.41	31407.0
2010-08-11 13:00:00	NQ	Futures	2107.69	2115.43	2107.41	2112.28	24126.0
2010-08-11 14:00:00	NQ	Futures	2112.28	2119.44	2109.7	2112.85	36176.0
2010-08-11 15:00:00	NQ	Futures	2112.85	2119.44	2110.85	2114.57	64146.0
2010-08-11 16:00:00	NQ	Futures	2114.57	2115.72	2089.07	2092.51	20051.0
2010-08-11 17:00:00	NQ	Futures	2092.22	2092.51	2077.89	2081.33	3815.0
2010-08-11 18:00:00	NQ	Futures	2083.05	2087.06	2082.48	2085.63	552.0
2010-08-11 19:00:00	NQ	Futures	2085.63	2089.93	2085.05	2089.64	936.0
2010-08-11 20:00:00	NQ	Futures	2089.93	2095.94	2089.64	2095.08	1251.0
2010-08-11 21:00:00	NQ	Futures	2095.08	2095.94	2089.35	2091.93	1127.0
2010-08-11 22:00:00	NQ	Futures	2092.22	2095.94	2091.07	2091.65	477.0
2010-08-11 23:00:00	NQ	Futures	2091.36	2092.79	2087.63	2091.36	433.0
2010-08-11 00:00:00	YM	Futures	10002.8	10002.8	9986.7	9993.3	402.0
2010-08-11 01:00:00	YM	Futures	9989.5	9994.3	9977.2	9985.8	416.0

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

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