PREVIEW / futures_1hour / 2009-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-27.parquet
  size:    41 KB
  rows:    1,232

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-08-27 00:00:00	ES	Futures	985.16	989.26	984.92	988.78	5816.0
2009-08-27 01:00:00	ES	Futures	989.02	989.99	987.82	989.02	6372.0
2009-08-27 02:00:00	ES	Futures	989.02	990.23	988.06	988.3	8082.0
2009-08-27 03:00:00	ES	Futures	988.3	991.67	987.82	990.47	17391.0
2009-08-27 04:00:00	ES	Futures	990.47	992.88	989.99	991.19	13061.0
2009-08-27 05:00:00	ES	Futures	991.43	992.4	990.95	991.19	6569.0
2009-08-27 06:00:00	ES	Futures	991.19	992.4	988.3	989.02	11665.0
2009-08-27 07:00:00	ES	Futures	988.78	991.19	988.78	990.23	11352.0
2009-08-27 08:00:00	ES	Futures	990.23	994.57	989.02	991.19	69264.0
2009-08-27 09:00:00	ES	Futures	991.43	991.92	981.79	982.03	292050.0
2009-08-27 10:00:00	ES	Futures	981.79	982.75	978.89	980.1	388937.0
2009-08-27 11:00:00	ES	Futures	980.34	985.16	979.37	984.92	195373.0
2009-08-27 12:00:00	ES	Futures	985.16	988.3	984.68	987.09	151578.0
2009-08-27 13:00:00	ES	Futures	987.09	991.43	985.4	990.23	178354.0
2009-08-27 14:00:00	ES	Futures	990.23	996.26	989.99	994.33	309107.0
2009-08-27 15:00:00	ES	Futures	994.33	995.05	992.16	993.6	286771.0
2009-08-27 16:00:00	ES	Futures	993.6	993.84	992.4	993.36	79160.0
2009-08-27 17:00:00	ES	Futures	993.6	993.6	993.12	993.36	1179.0
2009-08-27 18:00:00	ES	Futures	993.12	994.09	992.88	993.12	2437.0
2009-08-27 19:00:00	ES	Futures	993.12	993.6	992.16	993.6	2322.0
2009-08-27 20:00:00	ES	Futures	993.36	994.09	992.16	992.64	3326.0
2009-08-27 21:00:00	ES	Futures	992.88	993.6	992.4	992.64	1699.0
2009-08-27 22:00:00	ES	Futures	992.88	993.36	990.71	991.67	5186.0
2009-08-27 23:00:00	ES	Futures	991.43	991.92	990.95	991.19	1788.0
2009-08-27 00:00:00	NQ	Futures	1855.26	1861.81	1855.26	1861.24	572.0
2009-08-27 01:00:00	NQ	Futures	1861.52	1862.66	1858.96	1861.24	422.0
2009-08-27 02:00:00	NQ	Futures	1860.95	1862.66	1859.81	1859.81	486.0
2009-08-27 03:00:00	NQ	Futures	1859.81	1865.22	1859.24	1864.08	993.0
2009-08-27 04:00:00	NQ	Futures	1864.08	1867.79	1863.8	1865.51	974.0
2009-08-27 05:00:00	NQ	Futures	1865.22	1865.79	1863.51	1863.8	548.0
2009-08-27 06:00:00	NQ	Futures	1864.08	1866.36	1859.81	1860.67	687.0
2009-08-27 07:00:00	NQ	Futures	1860.38	1865.22	1860.38	1864.08	865.0
2009-08-27 08:00:00	NQ	Futures	1864.08	1871.49	1862.09	1865.22	4319.0
2009-08-27 09:00:00	NQ	Futures	1865.22	1866.36	1843.58	1843.58	42153.0
2009-08-27 10:00:00	NQ	Futures	1843.86	1844.72	1834.75	1839.59	64467.0
2009-08-27 11:00:00	NQ	Futures	1839.59	1848.42	1837.88	1848.13	31215.0
2009-08-27 12:00:00	NQ	Futures	1848.13	1853.83	1847.28	1850.98	21954.0
2009-08-27 13:00:00	NQ	Futures	1851.27	1863.51	1847.28	1861.52	34838.0
2009-08-27 14:00:00	NQ	Futures	1861.52	1872.34	1861.52	1866.65	48101.0
2009-08-27 15:00:00	NQ	Futures	1866.65	1871.77	1862.95	1869.21	48530.0
2009-08-27 16:00:00	NQ	Futures	1869.5	1870.07	1865.79	1867.79	9938.0
2009-08-27 17:00:00	NQ	Futures	1867.79	1869.5	1867.5	1868.36	360.0
2009-08-27 18:00:00	NQ	Futures	1869.21	1870.35	1867.79	1868.36	216.0
2009-08-27 19:00:00	NQ	Futures	1868.07	1870.35	1867.5	1870.07	240.0
2009-08-27 20:00:00	NQ	Futures	1869.78	1870.35	1867.22	1868.07	385.0
2009-08-27 21:00:00	NQ	Futures	1867.5	1869.78	1867.5	1868.36	162.0
2009-08-27 22:00:00	NQ	Futures	1868.07	1869.21	1864.94	1866.65	431.0
2009-08-27 23:00:00	NQ	Futures	1866.65	1867.22	1865.22	1866.08	129.0
2009-08-27 00:00:00	YM	Futures	8771.1	8801.6	8771.1	8799.8	451.0
2009-08-27 01:00:00	YM	Futures	8799.8	8808.1	8789.6	8796.1	309.0

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

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