PREVIEW / futures_1hour / 2009-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-14.parquet
  size:    46 KB
  rows:    1,352

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-14 00:00:00	ES	Futures	1044.7	1045.43	1044.7	1044.94	1875.0
2009-10-14 01:00:00	ES	Futures	1044.94	1045.19	1043.73	1043.98	2826.0
2009-10-14 02:00:00	ES	Futures	1043.98	1046.16	1043.73	1044.94	14025.0
2009-10-14 03:00:00	ES	Futures	1044.94	1046.64	1044.7	1045.91	30508.0
2009-10-14 04:00:00	ES	Futures	1046.16	1048.09	1044.7	1047.85	18479.0
2009-10-14 05:00:00	ES	Futures	1048.09	1049.79	1047.12	1048.82	32726.0
2009-10-14 06:00:00	ES	Futures	1048.82	1051.97	1048.09	1051.73	35092.0
2009-10-14 07:00:00	ES	Futures	1051.73	1051.73	1049.06	1049.3	41037.0
2009-10-14 08:00:00	ES	Futures	1049.3	1050.76	1048.34	1050.03	48388.0
2009-10-14 09:00:00	ES	Futures	1050.03	1050.27	1045.19	1047.37	243323.0
2009-10-14 10:00:00	ES	Futures	1047.61	1048.34	1044.22	1047.61	314257.0
2009-10-14 11:00:00	ES	Futures	1047.61	1050.03	1047.37	1049.06	186479.0
2009-10-14 12:00:00	ES	Futures	1049.06	1049.79	1047.85	1049.79	119114.0
2009-10-14 13:00:00	ES	Futures	1049.79	1051.48	1049.3	1050.52	140888.0
2009-10-14 14:00:00	ES	Futures	1050.52	1051.73	1049.06	1050.52	170291.0
2009-10-14 15:00:00	ES	Futures	1050.27	1055.84	1050.27	1054.88	382944.0
2009-10-14 16:00:00	ES	Futures	1055.12	1055.36	1053.42	1054.63	111884.0
2009-10-14 17:00:00	ES	Futures	1054.63	1054.88	1053.42	1053.66	2612.0
2009-10-14 18:00:00	ES	Futures	1053.42	1054.88	1053.42	1054.63	3938.0
2009-10-14 19:00:00	ES	Futures	1054.63	1055.12	1054.39	1054.88	2815.0
2009-10-14 20:00:00	ES	Futures	1054.63	1055.6	1054.15	1054.15	4315.0
2009-10-14 21:00:00	ES	Futures	1054.39	1055.6	1054.39	1055.36	2609.0
2009-10-14 22:00:00	ES	Futures	1055.36	1055.84	1054.63	1054.63	2474.0
2009-10-14 23:00:00	ES	Futures	1054.63	1054.88	1053.42	1053.66	2757.0
2009-10-14 00:00:00	NQ	Futures	1990.37	1991.23	1990.08	1990.94	242.0
2009-10-14 01:00:00	NQ	Futures	1990.94	1991.51	1989.51	1989.8	348.0
2009-10-14 02:00:00	NQ	Futures	1989.8	1991.51	1988.94	1990.94	1243.0
2009-10-14 03:00:00	NQ	Futures	1990.66	1993.22	1988.94	1991.51	3540.0
2009-10-14 04:00:00	NQ	Futures	1991.51	1994.93	1989.23	1994.65	1981.0
2009-10-14 05:00:00	NQ	Futures	1994.65	1996.64	1993.51	1994.36	2867.0
2009-10-14 06:00:00	NQ	Futures	1994.36	1999.78	1993.51	1999.21	2506.0
2009-10-14 07:00:00	NQ	Futures	1999.21	1999.5	1995.5	1997.5	4126.0
2009-10-14 08:00:00	NQ	Futures	1997.5	1999.78	1994.65	1997.79	3769.0
2009-10-14 09:00:00	NQ	Futures	1998.07	1998.64	1984.67	1988.94	48409.0
2009-10-14 10:00:00	NQ	Futures	1989.23	1992.37	1986.09	1989.23	43822.0
2009-10-14 11:00:00	NQ	Futures	1989.51	1995.5	1989.23	1992.94	25841.0
2009-10-14 12:00:00	NQ	Futures	1992.94	1994.08	1989.51	1994.08	19681.0
2009-10-14 13:00:00	NQ	Futures	1994.08	1995.79	1991.51	1992.37	15107.0
2009-10-14 14:00:00	NQ	Futures	1992.65	1995.5	1989.51	1992.37	26952.0
2009-10-14 15:00:00	NQ	Futures	1991.8	2001.49	1991.8	1998.93	50250.0
2009-10-14 16:00:00	NQ	Futures	1998.93	1999.5	1992.65	1995.5	15314.0
2009-10-14 17:00:00	NQ	Futures	1995.22	1995.5	1993.51	1993.79	246.0
2009-10-14 18:00:00	NQ	Futures	1993.22	1993.79	1992.65	1993.79	666.0
2009-10-14 19:00:00	NQ	Futures	1993.79	1994.93	1993.51	1994.65	750.0
2009-10-14 20:00:00	NQ	Futures	1994.36	1994.93	1993.22	1993.51	978.0
2009-10-14 21:00:00	NQ	Futures	1993.79	1994.93	1993.51	1994.65	395.0
2009-10-14 22:00:00	NQ	Futures	1994.65	1994.93	1993.51	1994.36	188.0
2009-10-14 23:00:00	NQ	Futures	1993.51	1993.79	1991.23	1992.08	294.0
2009-10-14 00:00:00	YM	Futures	9196.7	9200.5	9194.9	9196.7	236.0
2009-10-14 01:00:00	YM	Futures	9195.8	9197.7	9185.6	9188.4	301.0

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

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