PREVIEW / futures_1hour / 2009-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-15.parquet
  size:    44 KB
  rows:    1,269

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-09-15 00:00:00	ES	Futures	1008.61	1009.34	1007.88	1008.37	1662.0
2009-09-15 01:00:00	ES	Futures	1008.13	1009.34	1007.4	1008.85	2367.0
2009-09-15 02:00:00	ES	Futures	1008.85	1011.03	1008.85	1010.06	6511.0
2009-09-15 03:00:00	ES	Futures	1010.31	1010.79	1007.4	1008.13	27630.0
2009-09-15 04:00:00	ES	Futures	1008.13	1009.34	1007.4	1008.37	12820.0
2009-09-15 05:00:00	ES	Futures	1008.37	1008.85	1006.43	1008.85	13745.0
2009-09-15 06:00:00	ES	Futures	1008.61	1010.55	1008.13	1010.06	10690.0
2009-09-15 07:00:00	ES	Futures	1010.06	1012.24	1008.61	1011.52	21933.0
2009-09-15 08:00:00	ES	Futures	1011.52	1016.12	1010.06	1013.46	91116.0
2009-09-15 09:00:00	ES	Futures	1013.21	1014.91	1009.58	1011.03	336761.0
2009-09-15 10:00:00	ES	Futures	1011.28	1012.97	1005.95	1012.73	500600.0
2009-09-15 11:00:00	ES	Futures	1012.73	1013.7	1009.1	1012.73	211400.0
2009-09-15 12:00:00	ES	Futures	1012.73	1014.67	1011.76	1014.18	149886.0
2009-09-15 13:00:00	ES	Futures	1014.18	1017.33	1013.7	1016.6	191791.0
2009-09-15 14:00:00	ES	Futures	1016.85	1017.09	1013.7	1015.64	150840.0
2009-09-15 15:00:00	ES	Futures	1015.64	1019.27	1014.42	1015.39	311245.0
2009-09-15 16:00:00	ES	Futures	1015.39	1015.64	1012.0	1012.24	126785.0
2009-09-15 17:00:00	ES	Futures	1012.24	1013.21	1012.24	1012.73	2079.0
2009-09-15 18:00:00	ES	Futures	1012.97	1014.42	1012.73	1013.94	6464.0
2009-09-15 19:00:00	ES	Futures	1013.7	1014.42	1012.97	1014.18	1397.0
2009-09-15 20:00:00	ES	Futures	1014.18	1015.15	1013.94	1015.15	3104.0
2009-09-15 21:00:00	ES	Futures	1015.15	1015.64	1013.46	1014.42	4645.0
2009-09-15 22:00:00	ES	Futures	1014.42	1014.42	1012.73	1013.21	2628.0
2009-09-15 23:00:00	ES	Futures	1012.97	1016.12	1012.97	1015.39	6304.0
2009-09-15 00:00:00	NQ	Futures	1920.78	1921.64	1919.36	1919.36	100.0
2009-09-15 01:00:00	NQ	Futures	1919.64	1922.21	1919.07	1921.64	177.0
2009-09-15 02:00:00	NQ	Futures	1921.35	1926.2	1921.35	1924.2	1430.0
2009-09-15 03:00:00	NQ	Futures	1924.2	1925.63	1920.5	1922.49	1866.0
2009-09-15 04:00:00	NQ	Futures	1922.21	1923.92	1920.5	1921.07	942.0
2009-09-15 05:00:00	NQ	Futures	1921.07	1921.92	1916.22	1921.92	1554.0
2009-09-15 06:00:00	NQ	Futures	1921.92	1925.92	1921.35	1924.78	682.0
2009-09-15 07:00:00	NQ	Futures	1924.78	1927.34	1922.49	1926.2	1271.0
2009-09-15 08:00:00	NQ	Futures	1926.49	1934.19	1923.35	1926.77	7860.0
2009-09-15 09:00:00	NQ	Futures	1927.06	1937.89	1923.35	1931.33	51534.0
2009-09-15 10:00:00	NQ	Futures	1931.33	1935.9	1923.35	1935.33	58646.0
2009-09-15 11:00:00	NQ	Futures	1935.33	1937.04	1929.05	1935.33	26904.0
2009-09-15 12:00:00	NQ	Futures	1935.33	1937.04	1932.48	1936.18	17815.0
2009-09-15 13:00:00	NQ	Futures	1936.18	1939.32	1935.04	1938.18	22783.0
2009-09-15 14:00:00	NQ	Futures	1938.46	1938.75	1933.05	1935.61	23833.0
2009-09-15 15:00:00	NQ	Futures	1935.61	1941.6	1933.9	1934.47	41855.0
2009-09-15 16:00:00	NQ	Futures	1934.47	1935.33	1931.33	1932.19	10311.0
2009-09-15 17:00:00	NQ	Futures	1932.76	1932.76	1931.91	1932.48	145.0
2009-09-15 18:00:00	NQ	Futures	1932.48	1935.9	1932.48	1935.33	1025.0
2009-09-15 19:00:00	NQ	Futures	1935.33	1935.61	1934.47	1935.33	215.0
2009-09-15 20:00:00	NQ	Futures	1935.33	1937.61	1935.04	1937.32	429.0
2009-09-15 21:00:00	NQ	Futures	1937.89	1938.46	1935.33	1937.61	369.0
2009-09-15 22:00:00	NQ	Futures	1937.04	1937.04	1933.62	1934.19	345.0
2009-09-15 23:00:00	NQ	Futures	1934.19	1939.89	1934.19	1937.61	1142.0
2009-09-15 00:00:00	YM	Futures	8868.4	8872.1	8862.8	8864.7	122.0
2009-09-15 01:00:00	YM	Futures	8863.7	8873.0	8859.1	8869.3	150.0

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

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