PREVIEW / futures_1hour / 2009-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-08.parquet
  size:    42 KB
  rows:    1,270

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-08 00:00:00	ES	Futures	983.72	984.92	983.23	984.92	2106.0
2009-09-08 01:00:00	ES	Futures	984.68	985.89	984.2	985.64	3437.0
2009-09-08 02:00:00	ES	Futures	985.64	987.33	984.2	987.09	8344.0
2009-09-08 03:00:00	ES	Futures	987.33	989.74	984.92	989.26	28597.0
2009-09-08 04:00:00	ES	Futures	989.02	990.71	987.57	988.3	19775.0
2009-09-08 05:00:00	ES	Futures	988.3	989.99	987.82	988.3	9517.0
2009-09-08 06:00:00	ES	Futures	988.3	988.78	987.09	987.33	15266.0
2009-09-08 07:00:00	ES	Futures	987.33	989.5	987.33	989.26	15892.0
2009-09-08 08:00:00	ES	Futures	989.26	989.26	987.09	988.3	25077.0
2009-09-08 09:00:00	ES	Futures	988.3	989.5	984.44	985.16	249270.0
2009-09-08 10:00:00	ES	Futures	985.16	989.26	982.99	988.78	268535.0
2009-09-08 11:00:00	ES	Futures	988.54	989.26	984.44	985.89	132818.0
2009-09-08 12:00:00	ES	Futures	985.89	987.33	984.92	986.37	62302.0
2009-09-08 13:00:00	ES	Futures	986.13	987.09	984.2	986.13	87587.0
2009-09-08 14:00:00	ES	Futures	986.13	989.02	984.92	987.82	118233.0
2009-09-08 15:00:00	ES	Futures	987.82	989.26	986.13	988.3	175520.0
2009-09-08 16:00:00	ES	Futures	988.3	989.02	986.37	986.61	77308.0
2009-09-08 17:00:00	ES	Futures	986.37	987.33	986.13	986.85	2083.0
2009-09-08 18:00:00	ES	Futures	986.85	987.33	986.37	987.33	1636.0
2009-09-08 19:00:00	ES	Futures	987.09	988.06	987.09	987.33	4011.0
2009-09-08 20:00:00	ES	Futures	987.57	988.3	986.85	988.06	3778.0
2009-09-08 21:00:00	ES	Futures	988.06	988.54	987.82	987.82	2014.0
2009-09-08 22:00:00	ES	Futures	988.06	988.06	986.85	987.82	4166.0
2009-09-08 23:00:00	ES	Futures	987.82	988.06	985.64	985.64	3497.0
2009-09-08 00:00:00	NQ	Futures	1871.49	1873.77	1871.49	1873.77	203.0
2009-09-08 01:00:00	NQ	Futures	1873.48	1875.76	1873.2	1874.91	323.0
2009-09-08 02:00:00	NQ	Futures	1875.19	1877.47	1873.48	1877.47	956.0
2009-09-08 03:00:00	NQ	Futures	1877.19	1882.31	1873.77	1881.74	2948.0
2009-09-08 04:00:00	NQ	Futures	1881.46	1887.44	1881.46	1882.88	3493.0
2009-09-08 05:00:00	NQ	Futures	1882.6	1886.3	1881.74	1882.03	950.0
2009-09-08 06:00:00	NQ	Futures	1882.03	1883.17	1880.89	1881.74	1149.0
2009-09-08 07:00:00	NQ	Futures	1881.74	1884.88	1881.17	1882.6	1764.0
2009-09-08 08:00:00	NQ	Futures	1882.31	1882.6	1878.32	1880.03	3248.0
2009-09-08 09:00:00	NQ	Futures	1880.32	1886.58	1874.05	1876.33	45324.0
2009-09-08 10:00:00	NQ	Futures	1876.33	1883.45	1872.91	1882.6	41714.0
2009-09-08 11:00:00	NQ	Futures	1882.6	1883.74	1874.05	1876.05	20351.0
2009-09-08 12:00:00	NQ	Futures	1876.33	1879.18	1874.62	1876.62	10093.0
2009-09-08 13:00:00	NQ	Futures	1876.62	1878.32	1871.77	1876.33	15461.0
2009-09-08 14:00:00	NQ	Futures	1876.33	1882.6	1873.48	1880.32	19336.0
2009-09-08 15:00:00	NQ	Futures	1880.03	1885.16	1877.47	1884.59	27546.0
2009-09-08 16:00:00	NQ	Futures	1884.88	1885.45	1882.31	1882.31	9044.0
2009-09-08 17:00:00	NQ	Futures	1882.6	1882.6	1881.46	1881.74	111.0
2009-09-08 18:00:00	NQ	Futures	1882.6	1882.88	1882.03	1882.6	48.0
2009-09-08 19:00:00	NQ	Futures	1882.31	1884.31	1882.31	1883.17	264.0
2009-09-08 20:00:00	NQ	Futures	1882.88	1884.31	1882.03	1884.02	247.0
2009-09-08 21:00:00	NQ	Futures	1884.02	1884.59	1883.17	1883.17	112.0
2009-09-08 22:00:00	NQ	Futures	1882.88	1883.17	1881.46	1882.88	258.0
2009-09-08 23:00:00	NQ	Futures	1882.88	1883.17	1878.61	1878.89	307.0
2009-09-08 00:00:00	YM	Futures	8751.7	8760.0	8750.8	8759.1	124.0
2009-09-08 01:00:00	YM	Futures	8759.1	8769.3	8756.3	8766.5	160.0

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

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