PREVIEW / futures_1hour / 2009-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-11.parquet
  size:    36 KB
  rows:    1,027

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-11 00:00:00	ES	Futures	1003.97	1004.21	1002.77	1003.01	1052.0
2009-09-11 01:00:00	ES	Futures	1003.01	1003.73	1002.77	1003.25	1805.0
2009-09-11 02:00:00	ES	Futures	1003.25	1004.7	1002.77	1003.25	4796.0
2009-09-11 03:00:00	ES	Futures	1003.25	1005.18	1002.77	1004.46	9556.0
2009-09-11 04:00:00	ES	Futures	1004.21	1005.66	1003.25	1005.18	7751.0
2009-09-11 05:00:00	ES	Futures	1005.42	1007.11	1004.94	1005.9	6375.0
2009-09-11 06:00:00	ES	Futures	1005.9	1007.11	1005.42	1006.87	4451.0
2009-09-11 07:00:00	ES	Futures	1006.87	1007.11	1005.9	1006.63	5126.0
2009-09-11 08:00:00	ES	Futures	1006.63	1007.11	1005.66	1006.63	10381.0
2009-09-11 09:00:00	ES	Futures	1006.63	1011.21	1006.63	1010.0	70283.0
2009-09-11 10:00:00	ES	Futures	1010.24	1011.21	1005.9	1008.8	54918.0
2009-09-11 11:00:00	ES	Futures	1008.8	1010.24	1005.18	1006.87	45004.0
2009-09-11 12:00:00	ES	Futures	1006.63	1007.35	1001.32	1003.97	42926.0
2009-09-11 13:00:00	ES	Futures	1004.21	1005.66	1002.77	1003.01	19758.0
2009-09-11 14:00:00	ES	Futures	1002.77	1006.63	1002.77	1005.18	20909.0
2009-09-11 15:00:00	ES	Futures	1005.18	1008.07	1004.7	1005.9	29838.0
2009-09-11 16:00:00	ES	Futures	1005.9	1006.39	1004.21	1004.94	12333.0
2009-09-11 00:00:00	NQ	Futures	1917.63	1917.91	1915.92	1916.49	88.0
2009-09-11 01:00:00	NQ	Futures	1916.49	1917.91	1916.2	1917.63	96.0
2009-09-11 02:00:00	NQ	Futures	1916.77	1919.91	1915.63	1916.2	473.0
2009-09-11 03:00:00	NQ	Futures	1915.92	1919.62	1915.63	1918.48	319.0
2009-09-11 04:00:00	NQ	Futures	1918.48	1920.19	1915.35	1919.34	322.0
2009-09-11 05:00:00	NQ	Futures	1919.34	1922.19	1919.05	1919.05	240.0
2009-09-11 06:00:00	NQ	Futures	1919.34	1922.19	1919.05	1921.33	250.0
2009-09-11 07:00:00	NQ	Futures	1921.33	1925.6	1920.48	1923.32	1063.0
2009-09-11 08:00:00	NQ	Futures	1923.04	1924.18	1921.05	1923.04	804.0
2009-09-11 09:00:00	NQ	Futures	1922.76	1926.46	1916.2	1921.62	11738.0
2009-09-11 10:00:00	NQ	Futures	1921.33	1925.03	1914.5	1921.62	10577.0
2009-09-11 11:00:00	NQ	Futures	1921.9	1924.75	1914.21	1916.49	6744.0
2009-09-11 12:00:00	NQ	Futures	1916.49	1917.06	1907.09	1913.93	7577.0
2009-09-11 13:00:00	NQ	Futures	1913.64	1918.2	1911.65	1911.93	3548.0
2009-09-11 14:00:00	NQ	Futures	1911.65	1920.19	1911.65	1917.34	4755.0
2009-09-11 15:00:00	NQ	Futures	1917.63	1922.76	1916.2	1920.48	6186.0
2009-09-11 16:00:00	NQ	Futures	1920.48	1921.62	1919.62	1920.76	1227.0
2009-09-11 00:00:00	YM	Futures	8873.0	8873.0	8864.7	8865.6	177.0
2009-09-11 01:00:00	YM	Futures	8867.5	8872.1	8865.6	8868.4	225.0
2009-09-11 02:00:00	YM	Futures	8868.4	8879.5	8864.7	8867.5	316.0
2009-09-11 03:00:00	YM	Futures	8866.5	8882.3	8863.7	8874.0	655.0
2009-09-11 04:00:00	YM	Futures	8874.0	8882.3	8866.5	8879.5	757.0
2009-09-11 05:00:00	YM	Futures	8881.4	8895.4	8878.6	8887.0	443.0
2009-09-11 06:00:00	YM	Futures	8886.1	8893.5	8883.3	8892.6	292.0
2009-09-11 07:00:00	YM	Futures	8893.5	8893.5	8883.3	8888.8	328.0
2009-09-11 08:00:00	YM	Futures	8889.8	8893.5	8880.5	8888.8	1246.0
2009-09-11 09:00:00	YM	Futures	8887.9	8916.7	8882.3	8910.2	19700.0
2009-09-11 10:00:00	YM	Futures	8909.3	8918.6	8874.9	8899.1	19255.0
2009-09-11 11:00:00	YM	Futures	8899.1	8910.2	8871.2	8884.2	13036.0
2009-09-11 12:00:00	YM	Futures	8883.3	8887.9	8845.1	8863.7	11060.0
2009-09-11 13:00:00	YM	Futures	8862.8	8872.1	8851.6	8852.6	9162.0
2009-09-11 14:00:00	YM	Futures	8853.5	8881.4	8852.6	8870.2	9472.0
2009-09-11 15:00:00	YM	Futures	8869.3	8895.4	8867.5	8879.5	10246.0

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

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