PREVIEW / futures_1hour / 2010-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-16.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-06-16 00:00:00	ES	Futures	1087.52	1087.77	1085.8	1086.3	3213.0
2010-06-16 01:00:00	ES	Futures	1086.3	1086.54	1085.31	1085.56	6504.0
2010-06-16 02:00:00	ES	Futures	1085.56	1088.01	1085.31	1086.79	8112.0
2010-06-16 03:00:00	ES	Futures	1086.79	1086.79	1083.35	1084.33	37163.0
2010-06-16 04:00:00	ES	Futures	1084.58	1085.31	1083.11	1085.07	30456.0
2010-06-16 05:00:00	ES	Futures	1085.07	1085.56	1082.37	1085.31	23580.0
2010-06-16 06:00:00	ES	Futures	1085.31	1086.3	1084.09	1084.33	14693.0
2010-06-16 07:00:00	ES	Futures	1084.58	1085.31	1081.63	1082.86	52781.0
2010-06-16 08:00:00	ES	Futures	1083.11	1083.11	1079.67	1082.12	121423.0
2010-06-16 09:00:00	ES	Futures	1082.12	1087.52	1081.63	1087.52	295084.0
2010-06-16 10:00:00	ES	Futures	1087.52	1088.5	1082.12	1086.3	357096.0
2010-06-16 11:00:00	ES	Futures	1086.3	1090.22	1085.31	1088.99	258313.0
2010-06-16 12:00:00	ES	Futures	1088.99	1092.92	1088.26	1089.49	185404.0
2010-06-16 13:00:00	ES	Futures	1089.49	1092.43	1088.01	1092.18	119580.0
2010-06-16 14:00:00	ES	Futures	1092.43	1094.15	1089.73	1091.69	199425.0
2010-06-16 15:00:00	ES	Futures	1091.45	1091.69	1085.07	1089.24	327315.0
2010-06-16 16:00:00	ES	Futures	1089.24	1090.96	1087.52	1088.01	87456.0
2010-06-16 17:00:00	ES	Futures	1088.01	1088.01	1086.54	1087.28	4141.0
2010-06-16 18:00:00	ES	Futures	1087.28	1087.28	1086.3	1086.79	3986.0
2010-06-16 19:00:00	ES	Futures	1086.79	1086.79	1085.8	1086.05	1796.0
2010-06-16 20:00:00	ES	Futures	1086.05	1087.52	1085.56	1086.79	5414.0
2010-06-16 21:00:00	ES	Futures	1086.79	1087.52	1084.82	1085.56	6699.0
2010-06-16 22:00:00	ES	Futures	1085.31	1085.8	1085.07	1085.56	2741.0
2010-06-16 23:00:00	ES	Futures	1085.31	1085.56	1084.09	1084.33	2726.0
2010-06-16 00:00:00	NQ	Futures	2167.01	2167.3	2164.72	2165.87	185.0
2010-06-16 01:00:00	NQ	Futures	2165.29	2166.15	2164.15	2164.43	334.0
2010-06-16 02:00:00	NQ	Futures	2164.72	2168.73	2164.43	2166.73	616.0
2010-06-16 03:00:00	NQ	Futures	2166.73	2166.73	2159.28	2161.57	2495.0
2010-06-16 04:00:00	NQ	Futures	2161.57	2163.0	2158.7	2162.71	2280.0
2010-06-16 05:00:00	NQ	Futures	2162.71	2165.01	2158.13	2165.01	1497.0
2010-06-16 06:00:00	NQ	Futures	2165.01	2166.73	2163.0	2163.86	1133.0
2010-06-16 07:00:00	NQ	Futures	2164.15	2165.01	2158.7	2161.28	2925.0
2010-06-16 08:00:00	NQ	Futures	2161.28	2161.57	2153.83	2158.99	8750.0
2010-06-16 09:00:00	NQ	Futures	2158.7	2175.9	2158.13	2175.04	49415.0
2010-06-16 10:00:00	NQ	Futures	2175.04	2175.32	2163.57	2173.6	47679.0
2010-06-16 11:00:00	NQ	Futures	2173.6	2182.2	2170.16	2180.77	41194.0
2010-06-16 12:00:00	NQ	Futures	2180.77	2187.65	2177.9	2181.05	24629.0
2010-06-16 13:00:00	NQ	Futures	2180.77	2188.22	2178.47	2188.22	18826.0
2010-06-16 14:00:00	NQ	Futures	2188.22	2192.52	2186.5	2189.94	38480.0
2010-06-16 15:00:00	NQ	Futures	2189.94	2189.94	2174.46	2182.2	54037.0
2010-06-16 16:00:00	NQ	Futures	2182.2	2185.35	2180.19	2181.63	9640.0
2010-06-16 17:00:00	NQ	Futures	2181.34	2181.34	2178.76	2180.19	221.0
2010-06-16 18:00:00	NQ	Futures	2181.05	2181.05	2179.05	2179.62	175.0
2010-06-16 19:00:00	NQ	Futures	2179.91	2179.91	2177.9	2179.05	166.0
2010-06-16 20:00:00	NQ	Futures	2178.76	2180.77	2177.62	2179.62	584.0
2010-06-16 21:00:00	NQ	Futures	2179.62	2180.77	2176.18	2177.62	433.0
2010-06-16 22:00:00	NQ	Futures	2177.33	2178.19	2177.04	2177.62	302.0
2010-06-16 23:00:00	NQ	Futures	2177.62	2177.9	2175.32	2175.9	299.0
2010-06-16 00:00:00	YM	Futures	9769.0	9770.9	9756.7	9760.5	163.0
2010-06-16 01:00:00	YM	Futures	9759.5	9764.2	9755.7	9756.7	450.0

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

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