PREVIEW / futures_1hour / 2009-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-27.parquet
  size:    45 KB
  rows:    1,338

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-27 00:00:00	ES	Futures	1031.62	1032.11	1030.65	1030.65	3229.0
2009-10-27 01:00:00	ES	Futures	1030.9	1031.86	1030.65	1031.62	2232.0
2009-10-27 02:00:00	ES	Futures	1031.86	1033.56	1031.62	1033.32	3355.0
2009-10-27 03:00:00	ES	Futures	1033.08	1034.04	1031.86	1033.32	11227.0
2009-10-27 04:00:00	ES	Futures	1033.32	1035.01	1031.38	1032.83	38785.0
2009-10-27 05:00:00	ES	Futures	1032.59	1033.56	1030.9	1032.83	22237.0
2009-10-27 06:00:00	ES	Futures	1033.08	1035.01	1032.59	1034.29	16886.0
2009-10-27 07:00:00	ES	Futures	1034.29	1036.47	1033.08	1035.01	29441.0
2009-10-27 08:00:00	ES	Futures	1034.77	1035.01	1031.86	1034.04	36300.0
2009-10-27 09:00:00	ES	Futures	1034.04	1035.5	1029.93	1031.14	289926.0
2009-10-27 10:00:00	ES	Futures	1031.14	1035.98	1024.11	1033.08	612253.0
2009-10-27 11:00:00	ES	Futures	1033.08	1034.53	1029.93	1033.8	226971.0
2009-10-27 12:00:00	ES	Futures	1033.8	1034.29	1029.2	1029.68	175337.0
2009-10-27 13:00:00	ES	Futures	1029.68	1030.9	1024.36	1027.02	286794.0
2009-10-27 14:00:00	ES	Futures	1027.02	1032.35	1024.84	1031.14	215097.0
2009-10-27 15:00:00	ES	Futures	1031.14	1031.86	1025.32	1026.78	348662.0
2009-10-27 16:00:00	ES	Futures	1026.78	1029.2	1025.32	1028.96	111690.0
2009-10-27 17:00:00	ES	Futures	1028.96	1028.96	1028.47	1028.72	1304.0
2009-10-27 18:00:00	ES	Futures	1028.72	1029.93	1028.72	1029.44	4942.0
2009-10-27 19:00:00	ES	Futures	1029.68	1029.68	1028.96	1029.68	2167.0
2009-10-27 20:00:00	ES	Futures	1029.68	1029.93	1027.75	1027.99	4341.0
2009-10-27 21:00:00	ES	Futures	1027.99	1028.96	1027.5	1028.72	4126.0
2009-10-27 22:00:00	ES	Futures	1028.72	1029.2	1026.54	1026.78	6055.0
2009-10-27 23:00:00	ES	Futures	1026.54	1027.02	1026.05	1027.02	4193.0
2009-10-27 00:00:00	NQ	Futures	1988.66	1989.23	1987.23	1987.23	128.0
2009-10-27 01:00:00	NQ	Futures	1987.52	1989.23	1986.95	1988.94	235.0
2009-10-27 02:00:00	NQ	Futures	1989.51	1992.94	1988.94	1992.37	1051.0
2009-10-27 03:00:00	NQ	Futures	1992.08	1994.93	1991.23	1992.65	1008.0
2009-10-27 04:00:00	NQ	Futures	1993.22	1995.5	1988.94	1991.8	2517.0
2009-10-27 05:00:00	NQ	Futures	1992.37	1993.79	1988.94	1991.8	1460.0
2009-10-27 06:00:00	NQ	Futures	1992.37	1995.79	1991.51	1994.36	1331.0
2009-10-27 07:00:00	NQ	Futures	1994.08	1998.36	1991.51	1994.08	2474.0
2009-10-27 08:00:00	NQ	Futures	1994.08	1994.08	1988.09	1991.51	5753.0
2009-10-27 09:00:00	NQ	Futures	1991.8	1996.93	1984.1	1984.1	57112.0
2009-10-27 10:00:00	NQ	Futures	1984.1	1993.22	1959.85	1983.81	110904.0
2009-10-27 11:00:00	NQ	Futures	1984.1	1985.81	1975.83	1978.68	42771.0
2009-10-27 12:00:00	NQ	Futures	1978.68	1979.53	1969.27	1969.84	31068.0
2009-10-27 13:00:00	NQ	Futures	1970.12	1971.83	1954.15	1960.71	68462.0
2009-10-27 14:00:00	NQ	Futures	1960.71	1971.26	1957.0	1969.27	42253.0
2009-10-27 15:00:00	NQ	Futures	1969.27	1970.41	1959.0	1961.57	56726.0
2009-10-27 16:00:00	NQ	Futures	1961.57	1963.56	1959.28	1962.99	13530.0
2009-10-27 17:00:00	NQ	Futures	1963.28	1964.13	1962.71	1963.85	524.0
2009-10-27 18:00:00	NQ	Futures	1963.56	1965.56	1963.56	1964.99	202.0
2009-10-27 19:00:00	NQ	Futures	1964.99	1965.56	1964.13	1964.7	288.0
2009-10-27 20:00:00	NQ	Futures	1964.99	1965.56	1961.57	1962.14	761.0
2009-10-27 21:00:00	NQ	Futures	1962.42	1964.7	1961.85	1962.99	462.0
2009-10-27 22:00:00	NQ	Futures	1962.71	1963.85	1959.0	1959.85	352.0
2009-10-27 23:00:00	NQ	Futures	1959.57	1960.42	1957.57	1959.85	434.0
2009-10-27 00:00:00	YM	Futures	9147.4	9150.2	9140.0	9140.0	186.0
2009-10-27 01:00:00	YM	Futures	9139.1	9150.2	9139.1	9149.3	266.0

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

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