PREVIEW / futures_1hour / 2010-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-30.parquet
  size:    39 KB
  rows:    1,107

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-07-30 00:00:00	ES	Futures	1071.82	1072.55	1070.84	1072.55	4651.0
2010-07-30 01:00:00	ES	Futures	1072.55	1073.78	1072.06	1073.78	3493.0
2010-07-30 02:00:00	ES	Futures	1073.78	1075.5	1072.8	1074.76	7305.0
2010-07-30 03:00:00	ES	Futures	1074.52	1077.71	1072.8	1074.76	28210.0
2010-07-30 04:00:00	ES	Futures	1074.76	1075.01	1071.82	1072.8	17577.0
2010-07-30 05:00:00	ES	Futures	1072.8	1073.78	1070.1	1070.35	19988.0
2010-07-30 06:00:00	ES	Futures	1070.59	1073.54	1070.1	1073.29	13460.0
2010-07-30 07:00:00	ES	Futures	1073.29	1073.54	1071.08	1072.06	12306.0
2010-07-30 08:00:00	ES	Futures	1072.06	1072.31	1063.47	1065.68	126915.0
2010-07-30 09:00:00	ES	Futures	1065.68	1073.04	1064.46	1071.33	376268.0
2010-07-30 10:00:00	ES	Futures	1071.33	1080.9	1070.84	1078.2	384093.0
2010-07-30 11:00:00	ES	Futures	1078.44	1079.67	1074.27	1077.22	193414.0
2010-07-30 12:00:00	ES	Futures	1077.22	1077.95	1074.76	1076.97	102238.0
2010-07-30 13:00:00	ES	Futures	1076.97	1077.71	1070.1	1070.84	146118.0
2010-07-30 14:00:00	ES	Futures	1070.59	1077.46	1070.35	1075.01	180685.0
2010-07-30 15:00:00	ES	Futures	1074.76	1083.11	1074.03	1077.71	372778.0
2010-07-30 16:00:00	ES	Futures	1077.46	1080.16	1076.73	1079.92	101481.0
2010-07-30 00:00:00	NQ	Futures	2119.16	2120.59	2118.3	2120.59	247.0
2010-07-30 01:00:00	NQ	Futures	2120.59	2124.31	2120.3	2123.45	230.0
2010-07-30 02:00:00	NQ	Futures	2123.74	2127.75	2122.59	2126.32	580.0
2010-07-30 03:00:00	NQ	Futures	2126.03	2130.9	2120.3	2124.6	2557.0
2010-07-30 04:00:00	NQ	Futures	2124.6	2124.6	2118.58	2120.3	1305.0
2010-07-30 05:00:00	NQ	Futures	2120.02	2122.31	2117.44	2117.72	1545.0
2010-07-30 06:00:00	NQ	Futures	2118.01	2123.74	2117.15	2123.45	1522.0
2010-07-30 07:00:00	NQ	Futures	2123.74	2123.74	2119.44	2121.16	1243.0
2010-07-30 08:00:00	NQ	Futures	2121.16	2121.16	2102.25	2107.41	13049.0
2010-07-30 09:00:00	NQ	Futures	2107.41	2114.28	2099.38	2110.85	71052.0
2010-07-30 10:00:00	NQ	Futures	2110.85	2137.78	2110.27	2132.34	66743.0
2010-07-30 11:00:00	NQ	Futures	2132.05	2135.2	2124.89	2131.76	36230.0
2010-07-30 12:00:00	NQ	Futures	2132.05	2136.06	2126.89	2134.63	25016.0
2010-07-30 13:00:00	NQ	Futures	2134.63	2136.06	2119.44	2120.59	26316.0
2010-07-30 14:00:00	NQ	Futures	2120.3	2134.06	2118.87	2129.47	30817.0
2010-07-30 15:00:00	NQ	Futures	2129.47	2147.53	2127.47	2135.2	63573.0
2010-07-30 16:00:00	NQ	Futures	2134.92	2138.36	2134.34	2136.35	10235.0
2010-07-30 00:00:00	YM	Futures	9818.2	9822.0	9811.6	9822.0	493.0
2010-07-30 01:00:00	YM	Futures	9822.0	9835.2	9821.0	9833.3	228.0
2010-07-30 02:00:00	YM	Futures	9832.4	9845.7	9827.7	9840.0	1019.0
2010-07-30 03:00:00	YM	Futures	9840.0	9863.6	9824.8	9840.0	2344.0
2010-07-30 04:00:00	YM	Futures	9840.0	9840.0	9818.2	9829.6	1158.0
2010-07-30 05:00:00	YM	Futures	9825.8	9832.4	9806.8	9808.7	673.0
2010-07-30 06:00:00	YM	Futures	9808.7	9832.4	9805.9	9832.4	660.0
2010-07-30 07:00:00	YM	Futures	9832.4	9832.4	9814.4	9820.1	705.0
2010-07-30 08:00:00	YM	Futures	9820.1	9823.9	9736.8	9766.1	9894.0
2010-07-30 09:00:00	YM	Futures	9766.1	9819.1	9748.2	9805.9	26008.0
2010-07-30 10:00:00	YM	Futures	9805.9	9891.1	9802.1	9866.5	27969.0
2010-07-30 11:00:00	YM	Futures	9865.5	9877.8	9834.3	9858.0	14247.0
2010-07-30 12:00:00	YM	Futures	9858.9	9863.6	9836.2	9849.4	9306.0
2010-07-30 13:00:00	YM	Futures	9849.4	9854.2	9791.7	9794.5	11769.0
2010-07-30 14:00:00	YM	Futures	9795.5	9849.4	9790.8	9828.6	13628.0
2010-07-30 15:00:00	YM	Futures	9827.7	9901.5	9822.0	9859.9	25129.0

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

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