PREVIEW / futures_1hour / 2010-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-20.parquet
  size:    44 KB
  rows:    1,358

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-09-20 00:00:00	ES	Futures	1104.23	1104.96	1103.24	1104.96	2260.0
2010-09-20 01:00:00	ES	Futures	1104.72	1106.2	1103.49	1105.7	3768.0
2010-09-20 02:00:00	ES	Futures	1105.7	1106.94	1104.72	1106.44	8547.0
2010-09-20 03:00:00	ES	Futures	1106.44	1109.15	1105.46	1107.43	31789.0
2010-09-20 04:00:00	ES	Futures	1107.43	1109.15	1106.69	1108.42	16695.0
2010-09-20 05:00:00	ES	Futures	1108.42	1110.39	1107.68	1110.14	16353.0
2010-09-20 06:00:00	ES	Futures	1110.14	1110.63	1109.15	1109.65	9996.0
2010-09-20 07:00:00	ES	Futures	1109.89	1109.89	1108.17	1108.91	21923.0
2010-09-20 08:00:00	ES	Futures	1108.66	1110.14	1106.69	1107.18	55106.0
2010-09-20 09:00:00	ES	Futures	1107.18	1109.89	1105.46	1109.15	179064.0
2010-09-20 10:00:00	ES	Futures	1109.15	1117.04	1107.68	1116.8	429257.0
2010-09-20 11:00:00	ES	Futures	1116.8	1117.78	1115.56	1116.06	166965.0
2010-09-20 12:00:00	ES	Futures	1116.06	1116.8	1113.84	1116.06	113861.0
2010-09-20 13:00:00	ES	Futures	1116.3	1117.29	1114.58	1116.55	80843.0
2010-09-20 14:00:00	ES	Futures	1116.8	1121.23	1116.06	1120.99	197685.0
2010-09-20 15:00:00	ES	Futures	1120.74	1124.19	1120.0	1121.73	326596.0
2010-09-20 16:00:00	ES	Futures	1121.48	1121.97	1119.26	1120.0	102235.0
2010-09-20 17:00:00	ES	Futures	1119.75	1120.25	1119.75	1120.0	1410.0
2010-09-20 18:00:00	ES	Futures	1120.0	1120.49	1119.75	1120.25	2851.0
2010-09-20 19:00:00	ES	Futures	1120.0	1120.99	1119.75	1120.49	3442.0
2010-09-20 20:00:00	ES	Futures	1120.49	1120.74	1119.75	1120.25	3956.0
2010-09-20 21:00:00	ES	Futures	1120.0	1120.49	1118.77	1119.51	4670.0
2010-09-20 22:00:00	ES	Futures	1119.75	1119.75	1118.03	1118.77	3683.0
2010-09-20 23:00:00	ES	Futures	1119.01	1119.01	1118.03	1118.77	3045.0
2010-09-20 00:00:00	NQ	Futures	2242.72	2246.45	2241.57	2244.44	229.0
2010-09-20 01:00:00	NQ	Futures	2244.73	2246.45	2242.14	2246.16	210.0
2010-09-20 02:00:00	NQ	Futures	2245.87	2248.17	2244.44	2247.59	703.0
2010-09-20 03:00:00	NQ	Futures	2247.31	2253.05	2243.86	2249.32	5280.0
2010-09-20 04:00:00	NQ	Futures	2249.32	2252.76	2248.45	2251.9	1005.0
2010-09-20 05:00:00	NQ	Futures	2251.61	2254.48	2250.18	2253.05	1686.0
2010-09-20 06:00:00	NQ	Futures	2253.33	2254.19	2251.61	2252.18	1057.0
2010-09-20 07:00:00	NQ	Futures	2252.18	2252.47	2249.03	2249.32	1188.0
2010-09-20 08:00:00	NQ	Futures	2249.03	2252.18	2246.45	2247.31	5278.0
2010-09-20 09:00:00	NQ	Futures	2247.31	2255.91	2246.16	2253.33	34368.0
2010-09-20 10:00:00	NQ	Futures	2253.33	2272.27	2250.46	2269.97	67195.0
2010-09-20 11:00:00	NQ	Futures	2269.97	2271.41	2264.23	2265.67	29068.0
2010-09-20 12:00:00	NQ	Futures	2265.67	2267.68	2260.22	2265.96	24947.0
2010-09-20 13:00:00	NQ	Futures	2265.96	2269.97	2262.51	2269.4	20471.0
2010-09-20 14:00:00	NQ	Futures	2269.11	2277.72	2267.39	2276.57	31334.0
2010-09-20 15:00:00	NQ	Futures	2276.57	2284.6	2275.42	2279.73	46390.0
2010-09-20 16:00:00	NQ	Futures	2279.73	2280.87	2273.42	2274.56	10999.0
2010-09-20 17:00:00	NQ	Futures	2274.56	2275.14	2273.99	2275.14	84.0
2010-09-20 18:00:00	NQ	Futures	2274.28	2275.14	2274.28	2274.85	96.0
2010-09-20 19:00:00	NQ	Futures	2274.56	2276.86	2273.42	2276.57	437.0
2010-09-20 20:00:00	NQ	Futures	2276.28	2276.28	2274.56	2275.71	458.0
2010-09-20 21:00:00	NQ	Futures	2275.71	2276.0	2273.7	2274.85	359.0
2010-09-20 22:00:00	NQ	Futures	2274.85	2274.85	2272.27	2273.13	515.0
2010-09-20 23:00:00	NQ	Futures	2272.84	2273.13	2271.98	2273.13	230.0
2010-09-20 00:00:00	YM	Futures	10038.1	10045.7	10029.6	10042.9	87.0
2010-09-20 01:00:00	YM	Futures	10046.7	10055.3	10034.3	10052.4	170.0

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

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