PREVIEW / futures_1hour / 2009-09-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	1026.05	1027.26	1026.05	1027.02	1462.0
2009-09-29 01:00:00	ES	Futures	1027.02	1027.5	1026.54	1027.02	2335.0
2009-09-29 02:00:00	ES	Futures	1026.78	1027.99	1025.08	1027.5	9077.0
2009-09-29 03:00:00	ES	Futures	1027.75	1027.75	1024.11	1024.6	17688.0
2009-09-29 04:00:00	ES	Futures	1024.6	1025.32	1023.63	1024.36	16469.0
2009-09-29 05:00:00	ES	Futures	1024.36	1025.08	1023.39	1024.6	11162.0
2009-09-29 06:00:00	ES	Futures	1024.6	1026.05	1023.14	1024.11	11756.0
2009-09-29 07:00:00	ES	Futures	1024.11	1026.29	1023.63	1024.11	13856.0
2009-09-29 08:00:00	ES	Futures	1024.11	1026.54	1023.39	1026.05	35059.0
2009-09-29 09:00:00	ES	Futures	1026.29	1032.59	1026.05	1031.62	271540.0
2009-09-29 10:00:00	ES	Futures	1031.38	1031.38	1022.66	1023.14	423257.0
2009-09-29 11:00:00	ES	Futures	1023.14	1024.84	1020.48	1022.18	182663.0
2009-09-29 12:00:00	ES	Futures	1022.42	1025.81	1021.93	1025.81	113778.0
2009-09-29 13:00:00	ES	Futures	1025.81	1027.99	1025.57	1027.26	108118.0
2009-09-29 14:00:00	ES	Futures	1027.5	1027.75	1023.87	1025.81	111954.0
2009-09-29 15:00:00	ES	Futures	1025.81	1026.78	1022.66	1022.9	204280.0
2009-09-29 16:00:00	ES	Futures	1022.9	1024.11	1021.45	1021.93	86854.0
2009-09-29 17:00:00	ES	Futures	1021.69	1022.66	1020.96	1022.18	2674.0
2009-09-29 18:00:00	ES	Futures	1022.18	1022.66	1021.69	1022.42	1305.0
2009-09-29 19:00:00	ES	Futures	1022.42	1023.14	1022.18	1022.9	1232.0
2009-09-29 20:00:00	ES	Futures	1022.9	1023.87	1022.9	1023.63	2867.0
2009-09-29 21:00:00	ES	Futures	1023.87	1024.11	1022.18	1023.39	6060.0
2009-09-29 22:00:00	ES	Futures	1023.63	1024.36	1023.14	1023.87	2773.0
2009-09-29 23:00:00	ES	Futures	1023.63	1024.11	1022.9	1023.63	1610.0
2009-09-29 00:00:00	NQ	Futures	1964.42	1965.56	1964.13	1965.56	360.0
2009-09-29 01:00:00	NQ	Futures	1965.56	1965.84	1964.7	1964.99	382.0
2009-09-29 02:00:00	NQ	Futures	1964.7	1966.41	1962.71	1966.13	1458.0
2009-09-29 03:00:00	NQ	Futures	1966.13	1966.41	1960.14	1961.0	2641.0
2009-09-29 04:00:00	NQ	Futures	1961.57	1961.85	1958.43	1959.0	2242.0
2009-09-29 05:00:00	NQ	Futures	1959.28	1959.28	1956.72	1958.14	1754.0
2009-09-29 06:00:00	NQ	Futures	1958.43	1960.14	1955.29	1957.57	1231.0
2009-09-29 07:00:00	NQ	Futures	1957.86	1961.0	1956.72	1958.14	1276.0
2009-09-29 08:00:00	NQ	Futures	1958.14	1962.71	1956.43	1961.85	3915.0
2009-09-29 09:00:00	NQ	Futures	1961.85	1974.4	1961.85	1971.55	42210.0
2009-09-29 10:00:00	NQ	Futures	1971.55	1971.55	1951.58	1951.87	67446.0
2009-09-29 11:00:00	NQ	Futures	1951.87	1955.58	1947.02	1949.87	37332.0
2009-09-29 12:00:00	NQ	Futures	1949.87	1959.85	1949.59	1959.85	29229.0
2009-09-29 13:00:00	NQ	Futures	1959.85	1964.42	1959.57	1961.28	25506.0
2009-09-29 14:00:00	NQ	Futures	1961.28	1961.85	1956.15	1959.0	18182.0
2009-09-29 15:00:00	NQ	Futures	1959.0	1961.28	1954.72	1956.43	29606.0
2009-09-29 16:00:00	NQ	Futures	1956.72	1958.71	1955.29	1955.29	9007.0
2009-09-29 17:00:00	NQ	Futures	1955.58	1957.57	1954.44	1956.72	234.0
2009-09-29 18:00:00	NQ	Futures	1956.43	1956.43	1954.44	1955.86	105.0
2009-09-29 19:00:00	NQ	Futures	1955.86	1957.86	1955.86	1957.86	179.0
2009-09-29 20:00:00	NQ	Futures	1957.86	1960.71	1957.0	1959.0	355.0
2009-09-29 21:00:00	NQ	Futures	1959.0	1960.14	1957.0	1959.0	780.0
2009-09-29 22:00:00	NQ	Futures	1959.28	1960.71	1958.71	1959.85	314.0
2009-09-29 23:00:00	NQ	Futures	1959.57	1959.57	1958.14	1959.28	139.0
2009-09-29 00:00:00	YM	Futures	9051.6	9060.0	9051.6	9060.0	255.0
2009-09-29 01:00:00	YM	Futures	9060.0	9061.9	9056.3	9056.3	256.0

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

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