PREVIEW / futures_1hour / 2009-10-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-08.parquet
  size:    44 KB
  rows:    1,329

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-10-08 00:00:00	ES	Futures	1029.93	1029.93	1028.96	1029.68	4221.0
2009-10-08 01:00:00	ES	Futures	1029.93	1029.93	1029.44	1029.93	2002.0
2009-10-08 02:00:00	ES	Futures	1029.68	1031.86	1029.68	1031.62	12738.0
2009-10-08 03:00:00	ES	Futures	1031.62	1031.86	1030.17	1031.62	28794.0
2009-10-08 04:00:00	ES	Futures	1031.62	1032.59	1029.68	1029.68	19385.0
2009-10-08 05:00:00	ES	Futures	1029.68	1031.14	1028.96	1030.65	8941.0
2009-10-08 06:00:00	ES	Futures	1030.65	1030.9	1029.44	1030.17	10962.0
2009-10-08 07:00:00	ES	Futures	1029.93	1030.65	1028.72	1029.2	19617.0
2009-10-08 08:00:00	ES	Futures	1029.2	1032.59	1028.23	1030.41	50923.0
2009-10-08 09:00:00	ES	Futures	1030.17	1030.65	1025.57	1027.26	254222.0
2009-10-08 10:00:00	ES	Futures	1027.26	1029.93	1023.87	1029.2	267088.0
2009-10-08 11:00:00	ES	Futures	1028.96	1033.56	1027.75	1032.59	286517.0
2009-10-08 12:00:00	ES	Futures	1032.59	1034.04	1030.9	1032.83	141205.0
2009-10-08 13:00:00	ES	Futures	1032.59	1033.08	1027.99	1030.65	187860.0
2009-10-08 14:00:00	ES	Futures	1030.65	1031.14	1027.26	1029.68	123902.0
2009-10-08 15:00:00	ES	Futures	1029.68	1032.11	1027.5	1028.47	272758.0
2009-10-08 16:00:00	ES	Futures	1028.23	1031.86	1028.23	1031.14	86701.0
2009-10-08 17:00:00	ES	Futures	1030.9	1031.62	1030.65	1030.65	1885.0
2009-10-08 18:00:00	ES	Futures	1030.65	1031.62	1030.41	1031.14	2379.0
2009-10-08 19:00:00	ES	Futures	1031.38	1031.62	1030.17	1031.14	2761.0
2009-10-08 20:00:00	ES	Futures	1031.14	1031.38	1030.17	1030.9	2681.0
2009-10-08 21:00:00	ES	Futures	1030.65	1032.35	1029.68	1029.93	6388.0
2009-10-08 22:00:00	ES	Futures	1029.93	1030.41	1029.2	1029.44	1951.0
2009-10-08 23:00:00	ES	Futures	1029.2	1030.41	1028.96	1030.41	2641.0
2009-10-08 00:00:00	NQ	Futures	1963.28	1963.56	1962.42	1963.56	391.0
2009-10-08 01:00:00	NQ	Futures	1963.28	1963.56	1962.42	1962.99	191.0
2009-10-08 02:00:00	NQ	Futures	1963.28	1966.7	1963.28	1966.41	1509.0
2009-10-08 03:00:00	NQ	Futures	1966.13	1966.98	1963.28	1965.84	3285.0
2009-10-08 04:00:00	NQ	Futures	1966.13	1967.84	1963.28	1963.28	2139.0
2009-10-08 05:00:00	NQ	Futures	1962.99	1965.84	1962.14	1964.7	866.0
2009-10-08 06:00:00	NQ	Futures	1964.42	1964.99	1962.71	1963.56	571.0
2009-10-08 07:00:00	NQ	Futures	1963.28	1963.85	1961.57	1962.42	1478.0
2009-10-08 08:00:00	NQ	Futures	1962.14	1966.7	1960.42	1963.85	4214.0
2009-10-08 09:00:00	NQ	Futures	1963.85	1966.98	1956.72	1960.42	41907.0
2009-10-08 10:00:00	NQ	Futures	1960.42	1964.42	1952.15	1962.71	44213.0
2009-10-08 11:00:00	NQ	Futures	1962.42	1973.54	1960.14	1970.41	55463.0
2009-10-08 12:00:00	NQ	Futures	1970.41	1974.4	1967.27	1970.12	22548.0
2009-10-08 13:00:00	NQ	Futures	1970.12	1970.69	1959.0	1964.7	31664.0
2009-10-08 14:00:00	NQ	Futures	1964.42	1965.56	1956.72	1962.99	23146.0
2009-10-08 15:00:00	NQ	Futures	1962.71	1967.84	1955.58	1955.58	44005.0
2009-10-08 16:00:00	NQ	Futures	1955.86	1958.71	1953.87	1954.72	16598.0
2009-10-08 17:00:00	NQ	Futures	1954.72	1955.29	1953.58	1954.15	733.0
2009-10-08 18:00:00	NQ	Futures	1954.44	1956.15	1953.87	1955.29	807.0
2009-10-08 19:00:00	NQ	Futures	1955.29	1956.15	1952.72	1955.58	533.0
2009-10-08 20:00:00	NQ	Futures	1955.29	1955.86	1953.01	1955.01	741.0
2009-10-08 21:00:00	NQ	Futures	1954.72	1957.0	1951.87	1952.72	1164.0
2009-10-08 22:00:00	NQ	Futures	1952.72	1953.01	1950.73	1950.73	422.0
2009-10-08 23:00:00	NQ	Futures	1950.73	1953.58	1950.73	1953.58	212.0
2009-10-08 00:00:00	YM	Futures	9066.5	9069.3	9062.8	9067.4	161.0
2009-10-08 01:00:00	YM	Futures	9067.4	9069.3	9065.6	9067.4	217.0

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

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