PREVIEW / futures_1hour / 2009-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-02.parquet
  size:    38 KB
  rows:    1,077

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-02 00:00:00	ES	Futures	993.11	994.08	992.38	992.62	2795.0
2009-10-02 01:00:00	ES	Futures	992.62	993.59	991.9	992.62	5155.0
2009-10-02 02:00:00	ES	Futures	992.62	993.59	992.14	992.62	10124.0
2009-10-02 03:00:00	ES	Futures	992.38	994.56	990.44	993.35	41011.0
2009-10-02 04:00:00	ES	Futures	993.11	994.08	991.41	993.11	16555.0
2009-10-02 05:00:00	ES	Futures	993.11	995.05	991.41	991.66	16337.0
2009-10-02 06:00:00	ES	Futures	991.66	993.84	991.41	991.66	15473.0
2009-10-02 07:00:00	ES	Futures	991.9	993.59	991.41	992.62	20185.0
2009-10-02 08:00:00	ES	Futures	992.62	992.87	981.0	981.48	245710.0
2009-10-02 09:00:00	ES	Futures	981.48	989.23	980.51	986.81	457355.0
2009-10-02 10:00:00	ES	Futures	986.81	994.32	984.87	989.23	598616.0
2009-10-02 11:00:00	ES	Futures	989.23	992.38	987.05	987.78	257680.0
2009-10-02 12:00:00	ES	Futures	987.78	992.62	987.78	991.17	189058.0
2009-10-02 13:00:00	ES	Futures	991.17	994.08	990.93	992.14	160280.0
2009-10-02 14:00:00	ES	Futures	992.14	993.59	990.44	991.41	156708.0
2009-10-02 15:00:00	ES	Futures	991.41	992.14	987.3	989.23	232472.0
2009-10-02 16:00:00	ES	Futures	989.23	990.69	988.26	990.2	90128.0
2009-10-02 00:00:00	NQ	Futures	1900.53	1901.96	1899.96	1899.96	178.0
2009-10-02 01:00:00	NQ	Futures	1899.96	1901.39	1898.82	1899.96	289.0
2009-10-02 02:00:00	NQ	Futures	1900.25	1901.1	1899.11	1899.96	629.0
2009-10-02 03:00:00	NQ	Futures	1899.96	1903.39	1896.26	1900.25	3560.0
2009-10-02 04:00:00	NQ	Futures	1899.96	1900.82	1896.83	1899.39	2213.0
2009-10-02 05:00:00	NQ	Futures	1899.39	1903.39	1897.11	1897.68	1402.0
2009-10-02 06:00:00	NQ	Futures	1898.25	1901.39	1897.68	1897.68	1148.0
2009-10-02 07:00:00	NQ	Futures	1897.97	1901.39	1897.4	1899.68	1469.0
2009-10-02 08:00:00	NQ	Futures	1900.25	1900.53	1882.0	1883.14	23310.0
2009-10-02 09:00:00	NQ	Futures	1882.85	1903.39	1882.0	1899.11	81580.0
2009-10-02 10:00:00	NQ	Futures	1899.11	1910.52	1895.69	1899.39	84935.0
2009-10-02 11:00:00	NQ	Futures	1899.68	1903.67	1893.69	1895.97	43914.0
2009-10-02 12:00:00	NQ	Futures	1895.97	1906.24	1895.69	1903.39	33293.0
2009-10-02 13:00:00	NQ	Futures	1903.39	1907.38	1901.96	1903.96	18074.0
2009-10-02 14:00:00	NQ	Futures	1903.96	1905.95	1899.96	1902.53	19211.0
2009-10-02 15:00:00	NQ	Futures	1902.82	1904.24	1892.55	1893.97	37628.0
2009-10-02 16:00:00	NQ	Futures	1893.97	1896.54	1893.4	1895.97	10697.0
2009-10-02 00:00:00	YM	Futures	8785.6	8792.1	8782.8	8785.6	169.0
2009-10-02 01:00:00	YM	Futures	8785.6	8790.2	8780.0	8783.7	158.0
2009-10-02 02:00:00	YM	Futures	8782.8	8790.2	8780.9	8784.7	591.0
2009-10-02 03:00:00	YM	Futures	8784.7	8798.6	8765.1	8787.5	1970.0
2009-10-02 04:00:00	YM	Futures	8787.5	8792.1	8774.4	8785.6	753.0
2009-10-02 05:00:00	YM	Futures	8786.5	8798.6	8770.7	8773.5	761.0
2009-10-02 06:00:00	YM	Futures	8774.4	8788.4	8773.5	8774.4	768.0
2009-10-02 07:00:00	YM	Futures	8773.5	8786.5	8773.5	8780.9	972.0
2009-10-02 08:00:00	YM	Futures	8780.9	8783.7	8684.2	8691.6	13610.0
2009-10-02 09:00:00	YM	Futures	8692.6	8756.8	8686.1	8738.2	32686.0
2009-10-02 10:00:00	YM	Futures	8737.2	8790.2	8720.5	8762.3	46397.0
2009-10-02 11:00:00	YM	Futures	8760.5	8790.2	8750.2	8762.3	20182.0
2009-10-02 12:00:00	YM	Futures	8762.3	8791.2	8762.3	8780.0	15543.0
2009-10-02 13:00:00	YM	Futures	8780.9	8805.1	8776.3	8788.4	13311.0
2009-10-02 14:00:00	YM	Futures	8789.3	8803.3	8775.4	8789.3	11018.0
2009-10-02 15:00:00	YM	Futures	8788.4	8794.9	8753.0	8767.0	16151.0

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

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