PREVIEW / futures_1hour / 2010-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-01.parquet
  size:    47 KB
  rows:    1,383

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
2010-07-01 00:00:00	ES	Futures	1000.41	1003.85	999.43	1002.13	5685.0
2010-07-01 01:00:00	ES	Futures	1002.38	1005.57	1002.13	1003.6	9585.0
2010-07-01 02:00:00	ES	Futures	1003.85	1004.58	1001.64	1003.6	10618.0
2010-07-01 03:00:00	ES	Futures	1003.36	1005.57	1001.39	1002.87	42926.0
2010-07-01 04:00:00	ES	Futures	1002.87	1006.55	1001.64	1005.32	42891.0
2010-07-01 05:00:00	ES	Futures	1005.57	1005.57	1002.62	1004.09	26996.0
2010-07-01 06:00:00	ES	Futures	1004.09	1008.51	1004.09	1008.51	29580.0
2010-07-01 07:00:00	ES	Futures	1008.51	1008.76	1003.85	1004.34	36607.0
2010-07-01 08:00:00	ES	Futures	1004.58	1007.28	1000.17	1007.28	111807.0
2010-07-01 09:00:00	ES	Futures	1007.04	1010.72	1003.6	1004.34	318652.0
2010-07-01 10:00:00	ES	Futures	1004.34	1004.58	988.88	991.33	740103.0
2010-07-01 11:00:00	ES	Futures	991.09	998.69	987.41	996.49	499660.0
2010-07-01 12:00:00	ES	Futures	996.24	1005.32	992.81	1001.39	339544.0
2010-07-01 13:00:00	ES	Futures	1001.39	1005.81	998.94	1003.85	282503.0
2010-07-01 14:00:00	ES	Futures	1003.85	1007.28	996.98	1000.66	280087.0
2010-07-01 15:00:00	ES	Futures	1000.41	1006.3	999.43	1004.09	405162.0
2010-07-01 16:00:00	ES	Futures	1004.09	1004.58	1002.38	1002.87	92529.0
2010-07-01 17:00:00	ES	Futures	1002.87	1003.85	1002.62	1003.6	1408.0
2010-07-01 18:00:00	ES	Futures	1003.6	1004.83	1003.6	1004.34	2511.0
2010-07-01 19:00:00	ES	Futures	1004.34	1005.32	1003.85	1005.32	2474.0
2010-07-01 20:00:00	ES	Futures	1005.32	1007.53	1003.6	1004.09	9132.0
2010-07-01 21:00:00	ES	Futures	1003.85	1008.26	1003.6	1008.02	6771.0
2010-07-01 22:00:00	ES	Futures	1008.26	1009.0	1008.02	1008.76	8282.0
2010-07-01 23:00:00	ES	Futures	1008.76	1008.76	1005.32	1005.57	4643.0
2010-07-01 00:00:00	NQ	Futures	1976.45	1983.04	1975.59	1980.46	693.0
2010-07-01 01:00:00	NQ	Futures	1981.03	1986.19	1981.03	1982.75	693.0
2010-07-01 02:00:00	NQ	Futures	1982.46	1984.47	1979.6	1983.61	1090.0
2010-07-01 03:00:00	NQ	Futures	1983.61	1986.48	1978.45	1980.46	3884.0
2010-07-01 04:00:00	NQ	Futures	1980.46	1987.05	1978.74	1985.33	3447.0
2010-07-01 05:00:00	NQ	Futures	1985.04	1985.62	1980.46	1982.46	2303.0
2010-07-01 06:00:00	NQ	Futures	1982.46	1990.49	1981.89	1990.2	2671.0
2010-07-01 07:00:00	NQ	Futures	1990.49	1990.77	1982.75	1983.61	3189.0
2010-07-01 08:00:00	NQ	Futures	1983.61	1991.63	1977.31	1990.77	15445.0
2010-07-01 09:00:00	NQ	Futures	1991.06	2001.09	1984.76	1987.91	58476.0
2010-07-01 10:00:00	NQ	Futures	1987.62	1987.62	1946.36	1956.96	124222.0
2010-07-01 11:00:00	NQ	Futures	1956.96	1980.46	1952.09	1975.59	69379.0
2010-07-01 12:00:00	NQ	Futures	1975.59	1991.06	1966.13	1981.6	49567.0
2010-07-01 13:00:00	NQ	Futures	1981.89	1989.91	1976.73	1985.9	42752.0
2010-07-01 14:00:00	NQ	Futures	1985.62	1993.35	1969.85	1977.88	46776.0
2010-07-01 15:00:00	NQ	Futures	1978.17	1991.35	1974.15	1983.32	61745.0
2010-07-01 16:00:00	NQ	Futures	1983.32	1985.62	1980.17	1980.74	12997.0
2010-07-01 17:00:00	NQ	Futures	1980.74	1983.32	1980.74	1982.75	286.0
2010-07-01 18:00:00	NQ	Futures	1982.75	1985.04	1982.75	1984.18	344.0
2010-07-01 19:00:00	NQ	Futures	1984.76	1987.05	1983.04	1986.48	431.0
2010-07-01 20:00:00	NQ	Futures	1986.19	1990.2	1982.18	1983.04	759.0
2010-07-01 21:00:00	NQ	Futures	1983.04	1990.77	1982.75	1990.77	865.0
2010-07-01 22:00:00	NQ	Futures	1990.77	1995.36	1990.77	1994.21	2249.0
2010-07-01 23:00:00	NQ	Futures	1994.21	1994.21	1988.2	1988.48	784.0
2010-07-01 00:00:00	YM	Futures	9143.3	9170.7	9137.6	9158.4	760.0
2010-07-01 01:00:00	YM	Futures	9157.5	9183.0	9157.5	9167.9	1171.0

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

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