PREVIEW / futures_1hour / 2009-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-05.parquet
  size:    44 KB
  rows:    1,315

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-10-05 00:00:00	ES	Futures	992.87	993.11	990.69	991.66	2411.0
2009-10-05 01:00:00	ES	Futures	991.9	992.38	990.44	991.41	3815.0
2009-10-05 02:00:00	ES	Futures	991.17	995.05	991.17	992.87	11545.0
2009-10-05 03:00:00	ES	Futures	992.62	994.56	990.2	994.32	24820.0
2009-10-05 04:00:00	ES	Futures	994.32	996.5	993.84	994.56	17879.0
2009-10-05 05:00:00	ES	Futures	994.8	996.02	993.84	995.05	9568.0
2009-10-05 06:00:00	ES	Futures	994.8	996.02	994.56	995.53	7884.0
2009-10-05 07:00:00	ES	Futures	995.53	996.02	994.56	995.77	12054.0
2009-10-05 08:00:00	ES	Futures	995.77	995.77	992.14	992.62	34464.0
2009-10-05 09:00:00	ES	Futures	992.62	997.71	989.48	996.74	248299.0
2009-10-05 10:00:00	ES	Futures	996.74	999.41	990.93	998.92	383195.0
2009-10-05 11:00:00	ES	Futures	999.16	1000.38	996.26	998.44	164409.0
2009-10-05 12:00:00	ES	Futures	998.44	1001.59	997.95	1000.86	104762.0
2009-10-05 13:00:00	ES	Futures	1000.86	1001.83	999.65	1000.62	74239.0
2009-10-05 14:00:00	ES	Futures	1000.86	1006.19	999.16	1004.98	189340.0
2009-10-05 15:00:00	ES	Futures	1004.98	1005.7	1002.8	1003.28	273320.0
2009-10-05 16:00:00	ES	Futures	1003.28	1005.22	1002.8	1004.74	89205.0
2009-10-05 17:00:00	ES	Futures	1004.49	1005.22	1003.77	1004.25	2085.0
2009-10-05 18:00:00	ES	Futures	1004.01	1004.74	1003.77	1004.49	2254.0
2009-10-05 19:00:00	ES	Futures	1004.49	1005.22	1003.77	1004.25	2609.0
2009-10-05 20:00:00	ES	Futures	1004.25	1004.98	1003.77	1004.25	2951.0
2009-10-05 21:00:00	ES	Futures	1004.25	1005.46	1003.28	1004.25	5067.0
2009-10-05 22:00:00	ES	Futures	1004.25	1005.95	1004.01	1005.22	3362.0
2009-10-05 23:00:00	ES	Futures	1004.98	1005.46	1003.52	1004.49	4706.0
2009-10-05 00:00:00	NQ	Futures	1902.82	1902.82	1898.25	1900.82	225.0
2009-10-05 01:00:00	NQ	Futures	1900.82	1901.67	1898.25	1899.96	321.0
2009-10-05 02:00:00	NQ	Futures	1900.53	1905.67	1899.96	1902.25	1392.0
2009-10-05 03:00:00	NQ	Futures	1901.96	1904.81	1897.4	1904.81	2848.0
2009-10-05 04:00:00	NQ	Futures	1904.81	1909.09	1904.53	1906.81	1806.0
2009-10-05 05:00:00	NQ	Futures	1907.09	1909.95	1905.67	1907.95	1870.0
2009-10-05 06:00:00	NQ	Futures	1907.95	1909.95	1907.66	1908.52	853.0
2009-10-05 07:00:00	NQ	Futures	1908.8	1909.09	1906.81	1908.8	699.0
2009-10-05 08:00:00	NQ	Futures	1908.23	1908.52	1902.53	1903.39	3249.0
2009-10-05 09:00:00	NQ	Futures	1903.1	1909.37	1896.83	1903.67	47460.0
2009-10-05 10:00:00	NQ	Futures	1903.39	1915.08	1891.41	1914.51	64768.0
2009-10-05 11:00:00	NQ	Futures	1914.51	1916.22	1903.96	1908.52	31658.0
2009-10-05 12:00:00	NQ	Futures	1908.8	1913.37	1906.24	1911.09	17417.0
2009-10-05 13:00:00	NQ	Futures	1911.09	1913.08	1908.23	1910.8	11161.0
2009-10-05 14:00:00	NQ	Futures	1910.8	1917.93	1905.38	1913.94	27474.0
2009-10-05 15:00:00	NQ	Futures	1913.94	1916.22	1908.52	1908.8	36406.0
2009-10-05 16:00:00	NQ	Futures	1908.8	1911.66	1907.66	1911.09	10211.0
2009-10-05 17:00:00	NQ	Futures	1911.09	1911.37	1910.23	1911.09	326.0
2009-10-05 18:00:00	NQ	Futures	1911.37	1911.37	1909.95	1911.09	281.0
2009-10-05 19:00:00	NQ	Futures	1911.09	1912.51	1911.09	1912.23	376.0
2009-10-05 20:00:00	NQ	Futures	1911.94	1913.65	1911.37	1912.23	598.0
2009-10-05 21:00:00	NQ	Futures	1912.23	1914.51	1911.09	1913.65	1180.0
2009-10-05 22:00:00	NQ	Futures	1913.65	1915.93	1913.08	1914.22	712.0
2009-10-05 23:00:00	NQ	Futures	1914.22	1914.79	1911.37	1913.08	532.0
2009-10-05 00:00:00	YM	Futures	8801.4	8801.4	8783.7	8793.0	154.0
2009-10-05 01:00:00	YM	Futures	8793.0	8795.8	8780.9	8790.2	182.0

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

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