PREVIEW / futures_1hour / 2010-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-02-04.parquet
  size:    49 KB
  rows:    1,417

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-02-04 00:00:00	ES	Futures	1065.23	1066.45	1064.99	1065.47	3151.0
2010-02-04 01:00:00	ES	Futures	1065.47	1066.2	1064.5	1064.74	1967.0
2010-02-04 02:00:00	ES	Futures	1064.74	1064.99	1062.8	1062.8	9443.0
2010-02-04 03:00:00	ES	Futures	1062.8	1065.23	1061.34	1061.58	34457.0
2010-02-04 04:00:00	ES	Futures	1061.34	1062.07	1058.91	1060.12	48986.0
2010-02-04 05:00:00	ES	Futures	1060.12	1060.85	1058.18	1059.88	25458.0
2010-02-04 06:00:00	ES	Futures	1059.64	1061.09	1059.15	1060.12	20411.0
2010-02-04 07:00:00	ES	Futures	1059.88	1062.31	1058.91	1060.85	25714.0
2010-02-04 08:00:00	ES	Futures	1060.85	1061.58	1055.5	1056.47	106681.0
2010-02-04 09:00:00	ES	Futures	1056.47	1056.96	1044.55	1045.77	423333.0
2010-02-04 10:00:00	ES	Futures	1045.53	1047.96	1040.9	1041.15	529790.0
2010-02-04 11:00:00	ES	Futures	1041.15	1044.55	1037.01	1040.9	469631.0
2010-02-04 12:00:00	ES	Futures	1040.66	1041.39	1036.04	1039.2	260561.0
2010-02-04 13:00:00	ES	Futures	1038.96	1039.93	1035.8	1036.53	229829.0
2010-02-04 14:00:00	ES	Futures	1036.77	1040.66	1035.07	1038.96	308628.0
2010-02-04 15:00:00	ES	Futures	1039.2	1039.44	1030.69	1031.17	571659.0
2010-02-04 16:00:00	ES	Futures	1031.17	1034.09	1030.93	1032.88	194648.0
2010-02-04 17:00:00	ES	Futures	1032.88	1033.85	1032.39	1033.61	2387.0
2010-02-04 18:00:00	ES	Futures	1034.09	1035.07	1033.85	1034.82	6855.0
2010-02-04 19:00:00	ES	Futures	1034.58	1035.07	1033.12	1033.85	8231.0
2010-02-04 20:00:00	ES	Futures	1033.85	1035.07	1032.39	1034.82	10170.0
2010-02-04 21:00:00	ES	Futures	1035.07	1035.31	1034.09	1034.82	5900.0
2010-02-04 22:00:00	ES	Futures	1035.07	1035.8	1034.58	1035.55	4321.0
2010-02-04 23:00:00	ES	Futures	1035.55	1036.04	1035.31	1035.31	3813.0
2010-02-04 00:00:00	NQ	Futures	2041.39	2042.25	2040.25	2040.25	706.0
2010-02-04 01:00:00	NQ	Futures	2040.53	2041.39	2039.39	2039.68	242.0
2010-02-04 02:00:00	NQ	Futures	2039.68	2039.68	2035.39	2035.68	1180.0
2010-02-04 03:00:00	NQ	Futures	2035.68	2039.39	2033.11	2033.97	3038.0
2010-02-04 04:00:00	NQ	Futures	2033.68	2033.68	2029.68	2031.68	4041.0
2010-02-04 05:00:00	NQ	Futures	2031.68	2031.68	2027.4	2029.68	2820.0
2010-02-04 06:00:00	NQ	Futures	2029.4	2031.39	2028.25	2029.4	1949.0
2010-02-04 07:00:00	NQ	Futures	2029.4	2033.68	2027.97	2032.25	2785.0
2010-02-04 08:00:00	NQ	Futures	2032.25	2035.11	2023.68	2023.97	12156.0
2010-02-04 09:00:00	NQ	Futures	2024.25	2025.97	2001.4	2002.55	72775.0
2010-02-04 10:00:00	NQ	Futures	2002.55	2007.12	1995.69	1996.55	87556.0
2010-02-04 11:00:00	NQ	Futures	1996.83	1999.69	1985.69	1991.69	59053.0
2010-02-04 12:00:00	NQ	Futures	1991.98	1994.55	1983.98	1989.41	39690.0
2010-02-04 13:00:00	NQ	Futures	1989.41	1992.26	1985.41	1986.27	33877.0
2010-02-04 14:00:00	NQ	Futures	1986.55	1993.12	1983.98	1990.26	53835.0
2010-02-04 15:00:00	NQ	Futures	1989.98	1991.41	1978.27	1978.55	81220.0
2010-02-04 16:00:00	NQ	Futures	1978.84	1983.41	1978.84	1979.98	20254.0
2010-02-04 17:00:00	NQ	Futures	1979.98	1981.98	1979.7	1981.98	72.0
2010-02-04 18:00:00	NQ	Futures	1981.98	1984.27	1981.98	1983.12	280.0
2010-02-04 19:00:00	NQ	Futures	1983.12	1984.27	1981.41	1982.27	383.0
2010-02-04 20:00:00	NQ	Futures	1981.98	1983.41	1979.12	1982.84	572.0
2010-02-04 21:00:00	NQ	Futures	1983.12	1985.12	1982.27	1985.12	318.0
2010-02-04 22:00:00	NQ	Futures	1985.12	1985.98	1983.98	1985.69	291.0
2010-02-04 23:00:00	NQ	Futures	1985.69	1986.55	1985.12	1985.12	223.0
2010-02-04 00:00:00	YM	Futures	9571.5	9579.9	9569.6	9571.5	415.0
2010-02-04 01:00:00	YM	Futures	9571.5	9575.2	9565.9	9568.7	315.0

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

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