PREVIEW / futures_1hour / 2009-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-23.parquet
  size:    44 KB
  rows:    1,282

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-09-23 00:00:00	ES	Futures	1033.08	1034.29	1032.83	1033.8	1402.0
2009-09-23 01:00:00	ES	Futures	1034.04	1034.53	1033.8	1034.29	1904.0
2009-09-23 02:00:00	ES	Futures	1034.04	1034.29	1032.11	1033.32	7236.0
2009-09-23 03:00:00	ES	Futures	1033.32	1037.19	1032.59	1036.95	22431.0
2009-09-23 04:00:00	ES	Futures	1036.95	1037.19	1035.26	1035.98	12124.0
2009-09-23 05:00:00	ES	Futures	1035.98	1036.95	1032.83	1033.56	16460.0
2009-09-23 06:00:00	ES	Futures	1033.56	1035.26	1033.32	1034.77	9703.0
2009-09-23 07:00:00	ES	Futures	1034.53	1037.19	1034.53	1036.22	13847.0
2009-09-23 08:00:00	ES	Futures	1036.22	1036.71	1035.5	1035.98	18741.0
2009-09-23 09:00:00	ES	Futures	1035.98	1036.71	1032.11	1032.35	202187.0
2009-09-23 10:00:00	ES	Futures	1032.35	1034.77	1029.2	1031.38	271826.0
2009-09-23 11:00:00	ES	Futures	1031.62	1033.32	1029.93	1033.32	116393.0
2009-09-23 12:00:00	ES	Futures	1033.32	1035.5	1033.08	1035.26	89528.0
2009-09-23 13:00:00	ES	Futures	1035.26	1036.47	1033.8	1035.74	76954.0
2009-09-23 14:00:00	ES	Futures	1035.74	1042.28	1033.8	1036.22	433836.0
2009-09-23 15:00:00	ES	Futures	1036.22	1039.13	1022.42	1023.63	680679.0
2009-09-23 16:00:00	ES	Futures	1023.87	1027.5	1023.63	1025.57	137190.0
2009-09-23 17:00:00	ES	Futures	1025.57	1025.57	1024.11	1024.6	3121.0
2009-09-23 18:00:00	ES	Futures	1024.6	1024.6	1024.11	1024.11	2858.0
2009-09-23 19:00:00	ES	Futures	1024.36	1024.84	1023.63	1024.6	3820.0
2009-09-23 20:00:00	ES	Futures	1024.6	1027.99	1023.87	1027.75	15347.0
2009-09-23 21:00:00	ES	Futures	1027.75	1027.75	1026.05	1027.26	4099.0
2009-09-23 22:00:00	ES	Futures	1027.26	1027.75	1025.57	1025.57	4652.0
2009-09-23 23:00:00	ES	Futures	1025.81	1025.81	1023.14	1023.14	8247.0
2009-09-23 00:00:00	NQ	Futures	1978.11	1980.39	1978.11	1980.1	128.0
2009-09-23 01:00:00	NQ	Futures	1980.1	1980.39	1979.25	1980.1	133.0
2009-09-23 02:00:00	NQ	Futures	1979.53	1979.53	1976.68	1978.11	550.0
2009-09-23 03:00:00	NQ	Futures	1978.39	1983.81	1976.68	1983.53	2577.0
2009-09-23 04:00:00	NQ	Futures	1983.53	1983.81	1981.24	1982.38	695.0
2009-09-23 05:00:00	NQ	Futures	1982.67	1983.81	1976.4	1976.97	1476.0
2009-09-23 06:00:00	NQ	Futures	1977.54	1981.81	1977.25	1981.24	798.0
2009-09-23 07:00:00	NQ	Futures	1981.53	1984.38	1981.53	1983.24	2270.0
2009-09-23 08:00:00	NQ	Futures	1983.53	1985.24	1982.95	1983.81	3024.0
2009-09-23 09:00:00	NQ	Futures	1984.1	1985.52	1978.11	1978.96	30938.0
2009-09-23 10:00:00	NQ	Futures	1978.96	1984.1	1973.83	1977.82	39213.0
2009-09-23 11:00:00	NQ	Futures	1977.82	1982.95	1974.68	1982.67	19063.0
2009-09-23 12:00:00	NQ	Futures	1982.38	1986.09	1981.53	1984.1	16935.0
2009-09-23 13:00:00	NQ	Futures	1983.81	1986.66	1981.81	1985.24	12563.0
2009-09-23 14:00:00	NQ	Futures	1985.24	2000.07	1982.95	1987.52	71129.0
2009-09-23 15:00:00	NQ	Futures	1987.23	1992.65	1962.99	1965.27	93855.0
2009-09-23 16:00:00	NQ	Futures	1964.99	1969.84	1964.42	1966.41	13271.0
2009-09-23 17:00:00	NQ	Futures	1966.98	1966.98	1963.56	1964.7	251.0
2009-09-23 18:00:00	NQ	Futures	1964.13	1965.27	1963.85	1964.7	189.0
2009-09-23 19:00:00	NQ	Futures	1964.7	1964.7	1962.99	1964.7	264.0
2009-09-23 20:00:00	NQ	Futures	1964.99	1971.55	1963.85	1971.26	1416.0
2009-09-23 21:00:00	NQ	Futures	1971.55	1971.83	1968.98	1971.26	707.0
2009-09-23 22:00:00	NQ	Futures	1971.26	1972.4	1968.12	1968.12	786.0
2009-09-23 23:00:00	NQ	Futures	1968.12	1968.41	1963.85	1964.13	534.0
2009-09-23 00:00:00	YM	Futures	9076.7	9087.9	9074.9	9086.0	88.0
2009-09-23 01:00:00	YM	Futures	9087.0	9087.9	9082.3	9087.9	287.0

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

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