PREVIEW / futures_1hour / 2009-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-09.parquet
  size:    37 KB
  rows:    1,025

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-09 00:00:00	ES	Futures	1030.41	1031.62	1030.17	1030.41	2240.0
2009-10-09 01:00:00	ES	Futures	1030.65	1031.38	1029.93	1030.65	3498.0
2009-10-09 02:00:00	ES	Futures	1030.65	1031.14	1027.5	1027.75	12882.0
2009-10-09 03:00:00	ES	Futures	1027.5	1034.04	1027.5	1032.59	28710.0
2009-10-09 04:00:00	ES	Futures	1032.35	1033.56	1028.96	1029.68	21797.0
2009-10-09 05:00:00	ES	Futures	1029.44	1030.17	1026.78	1027.02	13002.0
2009-10-09 06:00:00	ES	Futures	1027.02	1029.68	1026.78	1028.96	12587.0
2009-10-09 07:00:00	ES	Futures	1029.2	1030.9	1028.72	1028.96	16371.0
2009-10-09 08:00:00	ES	Futures	1028.96	1029.68	1025.57	1028.72	56418.0
2009-10-09 09:00:00	ES	Futures	1028.72	1031.38	1026.05	1031.14	193774.0
2009-10-09 10:00:00	ES	Futures	1031.38	1032.35	1029.2	1031.14	200791.0
2009-10-09 11:00:00	ES	Futures	1031.14	1032.59	1029.93	1030.41	142439.0
2009-10-09 12:00:00	ES	Futures	1030.41	1030.9	1028.72	1030.9	91448.0
2009-10-09 13:00:00	ES	Futures	1030.9	1031.86	1030.41	1031.38	61664.0
2009-10-09 14:00:00	ES	Futures	1031.14	1032.59	1029.93	1032.59	100090.0
2009-10-09 15:00:00	ES	Futures	1032.59	1034.77	1032.11	1034.29	240846.0
2009-10-09 16:00:00	ES	Futures	1034.53	1035.26	1033.8	1035.01	80780.0
2009-10-09 00:00:00	NQ	Futures	1953.87	1954.72	1953.29	1953.87	280.0
2009-10-09 01:00:00	NQ	Futures	1953.87	1955.29	1953.01	1954.44	237.0
2009-10-09 02:00:00	NQ	Futures	1954.15	1956.15	1949.87	1950.16	1836.0
2009-10-09 03:00:00	NQ	Futures	1950.16	1959.28	1949.87	1957.29	4753.0
2009-10-09 04:00:00	NQ	Futures	1957.57	1959.0	1951.3	1952.44	2240.0
2009-10-09 05:00:00	NQ	Futures	1952.15	1953.01	1947.31	1947.31	1103.0
2009-10-09 06:00:00	NQ	Futures	1947.31	1952.15	1947.31	1950.73	536.0
2009-10-09 07:00:00	NQ	Futures	1951.01	1955.01	1951.01	1951.3	1605.0
2009-10-09 08:00:00	NQ	Futures	1951.58	1953.01	1946.74	1951.3	3780.0
2009-10-09 09:00:00	NQ	Futures	1951.3	1965.56	1948.16	1964.42	43434.0
2009-10-09 10:00:00	NQ	Futures	1964.7	1967.84	1960.42	1964.42	32050.0
2009-10-09 11:00:00	NQ	Futures	1964.13	1967.84	1962.14	1963.56	20842.0
2009-10-09 12:00:00	NQ	Futures	1963.56	1964.99	1961.0	1963.56	16323.0
2009-10-09 13:00:00	NQ	Futures	1963.85	1967.27	1962.14	1963.85	13137.0
2009-10-09 14:00:00	NQ	Futures	1963.85	1966.7	1961.28	1966.7	14105.0
2009-10-09 15:00:00	NQ	Futures	1966.41	1970.98	1963.28	1966.98	35579.0
2009-10-09 16:00:00	NQ	Futures	1966.98	1969.84	1966.41	1969.55	7600.0
2009-10-09 00:00:00	YM	Futures	9068.4	9073.0	9064.6	9064.6	137.0
2009-10-09 01:00:00	YM	Futures	9065.6	9073.0	9061.9	9066.5	219.0
2009-10-09 02:00:00	YM	Futures	9065.6	9070.2	9043.3	9043.3	774.0
2009-10-09 03:00:00	YM	Futures	9043.3	9092.6	9042.3	9081.4	1491.0
2009-10-09 04:00:00	YM	Futures	9081.4	9087.9	9054.4	9060.9	814.0
2009-10-09 05:00:00	YM	Futures	9063.7	9064.6	9041.4	9041.4	392.0
2009-10-09 06:00:00	YM	Futures	9042.3	9060.9	9041.4	9056.3	429.0
2009-10-09 07:00:00	YM	Futures	9058.1	9069.3	9053.5	9054.4	709.0
2009-10-09 08:00:00	YM	Futures	9053.5	9059.1	9028.4	9051.6	2272.0
2009-10-09 09:00:00	YM	Futures	9050.7	9079.5	9030.2	9077.7	17400.0
2009-10-09 10:00:00	YM	Futures	9077.7	9088.8	9061.9	9079.5	15346.0
2009-10-09 11:00:00	YM	Futures	9079.5	9094.4	9072.1	9083.3	11602.0
2009-10-09 12:00:00	YM	Futures	9083.3	9086.0	9071.2	9086.0	7662.0
2009-10-09 13:00:00	YM	Futures	9086.0	9099.1	9084.2	9092.6	6113.0
2009-10-09 14:00:00	YM	Futures	9093.5	9106.5	9083.3	9105.6	8129.0
2009-10-09 15:00:00	YM	Futures	9106.5	9124.2	9101.9	9122.3	14081.0

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

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