PREVIEW / futures_1hour / 2009-09-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	1026.54	1027.5	1026.05	1027.02	2897.0
2009-09-18 01:00:00	ES	Futures	1026.78	1028.96	1026.78	1026.78	6002.0
2009-09-18 02:00:00	ES	Futures	1027.02	1027.99	1025.08	1026.29	10357.0
2009-09-18 03:00:00	ES	Futures	1026.05	1028.47	1024.84	1026.54	23975.0
2009-09-18 04:00:00	ES	Futures	1026.54	1027.75	1024.6	1027.5	14783.0
2009-09-18 05:00:00	ES	Futures	1027.5	1029.93	1026.05	1029.68	20486.0
2009-09-18 06:00:00	ES	Futures	1029.44	1031.38	1029.44	1030.9	14444.0
2009-09-18 07:00:00	ES	Futures	1031.14	1031.62	1030.41	1030.9	12960.0
2009-09-18 08:00:00	ES	Futures	1030.65	1032.83	1029.68	1032.83	54960.0
2009-09-18 09:00:00	ES	Futures	1032.83	1034.53	1029.2	1029.93	350869.0
2009-09-18 10:00:00	ES	Futures	1029.93	1031.62	1027.26	1029.93	392421.0
2009-09-18 11:00:00	ES	Futures	1030.17	1030.65	1027.26	1027.26	231970.0
2009-09-18 12:00:00	ES	Futures	1027.5	1031.38	1026.29	1031.14	160207.0
2009-09-18 13:00:00	ES	Futures	1031.14	1033.32	1030.41	1032.59	79179.0
2009-09-18 14:00:00	ES	Futures	1032.59	1033.32	1030.9	1031.38	83106.0
2009-09-18 15:00:00	ES	Futures	1031.14	1034.04	1029.44	1029.68	251608.0
2009-09-18 16:00:00	ES	Futures	1029.93	1030.17	1027.26	1027.75	98420.0
2009-09-18 00:00:00	NQ	Futures	1958.71	1960.42	1957.57	1959.28	320.0
2009-09-18 01:00:00	NQ	Futures	1959.28	1962.99	1958.71	1958.71	385.0
2009-09-18 02:00:00	NQ	Futures	1958.71	1961.28	1956.15	1958.43	683.0
2009-09-18 03:00:00	NQ	Futures	1958.14	1959.85	1955.86	1956.43	2575.0
2009-09-18 04:00:00	NQ	Futures	1956.15	1959.57	1953.87	1958.71	1265.0
2009-09-18 05:00:00	NQ	Futures	1958.71	1962.71	1956.15	1962.14	865.0
2009-09-18 06:00:00	NQ	Futures	1962.71	1964.99	1962.14	1964.42	838.0
2009-09-18 07:00:00	NQ	Futures	1964.7	1965.27	1963.85	1964.7	557.0
2009-09-18 08:00:00	NQ	Futures	1964.7	1968.12	1962.71	1968.12	3536.0
2009-09-18 09:00:00	NQ	Futures	1968.41	1972.69	1962.71	1966.13	44898.0
2009-09-18 10:00:00	NQ	Futures	1966.13	1966.98	1955.58	1966.13	46057.0
2009-09-18 11:00:00	NQ	Futures	1966.41	1968.41	1961.85	1962.42	31146.0
2009-09-18 12:00:00	NQ	Futures	1962.14	1969.27	1959.85	1968.7	25317.0
2009-09-18 13:00:00	NQ	Futures	1968.7	1974.11	1967.55	1972.12	16678.0
2009-09-18 14:00:00	NQ	Futures	1972.12	1973.54	1966.98	1967.27	17442.0
2009-09-18 15:00:00	NQ	Futures	1967.27	1970.98	1964.42	1966.13	27558.0
2009-09-18 16:00:00	NQ	Futures	1966.13	1966.7	1961.85	1962.71	11940.0
2009-09-18 00:00:00	YM	Futures	9029.3	9038.6	9026.5	9034.9	167.0
2009-09-18 01:00:00	YM	Futures	9034.9	9050.7	9034.0	9034.0	440.0
2009-09-18 02:00:00	YM	Futures	9034.0	9041.4	9019.1	9026.5	458.0
2009-09-18 03:00:00	YM	Futures	9026.5	9045.1	9016.3	9031.2	1298.0
2009-09-18 04:00:00	YM	Futures	9031.2	9040.5	9019.1	9040.5	741.0
2009-09-18 05:00:00	YM	Futures	9038.6	9058.1	9030.2	9054.4	778.0
2009-09-18 06:00:00	YM	Futures	9056.3	9067.4	9054.4	9064.6	750.0
2009-09-18 07:00:00	YM	Futures	9065.6	9069.3	9061.9	9068.4	951.0
2009-09-18 08:00:00	YM	Futures	9067.4	9085.1	9060.0	9083.3	2756.0
2009-09-18 09:00:00	YM	Futures	9084.2	9100.9	9063.7	9068.4	23858.0
2009-09-18 10:00:00	YM	Futures	9069.3	9089.8	9055.3	9080.5	28252.0
2009-09-18 11:00:00	YM	Futures	9080.5	9086.0	9060.0	9060.9	19916.0
2009-09-18 12:00:00	YM	Futures	9061.9	9088.8	9052.6	9087.0	12610.0
2009-09-18 13:00:00	YM	Futures	9087.0	9102.8	9084.2	9094.4	6968.0
2009-09-18 14:00:00	YM	Futures	9094.4	9100.9	9082.3	9084.2	8156.0
2009-09-18 15:00:00	YM	Futures	9084.2	9099.1	9068.4	9069.3	13594.0

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

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