PREVIEW / futures_1hour / 2009-10-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1037.92	1039.13	1037.68	1038.4	2608.0
2009-10-13 01:00:00	ES	Futures	1038.4	1038.65	1037.19	1037.92	1993.0
2009-10-13 02:00:00	ES	Futures	1037.92	1038.65	1036.95	1038.16	5214.0
2009-10-13 03:00:00	ES	Futures	1038.16	1039.13	1035.26	1036.22	26188.0
2009-10-13 04:00:00	ES	Futures	1035.98	1038.4	1035.5	1037.44	12935.0
2009-10-13 05:00:00	ES	Futures	1037.44	1037.44	1034.53	1036.47	17987.0
2009-10-13 06:00:00	ES	Futures	1036.22	1038.4	1035.98	1038.4	9679.0
2009-10-13 07:00:00	ES	Futures	1038.16	1040.83	1038.16	1038.89	25133.0
2009-10-13 08:00:00	ES	Futures	1038.65	1039.37	1036.22	1036.22	31265.0
2009-10-13 09:00:00	ES	Futures	1036.47	1037.68	1031.86	1032.35	216663.0
2009-10-13 10:00:00	ES	Futures	1032.35	1034.04	1029.93	1033.56	286409.0
2009-10-13 11:00:00	ES	Futures	1033.56	1038.4	1031.62	1037.92	220788.0
2009-10-13 12:00:00	ES	Futures	1037.68	1038.65	1035.5	1036.22	125133.0
2009-10-13 13:00:00	ES	Futures	1035.98	1037.19	1034.77	1036.22	97508.0
2009-10-13 14:00:00	ES	Futures	1036.22	1036.95	1033.08	1035.5	153628.0
2009-10-13 15:00:00	ES	Futures	1035.74	1038.65	1035.01	1037.44	196248.0
2009-10-13 16:00:00	ES	Futures	1037.44	1042.28	1034.77	1041.31	101703.0
2009-10-13 17:00:00	ES	Futures	1041.07	1047.85	1041.07	1044.46	23992.0
2009-10-13 18:00:00	ES	Futures	1044.46	1045.43	1043.01	1043.25	6202.0
2009-10-13 19:00:00	ES	Futures	1043.25	1044.22	1042.76	1043.98	2744.0
2009-10-13 20:00:00	ES	Futures	1043.98	1044.22	1042.28	1043.01	3314.0
2009-10-13 21:00:00	ES	Futures	1043.01	1044.94	1042.76	1044.7	3162.0
2009-10-13 22:00:00	ES	Futures	1044.94	1044.94	1044.22	1044.7	1812.0
2009-10-13 23:00:00	ES	Futures	1044.7	1045.43	1044.46	1044.94	1850.0
2009-10-13 00:00:00	NQ	Futures	1970.69	1972.69	1970.41	1970.98	218.0
2009-10-13 01:00:00	NQ	Futures	1971.26	1971.83	1969.84	1969.84	146.0
2009-10-13 02:00:00	NQ	Futures	1970.12	1971.55	1969.27	1971.26	428.0
2009-10-13 03:00:00	NQ	Futures	1970.98	1972.97	1966.41	1968.12	2999.0
2009-10-13 04:00:00	NQ	Futures	1968.41	1972.12	1967.55	1970.69	1294.0
2009-10-13 05:00:00	NQ	Futures	1970.12	1970.12	1965.56	1969.27	1151.0
2009-10-13 06:00:00	NQ	Futures	1968.98	1972.97	1968.98	1972.4	713.0
2009-10-13 07:00:00	NQ	Futures	1972.69	1977.25	1972.4	1973.54	1571.0
2009-10-13 08:00:00	NQ	Futures	1973.26	1974.4	1969.55	1970.12	2718.0
2009-10-13 09:00:00	NQ	Futures	1970.41	1977.25	1966.41	1967.55	32775.0
2009-10-13 10:00:00	NQ	Futures	1967.55	1971.26	1962.42	1969.27	32744.0
2009-10-13 11:00:00	NQ	Futures	1969.27	1980.1	1964.99	1978.11	34330.0
2009-10-13 12:00:00	NQ	Futures	1978.11	1979.53	1971.83	1972.97	21013.0
2009-10-13 13:00:00	NQ	Futures	1972.69	1973.54	1969.27	1971.83	18498.0
2009-10-13 14:00:00	NQ	Futures	1971.55	1972.4	1965.84	1970.12	27508.0
2009-10-13 15:00:00	NQ	Futures	1969.84	1975.54	1968.98	1972.4	28134.0
2009-10-13 16:00:00	NQ	Futures	1972.12	1990.66	1963.85	1986.09	19945.0
2009-10-13 17:00:00	NQ	Futures	1986.09	1991.8	1984.95	1987.8	2067.0
2009-10-13 18:00:00	NQ	Futures	1988.09	1990.37	1988.09	1988.94	579.0
2009-10-13 19:00:00	NQ	Futures	1988.37	1988.94	1988.09	1988.66	361.0
2009-10-13 20:00:00	NQ	Futures	1988.66	1989.23	1987.23	1988.09	663.0
2009-10-13 21:00:00	NQ	Futures	1988.09	1990.37	1988.09	1990.37	457.0
2009-10-13 22:00:00	NQ	Futures	1990.08	1990.66	1989.51	1989.8	195.0
2009-10-13 23:00:00	NQ	Futures	1990.08	1990.66	1989.8	1990.37	181.0
2009-10-13 00:00:00	YM	Futures	9135.3	9142.8	9133.5	9136.3	166.0
2009-10-13 01:00:00	YM	Futures	9136.3	9140.0	9131.6	9132.6	199.0

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

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