PREVIEW / futures_1hour / 2008-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-23.parquet
  size:    32 KB
  rows:    795

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
2008-01-23 00:00:00	ES	Futures	1205.88	1210.31	1205.42	1209.85	2412.0
2008-01-23 01:00:00	ES	Futures	1209.61	1216.14	1207.52	1214.98	5129.0
2008-01-23 02:00:00	ES	Futures	1214.98	1224.54	1211.71	1224.07	18586.0
2008-01-23 03:00:00	ES	Futures	1224.07	1229.9	1218.01	1219.87	38015.0
2008-01-23 04:00:00	ES	Futures	1219.87	1220.34	1208.22	1214.04	45032.0
2008-01-23 05:00:00	ES	Futures	1214.04	1216.84	1204.48	1208.45	32181.0
2008-01-23 06:00:00	ES	Futures	1208.68	1210.78	1196.32	1202.39	63719.0
2008-01-23 07:00:00	ES	Futures	1202.62	1207.52	1196.56	1198.66	53724.0
2008-01-23 08:00:00	ES	Futures	1198.66	1202.85	1176.04	1186.53	196602.0
2008-01-23 09:00:00	ES	Futures	1186.76	1209.15	1185.13	1206.82	455650.0
2008-01-23 10:00:00	ES	Futures	1207.05	1222.67	1204.25	1210.78	652122.0
2008-01-23 11:00:00	ES	Futures	1210.78	1214.28	1197.96	1200.29	385646.0
2008-01-23 12:00:00	ES	Futures	1200.05	1205.42	1184.43	1192.13	384449.0
2008-01-23 13:00:00	ES	Futures	1192.13	1210.31	1188.63	1206.82	390215.0
2008-01-23 14:00:00	ES	Futures	1207.05	1221.04	1203.55	1215.68	418888.0
2008-01-23 15:00:00	ES	Futures	1215.68	1251.58	1214.04	1250.42	758157.0
2008-01-23 16:00:00	ES	Futures	1250.42	1259.98	1249.25	1252.75	146861.0
2008-01-23 17:00:00	ES	Futures	1252.98	1255.31	1252.98	1254.38	3159.0
2008-01-23 18:00:00	ES	Futures	1255.78	1258.34	1252.51	1253.21	9586.0
2008-01-23 19:00:00	ES	Futures	1253.21	1254.38	1252.51	1253.68	6783.0
2008-01-23 20:00:00	ES	Futures	1253.91	1254.61	1252.51	1252.75	2474.0
2008-01-23 21:00:00	ES	Futures	1252.51	1253.21	1249.02	1249.48	6914.0
2008-01-23 22:00:00	ES	Futures	1249.25	1254.15	1248.78	1253.45	3505.0
2008-01-23 23:00:00	ES	Futures	1253.45	1257.64	1253.45	1257.41	5051.0
2008-01-23 00:00:00	NQ	Futures	2002.8	2011.6	2002.8	2006.49	607.0
2008-01-23 01:00:00	NQ	Futures	2007.06	2012.45	2004.5	2010.75	719.0
2008-01-23 02:00:00	NQ	Futures	2010.18	2029.2	2006.77	2028.06	1617.0
2008-01-23 03:00:00	NQ	Futures	2028.91	2039.42	2019.83	2026.64	3146.0
2008-01-23 04:00:00	NQ	Futures	2027.78	2028.06	2012.74	2021.53	3699.0
2008-01-23 05:00:00	NQ	Futures	2020.97	2026.64	2013.87	2016.99	1909.0
2008-01-23 06:00:00	NQ	Futures	2017.56	2017.56	1988.89	1998.26	4650.0
2008-01-23 07:00:00	NQ	Futures	1998.26	2001.67	1982.65	1988.61	6664.0
2008-01-23 08:00:00	NQ	Futures	1989.46	1997.12	1956.25	1969.59	23246.0
2008-01-23 09:00:00	NQ	Futures	1969.31	1996.56	1962.5	1993.15	95203.0
2008-01-23 10:00:00	NQ	Futures	1993.15	2011.88	1984.92	1992.87	122082.0
2008-01-23 11:00:00	NQ	Futures	1992.58	1994.57	1951.99	1953.98	119223.0
2008-01-23 12:00:00	NQ	Futures	1953.98	1963.91	1928.15	1942.34	109873.0
2008-01-23 13:00:00	NQ	Futures	1942.63	1965.62	1935.81	1961.08	93036.0
2008-01-23 14:00:00	NQ	Futures	1960.79	1992.01	1955.12	1978.96	102972.0
2008-01-23 15:00:00	NQ	Futures	1979.24	2045.95	1976.12	2038.85	156180.0
2008-01-23 16:00:00	NQ	Futures	2038.28	2058.43	2036.29	2051.05	23176.0
2008-01-23 17:00:00	NQ	Futures	2050.49	2056.16	2050.49	2054.46	669.0
2008-01-23 18:00:00	NQ	Futures	2055.88	2060.71	2055.31	2057.02	1652.0
2008-01-23 19:00:00	NQ	Futures	2056.73	2060.71	2056.45	2059.29	661.0
2008-01-23 20:00:00	NQ	Futures	2058.72	2060.42	2056.45	2057.3	548.0
2008-01-23 21:00:00	NQ	Futures	2057.3	2059.57	2055.03	2055.03	619.0
2008-01-23 22:00:00	NQ	Futures	2055.6	2064.39	2054.46	2059.85	181.0
2008-01-23 23:00:00	NQ	Futures	2060.99	2065.25	2060.14	2064.39	279.0
2008-01-23 00:00:00	YM	Futures	10762.1	10792.0	10753.0	10783.9	256.0
2008-01-23 01:00:00	YM	Futures	10787.5	10839.3	10764.8	10836.6	246.0

> showing 50 of 795 rows — these rows as CSV

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