PREVIEW / futures_1hour / 2009-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-12.parquet
  size:    43 KB
  rows:    1,274

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-12 00:00:00	ES	Futures	1034.77	1035.98	1034.53	1035.98	1586.0
2009-10-12 01:00:00	ES	Futures	1035.74	1036.22	1035.5	1035.74	1362.0
2009-10-12 02:00:00	ES	Futures	1035.74	1037.68	1035.5	1036.22	8074.0
2009-10-12 03:00:00	ES	Futures	1035.98	1036.47	1034.29	1036.22	20662.0
2009-10-12 04:00:00	ES	Futures	1036.22	1041.07	1035.26	1041.07	32207.0
2009-10-12 05:00:00	ES	Futures	1041.07	1042.04	1039.62	1040.34	14035.0
2009-10-12 06:00:00	ES	Futures	1040.58	1041.8	1040.34	1041.8	9120.0
2009-10-12 07:00:00	ES	Futures	1041.8	1043.25	1041.07	1041.8	23658.0
2009-10-12 08:00:00	ES	Futures	1041.8	1041.8	1039.62	1040.1	19585.0
2009-10-12 09:00:00	ES	Futures	1040.1	1042.52	1038.4	1042.28	110716.0
2009-10-12 10:00:00	ES	Futures	1042.52	1042.76	1040.1	1042.04	162512.0
2009-10-12 11:00:00	ES	Futures	1042.04	1042.28	1040.1	1040.58	80016.0
2009-10-12 12:00:00	ES	Futures	1040.58	1041.8	1040.1	1041.31	51718.0
2009-10-12 13:00:00	ES	Futures	1041.31	1041.8	1040.34	1041.31	49784.0
2009-10-12 14:00:00	ES	Futures	1041.31	1041.55	1034.77	1036.95	232714.0
2009-10-12 15:00:00	ES	Futures	1037.19	1039.37	1036.71	1039.13	175909.0
2009-10-12 16:00:00	ES	Futures	1039.13	1039.37	1037.44	1037.68	53326.0
2009-10-12 17:00:00	ES	Futures	1037.68	1038.65	1037.44	1038.4	1229.0
2009-10-12 18:00:00	ES	Futures	1038.16	1038.4	1037.68	1037.68	811.0
2009-10-12 19:00:00	ES	Futures	1037.68	1038.16	1037.19	1037.44	1669.0
2009-10-12 20:00:00	ES	Futures	1037.44	1037.92	1036.95	1036.95	2134.0
2009-10-12 21:00:00	ES	Futures	1037.19	1037.44	1035.98	1036.22	2809.0
2009-10-12 22:00:00	ES	Futures	1036.47	1037.68	1035.26	1036.71	5128.0
2009-10-12 23:00:00	ES	Futures	1036.95	1037.92	1036.95	1037.68	1819.0
2009-10-12 00:00:00	NQ	Futures	1968.41	1969.55	1967.84	1969.27	118.0
2009-10-12 01:00:00	NQ	Futures	1969.27	1970.12	1968.98	1969.55	78.0
2009-10-12 02:00:00	NQ	Futures	1969.55	1972.69	1968.98	1970.12	544.0
2009-10-12 03:00:00	NQ	Futures	1969.55	1970.41	1966.41	1970.12	1598.0
2009-10-12 04:00:00	NQ	Futures	1970.41	1978.68	1968.41	1978.68	2018.0
2009-10-12 05:00:00	NQ	Futures	1978.39	1980.1	1976.68	1977.82	1019.0
2009-10-12 06:00:00	NQ	Futures	1977.82	1979.82	1977.54	1979.82	439.0
2009-10-12 07:00:00	NQ	Futures	1979.82	1982.38	1978.96	1979.82	1607.0
2009-10-12 08:00:00	NQ	Futures	1979.82	1979.82	1976.4	1977.54	2203.0
2009-10-12 09:00:00	NQ	Futures	1977.54	1984.1	1972.97	1983.81	25954.0
2009-10-12 10:00:00	NQ	Futures	1983.81	1985.52	1979.53	1982.67	23082.0
2009-10-12 11:00:00	NQ	Futures	1982.95	1984.1	1978.96	1979.25	13304.0
2009-10-12 12:00:00	NQ	Futures	1979.25	1979.25	1974.68	1976.4	14444.0
2009-10-12 13:00:00	NQ	Futures	1976.4	1977.82	1974.4	1976.68	9154.0
2009-10-12 14:00:00	NQ	Futures	1976.68	1976.68	1958.14	1964.13	43484.0
2009-10-12 15:00:00	NQ	Futures	1964.13	1971.55	1964.13	1971.55	29295.0
2009-10-12 16:00:00	NQ	Futures	1971.55	1972.4	1969.55	1970.12	9449.0
2009-10-12 17:00:00	NQ	Futures	1969.84	1971.26	1969.27	1970.69	146.0
2009-10-12 18:00:00	NQ	Futures	1970.69	1970.98	1969.55	1970.41	139.0
2009-10-12 19:00:00	NQ	Futures	1970.12	1970.41	1969.55	1969.84	113.0
2009-10-12 20:00:00	NQ	Futures	1969.55	1970.69	1968.7	1968.98	306.0
2009-10-12 21:00:00	NQ	Futures	1968.98	1969.55	1966.7	1967.55	463.0
2009-10-12 22:00:00	NQ	Futures	1968.12	1970.41	1965.27	1968.98	504.0
2009-10-12 23:00:00	NQ	Futures	1968.98	1971.26	1968.98	1970.69	180.0
2009-10-12 00:00:00	YM	Futures	9121.4	9130.7	9121.4	9130.7	113.0
2009-10-12 01:00:00	YM	Futures	9127.9	9132.6	9127.9	9131.6	59.0

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

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