PREVIEW / futures_1hour / 2010-10-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-20.parquet
  size:    49 KB
  rows:    1,453

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-10-20 00:00:00	ES	Futures	1150.32	1152.04	1150.32	1151.3	9997.0
2010-10-20 01:00:00	ES	Futures	1151.3	1151.8	1150.07	1150.32	6128.0
2010-10-20 02:00:00	ES	Futures	1150.32	1151.3	1148.35	1149.08	17890.0
2010-10-20 03:00:00	ES	Futures	1148.84	1151.06	1147.61	1150.07	28142.0
2010-10-20 04:00:00	ES	Futures	1150.07	1152.29	1148.1	1152.04	21447.0
2010-10-20 05:00:00	ES	Futures	1152.04	1152.78	1151.06	1152.29	19248.0
2010-10-20 06:00:00	ES	Futures	1152.29	1153.77	1151.3	1152.54	29278.0
2010-10-20 07:00:00	ES	Futures	1152.29	1153.27	1151.06	1151.55	42793.0
2010-10-20 08:00:00	ES	Futures	1151.3	1152.54	1148.59	1148.59	76029.0
2010-10-20 09:00:00	ES	Futures	1148.84	1154.51	1147.61	1151.3	333773.0
2010-10-20 10:00:00	ES	Futures	1151.3	1157.96	1148.35	1156.48	478029.0
2010-10-20 11:00:00	ES	Futures	1156.48	1159.68	1155.25	1158.2	247930.0
2010-10-20 12:00:00	ES	Futures	1158.2	1162.64	1157.96	1161.16	201939.0
2010-10-20 13:00:00	ES	Futures	1160.92	1162.89	1159.68	1159.93	133110.0
2010-10-20 14:00:00	ES	Futures	1160.18	1163.38	1158.2	1160.92	199052.0
2010-10-20 15:00:00	ES	Futures	1160.92	1162.39	1156.73	1157.71	296588.0
2010-10-20 16:00:00	ES	Futures	1157.46	1160.42	1156.97	1159.93	94415.0
2010-10-20 17:00:00	ES	Futures	1159.68	1159.93	1158.7	1158.94	2439.0
2010-10-20 18:00:00	ES	Futures	1160.18	1160.67	1159.68	1160.18	2503.0
2010-10-20 19:00:00	ES	Futures	1160.18	1161.16	1159.68	1160.67	3412.0
2010-10-20 20:00:00	ES	Futures	1160.42	1160.67	1155.99	1157.22	14525.0
2010-10-20 21:00:00	ES	Futures	1156.97	1159.44	1156.23	1158.45	15919.0
2010-10-20 22:00:00	ES	Futures	1158.2	1159.44	1156.73	1156.97	8569.0
2010-10-20 23:00:00	ES	Futures	1156.97	1158.45	1155.49	1158.2	6425.0
2010-10-20 00:00:00	NQ	Futures	2381.58	2384.16	2381.0	2382.73	462.0
2010-10-20 01:00:00	NQ	Futures	2383.01	2383.87	2381.86	2382.44	434.0
2010-10-20 02:00:00	NQ	Futures	2382.15	2383.3	2378.71	2379.86	961.0
2010-10-20 03:00:00	NQ	Futures	2379.86	2384.45	2376.7	2382.44	2436.0
2010-10-20 04:00:00	NQ	Futures	2382.15	2385.88	2378.42	2385.59	1688.0
2010-10-20 05:00:00	NQ	Futures	2385.31	2386.46	2383.3	2385.59	960.0
2010-10-20 06:00:00	NQ	Futures	2385.59	2387.6	2383.59	2385.31	1991.0
2010-10-20 07:00:00	NQ	Futures	2385.02	2387.6	2382.44	2385.31	3731.0
2010-10-20 08:00:00	NQ	Futures	2385.31	2386.46	2377.56	2377.85	4744.0
2010-10-20 09:00:00	NQ	Futures	2378.13	2390.18	2377.85	2385.02	44410.0
2010-10-20 10:00:00	NQ	Futures	2385.02	2395.92	2375.84	2393.63	57834.0
2010-10-20 11:00:00	NQ	Futures	2393.63	2404.24	2389.9	2400.23	39588.0
2010-10-20 12:00:00	NQ	Futures	2400.23	2408.26	2399.65	2400.8	26123.0
2010-10-20 13:00:00	NQ	Futures	2400.51	2405.1	2397.93	2398.79	19222.0
2010-10-20 14:00:00	NQ	Futures	2399.08	2404.53	2393.63	2400.23	29063.0
2010-10-20 15:00:00	NQ	Futures	2400.51	2401.95	2389.04	2389.61	43161.0
2010-10-20 16:00:00	NQ	Futures	2389.61	2397.93	2388.75	2397.36	8748.0
2010-10-20 17:00:00	NQ	Futures	2397.36	2397.93	2395.92	2396.5	604.0
2010-10-20 18:00:00	NQ	Futures	2397.36	2398.79	2396.78	2397.93	172.0
2010-10-20 19:00:00	NQ	Futures	2397.64	2399.08	2397.36	2398.22	263.0
2010-10-20 20:00:00	NQ	Futures	2398.22	2398.22	2391.91	2393.34	1120.0
2010-10-20 21:00:00	NQ	Futures	2393.34	2397.07	2391.62	2394.78	1110.0
2010-10-20 22:00:00	NQ	Futures	2394.49	2397.36	2391.33	2391.33	819.0
2010-10-20 23:00:00	NQ	Futures	2391.33	2392.48	2388.46	2392.48	558.0
2010-10-20 00:00:00	YM	Futures	10438.2	10450.6	10436.3	10443.9	458.0
2010-10-20 01:00:00	YM	Futures	10443.9	10448.7	10435.3	10435.3	262.0

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

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