PREVIEW / futures_1hour / 2009-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-14.parquet
  size:    41 KB
  rows:    1,253

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-14 00:00:00	ES	Futures	995.77	996.5	994.8	995.05	2035.0
2009-09-14 01:00:00	ES	Futures	995.29	996.26	994.32	995.77	2928.0
2009-09-14 02:00:00	ES	Futures	996.02	997.71	995.29	997.23	9454.0
2009-09-14 03:00:00	ES	Futures	997.23	998.92	996.26	997.71	31368.0
2009-09-14 04:00:00	ES	Futures	997.71	998.2	994.32	995.05	18150.0
2009-09-14 05:00:00	ES	Futures	995.29	996.98	994.56	996.02	8966.0
2009-09-14 06:00:00	ES	Futures	996.02	998.44	996.02	996.98	8478.0
2009-09-14 07:00:00	ES	Futures	996.74	998.2	996.26	997.71	8709.0
2009-09-14 08:00:00	ES	Futures	997.95	998.92	996.98	998.68	15854.0
2009-09-14 09:00:00	ES	Futures	998.68	1002.8	997.23	1002.31	202259.0
2009-09-14 10:00:00	ES	Futures	1002.07	1006.67	1000.13	1005.22	327306.0
2009-09-14 11:00:00	ES	Futures	1005.22	1007.64	1004.01	1004.49	146527.0
2009-09-14 12:00:00	ES	Futures	1004.49	1005.95	1004.25	1005.46	61217.0
2009-09-14 13:00:00	ES	Futures	1005.7	1007.4	1004.01	1006.92	118249.0
2009-09-14 14:00:00	ES	Futures	1006.92	1010.79	1006.19	1010.31	197850.0
2009-09-14 15:00:00	ES	Futures	1010.06	1012.73	1009.1	1011.52	252561.0
2009-09-14 16:00:00	ES	Futures	1011.52	1011.76	1010.06	1010.55	82662.0
2009-09-14 17:00:00	ES	Futures	1010.55	1010.55	1010.06	1010.06	2013.0
2009-09-14 18:00:00	ES	Futures	1010.31	1010.31	1009.58	1009.58	2450.0
2009-09-14 19:00:00	ES	Futures	1009.82	1010.06	1009.1	1009.58	2060.0
2009-09-14 20:00:00	ES	Futures	1009.82	1010.31	1009.1	1009.34	2485.0
2009-09-14 21:00:00	ES	Futures	1009.34	1009.58	1007.88	1008.37	4764.0
2009-09-14 22:00:00	ES	Futures	1008.37	1008.85	1007.88	1008.13	3192.0
2009-09-14 23:00:00	ES	Futures	1008.13	1008.85	1007.64	1008.61	1883.0
2009-09-14 00:00:00	NQ	Futures	1905.1	1906.81	1903.1	1903.1	179.0
2009-09-14 01:00:00	NQ	Futures	1903.1	1905.95	1902.25	1905.38	365.0
2009-09-14 02:00:00	NQ	Futures	1904.81	1908.23	1903.96	1906.24	1148.0
2009-09-14 03:00:00	NQ	Futures	1906.52	1908.52	1904.24	1905.38	2816.0
2009-09-14 04:00:00	NQ	Futures	1905.1	1905.95	1899.68	1901.1	1671.0
2009-09-14 05:00:00	NQ	Futures	1900.82	1904.53	1900.25	1903.1	625.0
2009-09-14 06:00:00	NQ	Futures	1903.67	1907.09	1903.39	1903.39	727.0
2009-09-14 07:00:00	NQ	Futures	1903.67	1906.81	1902.25	1906.81	907.0
2009-09-14 08:00:00	NQ	Futures	1906.81	1908.8	1905.67	1908.52	1438.0
2009-09-14 09:00:00	NQ	Futures	1908.8	1918.22	1906.52	1918.22	33958.0
2009-09-14 10:00:00	NQ	Futures	1918.22	1923.63	1913.65	1921.64	40214.0
2009-09-14 11:00:00	NQ	Futures	1921.64	1925.06	1916.79	1917.65	24387.0
2009-09-14 12:00:00	NQ	Futures	1917.93	1922.21	1917.36	1921.64	10130.0
2009-09-14 13:00:00	NQ	Futures	1921.64	1924.49	1917.93	1922.78	17170.0
2009-09-14 14:00:00	NQ	Futures	1922.78	1928.77	1920.78	1927.34	26603.0
2009-09-14 15:00:00	NQ	Futures	1927.34	1929.91	1923.06	1928.48	30647.0
2009-09-14 16:00:00	NQ	Futures	1928.77	1929.05	1923.06	1923.35	9744.0
2009-09-14 17:00:00	NQ	Futures	1923.35	1923.63	1921.07	1922.21	1132.0
2009-09-14 18:00:00	NQ	Futures	1922.21	1922.49	1920.78	1921.92	353.0
2009-09-14 19:00:00	NQ	Futures	1921.92	1922.49	1921.07	1922.21	254.0
2009-09-14 20:00:00	NQ	Futures	1921.35	1922.78	1920.5	1921.64	252.0
2009-09-14 21:00:00	NQ	Futures	1921.07	1921.07	1919.07	1920.5	657.0
2009-09-14 22:00:00	NQ	Futures	1920.5	1921.35	1919.36	1920.21	301.0
2009-09-14 23:00:00	NQ	Futures	1919.64	1921.07	1919.07	1920.21	98.0
2009-09-14 00:00:00	YM	Futures	8794.9	8800.5	8788.4	8790.2	239.0
2009-09-14 01:00:00	YM	Futures	8790.2	8798.6	8783.7	8793.0	291.0

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

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