PREVIEW / futures_1hour / 2010-06-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	1084.33	1084.58	1083.6	1083.84	2504.0
2010-06-17 01:00:00	ES	Futures	1083.84	1084.58	1083.11	1084.33	4261.0
2010-06-17 02:00:00	ES	Futures	1084.58	1086.05	1083.84	1085.07	10315.0
2010-06-17 03:00:00	ES	Futures	1085.07	1086.54	1083.11	1084.82	36897.0
2010-06-17 04:00:00	ES	Futures	1084.82	1090.22	1084.33	1088.5	32432.0
2010-06-17 05:00:00	ES	Futures	1088.5	1094.15	1088.26	1092.43	35691.0
2010-06-17 06:00:00	ES	Futures	1092.43	1093.41	1091.45	1093.17	18962.0
2010-06-17 07:00:00	ES	Futures	1093.17	1094.88	1092.92	1093.9	30495.0
2010-06-17 08:00:00	ES	Futures	1093.66	1096.85	1089.49	1092.18	121984.0
2010-06-17 09:00:00	ES	Futures	1092.43	1094.15	1087.77	1090.71	276979.0
2010-06-17 10:00:00	ES	Futures	1090.71	1090.71	1080.9	1082.86	523947.0
2010-06-17 11:00:00	ES	Futures	1082.86	1087.52	1080.41	1086.54	255612.0
2010-06-17 12:00:00	ES	Futures	1086.54	1087.52	1083.11	1085.31	138653.0
2010-06-17 13:00:00	ES	Futures	1085.07	1089.24	1083.6	1088.99	156210.0
2010-06-17 14:00:00	ES	Futures	1088.99	1089.98	1084.33	1085.8	191770.0
2010-06-17 15:00:00	ES	Futures	1085.8	1091.94	1081.63	1090.96	456768.0
2010-06-17 16:00:00	ES	Futures	1090.96	1091.94	1089.98	1090.71	98155.0
2010-06-17 17:00:00	ES	Futures	1090.47	1091.2	1089.98	1090.47	2781.0
2010-06-17 18:00:00	ES	Futures	1090.47	1091.2	1089.73	1089.98	2681.0
2010-06-17 19:00:00	ES	Futures	1089.98	1090.47	1089.73	1090.22	1275.0
2010-06-17 20:00:00	ES	Futures	1089.98	1090.71	1088.75	1090.71	4662.0
2010-06-17 21:00:00	ES	Futures	1090.71	1091.2	1089.24	1089.98	3713.0
2010-06-17 22:00:00	ES	Futures	1090.22	1091.45	1089.73	1091.2	2899.0
2010-06-17 23:00:00	ES	Futures	1091.2	1091.94	1090.96	1091.69	2315.0
2010-06-17 00:00:00	NQ	Futures	2175.9	2176.47	2174.75	2175.32	385.0
2010-06-17 01:00:00	NQ	Futures	2175.32	2175.9	2173.89	2175.61	226.0
2010-06-17 02:00:00	NQ	Futures	2175.32	2177.9	2174.46	2176.47	962.0
2010-06-17 03:00:00	NQ	Futures	2176.47	2179.33	2173.32	2176.47	2574.0
2010-06-17 04:00:00	NQ	Futures	2176.18	2185.93	2175.32	2182.77	1928.0
2010-06-17 05:00:00	NQ	Futures	2183.06	2194.24	2182.77	2191.37	2294.0
2010-06-17 06:00:00	NQ	Futures	2191.66	2192.8	2189.36	2191.94	1356.0
2010-06-17 07:00:00	NQ	Futures	2191.94	2196.82	2191.94	2195.38	2497.0
2010-06-17 08:00:00	NQ	Futures	2195.1	2198.82	2186.5	2192.52	13991.0
2010-06-17 09:00:00	NQ	Futures	2192.52	2196.82	2182.49	2193.38	44155.0
2010-06-17 10:00:00	NQ	Futures	2193.38	2193.66	2169.59	2176.47	74220.0
2010-06-17 11:00:00	NQ	Futures	2176.47	2188.22	2170.45	2186.79	35106.0
2010-06-17 12:00:00	NQ	Futures	2186.5	2187.36	2177.9	2181.34	24028.0
2010-06-17 13:00:00	NQ	Futures	2181.05	2190.51	2178.19	2190.22	23749.0
2010-06-17 14:00:00	NQ	Futures	2190.51	2192.8	2178.76	2181.91	23356.0
2010-06-17 15:00:00	NQ	Futures	2182.2	2190.22	2172.74	2189.08	59521.0
2010-06-17 16:00:00	NQ	Futures	2188.79	2190.22	2187.07	2187.93	11778.0
2010-06-17 17:00:00	NQ	Futures	2187.93	2189.08	2187.07	2188.5	270.0
2010-06-17 18:00:00	NQ	Futures	2188.79	2189.36	2186.5	2186.79	204.0
2010-06-17 19:00:00	NQ	Futures	2187.07	2188.22	2186.5	2187.36	106.0
2010-06-17 20:00:00	NQ	Futures	2187.65	2189.36	2185.64	2188.79	394.0
2010-06-17 21:00:00	NQ	Futures	2189.08	2189.94	2186.5	2188.79	409.0
2010-06-17 22:00:00	NQ	Futures	2188.5	2190.51	2187.93	2189.94	124.0
2010-06-17 23:00:00	NQ	Futures	2189.94	2191.66	2189.65	2191.37	189.0
2010-06-17 00:00:00	YM	Futures	9758.6	9766.1	9752.9	9752.9	334.0
2010-06-17 01:00:00	YM	Futures	9754.8	9759.5	9751.0	9757.6	328.0

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

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