PREVIEW / futures_1hour / 2010-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-19.parquet
  size:    48 KB
  rows:    1,386

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-05-19 00:00:00	ES	Futures	1087.7	1089.16	1085.99	1087.21	5372.0
2010-05-19 01:00:00	ES	Futures	1087.21	1090.63	1086.96	1089.9	8428.0
2010-05-19 02:00:00	ES	Futures	1090.14	1091.61	1086.23	1091.61	26889.0
2010-05-19 03:00:00	ES	Futures	1091.61	1092.83	1087.45	1089.41	63885.0
2010-05-19 04:00:00	ES	Futures	1089.16	1089.16	1080.85	1083.79	73005.0
2010-05-19 05:00:00	ES	Futures	1083.54	1084.76	1080.12	1081.1	44169.0
2010-05-19 06:00:00	ES	Futures	1081.1	1084.03	1080.36	1083.79	32673.0
2010-05-19 07:00:00	ES	Futures	1084.03	1087.21	1083.3	1086.47	49769.0
2010-05-19 08:00:00	ES	Futures	1086.47	1092.1	1085.25	1091.36	120643.0
2010-05-19 09:00:00	ES	Futures	1091.12	1097.72	1087.7	1093.56	419508.0
2010-05-19 10:00:00	ES	Futures	1093.32	1093.81	1078.9	1086.23	718427.0
2010-05-19 11:00:00	ES	Futures	1085.99	1086.96	1074.25	1079.63	456550.0
2010-05-19 12:00:00	ES	Futures	1079.63	1088.43	1078.41	1088.19	303461.0
2010-05-19 13:00:00	ES	Futures	1088.19	1092.34	1085.01	1089.41	302278.0
2010-05-19 14:00:00	ES	Futures	1089.41	1093.07	1085.01	1087.94	263097.0
2010-05-19 15:00:00	ES	Futures	1087.7	1093.32	1082.32	1087.94	479355.0
2010-05-19 16:00:00	ES	Futures	1087.94	1090.87	1084.76	1090.14	130587.0
2010-05-19 17:00:00	ES	Futures	1090.39	1090.39	1087.94	1089.65	2981.0
2010-05-19 18:00:00	ES	Futures	1090.14	1090.63	1088.43	1088.67	4362.0
2010-05-19 19:00:00	ES	Futures	1088.67	1091.61	1088.43	1090.39	4382.0
2010-05-19 20:00:00	ES	Futures	1090.63	1090.87	1088.19	1088.19	7850.0
2010-05-19 21:00:00	ES	Futures	1088.19	1088.67	1085.99	1087.45	8549.0
2010-05-19 22:00:00	ES	Futures	1087.21	1089.65	1086.23	1087.94	6929.0
2010-05-19 23:00:00	ES	Futures	1087.7	1088.19	1085.5	1085.99	3500.0
2010-05-19 00:00:00	NQ	Futures	2150.37	2154.09	2147.79	2150.66	338.0
2010-05-19 01:00:00	NQ	Futures	2150.09	2156.96	2149.8	2154.95	392.0
2010-05-19 02:00:00	NQ	Futures	2154.67	2158.68	2148.08	2158.1	1587.0
2010-05-19 03:00:00	NQ	Futures	2158.1	2160.97	2149.51	2153.81	4690.0
2010-05-19 04:00:00	NQ	Futures	2153.24	2153.24	2137.49	2142.07	3237.0
2010-05-19 05:00:00	NQ	Futures	2142.07	2144.36	2136.34	2137.2	2111.0
2010-05-19 06:00:00	NQ	Futures	2137.2	2143.79	2136.05	2143.79	1400.0
2010-05-19 07:00:00	NQ	Futures	2143.79	2148.94	2142.07	2148.37	2139.0
2010-05-19 08:00:00	NQ	Futures	2148.37	2160.68	2146.36	2158.96	14103.0
2010-05-19 09:00:00	NQ	Futures	2158.68	2169.27	2150.09	2157.82	52909.0
2010-05-19 10:00:00	NQ	Futures	2157.82	2158.68	2122.88	2143.5	102278.0
2010-05-19 11:00:00	NQ	Futures	2143.5	2145.79	2118.58	2127.75	60622.0
2010-05-19 12:00:00	NQ	Futures	2127.75	2144.93	2126.6	2144.93	35495.0
2010-05-19 13:00:00	NQ	Futures	2144.93	2153.81	2138.34	2148.08	37331.0
2010-05-19 14:00:00	NQ	Futures	2147.79	2155.24	2136.63	2142.64	35170.0
2010-05-19 15:00:00	NQ	Futures	2142.35	2153.24	2130.04	2142.07	62359.0
2010-05-19 16:00:00	NQ	Futures	2142.35	2146.94	2136.63	2145.22	13636.0
2010-05-19 17:00:00	NQ	Futures	2145.5	2147.22	2141.21	2144.93	482.0
2010-05-19 18:00:00	NQ	Futures	2146.36	2146.65	2142.35	2142.93	288.0
2010-05-19 19:00:00	NQ	Futures	2142.64	2147.79	2142.35	2146.08	332.0
2010-05-19 20:00:00	NQ	Futures	2146.08	2146.36	2141.21	2141.49	455.0
2010-05-19 21:00:00	NQ	Futures	2141.49	2142.07	2136.91	2139.78	508.0
2010-05-19 22:00:00	NQ	Futures	2139.78	2144.64	2137.77	2140.92	383.0
2010-05-19 23:00:00	NQ	Futures	2141.21	2141.78	2137.2	2138.34	223.0
2010-05-19 00:00:00	YM	Futures	9828.5	9838.9	9814.4	9825.7	435.0
2010-05-19 01:00:00	YM	Futures	9825.7	9851.1	9823.8	9844.5	515.0

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

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