PREVIEW / futures_1hour / 2009-12-10

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-10.parquet
  size:    42 KB
  rows:    1,305

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-10 00:00:00	ES	Futures	1059.96	1061.42	1059.48	1060.69	2488.0
2009-12-10 01:00:00	ES	Futures	1060.69	1061.66	1058.99	1060.45	6139.0
2009-12-10 02:00:00	ES	Futures	1060.45	1060.93	1058.51	1059.48	9731.0
2009-12-10 03:00:00	ES	Futures	1059.24	1065.29	1058.51	1064.32	28433.0
2009-12-10 04:00:00	ES	Futures	1064.56	1064.81	1061.66	1062.38	13492.0
2009-12-10 05:00:00	ES	Futures	1062.38	1066.26	1061.9	1065.29	18284.0
2009-12-10 06:00:00	ES	Futures	1065.53	1066.26	1064.32	1065.78	8518.0
2009-12-10 07:00:00	ES	Futures	1066.02	1067.47	1065.29	1066.26	15679.0
2009-12-10 08:00:00	ES	Futures	1066.5	1070.14	1066.26	1067.96	69145.0
2009-12-10 09:00:00	ES	Futures	1067.96	1071.83	1067.23	1069.17	145013.0
2009-12-10 10:00:00	ES	Futures	1069.17	1070.14	1065.78	1069.17	154119.0
2009-12-10 11:00:00	ES	Futures	1068.92	1071.1	1068.2	1068.68	73850.0
2009-12-10 12:00:00	ES	Futures	1068.68	1070.38	1067.47	1069.41	48777.0
2009-12-10 13:00:00	ES	Futures	1069.41	1069.65	1066.5	1069.17	72010.0
2009-12-10 14:00:00	ES	Futures	1069.17	1070.62	1068.44	1069.17	47299.0
2009-12-10 15:00:00	ES	Futures	1068.92	1069.17	1065.29	1067.23	95101.0
2009-12-10 16:00:00	ES	Futures	1067.47	1069.17	1066.74	1069.17	31227.0
2009-12-10 17:00:00	ES	Futures	1069.17	1069.65	1068.92	1069.41	812.0
2009-12-10 18:00:00	ES	Futures	1069.17	1069.89	1068.68	1069.89	2404.0
2009-12-10 19:00:00	ES	Futures	1069.89	1070.14	1068.2	1068.44	1761.0
2009-12-10 20:00:00	ES	Futures	1068.68	1069.17	1067.71	1067.96	2200.0
2009-12-10 21:00:00	ES	Futures	1067.71	1070.38	1067.47	1069.65	3185.0
2009-12-10 22:00:00	ES	Futures	1069.65	1070.38	1069.41	1070.14	1005.0
2009-12-10 23:00:00	ES	Futures	1069.89	1071.1	1069.65	1070.86	2237.0
2009-12-10 00:00:00	NQ	Futures	2039.99	2042.85	2039.14	2041.13	218.0
2009-12-10 01:00:00	NQ	Futures	2041.42	2043.13	2038.85	2041.13	497.0
2009-12-10 02:00:00	NQ	Futures	2040.85	2042.28	2037.71	2040.56	878.0
2009-12-10 03:00:00	NQ	Futures	2040.56	2050.55	2038.28	2049.41	3235.0
2009-12-10 04:00:00	NQ	Futures	2049.41	2049.98	2042.85	2044.27	1392.0
2009-12-10 05:00:00	NQ	Futures	2044.27	2051.4	2043.7	2051.4	1705.0
2009-12-10 06:00:00	NQ	Futures	2051.12	2052.26	2048.83	2052.26	767.0
2009-12-10 07:00:00	NQ	Futures	2052.26	2054.82	2051.4	2054.25	1698.0
2009-12-10 08:00:00	NQ	Futures	2054.25	2057.96	2050.55	2051.12	6313.0
2009-12-10 09:00:00	NQ	Futures	2050.83	2063.09	2047.69	2055.68	35655.0
2009-12-10 10:00:00	NQ	Futures	2055.68	2061.38	2052.54	2057.96	20061.0
2009-12-10 11:00:00	NQ	Futures	2058.25	2061.67	2056.82	2057.68	12631.0
2009-12-10 12:00:00	NQ	Futures	2057.39	2060.81	2055.96	2060.53	8190.0
2009-12-10 13:00:00	NQ	Futures	2060.53	2060.53	2052.26	2056.82	11371.0
2009-12-10 14:00:00	NQ	Futures	2057.11	2059.67	2055.68	2057.39	7888.0
2009-12-10 15:00:00	NQ	Futures	2057.39	2058.82	2049.98	2051.69	11789.0
2009-12-10 16:00:00	NQ	Futures	2051.69	2054.54	2050.83	2053.97	3463.0
2009-12-10 17:00:00	NQ	Futures	2054.54	2055.39	2054.25	2055.11	51.0
2009-12-10 18:00:00	NQ	Futures	2055.11	2055.11	2054.25	2054.25	4.0
2009-12-10 19:00:00	NQ	Futures	2055.11	2055.39	2053.97	2053.97	32.0
2009-12-10 20:00:00	NQ	Futures	2053.97	2055.11	2052.83	2053.4	103.0
2009-12-10 21:00:00	NQ	Futures	2053.11	2057.39	2052.54	2056.25	247.0
2009-12-10 22:00:00	NQ	Futures	2056.54	2057.96	2056.25	2056.82	49.0
2009-12-10 23:00:00	NQ	Futures	2057.39	2058.25	2055.11	2057.96	109.0
2009-12-10 00:00:00	YM	Futures	9591.1	9607.0	9590.2	9599.6	29.0
2009-12-10 01:00:00	YM	Futures	9602.4	9608.0	9588.3	9594.9	40.0

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

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