PREVIEW / futures_1hour / 2008-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-05.parquet
  size:    37 KB
  rows:    1,021

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-09-05 00:00:00	ES	Futures	1146.04	1147.43	1144.41	1146.5	1688.0
2008-09-05 01:00:00	ES	Futures	1146.74	1147.43	1145.11	1146.97	1607.0
2008-09-05 02:00:00	ES	Futures	1147.2	1148.36	1145.11	1148.13	7364.0
2008-09-05 03:00:00	ES	Futures	1148.13	1150.46	1146.74	1148.83	19866.0
2008-09-05 04:00:00	ES	Futures	1149.06	1149.76	1140.69	1142.32	28764.0
2008-09-05 05:00:00	ES	Futures	1142.32	1144.88	1141.16	1143.72	14201.0
2008-09-05 06:00:00	ES	Futures	1143.72	1143.95	1142.32	1142.79	10388.0
2008-09-05 07:00:00	ES	Futures	1142.79	1147.67	1141.86	1147.2	30389.0
2008-09-05 08:00:00	ES	Futures	1147.43	1149.53	1134.42	1137.67	172930.0
2008-09-05 09:00:00	ES	Futures	1137.67	1147.43	1137.44	1142.32	373825.0
2008-09-05 10:00:00	ES	Futures	1142.55	1144.88	1132.33	1133.26	503017.0
2008-09-05 11:00:00	ES	Futures	1133.02	1145.81	1130.93	1143.02	421058.0
2008-09-05 12:00:00	ES	Futures	1143.25	1147.67	1140.23	1145.11	286367.0
2008-09-05 13:00:00	ES	Futures	1145.34	1149.53	1143.72	1147.67	265544.0
2008-09-05 14:00:00	ES	Futures	1147.67	1155.34	1144.41	1153.48	291808.0
2008-09-05 15:00:00	ES	Futures	1153.48	1157.66	1149.29	1155.1	336061.0
2008-09-05 16:00:00	ES	Futures	1155.1	1155.57	1153.01	1153.01	106656.0
2008-09-05 00:00:00	NQ	Futures	1989.84	1993.21	1987.87	1991.81	105.0
2008-09-05 01:00:00	NQ	Futures	1992.09	1993.49	1989.27	1992.65	174.0
2008-09-05 02:00:00	NQ	Futures	1992.65	1997.99	1988.43	1997.15	2607.0
2008-09-05 03:00:00	NQ	Futures	1997.43	2001.65	1996.59	1999.68	2256.0
2008-09-05 04:00:00	NQ	Futures	1999.96	2001.37	1985.9	1988.99	3497.0
2008-09-05 05:00:00	NQ	Futures	1988.71	1993.49	1986.46	1990.12	993.0
2008-09-05 06:00:00	NQ	Futures	1990.68	1991.52	1988.43	1990.12	659.0
2008-09-05 07:00:00	NQ	Futures	1990.12	2000.53	1989.27	1999.96	3439.0
2008-09-05 08:00:00	NQ	Futures	1999.4	1999.96	1969.3	1973.8	25262.0
2008-09-05 09:00:00	NQ	Futures	1973.8	1992.09	1973.24	1988.99	70494.0
2008-09-05 10:00:00	NQ	Futures	1988.99	1995.46	1964.8	1966.21	84521.0
2008-09-05 11:00:00	NQ	Futures	1966.21	1985.9	1959.18	1981.12	71589.0
2008-09-05 12:00:00	NQ	Futures	1981.12	1993.21	1978.02	1987.87	49171.0
2008-09-05 13:00:00	NQ	Futures	1987.87	1999.96	1981.96	1990.4	41854.0
2008-09-05 14:00:00	NQ	Futures	1990.12	2003.34	1981.68	1999.12	45582.0
2008-09-05 15:00:00	NQ	Futures	1998.56	1999.96	1987.59	1990.68	53159.0
2008-09-05 16:00:00	NQ	Futures	1990.68	1993.49	1987.31	1990.12	11690.0
2008-09-05 00:00:00	YM	Futures	10148.5	10159.4	10137.6	10153.9	133.0
2008-09-05 01:00:00	YM	Futures	10152.1	10156.7	10137.6	10150.3	151.0
2008-09-05 02:00:00	YM	Futures	10149.4	10166.7	10142.1	10164.8	293.0
2008-09-05 03:00:00	YM	Futures	10163.0	10182.1	10156.7	10173.0	1143.0
2008-09-05 04:00:00	YM	Futures	10173.9	10179.4	10108.5	10120.3	2137.0
2008-09-05 05:00:00	YM	Futures	10120.3	10140.3	10111.2	10130.3	1133.0
2008-09-05 06:00:00	YM	Futures	10129.4	10132.1	10119.4	10121.2	765.0
2008-09-05 07:00:00	YM	Futures	10121.2	10163.9	10114.0	10162.1	1723.0
2008-09-05 08:00:00	YM	Futures	10161.2	10177.6	10057.6	10088.5	14506.0
2008-09-05 09:00:00	YM	Futures	10088.5	10160.3	10083.1	10114.0	33527.0
2008-09-05 10:00:00	YM	Futures	10113.0	10136.7	10043.1	10051.2	50868.0
2008-09-05 11:00:00	YM	Futures	10051.2	10159.4	10034.0	10134.9	37737.0
2008-09-05 12:00:00	YM	Futures	10134.9	10178.5	10108.5	10154.9	31035.0
2008-09-05 13:00:00	YM	Futures	10153.9	10187.6	10134.9	10168.5	21926.0
2008-09-05 14:00:00	YM	Futures	10168.5	10213.9	10139.4	10201.2	26931.0
2008-09-05 15:00:00	YM	Futures	10200.3	10222.1	10163.9	10203.0	25494.0

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

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