PREVIEW / futures_1hour / 2009-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-28.parquet
  size:    42 KB
  rows:    1,284

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-28 00:00:00	ES	Futures	1004.49	1006.92	1004.49	1006.19	2869.0
2009-09-28 01:00:00	ES	Futures	1005.95	1006.92	1004.98	1005.22	2885.0
2009-09-28 02:00:00	ES	Futures	1005.46	1008.85	1005.22	1008.61	11592.0
2009-09-28 03:00:00	ES	Futures	1008.37	1010.79	1004.74	1005.95	37586.0
2009-09-28 04:00:00	ES	Futures	1005.95	1010.31	1005.46	1008.85	20009.0
2009-09-28 05:00:00	ES	Futures	1008.61	1010.55	1008.61	1009.1	8765.0
2009-09-28 06:00:00	ES	Futures	1009.34	1011.52	1008.61	1011.03	13624.0
2009-09-28 07:00:00	ES	Futures	1011.03	1012.97	1010.55	1012.0	21808.0
2009-09-28 08:00:00	ES	Futures	1012.0	1015.39	1011.76	1012.49	47940.0
2009-09-28 09:00:00	ES	Futures	1012.49	1020.0	1011.28	1019.03	237280.0
2009-09-28 10:00:00	ES	Futures	1019.03	1024.11	1018.78	1022.9	276477.0
2009-09-28 11:00:00	ES	Futures	1022.66	1026.05	1022.66	1025.08	154155.0
2009-09-28 12:00:00	ES	Futures	1025.08	1027.26	1024.6	1024.84	102812.0
2009-09-28 13:00:00	ES	Futures	1024.84	1027.99	1024.84	1025.57	91771.0
2009-09-28 14:00:00	ES	Futures	1025.57	1026.54	1024.11	1024.6	133949.0
2009-09-28 15:00:00	ES	Futures	1024.36	1026.29	1022.9	1025.57	202547.0
2009-09-28 16:00:00	ES	Futures	1025.57	1027.02	1024.84	1026.78	108220.0
2009-09-28 17:00:00	ES	Futures	1026.54	1027.02	1026.05	1026.78	2133.0
2009-09-28 18:00:00	ES	Futures	1026.54	1027.02	1026.29	1026.78	925.0
2009-09-28 19:00:00	ES	Futures	1026.78	1027.99	1026.54	1027.02	3055.0
2009-09-28 20:00:00	ES	Futures	1027.26	1027.26	1024.84	1026.05	7136.0
2009-09-28 21:00:00	ES	Futures	1026.05	1026.29	1025.32	1026.05	2798.0
2009-09-28 22:00:00	ES	Futures	1026.05	1027.26	1025.57	1026.05	3068.0
2009-09-28 23:00:00	ES	Futures	1026.05	1027.26	1025.08	1026.29	3041.0
2009-09-28 00:00:00	NQ	Futures	1927.91	1931.05	1927.06	1929.91	454.0
2009-09-28 01:00:00	NQ	Futures	1930.19	1931.33	1927.34	1928.48	448.0
2009-09-28 02:00:00	NQ	Futures	1928.48	1936.18	1928.48	1934.47	1387.0
2009-09-28 03:00:00	NQ	Futures	1934.47	1939.32	1927.91	1930.19	3209.0
2009-09-28 04:00:00	NQ	Futures	1930.19	1939.32	1929.62	1935.33	1824.0
2009-09-28 05:00:00	NQ	Futures	1935.61	1938.75	1935.61	1936.75	927.0
2009-09-28 06:00:00	NQ	Futures	1936.75	1941.89	1935.61	1939.89	1180.0
2009-09-28 07:00:00	NQ	Futures	1939.61	1944.17	1939.61	1942.17	1789.0
2009-09-28 08:00:00	NQ	Futures	1942.17	1948.73	1941.32	1943.6	5467.0
2009-09-28 09:00:00	NQ	Futures	1943.31	1960.14	1940.18	1958.14	46341.0
2009-09-28 10:00:00	NQ	Futures	1957.86	1970.69	1957.86	1968.98	55389.0
2009-09-28 11:00:00	NQ	Futures	1968.98	1974.68	1967.27	1972.4	29186.0
2009-09-28 12:00:00	NQ	Futures	1972.4	1976.4	1970.69	1971.26	17304.0
2009-09-28 13:00:00	NQ	Futures	1971.55	1975.54	1968.12	1968.7	15034.0
2009-09-28 14:00:00	NQ	Futures	1968.7	1970.12	1965.27	1966.7	20498.0
2009-09-28 15:00:00	NQ	Futures	1966.41	1969.27	1961.28	1964.99	31421.0
2009-09-28 16:00:00	NQ	Futures	1964.99	1966.98	1962.99	1965.27	14880.0
2009-09-28 17:00:00	NQ	Futures	1964.99	1965.84	1964.7	1965.27	150.0
2009-09-28 18:00:00	NQ	Futures	1964.7	1966.98	1964.42	1965.56	754.0
2009-09-28 19:00:00	NQ	Futures	1965.56	1967.55	1965.56	1966.41	286.0
2009-09-28 20:00:00	NQ	Futures	1966.13	1966.41	1962.42	1964.7	631.0
2009-09-28 21:00:00	NQ	Futures	1964.99	1964.99	1963.28	1964.13	483.0
2009-09-28 22:00:00	NQ	Futures	1964.7	1966.13	1962.71	1964.13	419.0
2009-09-28 23:00:00	NQ	Futures	1964.13	1966.13	1962.71	1964.42	370.0
2009-09-28 00:00:00	YM	Futures	8913.0	8927.9	8911.2	8923.3	273.0
2009-09-28 01:00:00	YM	Futures	8923.3	8927.9	8914.0	8915.8	240.0

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

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