PREVIEW / futures_1hour / 2009-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-06.parquet
  size:    37 KB
  rows:    1,082

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-11-06 00:00:00	ES	Futures	1028.47	1029.2	1028.47	1028.96	3494.0
2009-11-06 01:00:00	ES	Futures	1029.2	1029.2	1028.47	1028.72	1578.0
2009-11-06 02:00:00	ES	Futures	1028.96	1030.9	1028.47	1028.72	10212.0
2009-11-06 03:00:00	ES	Futures	1028.72	1033.32	1027.99	1032.83	37197.0
2009-11-06 04:00:00	ES	Futures	1032.83	1033.08	1029.68	1030.9	27837.0
2009-11-06 05:00:00	ES	Futures	1030.65	1031.14	1028.47	1030.65	23303.0
2009-11-06 06:00:00	ES	Futures	1030.41	1032.11	1030.17	1030.65	15779.0
2009-11-06 07:00:00	ES	Futures	1030.65	1032.35	1030.17	1031.86	21042.0
2009-11-06 08:00:00	ES	Futures	1031.86	1036.22	1020.72	1023.14	237071.0
2009-11-06 09:00:00	ES	Futures	1023.14	1035.26	1021.93	1033.8	388280.0
2009-11-06 10:00:00	ES	Futures	1033.56	1035.98	1024.6	1029.93	462068.0
2009-11-06 11:00:00	ES	Futures	1029.68	1031.86	1027.26	1030.41	211938.0
2009-11-06 12:00:00	ES	Futures	1030.41	1034.04	1030.41	1031.62	135337.0
2009-11-06 13:00:00	ES	Futures	1031.38	1034.53	1030.17	1032.11	106859.0
2009-11-06 14:00:00	ES	Futures	1032.11	1033.32	1030.17	1030.65	85508.0
2009-11-06 15:00:00	ES	Futures	1030.65	1033.8	1028.72	1033.56	203522.0
2009-11-06 16:00:00	ES	Futures	1033.32	1033.8	1032.59	1033.08	69151.0
2009-11-06 00:00:00	NQ	Futures	1958.71	1959.85	1958.71	1959.0	143.0
2009-11-06 01:00:00	NQ	Futures	1959.57	1959.85	1959.0	1959.28	114.0
2009-11-06 02:00:00	NQ	Futures	1959.57	1962.99	1958.71	1959.0	893.0
2009-11-06 03:00:00	NQ	Futures	1959.0	1966.98	1957.57	1965.27	2492.0
2009-11-06 04:00:00	NQ	Futures	1965.27	1965.56	1960.14	1962.42	1842.0
2009-11-06 05:00:00	NQ	Futures	1962.42	1963.56	1959.57	1962.99	1955.0
2009-11-06 06:00:00	NQ	Futures	1963.28	1966.13	1962.42	1962.99	961.0
2009-11-06 07:00:00	NQ	Futures	1962.99	1966.7	1962.42	1965.84	1039.0
2009-11-06 08:00:00	NQ	Futures	1965.84	1982.1	1945.02	1949.59	26248.0
2009-11-06 09:00:00	NQ	Futures	1949.3	1975.83	1947.88	1972.12	60995.0
2009-11-06 10:00:00	NQ	Futures	1971.83	1975.54	1954.15	1963.56	60651.0
2009-11-06 11:00:00	NQ	Futures	1963.56	1968.7	1961.28	1966.13	30753.0
2009-11-06 12:00:00	NQ	Futures	1965.84	1972.4	1964.7	1966.98	22840.0
2009-11-06 13:00:00	NQ	Futures	1966.98	1973.54	1964.99	1969.27	20184.0
2009-11-06 14:00:00	NQ	Futures	1969.27	1972.97	1966.13	1969.27	18164.0
2009-11-06 15:00:00	NQ	Futures	1968.7	1973.54	1966.13	1972.97	30595.0
2009-11-06 16:00:00	NQ	Futures	1972.97	1974.11	1972.4	1973.26	10548.0
2009-11-06 00:00:00	YM	Futures	9245.1	9250.7	9245.1	9247.9	143.0
2009-11-06 01:00:00	YM	Futures	9248.8	9250.7	9244.2	9246.0	461.0
2009-11-06 02:00:00	YM	Futures	9246.0	9260.9	9244.2	9245.1	1883.0
2009-11-06 03:00:00	YM	Futures	9244.2	9278.6	9238.6	9277.7	2164.0
2009-11-06 04:00:00	YM	Futures	9277.7	9277.7	9255.3	9263.7	1525.0
2009-11-06 05:00:00	YM	Futures	9263.7	9264.6	9247.9	9262.8	1024.0
2009-11-06 06:00:00	YM	Futures	9264.6	9274.9	9260.0	9264.6	644.0
2009-11-06 07:00:00	YM	Futures	9262.8	9274.9	9260.0	9272.1	966.0
2009-11-06 08:00:00	YM	Futures	9272.1	9300.0	9184.6	9205.1	14703.0
2009-11-06 09:00:00	YM	Futures	9204.2	9299.1	9195.8	9289.8	29507.0
2009-11-06 10:00:00	YM	Futures	9289.8	9308.4	9221.9	9266.5	35447.0
2009-11-06 11:00:00	YM	Futures	9265.6	9286.0	9249.8	9270.2	16412.0
2009-11-06 12:00:00	YM	Futures	9270.2	9296.3	9268.4	9273.0	10784.0
2009-11-06 13:00:00	YM	Futures	9273.0	9293.5	9261.8	9274.9	9508.0
2009-11-06 14:00:00	YM	Futures	9274.9	9284.2	9264.6	9266.5	6995.0
2009-11-06 15:00:00	YM	Futures	9265.6	9292.5	9250.7	9288.8	14854.0

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

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