PREVIEW / futures_1hour / 2010-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-05.parquet
  size:    33 KB
  rows:    909

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-05 00:00:00	ES	Futures	996.73	998.94	996.73	997.71	3503.0
2010-07-05 01:00:00	ES	Futures	997.71	998.69	995.75	998.69	5729.0
2010-07-05 02:00:00	ES	Futures	998.45	999.43	998.2	999.19	8873.0
2010-07-05 03:00:00	ES	Futures	998.94	999.68	994.52	995.01	15311.0
2010-07-05 04:00:00	ES	Futures	994.77	998.45	994.52	996.0	9065.0
2010-07-05 05:00:00	ES	Futures	996.24	996.98	994.77	996.24	7779.0
2010-07-05 06:00:00	ES	Futures	996.24	997.22	996.24	996.49	3818.0
2010-07-05 07:00:00	ES	Futures	996.73	996.98	995.01	996.73	4858.0
2010-07-05 08:00:00	ES	Futures	996.73	997.22	995.75	996.0	6003.0
2010-07-05 09:00:00	ES	Futures	995.75	996.49	994.52	995.01	8453.0
2010-07-05 10:00:00	ES	Futures	995.01	995.01	993.54	994.52	6337.0
2010-07-05 11:00:00	ES	Futures	994.52	995.01	992.56	993.3	5619.0
2010-07-05 18:00:00	ES	Futures	993.05	995.75	992.81	993.05	5166.0
2010-07-05 19:00:00	ES	Futures	992.81	992.81	988.63	989.62	7094.0
2010-07-05 20:00:00	ES	Futures	989.37	989.62	984.22	985.69	13202.0
2010-07-05 21:00:00	ES	Futures	985.93	989.62	985.69	989.37	7335.0
2010-07-05 22:00:00	ES	Futures	989.37	991.09	988.88	990.84	4625.0
2010-07-05 23:00:00	ES	Futures	990.84	995.01	989.12	994.28	7461.0
2010-07-05 00:00:00	NQ	Futures	1975.01	1977.88	1975.01	1975.59	66.0
2010-07-05 01:00:00	NQ	Futures	1977.02	1977.59	1973.87	1977.31	99.0
2010-07-05 02:00:00	NQ	Futures	1977.31	1980.74	1976.73	1980.17	336.0
2010-07-05 03:00:00	NQ	Futures	1980.46	1981.32	1970.71	1971.0	1370.0
2010-07-05 04:00:00	NQ	Futures	1971.0	1979.6	1970.43	1975.3	911.0
2010-07-05 05:00:00	NQ	Futures	1974.73	1977.31	1972.43	1975.87	1018.0
2010-07-05 06:00:00	NQ	Futures	1975.3	1977.59	1975.3	1977.31	703.0
2010-07-05 07:00:00	NQ	Futures	1977.02	1978.17	1973.58	1977.88	1319.0
2010-07-05 08:00:00	NQ	Futures	1977.31	1979.31	1976.45	1977.02	870.0
2010-07-05 09:00:00	NQ	Futures	1977.31	1977.59	1971.29	1975.01	2146.0
2010-07-05 10:00:00	NQ	Futures	1974.73	1975.3	1972.15	1972.43	1279.0
2010-07-05 11:00:00	NQ	Futures	1972.43	1973.87	1968.71	1971.57	1013.0
2010-07-05 18:00:00	NQ	Futures	1971.29	1975.59	1970.43	1970.71	354.0
2010-07-05 19:00:00	NQ	Futures	1970.71	1970.71	1962.4	1964.12	834.0
2010-07-05 20:00:00	NQ	Futures	1964.12	1964.12	1955.24	1957.25	1445.0
2010-07-05 21:00:00	NQ	Futures	1957.53	1963.26	1957.25	1963.26	906.0
2010-07-05 22:00:00	NQ	Futures	1963.55	1967.28	1962.98	1966.7	534.0
2010-07-05 23:00:00	NQ	Futures	1966.99	1973.29	1963.55	1972.72	779.0
2010-07-05 00:00:00	YM	Futures	9087.4	9100.7	9086.5	9093.1	179.0
2010-07-05 01:00:00	YM	Futures	9092.2	9102.6	9079.8	9102.6	147.0
2010-07-05 02:00:00	YM	Futures	9102.6	9111.1	9098.8	9111.1	376.0
2010-07-05 03:00:00	YM	Futures	9110.1	9115.8	9078.0	9080.8	1325.0
2010-07-05 04:00:00	YM	Futures	9079.8	9108.2	9078.0	9090.3	643.0
2010-07-05 05:00:00	YM	Futures	9090.3	9095.9	9079.8	9089.3	329.0
2010-07-05 06:00:00	YM	Futures	9094.0	9096.9	9091.2	9093.1	311.0
2010-07-05 07:00:00	YM	Futures	9095.0	9096.9	9081.7	9095.9	209.0
2010-07-05 08:00:00	YM	Futures	9095.9	9098.8	9087.4	9088.4	580.0
2010-07-05 09:00:00	YM	Futures	9088.4	9091.2	9076.1	9079.8	517.0
2010-07-05 10:00:00	YM	Futures	9078.9	9080.8	9070.4	9077.0	343.0
2010-07-05 11:00:00	YM	Futures	9077.0	9078.0	9060.0	9065.7	326.0
2010-07-05 18:00:00	YM	Futures	9063.8	9086.5	9061.9	9065.7	339.0
2010-07-05 19:00:00	YM	Futures	9063.8	9063.8	9026.8	9034.4	521.0

> showing 50 of 909 rows — these rows as CSV

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