PREVIEW / futures_1hour / 2009-09-22

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-22.parquet
  size:    42 KB
  rows:    1,264

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-09-22 00:00:00	ES	Futures	1029.44	1029.68	1028.72	1029.2	985.0
2009-09-22 01:00:00	ES	Futures	1029.2	1029.44	1028.72	1028.72	878.0
2009-09-22 02:00:00	ES	Futures	1028.96	1030.41	1028.72	1029.68	7215.0
2009-09-22 03:00:00	ES	Futures	1029.93	1035.5	1029.68	1034.53	33235.0
2009-09-22 04:00:00	ES	Futures	1034.53	1035.26	1034.04	1034.29	12944.0
2009-09-22 05:00:00	ES	Futures	1034.29	1034.77	1033.32	1033.8	11609.0
2009-09-22 06:00:00	ES	Futures	1033.8	1035.74	1033.8	1035.01	14465.0
2009-09-22 07:00:00	ES	Futures	1035.26	1035.26	1034.04	1034.29	14452.0
2009-09-22 08:00:00	ES	Futures	1034.29	1034.77	1033.08	1033.08	31138.0
2009-09-22 09:00:00	ES	Futures	1033.32	1034.29	1030.17	1030.65	215485.0
2009-09-22 10:00:00	ES	Futures	1030.65	1032.83	1028.47	1030.65	296798.0
2009-09-22 11:00:00	ES	Futures	1030.65	1033.56	1030.41	1033.08	138623.0
2009-09-22 12:00:00	ES	Futures	1033.08	1035.74	1032.83	1034.04	137244.0
2009-09-22 13:00:00	ES	Futures	1034.04	1035.98	1031.86	1033.32	133565.0
2009-09-22 14:00:00	ES	Futures	1033.32	1034.77	1032.35	1034.77	93942.0
2009-09-22 15:00:00	ES	Futures	1034.77	1035.5	1032.35	1033.08	193331.0
2009-09-22 16:00:00	ES	Futures	1033.32	1034.29	1032.83	1033.56	60976.0
2009-09-22 17:00:00	ES	Futures	1033.56	1034.04	1033.32	1033.32	1806.0
2009-09-22 18:00:00	ES	Futures	1033.32	1035.01	1033.32	1034.29	2660.0
2009-09-22 19:00:00	ES	Futures	1034.29	1035.01	1034.04	1034.53	1142.0
2009-09-22 20:00:00	ES	Futures	1034.29	1034.53	1032.35	1032.83	4871.0
2009-09-22 21:00:00	ES	Futures	1032.83	1032.83	1030.65	1032.11	4518.0
2009-09-22 22:00:00	ES	Futures	1031.86	1033.08	1031.14	1032.59	3201.0
2009-09-22 23:00:00	ES	Futures	1032.59	1033.56	1032.59	1033.32	1937.0
2009-09-22 00:00:00	NQ	Futures	1976.68	1976.97	1975.25	1976.11	119.0
2009-09-22 01:00:00	NQ	Futures	1976.11	1976.11	1974.97	1974.97	144.0
2009-09-22 02:00:00	NQ	Futures	1974.97	1978.39	1974.97	1976.68	534.0
2009-09-22 03:00:00	NQ	Futures	1976.68	1985.81	1976.4	1983.81	4987.0
2009-09-22 04:00:00	NQ	Futures	1983.81	1986.09	1983.24	1983.81	1857.0
2009-09-22 05:00:00	NQ	Futures	1983.81	1984.38	1982.67	1983.24	1113.0
2009-09-22 06:00:00	NQ	Futures	1983.53	1986.38	1982.67	1985.52	1488.0
2009-09-22 07:00:00	NQ	Futures	1985.81	1985.81	1982.1	1983.81	2246.0
2009-09-22 08:00:00	NQ	Futures	1983.53	1984.95	1980.96	1981.53	3547.0
2009-09-22 09:00:00	NQ	Futures	1981.24	1985.24	1973.54	1974.4	44501.0
2009-09-22 10:00:00	NQ	Futures	1974.4	1978.96	1968.41	1971.55	45206.0
2009-09-22 11:00:00	NQ	Futures	1971.55	1977.82	1971.55	1976.4	19026.0
2009-09-22 12:00:00	NQ	Futures	1976.68	1981.24	1975.54	1977.25	23688.0
2009-09-22 13:00:00	NQ	Futures	1977.25	1980.1	1972.4	1974.68	20260.0
2009-09-22 14:00:00	NQ	Futures	1974.97	1978.39	1972.69	1978.11	15729.0
2009-09-22 15:00:00	NQ	Futures	1977.82	1980.1	1973.83	1975.54	29501.0
2009-09-22 16:00:00	NQ	Futures	1975.83	1978.68	1974.68	1978.11	9515.0
2009-09-22 17:00:00	NQ	Futures	1978.11	1978.68	1977.54	1977.54	110.0
2009-09-22 18:00:00	NQ	Futures	1978.11	1979.82	1977.82	1979.53	114.0
2009-09-22 19:00:00	NQ	Futures	1979.82	1980.67	1979.25	1979.53	251.0
2009-09-22 20:00:00	NQ	Futures	1979.53	1980.1	1976.68	1976.97	270.0
2009-09-22 21:00:00	NQ	Futures	1976.97	1976.97	1974.11	1976.4	764.0
2009-09-22 22:00:00	NQ	Futures	1976.68	1977.82	1974.11	1977.25	345.0
2009-09-22 23:00:00	NQ	Futures	1977.54	1978.68	1977.25	1978.11	213.0
2009-09-22 00:00:00	YM	Futures	9057.2	9060.0	9054.4	9056.3	139.0
2009-09-22 01:00:00	YM	Futures	9056.3	9059.1	9056.3	9057.2	61.0

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

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