PREVIEW / futures_1hour / 2009-09-21

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-21.parquet
  size:    43 KB
  rows:    1,280

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-21 00:00:00	ES	Futures	1024.84	1026.54	1024.84	1026.29	1398.0
2009-09-21 01:00:00	ES	Futures	1026.29	1026.78	1025.32	1026.78	2160.0
2009-09-21 02:00:00	ES	Futures	1026.54	1027.26	1024.11	1025.57	7498.0
2009-09-21 03:00:00	ES	Futures	1025.32	1025.81	1021.69	1022.18	25010.0
2009-09-21 04:00:00	ES	Futures	1022.18	1023.63	1020.72	1020.72	24067.0
2009-09-21 05:00:00	ES	Futures	1020.96	1021.45	1019.27	1020.72	18363.0
2009-09-21 06:00:00	ES	Futures	1020.72	1022.18	1019.75	1021.45	13370.0
2009-09-21 07:00:00	ES	Futures	1021.45	1023.14	1020.96	1021.45	17985.0
2009-09-21 08:00:00	ES	Futures	1021.45	1022.66	1018.78	1021.45	53427.0
2009-09-21 09:00:00	ES	Futures	1021.45	1025.08	1020.0	1020.72	251951.0
2009-09-21 10:00:00	ES	Futures	1020.72	1024.36	1019.27	1023.14	321353.0
2009-09-21 11:00:00	ES	Futures	1022.9	1028.47	1022.9	1027.26	261484.0
2009-09-21 12:00:00	ES	Futures	1027.26	1027.99	1025.08	1025.81	88061.0
2009-09-21 13:00:00	ES	Futures	1025.81	1027.26	1024.36	1026.54	85705.0
2009-09-21 14:00:00	ES	Futures	1026.78	1027.99	1025.08	1026.54	141597.0
2009-09-21 15:00:00	ES	Futures	1026.78	1029.68	1024.6	1027.02	285930.0
2009-09-21 16:00:00	ES	Futures	1027.02	1027.99	1025.57	1026.78	82081.0
2009-09-21 17:00:00	ES	Futures	1026.78	1027.26	1026.78	1026.78	1618.0
2009-09-21 18:00:00	ES	Futures	1027.02	1027.26	1026.54	1027.26	1590.0
2009-09-21 19:00:00	ES	Futures	1027.26	1028.47	1026.54	1027.99	3850.0
2009-09-21 20:00:00	ES	Futures	1027.99	1028.96	1027.5	1028.23	2706.0
2009-09-21 21:00:00	ES	Futures	1028.23	1028.96	1027.75	1027.99	1896.0
2009-09-21 22:00:00	ES	Futures	1027.99	1029.68	1027.75	1029.44	3414.0
2009-09-21 23:00:00	ES	Futures	1029.2	1029.44	1028.96	1029.44	1049.0
2009-09-21 00:00:00	NQ	Futures	1956.72	1959.28	1956.72	1959.0	172.0
2009-09-21 01:00:00	NQ	Futures	1959.28	1959.57	1957.57	1959.28	229.0
2009-09-21 02:00:00	NQ	Futures	1959.57	1961.0	1955.58	1957.86	670.0
2009-09-21 03:00:00	NQ	Futures	1958.14	1958.71	1951.58	1953.58	2855.0
2009-09-21 04:00:00	NQ	Futures	1953.29	1954.72	1950.16	1950.73	1903.0
2009-09-21 05:00:00	NQ	Futures	1950.44	1952.15	1947.02	1948.73	2347.0
2009-09-21 06:00:00	NQ	Futures	1949.02	1951.3	1948.16	1951.3	966.0
2009-09-21 07:00:00	NQ	Futures	1951.3	1955.58	1951.3	1952.72	2134.0
2009-09-21 08:00:00	NQ	Futures	1953.01	1955.86	1949.02	1955.29	6210.0
2009-09-21 09:00:00	NQ	Futures	1955.29	1963.85	1951.87	1956.15	43918.0
2009-09-21 10:00:00	NQ	Futures	1956.43	1965.27	1952.72	1963.85	55586.0
2009-09-21 11:00:00	NQ	Futures	1963.85	1977.82	1962.71	1974.4	45255.0
2009-09-21 12:00:00	NQ	Futures	1974.4	1975.25	1970.12	1971.26	19195.0
2009-09-21 13:00:00	NQ	Futures	1971.26	1973.26	1968.12	1972.69	14306.0
2009-09-21 14:00:00	NQ	Futures	1972.97	1975.25	1968.41	1972.69	19656.0
2009-09-21 15:00:00	NQ	Futures	1972.69	1977.82	1969.27	1972.12	34564.0
2009-09-21 16:00:00	NQ	Futures	1972.12	1972.4	1968.98	1969.55	10491.0
2009-09-21 17:00:00	NQ	Futures	1969.55	1970.41	1969.55	1970.41	219.0
2009-09-21 18:00:00	NQ	Futures	1970.98	1971.83	1970.41	1970.98	1006.0
2009-09-21 19:00:00	NQ	Futures	1971.55	1974.68	1970.69	1974.11	809.0
2009-09-21 20:00:00	NQ	Futures	1974.11	1975.54	1972.4	1973.83	237.0
2009-09-21 21:00:00	NQ	Futures	1974.11	1975.25	1973.26	1973.54	227.0
2009-09-21 22:00:00	NQ	Futures	1973.54	1977.25	1973.54	1976.68	479.0
2009-09-21 23:00:00	NQ	Futures	1976.68	1976.97	1975.83	1976.4	77.0
2009-09-21 00:00:00	YM	Futures	9034.9	9045.1	9034.9	9044.2	149.0
2009-09-21 01:00:00	YM	Futures	9045.1	9048.8	9039.5	9048.8	92.0

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

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