PREVIEW / futures_1hour / 2009-09-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	998.91	1000.11	998.67	999.63	2131.0
2009-09-10 01:00:00	ES	Futures	999.63	1001.32	999.39	1001.08	6300.0
2009-09-10 02:00:00	ES	Futures	1000.84	1001.56	1000.36	1000.84	13397.0
2009-09-10 03:00:00	ES	Futures	1000.84	1002.04	997.22	997.7	25413.0
2009-09-10 04:00:00	ES	Futures	997.94	999.39	997.46	999.39	11110.0
2009-09-10 05:00:00	ES	Futures	999.39	999.63	994.57	994.81	15086.0
2009-09-10 06:00:00	ES	Futures	995.05	995.29	992.4	992.88	21363.0
2009-09-10 07:00:00	ES	Futures	993.12	996.74	992.88	995.77	22664.0
2009-09-10 08:00:00	ES	Futures	995.77	998.91	994.09	996.98	52810.0
2009-09-10 09:00:00	ES	Futures	996.98	997.7	991.19	994.33	144638.0
2009-09-10 10:00:00	ES	Futures	994.33	999.87	993.84	999.63	133737.0
2009-09-10 11:00:00	ES	Futures	999.63	1001.32	997.94	998.91	93333.0
2009-09-10 12:00:00	ES	Futures	998.91	1000.6	997.94	1000.11	28991.0
2009-09-10 13:00:00	ES	Futures	1000.36	1005.9	999.39	1005.66	110573.0
2009-09-10 14:00:00	ES	Futures	1005.66	1006.63	1004.21	1004.94	54002.0
2009-09-10 15:00:00	ES	Futures	1005.18	1007.11	1001.56	1006.14	96973.0
2009-09-10 16:00:00	ES	Futures	1006.14	1006.39	1004.21	1004.46	38755.0
2009-09-10 17:00:00	ES	Futures	1004.46	1005.18	1004.21	1004.94	1015.0
2009-09-10 18:00:00	ES	Futures	1004.94	1004.94	1003.49	1003.73	1704.0
2009-09-10 19:00:00	ES	Futures	1003.97	1004.21	1003.25	1003.25	829.0
2009-09-10 20:00:00	ES	Futures	1003.49	1003.97	1002.53	1002.77	2673.0
2009-09-10 21:00:00	ES	Futures	1003.01	1003.73	1002.53	1003.01	2153.0
2009-09-10 22:00:00	ES	Futures	1002.77	1003.97	1002.53	1003.49	2655.0
2009-09-10 23:00:00	ES	Futures	1003.49	1004.94	1003.49	1003.97	1788.0
2009-09-10 00:00:00	NQ	Futures	1904.81	1906.24	1904.53	1905.67	178.0
2009-09-10 01:00:00	NQ	Futures	1905.95	1909.37	1905.67	1908.8	593.0
2009-09-10 02:00:00	NQ	Futures	1908.51	1910.51	1908.23	1908.8	854.0
2009-09-10 03:00:00	NQ	Futures	1909.08	1910.51	1901.39	1901.96	3035.0
2009-09-10 04:00:00	NQ	Futures	1902.25	1905.38	1902.25	1904.81	1085.0
2009-09-10 05:00:00	NQ	Futures	1904.53	1905.67	1896.84	1897.41	1278.0
2009-09-10 06:00:00	NQ	Futures	1897.41	1898.26	1893.13	1894.27	1310.0
2009-09-10 07:00:00	NQ	Futures	1894.56	1901.68	1893.99	1899.4	1500.0
2009-09-10 08:00:00	NQ	Futures	1899.69	1904.53	1896.55	1902.25	4193.0
2009-09-10 09:00:00	NQ	Futures	1902.25	1909.37	1898.83	1903.67	23270.0
2009-09-10 10:00:00	NQ	Futures	1903.67	1910.79	1896.84	1908.8	20310.0
2009-09-10 11:00:00	NQ	Futures	1908.8	1912.5	1904.24	1908.23	11647.0
2009-09-10 12:00:00	NQ	Futures	1907.95	1910.22	1906.24	1909.65	3509.0
2009-09-10 13:00:00	NQ	Futures	1909.37	1919.05	1907.95	1918.48	12462.0
2009-09-10 14:00:00	NQ	Futures	1918.77	1920.76	1916.49	1917.34	15204.0
2009-09-10 15:00:00	NQ	Futures	1917.06	1921.33	1911.08	1918.77	12919.0
2009-09-10 16:00:00	NQ	Futures	1918.77	1921.33	1917.06	1919.34	4326.0
2009-09-10 17:00:00	NQ	Futures	1919.05	1920.76	1918.77	1920.76	228.0
2009-09-10 18:00:00	NQ	Futures	1919.91	1919.91	1918.2	1919.05	49.0
2009-09-10 19:00:00	NQ	Futures	1918.77	1918.77	1917.34	1917.34	54.0
2009-09-10 20:00:00	NQ	Futures	1917.34	1918.48	1915.63	1917.06	199.0
2009-09-10 21:00:00	NQ	Futures	1917.34	1917.91	1915.92	1916.2	137.0
2009-09-10 22:00:00	NQ	Futures	1916.49	1918.2	1915.92	1918.2	90.0
2009-09-10 23:00:00	NQ	Futures	1918.2	1919.91	1917.63	1917.91	71.0
2009-09-10 00:00:00	YM	Futures	8839.5	8848.8	8838.6	8846.1	52.0
2009-09-10 01:00:00	YM	Futures	8847.0	8860.9	8844.2	8860.9	22.0

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

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