PREVIEW / futures_1hour / 2009-09-17

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-17.parquet
  size:    44 KB
  rows:    1,290

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-17 00:00:00	ES	Futures	1030.9	1030.9	1028.96	1029.68	4320.0
2009-09-17 01:00:00	ES	Futures	1029.93	1036.71	1029.68	1032.59	13434.0
2009-09-17 02:00:00	ES	Futures	1032.59	1033.8	1031.14	1033.56	13777.0
2009-09-17 03:00:00	ES	Futures	1033.56	1033.8	1031.38	1032.83	27402.0
2009-09-17 04:00:00	ES	Futures	1032.83	1033.56	1029.2	1029.68	23648.0
2009-09-17 05:00:00	ES	Futures	1029.44	1033.32	1029.2	1033.08	12738.0
2009-09-17 06:00:00	ES	Futures	1033.08	1033.08	1031.86	1032.83	10090.0
2009-09-17 07:00:00	ES	Futures	1032.83	1033.08	1029.44	1029.68	17501.0
2009-09-17 08:00:00	ES	Futures	1029.93	1032.11	1027.99	1028.23	57137.0
2009-09-17 09:00:00	ES	Futures	1028.23	1036.22	1027.26	1035.98	303078.0
2009-09-17 10:00:00	ES	Futures	1035.98	1038.16	1029.44	1033.8	498554.0
2009-09-17 11:00:00	ES	Futures	1033.8	1035.74	1029.93	1031.38	277600.0
2009-09-17 12:00:00	ES	Futures	1031.38	1031.86	1024.6	1025.08	270385.0
2009-09-17 13:00:00	ES	Futures	1025.08	1028.47	1023.39	1027.99	185469.0
2009-09-17 14:00:00	ES	Futures	1027.99	1030.9	1026.78	1029.68	179718.0
2009-09-17 15:00:00	ES	Futures	1029.93	1031.38	1026.29	1029.2	274481.0
2009-09-17 16:00:00	ES	Futures	1028.96	1030.17	1028.47	1029.68	83544.0
2009-09-17 17:00:00	ES	Futures	1029.93	1030.17	1028.72	1029.68	2706.0
2009-09-17 18:00:00	ES	Futures	1029.2	1029.44	1028.72	1028.72	1220.0
2009-09-17 19:00:00	ES	Futures	1028.72	1028.96	1027.5	1027.75	3194.0
2009-09-17 20:00:00	ES	Futures	1027.75	1028.23	1027.02	1027.75	4027.0
2009-09-17 21:00:00	ES	Futures	1027.99	1028.23	1023.14	1023.63	11530.0
2009-09-17 22:00:00	ES	Futures	1023.87	1026.29	1023.63	1025.57	5393.0
2009-09-17 23:00:00	ES	Futures	1025.32	1027.02	1024.6	1026.54	3267.0
2009-09-17 00:00:00	NQ	Futures	1959.85	1959.85	1957.57	1958.14	525.0
2009-09-17 01:00:00	NQ	Futures	1958.43	1970.98	1958.14	1963.56	1360.0
2009-09-17 02:00:00	NQ	Futures	1963.28	1965.84	1961.57	1965.56	871.0
2009-09-17 03:00:00	NQ	Futures	1965.56	1965.56	1961.85	1964.13	2442.0
2009-09-17 04:00:00	NQ	Futures	1963.85	1964.99	1958.43	1959.28	2087.0
2009-09-17 05:00:00	NQ	Futures	1959.28	1964.99	1958.71	1964.7	1539.0
2009-09-17 06:00:00	NQ	Futures	1964.42	1964.7	1962.42	1963.85	701.0
2009-09-17 07:00:00	NQ	Futures	1963.85	1964.42	1956.43	1956.72	2344.0
2009-09-17 08:00:00	NQ	Futures	1957.0	1961.57	1954.15	1954.15	6803.0
2009-09-17 09:00:00	NQ	Futures	1954.44	1968.98	1953.29	1968.41	44343.0
2009-09-17 10:00:00	NQ	Futures	1968.41	1973.83	1962.42	1970.41	66904.0
2009-09-17 11:00:00	NQ	Futures	1970.12	1974.11	1963.85	1967.27	36751.0
2009-09-17 12:00:00	NQ	Futures	1966.98	1968.12	1953.58	1954.72	40949.0
2009-09-17 13:00:00	NQ	Futures	1954.72	1963.56	1953.87	1962.71	25125.0
2009-09-17 14:00:00	NQ	Futures	1962.71	1966.41	1960.14	1964.99	24916.0
2009-09-17 15:00:00	NQ	Futures	1965.27	1967.27	1958.71	1962.42	38187.0
2009-09-17 16:00:00	NQ	Futures	1962.14	1963.85	1961.28	1962.42	9813.0
2009-09-17 17:00:00	NQ	Futures	1962.71	1963.28	1961.57	1962.14	124.0
2009-09-17 18:00:00	NQ	Futures	1961.57	1963.28	1961.57	1961.57	49.0
2009-09-17 19:00:00	NQ	Futures	1961.28	1961.57	1960.14	1960.14	360.0
2009-09-17 20:00:00	NQ	Futures	1960.14	1961.28	1959.57	1960.42	344.0
2009-09-17 21:00:00	NQ	Futures	1960.71	1961.28	1954.44	1955.58	1518.0
2009-09-17 22:00:00	NQ	Futures	1955.29	1958.71	1954.72	1956.72	824.0
2009-09-17 23:00:00	NQ	Futures	1956.43	1959.85	1955.58	1959.28	339.0
2009-09-17 00:00:00	YM	Futures	9051.6	9051.6	9038.6	9044.2	224.0
2009-09-17 01:00:00	YM	Futures	9045.1	9097.2	9044.2	9071.2	1057.0

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

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