PREVIEW / futures_1hour / 2009-10-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	1046.64	1046.88	1045.91	1046.4	2173.0
2009-10-19 01:00:00	ES	Futures	1046.4	1048.58	1046.4	1047.85	3285.0
2009-10-19 02:00:00	ES	Futures	1047.85	1050.76	1047.85	1050.76	7600.0
2009-10-19 03:00:00	ES	Futures	1050.76	1055.6	1050.52	1054.88	35802.0
2009-10-19 04:00:00	ES	Futures	1054.88	1055.12	1053.18	1054.39	16929.0
2009-10-19 05:00:00	ES	Futures	1054.39	1055.12	1053.18	1053.42	14277.0
2009-10-19 06:00:00	ES	Futures	1053.42	1054.88	1053.42	1054.15	9633.0
2009-10-19 07:00:00	ES	Futures	1053.91	1055.12	1053.91	1054.39	13710.0
2009-10-19 08:00:00	ES	Futures	1054.39	1054.63	1052.7	1053.66	32114.0
2009-10-19 09:00:00	ES	Futures	1053.66	1053.91	1049.06	1049.79	176512.0
2009-10-19 10:00:00	ES	Futures	1049.79	1058.99	1049.3	1057.54	338887.0
2009-10-19 11:00:00	ES	Futures	1057.54	1061.66	1057.06	1060.93	208460.0
2009-10-19 12:00:00	ES	Futures	1061.17	1061.17	1059.72	1060.2	86321.0
2009-10-19 13:00:00	ES	Futures	1060.45	1062.63	1059.24	1060.93	149008.0
2009-10-19 14:00:00	ES	Futures	1061.17	1062.63	1060.2	1061.9	113514.0
2009-10-19 15:00:00	ES	Futures	1061.66	1062.14	1059.24	1059.72	204446.0
2009-10-19 16:00:00	ES	Futures	1059.96	1062.38	1055.84	1061.42	140791.0
2009-10-19 17:00:00	ES	Futures	1061.42	1062.38	1060.69	1060.93	4733.0
2009-10-19 18:00:00	ES	Futures	1060.69	1061.42	1059.96	1060.45	3380.0
2009-10-19 19:00:00	ES	Futures	1060.45	1061.42	1060.2	1061.42	1127.0
2009-10-19 20:00:00	ES	Futures	1061.17	1061.66	1060.69	1061.66	2101.0
2009-10-19 21:00:00	ES	Futures	1061.42	1062.14	1061.17	1061.9	1786.0
2009-10-19 22:00:00	ES	Futures	1061.9	1061.9	1060.69	1061.17	1452.0
2009-10-19 23:00:00	ES	Futures	1061.17	1061.9	1060.69	1060.93	1913.0
2009-10-19 00:00:00	NQ	Futures	1973.26	1973.83	1971.83	1973.54	268.0
2009-10-19 01:00:00	NQ	Futures	1973.83	1976.68	1973.26	1975.83	541.0
2009-10-19 02:00:00	NQ	Futures	1975.83	1980.96	1975.54	1980.67	785.0
2009-10-19 03:00:00	NQ	Futures	1980.67	1989.51	1980.67	1988.94	3443.0
2009-10-19 04:00:00	NQ	Futures	1988.66	1989.23	1985.52	1988.37	1394.0
2009-10-19 05:00:00	NQ	Futures	1988.09	1989.8	1985.81	1986.95	1735.0
2009-10-19 06:00:00	NQ	Futures	1986.95	1989.23	1986.66	1987.23	573.0
2009-10-19 07:00:00	NQ	Futures	1987.23	1989.23	1987.23	1988.09	1839.0
2009-10-19 08:00:00	NQ	Futures	1987.8	1988.09	1983.53	1985.52	4231.0
2009-10-19 09:00:00	NQ	Futures	1985.52	1987.23	1974.68	1975.83	37101.0
2009-10-19 10:00:00	NQ	Futures	1976.11	1993.51	1972.97	1990.94	56779.0
2009-10-19 11:00:00	NQ	Futures	1990.94	2003.77	1990.66	2002.63	48071.0
2009-10-19 12:00:00	NQ	Futures	2002.35	2002.92	1998.36	1999.5	21162.0
2009-10-19 13:00:00	NQ	Futures	1999.5	2002.63	1996.07	1998.07	21878.0
2009-10-19 14:00:00	NQ	Futures	1998.36	2000.07	1995.22	1998.36	21549.0
2009-10-19 15:00:00	NQ	Futures	1998.07	2003.77	1996.07	2000.92	34543.0
2009-10-19 16:00:00	NQ	Futures	2001.21	2023.17	1994.36	2021.17	29182.0
2009-10-19 17:00:00	NQ	Futures	2020.89	2022.03	2018.03	2018.32	1262.0
2009-10-19 18:00:00	NQ	Futures	2018.32	2019.17	2016.32	2016.61	703.0
2009-10-19 19:00:00	NQ	Futures	2016.61	2018.32	2016.32	2018.03	148.0
2009-10-19 20:00:00	NQ	Futures	2018.03	2018.03	2016.32	2017.46	484.0
2009-10-19 21:00:00	NQ	Futures	2017.46	2018.03	2016.89	2018.03	311.0
2009-10-19 22:00:00	NQ	Futures	2018.03	2018.03	2016.32	2016.61	149.0
2009-10-19 23:00:00	NQ	Futures	2016.32	2018.03	2015.47	2016.32	244.0
2009-10-19 00:00:00	YM	Futures	9214.4	9219.1	9210.7	9219.1	252.0
2009-10-19 01:00:00	YM	Futures	9218.1	9233.0	9218.1	9227.4	356.0

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

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