PREVIEW / futures_1hour / 2009-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-07.parquet
  size:    30 KB
  rows:    836

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-07 00:00:00	ES	Futures	977.93	978.89	977.93	978.65	1562.0
2009-09-07 01:00:00	ES	Futures	978.65	978.89	977.93	978.41	1515.0
2009-09-07 02:00:00	ES	Futures	978.17	979.13	978.17	978.65	4327.0
2009-09-07 03:00:00	ES	Futures	978.65	981.79	978.17	981.79	21657.0
2009-09-07 04:00:00	ES	Futures	981.54	983.72	981.06	981.79	17159.0
2009-09-07 05:00:00	ES	Futures	981.79	983.72	981.54	982.75	5988.0
2009-09-07 06:00:00	ES	Futures	982.75	982.99	981.54	982.27	5803.0
2009-09-07 07:00:00	ES	Futures	982.27	982.99	982.03	982.51	3623.0
2009-09-07 08:00:00	ES	Futures	982.27	982.51	981.54	982.03	5619.0
2009-09-07 09:00:00	ES	Futures	982.27	984.68	981.79	984.2	10363.0
2009-09-07 10:00:00	ES	Futures	984.44	986.85	983.96	986.13	14996.0
2009-09-07 11:00:00	ES	Futures	986.13	986.85	984.92	985.64	8687.0
2009-09-07 18:00:00	ES	Futures	985.16	985.4	983.72	983.96	3356.0
2009-09-07 19:00:00	ES	Futures	983.96	984.68	983.23	983.72	1683.0
2009-09-07 20:00:00	ES	Futures	983.72	984.2	983.23	983.47	2835.0
2009-09-07 21:00:00	ES	Futures	983.47	983.96	982.51	982.99	3501.0
2009-09-07 22:00:00	ES	Futures	982.99	983.96	982.99	983.47	1996.0
2009-09-07 23:00:00	ES	Futures	983.47	983.96	982.51	983.72	2016.0
2009-09-07 00:00:00	NQ	Futures	1864.65	1866.08	1864.08	1866.08	191.0
2009-09-07 01:00:00	NQ	Futures	1866.36	1867.22	1864.94	1865.51	443.0
2009-09-07 02:00:00	NQ	Futures	1865.51	1867.22	1865.22	1865.79	426.0
2009-09-07 03:00:00	NQ	Futures	1865.51	1870.07	1864.08	1869.78	2384.0
2009-09-07 04:00:00	NQ	Futures	1870.07	1873.48	1869.21	1870.35	2392.0
2009-09-07 05:00:00	NQ	Futures	1870.07	1873.48	1869.78	1871.2	487.0
2009-09-07 06:00:00	NQ	Futures	1871.2	1871.2	1869.5	1870.07	430.0
2009-09-07 07:00:00	NQ	Futures	1870.07	1871.2	1869.78	1870.63	204.0
2009-09-07 08:00:00	NQ	Futures	1870.35	1871.49	1868.93	1870.92	922.0
2009-09-07 09:00:00	NQ	Futures	1871.2	1876.05	1871.2	1874.62	949.0
2009-09-07 10:00:00	NQ	Futures	1874.91	1876.9	1873.48	1875.19	1710.0
2009-09-07 11:00:00	NQ	Futures	1875.48	1877.19	1874.62	1875.48	1264.0
2009-09-07 18:00:00	NQ	Futures	1874.91	1874.91	1872.63	1873.2	267.0
2009-09-07 19:00:00	NQ	Futures	1872.91	1874.62	1872.06	1872.91	128.0
2009-09-07 20:00:00	NQ	Futures	1872.91	1873.48	1871.49	1871.49	351.0
2009-09-07 21:00:00	NQ	Futures	1871.77	1872.34	1869.21	1870.07	426.0
2009-09-07 22:00:00	NQ	Futures	1870.07	1872.06	1870.07	1871.49	191.0
2009-09-07 23:00:00	NQ	Futures	1871.49	1872.34	1870.07	1871.77	193.0
2009-09-07 00:00:00	YM	Futures	8706.4	8712.9	8705.5	8712.9	261.0
2009-09-07 01:00:00	YM	Futures	8713.8	8713.8	8705.5	8705.5	151.0
2009-09-07 02:00:00	YM	Futures	8708.2	8714.7	8708.2	8711.9	295.0
2009-09-07 03:00:00	YM	Futures	8711.9	8736.9	8710.1	8735.1	1660.0
2009-09-07 04:00:00	YM	Futures	8735.1	8755.4	8735.1	8744.3	1582.0
2009-09-07 05:00:00	YM	Futures	8742.5	8757.3	8738.8	8748.9	469.0
2009-09-07 06:00:00	YM	Futures	8748.0	8748.9	8737.8	8743.4	539.0
2009-09-07 07:00:00	YM	Futures	8744.3	8749.9	8742.5	8743.4	458.0
2009-09-07 08:00:00	YM	Futures	8745.2	8748.0	8738.8	8745.2	675.0
2009-09-07 09:00:00	YM	Futures	8745.2	8763.7	8742.5	8757.3	608.0
2009-09-07 10:00:00	YM	Futures	8757.3	8773.0	8754.5	8768.3	1918.0
2009-09-07 11:00:00	YM	Futures	8767.4	8773.0	8757.3	8764.6	515.0
2009-09-07 18:00:00	YM	Futures	8762.8	8763.7	8750.8	8751.7	172.0
2009-09-07 19:00:00	YM	Futures	8753.6	8759.1	8748.0	8751.7	106.0

> showing 50 of 836 rows — these rows as CSV

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