PREVIEW / futures_1hour / 2009-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-16.parquet
  size:    38 KB
  rows:    1,110

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-16 00:00:00	ES	Futures	1056.57	1058.02	1056.57	1057.54	2860.0
2009-10-16 01:00:00	ES	Futures	1057.54	1058.02	1057.3	1057.54	2877.0
2009-10-16 02:00:00	ES	Futures	1057.54	1057.78	1057.06	1057.06	8561.0
2009-10-16 03:00:00	ES	Futures	1057.06	1061.42	1057.06	1058.99	34557.0
2009-10-16 04:00:00	ES	Futures	1058.99	1059.72	1057.06	1057.54	14536.0
2009-10-16 05:00:00	ES	Futures	1057.54	1058.99	1057.3	1058.51	10888.0
2009-10-16 06:00:00	ES	Futures	1058.27	1058.75	1053.42	1054.15	31004.0
2009-10-16 07:00:00	ES	Futures	1053.91	1054.15	1049.79	1051.73	70093.0
2009-10-16 08:00:00	ES	Futures	1051.97	1051.97	1046.88	1049.06	86189.0
2009-10-16 09:00:00	ES	Futures	1049.06	1052.21	1047.37	1048.09	323839.0
2009-10-16 10:00:00	ES	Futures	1048.09	1048.34	1043.98	1045.43	354386.0
2009-10-16 11:00:00	ES	Futures	1045.43	1048.58	1044.94	1047.12	209154.0
2009-10-16 12:00:00	ES	Futures	1047.12	1048.34	1045.91	1048.09	107177.0
2009-10-16 13:00:00	ES	Futures	1048.09	1053.18	1046.88	1051.0	167793.0
2009-10-16 14:00:00	ES	Futures	1051.24	1051.73	1048.82	1050.52	143285.0
2009-10-16 15:00:00	ES	Futures	1050.52	1054.39	1049.3	1050.52	298986.0
2009-10-16 16:00:00	ES	Futures	1050.27	1051.0	1047.12	1048.58	117411.0
2009-10-16 00:00:00	NQ	Futures	1997.5	1999.5	1996.93	1998.36	120.0
2009-10-16 01:00:00	NQ	Futures	1998.36	1998.64	1997.5	1997.79	259.0
2009-10-16 02:00:00	NQ	Futures	1997.79	1998.07	1996.36	1996.36	687.0
2009-10-16 03:00:00	NQ	Futures	1996.36	2005.49	1996.36	2000.92	3661.0
2009-10-16 04:00:00	NQ	Futures	2000.64	2001.78	1997.79	1998.36	1303.0
2009-10-16 05:00:00	NQ	Futures	1998.07	2000.92	1997.79	2000.35	1026.0
2009-10-16 06:00:00	NQ	Futures	2000.35	2000.64	1993.22	1993.51	2077.0
2009-10-16 07:00:00	NQ	Futures	1993.51	1993.79	1986.66	1989.8	4690.0
2009-10-16 08:00:00	NQ	Futures	1989.51	1990.08	1981.53	1985.24	7016.0
2009-10-16 09:00:00	NQ	Futures	1985.24	1990.94	1978.68	1980.67	49340.0
2009-10-16 10:00:00	NQ	Futures	1980.39	1980.39	1967.55	1970.12	70872.0
2009-10-16 11:00:00	NQ	Futures	1970.12	1975.54	1968.98	1972.12	34593.0
2009-10-16 12:00:00	NQ	Futures	1972.12	1977.25	1971.83	1976.11	22103.0
2009-10-16 13:00:00	NQ	Futures	1976.11	1991.23	1974.4	1986.38	42734.0
2009-10-16 14:00:00	NQ	Futures	1986.09	1987.23	1981.81	1983.24	25070.0
2009-10-16 15:00:00	NQ	Futures	1983.24	1989.51	1979.82	1981.81	47547.0
2009-10-16 16:00:00	NQ	Futures	1981.81	1982.1	1974.97	1976.68	15019.0
2009-10-16 00:00:00	YM	Futures	9272.1	9281.4	9271.2	9275.8	328.0
2009-10-16 01:00:00	YM	Futures	9275.8	9278.6	9272.1	9274.9	389.0
2009-10-16 02:00:00	YM	Futures	9276.7	9278.6	9271.2	9273.9	790.0
2009-10-16 03:00:00	YM	Futures	9273.9	9305.6	9273.9	9287.0	1872.0
2009-10-16 04:00:00	YM	Futures	9287.0	9292.5	9275.8	9279.5	1189.0
2009-10-16 05:00:00	YM	Futures	9279.5	9290.7	9279.5	9286.0	577.0
2009-10-16 06:00:00	YM	Futures	9286.0	9287.0	9248.8	9251.6	1644.0
2009-10-16 07:00:00	YM	Futures	9251.6	9252.5	9221.9	9233.0	3790.0
2009-10-16 08:00:00	YM	Futures	9233.0	9236.7	9200.5	9216.3	5562.0
2009-10-16 09:00:00	YM	Futures	9217.2	9250.7	9211.6	9220.0	27546.0
2009-10-16 10:00:00	YM	Futures	9220.0	9229.3	9193.9	9204.2	27421.0
2009-10-16 11:00:00	YM	Futures	9203.2	9226.5	9199.5	9211.6	15237.0
2009-10-16 12:00:00	YM	Futures	9210.7	9227.4	9206.0	9223.7	8678.0
2009-10-16 13:00:00	YM	Futures	9224.6	9262.8	9218.1	9244.2	13265.0
2009-10-16 14:00:00	YM	Futures	9245.1	9256.3	9230.2	9245.1	11736.0
2009-10-16 15:00:00	YM	Futures	9244.2	9273.0	9235.8	9252.5	22971.0

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

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