PREVIEW / futures_1hour / 2010-07-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	1068.38	1070.59	1068.38	1069.61	3745.0
2010-07-23 01:00:00	ES	Futures	1069.85	1071.82	1066.42	1068.14	8797.0
2010-07-23 02:00:00	ES	Futures	1068.14	1069.61	1067.65	1069.61	6517.0
2010-07-23 03:00:00	ES	Futures	1069.61	1071.33	1066.66	1069.85	31916.0
2010-07-23 04:00:00	ES	Futures	1070.1	1074.52	1069.85	1073.29	33547.0
2010-07-23 05:00:00	ES	Futures	1073.29	1073.29	1070.59	1071.57	15450.0
2010-07-23 06:00:00	ES	Futures	1071.57	1073.54	1070.59	1072.31	12757.0
2010-07-23 07:00:00	ES	Futures	1072.06	1073.78	1071.33	1072.06	24542.0
2010-07-23 08:00:00	ES	Futures	1072.06	1073.29	1070.35	1071.08	37253.0
2010-07-23 09:00:00	ES	Futures	1070.84	1071.82	1064.46	1064.95	348535.0
2010-07-23 10:00:00	ES	Futures	1064.95	1073.04	1063.97	1070.1	300682.0
2010-07-23 11:00:00	ES	Futures	1069.85	1073.29	1068.38	1071.33	190374.0
2010-07-23 12:00:00	ES	Futures	1071.57	1074.52	1066.42	1070.59	302165.0
2010-07-23 13:00:00	ES	Futures	1070.59	1078.93	1068.14	1077.71	230647.0
2010-07-23 14:00:00	ES	Futures	1077.71	1080.41	1075.74	1078.93	160788.0
2010-07-23 15:00:00	ES	Futures	1078.93	1079.42	1073.29	1078.69	261457.0
2010-07-23 16:00:00	ES	Futures	1078.44	1081.14	1077.71	1080.65	84723.0
2010-07-23 00:00:00	NQ	Futures	2123.74	2127.75	2123.74	2125.75	259.0
2010-07-23 01:00:00	NQ	Futures	2126.03	2129.76	2120.3	2122.88	433.0
2010-07-23 02:00:00	NQ	Futures	2123.45	2127.75	2122.31	2127.47	876.0
2010-07-23 03:00:00	NQ	Futures	2127.47	2131.48	2122.31	2128.33	1914.0
2010-07-23 04:00:00	NQ	Futures	2128.33	2137.21	2128.33	2135.49	2316.0
2010-07-23 05:00:00	NQ	Futures	2135.2	2135.2	2130.33	2132.62	670.0
2010-07-23 06:00:00	NQ	Futures	2131.76	2135.78	2130.62	2133.77	739.0
2010-07-23 07:00:00	NQ	Futures	2133.77	2136.64	2130.9	2131.48	1876.0
2010-07-23 08:00:00	NQ	Futures	2131.48	2132.91	2125.17	2126.32	6980.0
2010-07-23 09:00:00	NQ	Futures	2126.61	2131.48	2115.72	2116.0	51971.0
2010-07-23 10:00:00	NQ	Futures	2116.29	2134.63	2114.28	2127.47	46832.0
2010-07-23 11:00:00	NQ	Futures	2127.75	2131.19	2122.02	2127.75	31725.0
2010-07-23 12:00:00	NQ	Futures	2127.75	2133.48	2114.0	2124.03	49703.0
2010-07-23 13:00:00	NQ	Futures	2123.74	2146.38	2118.58	2140.36	41805.0
2010-07-23 14:00:00	NQ	Futures	2140.65	2147.53	2138.07	2145.23	28806.0
2010-07-23 15:00:00	NQ	Futures	2145.23	2147.81	2137.21	2147.24	45706.0
2010-07-23 16:00:00	NQ	Futures	2147.24	2150.68	2144.66	2149.25	10887.0
2010-07-23 00:00:00	YM	Futures	9723.5	9739.6	9723.5	9732.1	297.0
2010-07-23 01:00:00	YM	Futures	9735.8	9748.2	9708.4	9719.8	515.0
2010-07-23 02:00:00	YM	Futures	9719.8	9732.1	9716.0	9729.2	434.0
2010-07-23 03:00:00	YM	Futures	9730.2	9746.3	9705.6	9734.0	2080.0
2010-07-23 04:00:00	YM	Futures	9738.7	9769.9	9738.7	9760.5	2066.0
2010-07-23 05:00:00	YM	Futures	9758.6	9760.5	9738.7	9749.1	825.0
2010-07-23 06:00:00	YM	Futures	9747.2	9761.4	9740.6	9753.8	798.0
2010-07-23 07:00:00	YM	Futures	9753.8	9766.1	9744.4	9748.2	1290.0
2010-07-23 08:00:00	YM	Futures	9749.1	9755.7	9727.3	9731.1	2805.0
2010-07-23 09:00:00	YM	Futures	9732.1	9744.4	9688.5	9699.9	20042.0
2010-07-23 10:00:00	YM	Futures	9699.9	9759.5	9691.4	9734.0	20277.0
2010-07-23 11:00:00	YM	Futures	9734.0	9762.4	9726.4	9751.9	13864.0
2010-07-23 12:00:00	YM	Futures	9751.9	9774.7	9708.4	9741.5	24656.0
2010-07-23 13:00:00	YM	Futures	9740.6	9816.3	9723.5	9809.7	17891.0
2010-07-23 14:00:00	YM	Futures	9809.7	9838.1	9803.1	9825.8	16460.0
2010-07-23 15:00:00	YM	Futures	9826.7	9828.6	9778.4	9819.1	21496.0

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

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