PREVIEW / futures_1hour / 2010-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-02.parquet
  size:    38 KB
  rows:    1,102

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-02 00:00:00	ES	Futures	1005.32	1007.04	1004.58	1006.06	3034.0
2010-07-02 01:00:00	ES	Futures	1006.3	1006.3	1003.36	1004.09	4359.0
2010-07-02 02:00:00	ES	Futures	1004.34	1005.81	1003.85	1005.32	12454.0
2010-07-02 03:00:00	ES	Futures	1005.32	1005.57	1000.9	1001.88	33424.0
2010-07-02 04:00:00	ES	Futures	1001.88	1004.83	1001.15	1003.85	17707.0
2010-07-02 05:00:00	ES	Futures	1003.6	1004.58	1002.38	1003.6	14167.0
2010-07-02 06:00:00	ES	Futures	1003.6	1004.83	1002.62	1002.62	10006.0
2010-07-02 07:00:00	ES	Futures	1002.62	1006.3	1002.62	1006.3	25664.0
2010-07-02 08:00:00	ES	Futures	1006.3	1013.42	998.69	1002.62	267757.0
2010-07-02 09:00:00	ES	Futures	1002.62	1009.98	1002.13	1005.07	297994.0
2010-07-02 10:00:00	ES	Futures	1005.07	1007.28	1000.41	1001.88	285526.0
2010-07-02 11:00:00	ES	Futures	1001.88	1003.36	994.03	996.98	282519.0
2010-07-02 12:00:00	ES	Futures	996.98	999.43	994.52	995.01	137760.0
2010-07-02 13:00:00	ES	Futures	995.01	998.69	992.07	998.2	166666.0
2010-07-02 14:00:00	ES	Futures	998.2	998.69	995.01	997.96	114119.0
2010-07-02 15:00:00	ES	Futures	997.96	1007.04	996.98	998.45	308141.0
2010-07-02 16:00:00	ES	Futures	998.45	998.69	994.52	995.5	113159.0
2010-07-02 00:00:00	NQ	Futures	1988.2	1989.91	1985.9	1988.77	356.0
2010-07-02 01:00:00	NQ	Futures	1988.77	1989.05	1983.61	1985.62	534.0
2010-07-02 02:00:00	NQ	Futures	1985.33	1988.48	1985.04	1987.34	961.0
2010-07-02 03:00:00	NQ	Futures	1987.05	1987.05	1979.02	1980.46	3063.0
2010-07-02 04:00:00	NQ	Futures	1980.46	1987.91	1979.6	1984.76	2529.0
2010-07-02 05:00:00	NQ	Futures	1984.47	1985.9	1982.18	1984.18	993.0
2010-07-02 06:00:00	NQ	Futures	1984.18	1986.48	1983.9	1984.18	846.0
2010-07-02 07:00:00	NQ	Futures	1984.18	1991.35	1983.9	1991.06	2605.0
2010-07-02 08:00:00	NQ	Futures	1991.06	2001.09	1975.3	1982.46	23807.0
2010-07-02 09:00:00	NQ	Futures	1981.89	1995.07	1980.74	1986.19	59773.0
2010-07-02 10:00:00	NQ	Futures	1986.19	1990.49	1977.31	1979.31	49622.0
2010-07-02 11:00:00	NQ	Futures	1979.6	1984.47	1967.85	1973.29	42412.0
2010-07-02 12:00:00	NQ	Futures	1973.29	1978.74	1967.28	1969.0	19121.0
2010-07-02 13:00:00	NQ	Futures	1969.0	1977.02	1960.4	1976.16	27741.0
2010-07-02 14:00:00	NQ	Futures	1976.16	1978.45	1970.14	1976.45	19544.0
2010-07-02 15:00:00	NQ	Futures	1976.73	1994.21	1974.15	1978.45	43474.0
2010-07-02 16:00:00	NQ	Futures	1978.45	1979.31	1971.0	1972.43	14086.0
2010-07-02 00:00:00	YM	Futures	9165.0	9172.6	9155.6	9166.9	252.0
2010-07-02 01:00:00	YM	Futures	9168.8	9169.8	9146.1	9150.8	336.0
2010-07-02 02:00:00	YM	Futures	9150.8	9165.0	9148.0	9162.2	922.0
2010-07-02 03:00:00	YM	Futures	9161.3	9161.3	9128.1	9135.7	2244.0
2010-07-02 04:00:00	YM	Futures	9136.6	9159.4	9131.9	9152.7	1038.0
2010-07-02 05:00:00	YM	Futures	9151.8	9155.6	9139.5	9149.0	697.0
2010-07-02 06:00:00	YM	Futures	9149.9	9156.5	9143.3	9144.2	397.0
2010-07-02 07:00:00	YM	Futures	9142.3	9171.7	9141.4	9168.8	1244.0
2010-07-02 08:00:00	YM	Futures	9168.8	9232.3	9112.0	9144.2	15146.0
2010-07-02 09:00:00	YM	Futures	9143.3	9190.6	9139.5	9159.4	24363.0
2010-07-02 10:00:00	YM	Futures	9160.3	9167.9	9115.8	9120.6	21863.0
2010-07-02 11:00:00	YM	Futures	9120.6	9132.9	9055.2	9081.7	23138.0
2010-07-02 12:00:00	YM	Futures	9080.8	9098.8	9060.9	9064.7	10877.0
2010-07-02 13:00:00	YM	Futures	9065.7	9100.7	9042.0	9095.0	12532.0
2010-07-02 14:00:00	YM	Futures	9095.9	9097.8	9070.4	9095.0	8944.0
2010-07-02 15:00:00	YM	Futures	9094.0	9173.6	9087.4	9106.4	21086.0

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

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