PREVIEW / futures_1hour / 2009-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-04.parquet
  size:    45 KB
  rows:    1,333

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-04 00:00:00	ES	Futures	1012.49	1013.94	1012.24	1013.46	3850.0
2009-11-04 01:00:00	ES	Futures	1013.46	1014.42	1012.97	1013.46	3359.0
2009-11-04 02:00:00	ES	Futures	1013.46	1013.7	1012.0	1012.73	15368.0
2009-11-04 03:00:00	ES	Futures	1012.73	1015.88	1011.76	1015.15	36282.0
2009-11-04 04:00:00	ES	Futures	1015.15	1016.36	1014.42	1016.12	27697.0
2009-11-04 05:00:00	ES	Futures	1016.12	1016.6	1015.15	1015.64	22052.0
2009-11-04 06:00:00	ES	Futures	1015.39	1016.6	1015.15	1016.36	15104.0
2009-11-04 07:00:00	ES	Futures	1016.36	1016.6	1013.94	1014.67	24539.0
2009-11-04 08:00:00	ES	Futures	1014.42	1018.78	1012.49	1017.33	77419.0
2009-11-04 09:00:00	ES	Futures	1017.33	1019.51	1015.15	1018.3	261696.0
2009-11-04 10:00:00	ES	Futures	1018.3	1024.6	1015.88	1024.6	418760.0
2009-11-04 11:00:00	ES	Futures	1024.6	1024.6	1020.24	1020.96	156558.0
2009-11-04 12:00:00	ES	Futures	1020.96	1021.69	1018.78	1020.0	129522.0
2009-11-04 13:00:00	ES	Futures	1020.0	1020.48	1018.06	1019.27	91882.0
2009-11-04 14:00:00	ES	Futures	1019.03	1025.57	1013.46	1023.14	441404.0
2009-11-04 15:00:00	ES	Futures	1023.14	1023.39	1009.1	1011.03	509001.0
2009-11-04 16:00:00	ES	Futures	1011.03	1015.15	1010.55	1014.18	103994.0
2009-11-04 17:00:00	ES	Futures	1014.18	1014.91	1013.7	1013.7	2545.0
2009-11-04 18:00:00	ES	Futures	1014.18	1014.42	1012.0	1012.24	5605.0
2009-11-04 19:00:00	ES	Futures	1012.0	1013.46	1011.28	1011.52	6564.0
2009-11-04 20:00:00	ES	Futures	1011.52	1011.76	1010.31	1010.55	6995.0
2009-11-04 21:00:00	ES	Futures	1010.79	1012.0	1009.82	1010.79	5067.0
2009-11-04 22:00:00	ES	Futures	1010.79	1011.03	1009.58	1010.31	4411.0
2009-11-04 23:00:00	ES	Futures	1010.06	1010.79	1009.82	1010.06	1788.0
2009-11-04 00:00:00	NQ	Futures	1915.36	1917.36	1915.36	1917.36	169.0
2009-11-04 01:00:00	NQ	Futures	1917.36	1917.93	1915.36	1915.93	320.0
2009-11-04 02:00:00	NQ	Futures	1915.93	1917.08	1913.37	1915.65	1231.0
2009-11-04 03:00:00	NQ	Futures	1915.36	1919.36	1913.08	1918.22	3259.0
2009-11-04 04:00:00	NQ	Futures	1918.22	1919.07	1916.5	1918.79	2161.0
2009-11-04 05:00:00	NQ	Futures	1918.79	1919.36	1916.5	1917.36	1236.0
2009-11-04 06:00:00	NQ	Futures	1917.65	1919.64	1917.36	1919.36	825.0
2009-11-04 07:00:00	NQ	Futures	1919.36	1919.93	1915.08	1917.08	1918.0
2009-11-04 08:00:00	NQ	Futures	1916.5	1922.78	1915.93	1921.07	8399.0
2009-11-04 09:00:00	NQ	Futures	1921.07	1925.06	1916.5	1924.49	47799.0
2009-11-04 10:00:00	NQ	Futures	1924.49	1939.04	1918.22	1939.04	62546.0
2009-11-04 11:00:00	NQ	Futures	1938.75	1939.32	1931.05	1931.62	23814.0
2009-11-04 12:00:00	NQ	Futures	1931.62	1933.62	1928.48	1930.48	19692.0
2009-11-04 13:00:00	NQ	Futures	1930.48	1931.33	1925.92	1927.63	17020.0
2009-11-04 14:00:00	NQ	Futures	1927.63	1938.46	1919.07	1935.61	64924.0
2009-11-04 15:00:00	NQ	Futures	1935.61	1935.9	1911.66	1913.37	72651.0
2009-11-04 16:00:00	NQ	Futures	1913.08	1926.77	1912.8	1922.49	22638.0
2009-11-04 17:00:00	NQ	Futures	1922.49	1927.06	1922.21	1923.92	565.0
2009-11-04 18:00:00	NQ	Futures	1923.35	1923.92	1918.79	1919.36	392.0
2009-11-04 19:00:00	NQ	Futures	1919.36	1921.35	1917.65	1918.5	450.0
2009-11-04 20:00:00	NQ	Futures	1918.5	1919.36	1916.5	1916.79	476.0
2009-11-04 21:00:00	NQ	Futures	1916.79	1919.07	1915.36	1916.79	359.0
2009-11-04 22:00:00	NQ	Futures	1916.79	1917.08	1914.79	1916.22	283.0
2009-11-04 23:00:00	NQ	Futures	1915.65	1916.79	1914.79	1915.65	96.0
2009-11-04 00:00:00	YM	Futures	9070.2	9080.5	9068.4	9077.7	332.0
2009-11-04 01:00:00	YM	Futures	9077.7	9083.3	9074.0	9074.9	221.0

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

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