PREVIEW / futures_1hour / 2009-11-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	1009.82	1011.52	1009.58	1010.79	3725.0
2009-11-05 01:00:00	ES	Futures	1010.55	1011.52	1009.82	1010.06	2247.0
2009-11-05 02:00:00	ES	Futures	1010.06	1011.52	1009.1	1010.06	9152.0
2009-11-05 03:00:00	ES	Futures	1009.82	1011.52	1006.92	1007.4	46410.0
2009-11-05 04:00:00	ES	Futures	1007.16	1014.67	1006.67	1013.21	43116.0
2009-11-05 05:00:00	ES	Futures	1012.97	1014.42	1011.52	1014.18	24229.0
2009-11-05 06:00:00	ES	Futures	1014.18	1015.88	1012.97	1013.46	16752.0
2009-11-05 07:00:00	ES	Futures	1013.7	1016.6	1012.97	1016.12	33735.0
2009-11-05 08:00:00	ES	Futures	1016.12	1019.75	1014.42	1018.54	85467.0
2009-11-05 09:00:00	ES	Futures	1018.3	1023.87	1016.85	1023.39	308434.0
2009-11-05 10:00:00	ES	Futures	1023.39	1028.96	1021.93	1027.99	359431.0
2009-11-05 11:00:00	ES	Futures	1027.99	1028.96	1022.9	1023.39	217039.0
2009-11-05 12:00:00	ES	Futures	1023.39	1027.99	1022.9	1027.99	132386.0
2009-11-05 13:00:00	ES	Futures	1027.75	1029.93	1026.54	1027.02	118011.0
2009-11-05 14:00:00	ES	Futures	1027.02	1029.68	1025.32	1028.96	128047.0
2009-11-05 15:00:00	ES	Futures	1028.96	1030.9	1027.26	1030.65	278400.0
2009-11-05 16:00:00	ES	Futures	1030.65	1031.14	1029.44	1030.65	99665.0
2009-11-05 17:00:00	ES	Futures	1030.9	1031.38	1030.41	1030.65	2420.0
2009-11-05 18:00:00	ES	Futures	1030.9	1030.9	1029.44	1029.68	4045.0
2009-11-05 19:00:00	ES	Futures	1029.68	1030.65	1029.2	1029.93	3285.0
2009-11-05 20:00:00	ES	Futures	1029.93	1030.17	1029.44	1029.93	1744.0
2009-11-05 21:00:00	ES	Futures	1029.93	1030.65	1029.44	1029.68	2047.0
2009-11-05 22:00:00	ES	Futures	1029.68	1030.65	1029.2	1029.93	2212.0
2009-11-05 23:00:00	ES	Futures	1029.93	1030.17	1028.47	1028.47	4192.0
2009-11-05 00:00:00	NQ	Futures	1915.93	1917.93	1915.08	1916.5	184.0
2009-11-05 01:00:00	NQ	Futures	1916.5	1918.79	1916.5	1917.36	177.0
2009-11-05 02:00:00	NQ	Futures	1916.22	1918.22	1913.65	1915.08	883.0
2009-11-05 03:00:00	NQ	Futures	1914.79	1917.08	1906.81	1907.38	4930.0
2009-11-05 04:00:00	NQ	Futures	1907.38	1920.5	1906.81	1917.65	2624.0
2009-11-05 05:00:00	NQ	Futures	1917.08	1920.5	1915.08	1920.21	1025.0
2009-11-05 06:00:00	NQ	Futures	1920.21	1922.78	1917.08	1919.64	914.0
2009-11-05 07:00:00	NQ	Futures	1919.07	1927.91	1918.22	1927.34	3590.0
2009-11-05 08:00:00	NQ	Futures	1927.63	1937.32	1925.63	1935.33	8761.0
2009-11-05 09:00:00	NQ	Futures	1935.04	1951.01	1934.76	1949.87	58056.0
2009-11-05 10:00:00	NQ	Futures	1949.87	1964.42	1948.73	1961.57	67730.0
2009-11-05 11:00:00	NQ	Futures	1961.57	1963.28	1952.15	1953.01	35043.0
2009-11-05 12:00:00	NQ	Futures	1953.01	1959.85	1952.15	1959.57	27550.0
2009-11-05 13:00:00	NQ	Futures	1959.57	1962.42	1955.29	1957.29	18891.0
2009-11-05 14:00:00	NQ	Futures	1957.57	1961.85	1955.58	1960.42	22242.0
2009-11-05 15:00:00	NQ	Futures	1960.14	1962.14	1954.72	1961.57	42135.0
2009-11-05 16:00:00	NQ	Futures	1961.28	1962.99	1960.14	1962.42	14734.0
2009-11-05 17:00:00	NQ	Futures	1961.85	1962.71	1961.28	1962.42	344.0
2009-11-05 18:00:00	NQ	Futures	1961.28	1962.42	1960.14	1961.0	358.0
2009-11-05 19:00:00	NQ	Futures	1960.42	1962.14	1959.85	1961.0	229.0
2009-11-05 20:00:00	NQ	Futures	1961.0	1961.57	1960.42	1961.28	93.0
2009-11-05 21:00:00	NQ	Futures	1961.28	1961.85	1960.14	1960.42	255.0
2009-11-05 22:00:00	NQ	Futures	1960.71	1961.85	1959.85	1960.71	132.0
2009-11-05 23:00:00	NQ	Futures	1960.71	1960.71	1958.71	1958.71	247.0
2009-11-05 00:00:00	YM	Futures	9066.5	9076.7	9061.9	9071.2	211.0
2009-11-05 01:00:00	YM	Futures	9072.1	9078.6	9067.4	9067.4	285.0

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

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