PREVIEW / futures_1hour / 2010-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-23.parquet
  size:    46 KB
  rows:    1,363

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-23 00:00:00	ES	Futures	1073.54	1074.27	1073.04	1073.78	2438.0
2010-06-23 01:00:00	ES	Futures	1073.78	1074.03	1072.31	1073.29	5881.0
2010-06-23 02:00:00	ES	Futures	1073.29	1074.27	1071.33	1073.78	11406.0
2010-06-23 03:00:00	ES	Futures	1073.78	1075.5	1073.29	1074.76	35942.0
2010-06-23 04:00:00	ES	Futures	1074.76	1077.22	1074.03	1075.74	36935.0
2010-06-23 05:00:00	ES	Futures	1075.5	1076.23	1074.52	1075.74	14588.0
2010-06-23 06:00:00	ES	Futures	1075.74	1077.46	1075.01	1075.5	13724.0
2010-06-23 07:00:00	ES	Futures	1075.5	1076.23	1074.03	1075.01	23332.0
2010-06-23 08:00:00	ES	Futures	1074.76	1077.22	1074.27	1075.25	67940.0
2010-06-23 09:00:00	ES	Futures	1075.5	1075.5	1067.16	1070.84	313994.0
2010-06-23 10:00:00	ES	Futures	1070.84	1070.84	1060.28	1065.44	462187.0
2010-06-23 11:00:00	ES	Futures	1065.68	1066.17	1062.49	1063.72	163152.0
2010-06-23 12:00:00	ES	Futures	1063.97	1067.65	1062.74	1066.66	96598.0
2010-06-23 13:00:00	ES	Futures	1066.91	1068.87	1066.17	1068.38	110139.0
2010-06-23 14:00:00	ES	Futures	1068.14	1075.5	1064.21	1067.4	394621.0
2010-06-23 15:00:00	ES	Futures	1067.4	1071.33	1063.47	1067.4	368001.0
2010-06-23 16:00:00	ES	Futures	1067.65	1067.89	1065.19	1065.93	80188.0
2010-06-23 17:00:00	ES	Futures	1065.93	1066.17	1064.46	1064.7	1420.0
2010-06-23 18:00:00	ES	Futures	1064.95	1065.68	1064.46	1064.95	1793.0
2010-06-23 19:00:00	ES	Futures	1064.95	1066.42	1064.46	1066.42	3121.0
2010-06-23 20:00:00	ES	Futures	1066.42	1067.16	1065.93	1066.42	4998.0
2010-06-23 21:00:00	ES	Futures	1066.66	1067.89	1065.68	1066.42	4681.0
2010-06-23 22:00:00	ES	Futures	1066.42	1067.89	1066.42	1067.4	4100.0
2010-06-23 23:00:00	ES	Futures	1067.4	1069.61	1066.91	1069.36	4005.0
2010-06-23 00:00:00	NQ	Futures	2158.7	2159.28	2157.56	2158.42	103.0
2010-06-23 01:00:00	NQ	Futures	2158.42	2159.28	2157.27	2158.99	191.0
2010-06-23 02:00:00	NQ	Futures	2158.13	2160.13	2155.55	2158.99	982.0
2010-06-23 03:00:00	NQ	Futures	2158.99	2162.71	2158.13	2161.57	2309.0
2010-06-23 04:00:00	NQ	Futures	2161.28	2165.01	2160.13	2163.0	2070.0
2010-06-23 05:00:00	NQ	Futures	2163.0	2163.29	2160.99	2163.0	1538.0
2010-06-23 06:00:00	NQ	Futures	2163.29	2166.15	2161.28	2162.71	1429.0
2010-06-23 07:00:00	NQ	Futures	2163.0	2163.29	2160.71	2161.85	1882.0
2010-06-23 08:00:00	NQ	Futures	2161.85	2166.44	2160.71	2163.29	6845.0
2010-06-23 09:00:00	NQ	Futures	2163.0	2163.57	2144.95	2151.25	46450.0
2010-06-23 10:00:00	NQ	Futures	2150.68	2151.25	2129.47	2143.51	66845.0
2010-06-23 11:00:00	NQ	Futures	2143.8	2144.09	2135.49	2139.22	26774.0
2010-06-23 12:00:00	NQ	Futures	2139.5	2149.53	2137.78	2146.95	17438.0
2010-06-23 13:00:00	NQ	Futures	2147.24	2152.68	2144.95	2152.11	17399.0
2010-06-23 14:00:00	NQ	Futures	2151.82	2165.87	2141.79	2146.95	56892.0
2010-06-23 15:00:00	NQ	Futures	2146.95	2154.69	2137.5	2146.67	59414.0
2010-06-23 16:00:00	NQ	Futures	2146.67	2152.68	2140.93	2142.08	11168.0
2010-06-23 17:00:00	NQ	Futures	2142.08	2142.65	2139.5	2140.08	326.0
2010-06-23 18:00:00	NQ	Futures	2140.36	2140.36	2137.78	2138.07	757.0
2010-06-23 19:00:00	NQ	Futures	2138.64	2142.37	2137.78	2142.37	280.0
2010-06-23 20:00:00	NQ	Futures	2142.37	2143.51	2140.93	2142.37	382.0
2010-06-23 21:00:00	NQ	Futures	2142.65	2144.95	2141.51	2141.79	453.0
2010-06-23 22:00:00	NQ	Futures	2141.79	2144.95	2141.79	2144.09	341.0
2010-06-23 23:00:00	NQ	Futures	2144.09	2147.24	2143.8	2146.67	367.0
2010-06-23 00:00:00	YM	Futures	9714.1	9716.0	9708.4	9712.2	175.0
2010-06-23 01:00:00	YM	Futures	9713.1	9716.0	9702.7	9707.5	183.0

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

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