PREVIEW / futures_1hour / 2009-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-03.parquet
  size:    45 KB
  rows:    1,368

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
2009-12-03 00:00:00	ES	Futures	1078.13	1078.37	1077.16	1078.37	3705.0
2009-12-03 01:00:00	ES	Futures	1078.13	1079.82	1077.64	1079.34	5747.0
2009-12-03 02:00:00	ES	Futures	1079.1	1080.31	1078.86	1079.1	13502.0
2009-12-03 03:00:00	ES	Futures	1079.1	1080.55	1077.64	1080.07	29830.0
2009-12-03 04:00:00	ES	Futures	1080.07	1080.55	1079.1	1079.58	17772.0
2009-12-03 05:00:00	ES	Futures	1079.34	1080.31	1077.16	1077.64	14660.0
2009-12-03 06:00:00	ES	Futures	1077.89	1078.61	1075.95	1076.19	18668.0
2009-12-03 07:00:00	ES	Futures	1076.19	1078.37	1076.19	1077.89	21998.0
2009-12-03 08:00:00	ES	Futures	1078.13	1079.34	1074.98	1076.19	79700.0
2009-12-03 09:00:00	ES	Futures	1076.19	1082.25	1074.98	1078.13	286077.0
2009-12-03 10:00:00	ES	Futures	1078.13	1078.13	1070.86	1075.46	493430.0
2009-12-03 11:00:00	ES	Futures	1075.46	1076.19	1072.8	1074.01	151111.0
2009-12-03 12:00:00	ES	Futures	1074.25	1075.71	1073.28	1075.22	102011.0
2009-12-03 13:00:00	ES	Futures	1075.22	1076.19	1073.04	1075.46	88748.0
2009-12-03 14:00:00	ES	Futures	1075.46	1076.19	1072.07	1072.8	134944.0
2009-12-03 15:00:00	ES	Futures	1073.04	1074.01	1063.84	1065.05	404033.0
2009-12-03 16:00:00	ES	Futures	1065.05	1065.29	1062.38	1062.63	117184.0
2009-12-03 17:00:00	ES	Futures	1062.63	1062.87	1062.14	1062.63	2545.0
2009-12-03 18:00:00	ES	Futures	1063.11	1064.56	1062.63	1064.08	7843.0
2009-12-03 19:00:00	ES	Futures	1064.32	1064.56	1062.14	1062.87	8221.0
2009-12-03 20:00:00	ES	Futures	1062.87	1064.32	1062.63	1064.08	3698.0
2009-12-03 21:00:00	ES	Futures	1063.84	1064.56	1063.35	1064.32	2616.0
2009-12-03 22:00:00	ES	Futures	1064.32	1064.81	1062.63	1062.87	2944.0
2009-12-03 23:00:00	ES	Futures	1063.11	1063.6	1062.63	1063.6	2444.0
2009-12-03 00:00:00	NQ	Futures	2052.26	2053.11	2051.4	2052.83	384.0
2009-12-03 01:00:00	NQ	Futures	2052.54	2055.68	2051.97	2055.11	387.0
2009-12-03 02:00:00	NQ	Futures	2054.82	2055.68	2053.68	2053.68	2014.0
2009-12-03 03:00:00	NQ	Futures	2053.97	2054.82	2050.26	2054.25	3140.0
2009-12-03 04:00:00	NQ	Futures	2054.25	2055.39	2053.11	2053.4	2214.0
2009-12-03 05:00:00	NQ	Futures	2053.11	2053.97	2048.26	2049.12	1319.0
2009-12-03 06:00:00	NQ	Futures	2049.69	2050.55	2045.13	2045.13	1501.0
2009-12-03 07:00:00	NQ	Futures	2045.7	2049.41	2045.7	2047.98	1491.0
2009-12-03 08:00:00	NQ	Futures	2047.98	2050.26	2044.27	2046.84	7705.0
2009-12-03 09:00:00	NQ	Futures	2046.84	2061.1	2046.27	2055.39	42787.0
2009-12-03 10:00:00	NQ	Futures	2055.68	2055.96	2043.99	2052.26	61681.0
2009-12-03 11:00:00	NQ	Futures	2052.26	2054.25	2047.12	2049.12	27457.0
2009-12-03 12:00:00	NQ	Futures	2049.12	2051.69	2046.84	2051.12	20153.0
2009-12-03 13:00:00	NQ	Futures	2051.12	2053.11	2047.41	2051.97	16654.0
2009-12-03 14:00:00	NQ	Futures	2052.26	2053.4	2048.83	2049.98	21800.0
2009-12-03 15:00:00	NQ	Futures	2049.98	2051.69	2032.01	2032.86	51283.0
2009-12-03 16:00:00	NQ	Futures	2032.86	2033.15	2027.16	2027.16	14616.0
2009-12-03 17:00:00	NQ	Futures	2027.16	2027.45	2026.3	2027.45	231.0
2009-12-03 18:00:00	NQ	Futures	2027.73	2030.3	2027.16	2029.73	424.0
2009-12-03 19:00:00	NQ	Futures	2029.73	2030.87	2026.59	2028.3	554.0
2009-12-03 20:00:00	NQ	Futures	2028.3	2030.87	2027.73	2030.3	205.0
2009-12-03 21:00:00	NQ	Futures	2030.58	2031.44	2029.16	2031.44	106.0
2009-12-03 22:00:00	NQ	Futures	2031.44	2031.72	2027.45	2028.3	219.0
2009-12-03 23:00:00	NQ	Futures	2028.3	2028.87	2027.16	2028.87	132.0
2009-12-03 00:00:00	YM	Futures	9740.9	9743.7	9735.3	9741.8	304.0
2009-12-03 01:00:00	YM	Futures	9743.7	9754.8	9740.0	9752.1	347.0

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

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