PREVIEW / futures_1hour / 2009-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-03.parquet
  size:    46 KB
  rows:    1,343

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-11-03 00:00:00	ES	Futures	1008.61	1009.1	1007.88	1008.37	1816.0
2009-11-03 01:00:00	ES	Futures	1008.37	1009.1	1007.16	1007.16	3861.0
2009-11-03 02:00:00	ES	Futures	1007.4	1007.4	1004.01	1004.98	14591.0
2009-11-03 03:00:00	ES	Futures	1004.98	1005.22	1000.38	1001.1	41042.0
2009-11-03 04:00:00	ES	Futures	1001.34	1003.04	996.26	996.74	40373.0
2009-11-03 05:00:00	ES	Futures	996.98	998.68	995.29	998.68	38120.0
2009-11-03 06:00:00	ES	Futures	998.68	998.92	994.56	996.02	29866.0
2009-11-03 07:00:00	ES	Futures	996.02	1001.1	995.53	999.89	58252.0
2009-11-03 08:00:00	ES	Futures	999.65	1003.04	998.68	999.65	81959.0
2009-11-03 09:00:00	ES	Futures	999.41	1006.67	998.68	1004.98	308616.0
2009-11-03 10:00:00	ES	Futures	1005.22	1008.13	1000.62	1004.49	427568.0
2009-11-03 11:00:00	ES	Futures	1004.74	1006.43	998.92	1002.56	234979.0
2009-11-03 12:00:00	ES	Futures	1002.31	1009.1	999.89	1005.22	207555.0
2009-11-03 13:00:00	ES	Futures	1005.22	1007.88	1004.25	1007.88	142307.0
2009-11-03 14:00:00	ES	Futures	1007.88	1010.55	1004.01	1005.22	226892.0
2009-11-03 15:00:00	ES	Futures	1004.98	1010.31	1004.49	1009.34	327278.0
2009-11-03 16:00:00	ES	Futures	1009.34	1010.31	1008.61	1009.34	87981.0
2009-11-03 17:00:00	ES	Futures	1009.34	1009.58	1008.85	1009.58	1340.0
2009-11-03 18:00:00	ES	Futures	1009.34	1010.79	1008.37	1010.55	4256.0
2009-11-03 19:00:00	ES	Futures	1010.55	1011.03	1009.1	1010.79	4239.0
2009-11-03 20:00:00	ES	Futures	1010.79	1011.52	1010.55	1010.79	3904.0
2009-11-03 21:00:00	ES	Futures	1011.03	1012.97	1010.31	1012.49	6735.0
2009-11-03 22:00:00	ES	Futures	1012.49	1013.21	1012.0	1012.49	3488.0
2009-11-03 23:00:00	ES	Futures	1012.73	1012.97	1011.76	1012.49	2227.0
2009-11-03 00:00:00	NQ	Futures	1906.52	1907.09	1905.38	1905.67	122.0
2009-11-03 01:00:00	NQ	Futures	1905.67	1906.81	1903.96	1904.24	140.0
2009-11-03 02:00:00	NQ	Futures	1903.96	1903.96	1898.54	1899.96	1004.0
2009-11-03 03:00:00	NQ	Futures	1899.96	1900.82	1892.55	1894.26	3003.0
2009-11-03 04:00:00	NQ	Futures	1894.26	1897.11	1885.13	1886.27	2864.0
2009-11-03 05:00:00	NQ	Futures	1886.27	1892.26	1883.42	1890.27	3563.0
2009-11-03 06:00:00	NQ	Futures	1890.55	1890.84	1883.99	1887.13	2290.0
2009-11-03 07:00:00	NQ	Futures	1887.13	1897.4	1885.99	1893.97	4638.0
2009-11-03 08:00:00	NQ	Futures	1894.54	1900.53	1892.83	1895.69	6489.0
2009-11-03 09:00:00	NQ	Futures	1895.69	1902.82	1891.41	1900.25	53754.0
2009-11-03 10:00:00	NQ	Futures	1900.25	1907.38	1891.98	1898.82	62541.0
2009-11-03 11:00:00	NQ	Futures	1898.54	1902.82	1891.41	1897.4	33123.0
2009-11-03 12:00:00	NQ	Futures	1897.4	1909.09	1892.26	1903.39	33692.0
2009-11-03 13:00:00	NQ	Futures	1903.67	1909.09	1901.67	1908.52	20829.0
2009-11-03 14:00:00	NQ	Futures	1908.23	1911.94	1902.25	1905.38	38169.0
2009-11-03 15:00:00	NQ	Futures	1905.38	1913.65	1903.1	1910.52	46393.0
2009-11-03 16:00:00	NQ	Futures	1911.09	1912.23	1909.09	1910.52	8925.0
2009-11-03 17:00:00	NQ	Futures	1909.95	1910.52	1909.66	1910.52	83.0
2009-11-03 18:00:00	NQ	Futures	1910.52	1913.08	1909.37	1912.8	226.0
2009-11-03 19:00:00	NQ	Futures	1912.8	1914.22	1909.95	1913.08	500.0
2009-11-03 20:00:00	NQ	Futures	1913.37	1914.22	1913.08	1913.08	136.0
2009-11-03 21:00:00	NQ	Futures	1913.37	1916.5	1912.23	1915.93	636.0
2009-11-03 22:00:00	NQ	Futures	1915.93	1916.79	1915.08	1915.36	278.0
2009-11-03 23:00:00	NQ	Futures	1915.36	1915.93	1914.22	1915.36	203.0
2009-11-03 00:00:00	YM	Futures	9068.4	9073.0	9065.6	9065.6	152.0
2009-11-03 01:00:00	YM	Futures	9066.5	9069.3	9057.2	9057.2	245.0

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

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