PREVIEW / futures_1hour / 2010-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-07.parquet
  size:    47 KB
  rows:    1,364

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
2010-07-07 00:00:00	ES	Futures	1001.39	1001.64	999.92	1000.66	4105.0
2010-07-07 01:00:00	ES	Futures	1000.66	1003.6	1000.41	1001.15	6724.0
2010-07-07 02:00:00	ES	Futures	1001.15	1003.6	1001.15	1002.62	7828.0
2010-07-07 03:00:00	ES	Futures	1002.62	1004.34	1000.9	1002.62	33349.0
2010-07-07 04:00:00	ES	Futures	1002.62	1003.11	998.2	999.19	30162.0
2010-07-07 05:00:00	ES	Futures	998.94	1000.41	997.47	998.69	19408.0
2010-07-07 06:00:00	ES	Futures	998.45	1003.11	997.71	1002.62	20165.0
2010-07-07 07:00:00	ES	Futures	1002.62	1004.83	1001.88	1002.38	41990.0
2010-07-07 08:00:00	ES	Futures	1002.38	1006.79	1000.9	1005.81	79688.0
2010-07-07 09:00:00	ES	Futures	1005.81	1011.95	1004.34	1011.7	263003.0
2010-07-07 10:00:00	ES	Futures	1011.45	1022.5	1011.45	1021.27	497649.0
2010-07-07 11:00:00	ES	Futures	1021.27	1022.25	1016.61	1018.08	279748.0
2010-07-07 12:00:00	ES	Futures	1017.83	1021.76	1017.59	1020.53	131287.0
2010-07-07 13:00:00	ES	Futures	1020.53	1027.4	1020.29	1026.18	223409.0
2010-07-07 14:00:00	ES	Futures	1026.18	1028.88	1024.95	1028.63	187462.0
2010-07-07 15:00:00	ES	Futures	1028.88	1037.96	1026.67	1036.73	517112.0
2010-07-07 16:00:00	ES	Futures	1036.48	1040.16	1036.48	1039.43	186979.0
2010-07-07 17:00:00	ES	Futures	1039.43	1039.92	1038.69	1038.94	2663.0
2010-07-07 18:00:00	ES	Futures	1039.43	1039.92	1038.94	1039.43	4288.0
2010-07-07 19:00:00	ES	Futures	1039.18	1039.43	1038.2	1038.69	2959.0
2010-07-07 20:00:00	ES	Futures	1038.45	1039.43	1037.71	1038.94	8574.0
2010-07-07 21:00:00	ES	Futures	1038.94	1042.62	1038.45	1040.16	15471.0
2010-07-07 22:00:00	ES	Futures	1039.92	1040.41	1038.69	1039.92	5290.0
2010-07-07 23:00:00	ES	Futures	1039.92	1040.16	1038.69	1039.67	2906.0
2010-07-07 00:00:00	NQ	Futures	1981.6	1982.46	1978.45	1980.74	843.0
2010-07-07 01:00:00	NQ	Futures	1981.6	1986.48	1981.32	1983.9	1094.0
2010-07-07 02:00:00	NQ	Futures	1983.61	1986.48	1983.32	1984.76	681.0
2010-07-07 03:00:00	NQ	Futures	1984.76	1988.2	1982.46	1986.19	2290.0
2010-07-07 04:00:00	NQ	Futures	1986.19	1986.76	1975.59	1978.17	2279.0
2010-07-07 05:00:00	NQ	Futures	1977.88	1980.17	1973.58	1976.45	1784.0
2010-07-07 06:00:00	NQ	Futures	1976.45	1984.76	1974.44	1983.9	1433.0
2010-07-07 07:00:00	NQ	Futures	1983.61	1988.2	1982.75	1984.76	1703.0
2010-07-07 08:00:00	NQ	Futures	1984.76	1989.34	1982.18	1985.62	11219.0
2010-07-07 09:00:00	NQ	Futures	1985.9	2002.52	1983.61	1999.94	41454.0
2010-07-07 10:00:00	NQ	Futures	1999.94	2017.42	1999.94	2015.71	50574.0
2010-07-07 11:00:00	NQ	Futures	2015.71	2018.57	2007.97	2010.83	36159.0
2010-07-07 12:00:00	NQ	Futures	2010.55	2016.28	2009.69	2013.7	18940.0
2010-07-07 13:00:00	NQ	Futures	2013.41	2027.17	2012.84	2025.74	28219.0
2010-07-07 14:00:00	NQ	Futures	2025.45	2031.47	2022.58	2031.18	23957.0
2010-07-07 15:00:00	NQ	Futures	2031.18	2049.52	2026.59	2047.8	62024.0
2010-07-07 16:00:00	NQ	Futures	2047.8	2051.24	2047.23	2050.67	17125.0
2010-07-07 17:00:00	NQ	Futures	2050.67	2050.95	2049.81	2049.81	296.0
2010-07-07 18:00:00	NQ	Futures	2049.81	2054.39	2049.81	2050.95	491.0
2010-07-07 19:00:00	NQ	Futures	2050.67	2051.24	2048.95	2049.23	277.0
2010-07-07 20:00:00	NQ	Futures	2049.52	2050.67	2048.37	2050.38	611.0
2010-07-07 21:00:00	NQ	Futures	2049.81	2057.54	2049.23	2052.39	1100.0
2010-07-07 22:00:00	NQ	Futures	2052.39	2053.25	2050.67	2052.67	370.0
2010-07-07 23:00:00	NQ	Futures	2052.1	2052.39	2050.09	2051.53	366.0
2010-07-07 00:00:00	YM	Futures	9132.9	9135.7	9121.5	9124.3	530.0
2010-07-07 01:00:00	YM	Futures	9125.3	9149.0	9125.3	9131.9	426.0

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

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