PREVIEW / futures_1hour / 2009-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-24.parquet
  size:    40 KB
  rows:    1,202

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-24 00:00:00	ES	Futures	994.81	995.05	993.12	993.84	2873.0
2009-08-24 01:00:00	ES	Futures	993.84	995.77	993.12	995.53	4815.0
2009-08-24 02:00:00	ES	Futures	995.53	995.53	992.16	993.84	12124.0
2009-08-24 03:00:00	ES	Futures	993.6	996.01	990.95	993.36	28026.0
2009-08-24 04:00:00	ES	Futures	993.36	995.05	991.67	991.67	12625.0
2009-08-24 05:00:00	ES	Futures	991.92	993.12	990.95	992.64	10268.0
2009-08-24 06:00:00	ES	Futures	992.64	993.12	990.47	990.71	12999.0
2009-08-24 07:00:00	ES	Futures	990.71	992.88	990.23	991.43	17689.0
2009-08-24 08:00:00	ES	Futures	991.43	993.12	990.95	992.88	20266.0
2009-08-24 09:00:00	ES	Futures	992.88	996.01	991.19	994.81	285592.0
2009-08-24 10:00:00	ES	Futures	994.57	997.7	994.33	997.46	240208.0
2009-08-24 11:00:00	ES	Futures	997.46	998.43	995.05	995.05	138158.0
2009-08-24 12:00:00	ES	Futures	995.05	996.01	993.6	993.84	85870.0
2009-08-24 13:00:00	ES	Futures	993.84	993.84	987.09	989.74	272497.0
2009-08-24 14:00:00	ES	Futures	989.5	991.19	988.54	989.26	111727.0
2009-08-24 15:00:00	ES	Futures	989.02	989.74	985.16	988.78	350617.0
2009-08-24 16:00:00	ES	Futures	988.78	989.99	987.33	987.82	68329.0
2009-08-24 17:00:00	ES	Futures	988.06	988.06	987.09	987.57	1503.0
2009-08-24 18:00:00	ES	Futures	987.33	988.06	986.37	986.85	2370.0
2009-08-24 19:00:00	ES	Futures	986.61	987.09	985.4	985.89	3397.0
2009-08-24 20:00:00	ES	Futures	985.89	986.85	985.4	985.64	3663.0
2009-08-24 21:00:00	ES	Futures	985.64	990.23	985.64	986.85	15092.0
2009-08-24 22:00:00	ES	Futures	986.85	987.33	984.2	985.4	7215.0
2009-08-24 23:00:00	ES	Futures	985.4	987.09	984.92	986.61	3295.0
2009-08-24 00:00:00	NQ	Futures	1874.62	1874.91	1871.49	1872.91	233.0
2009-08-24 01:00:00	NQ	Futures	1873.2	1875.19	1871.2	1874.91	274.0
2009-08-24 02:00:00	NQ	Futures	1874.62	1874.91	1869.21	1872.06	884.0
2009-08-24 03:00:00	NQ	Futures	1871.49	1875.76	1866.93	1871.77	2541.0
2009-08-24 04:00:00	NQ	Futures	1871.77	1873.77	1867.5	1867.79	1832.0
2009-08-24 05:00:00	NQ	Futures	1867.5	1868.93	1865.22	1867.5	1216.0
2009-08-24 06:00:00	NQ	Futures	1867.5	1868.64	1863.8	1864.08	1012.0
2009-08-24 07:00:00	NQ	Futures	1864.08	1867.5	1863.23	1865.51	2059.0
2009-08-24 08:00:00	NQ	Futures	1865.22	1868.36	1864.65	1867.22	3416.0
2009-08-24 09:00:00	NQ	Futures	1867.79	1874.05	1863.8	1870.92	53655.0
2009-08-24 10:00:00	NQ	Futures	1870.35	1877.47	1870.35	1876.33	33461.0
2009-08-24 11:00:00	NQ	Futures	1876.62	1877.47	1869.5	1869.78	20535.0
2009-08-24 12:00:00	NQ	Futures	1869.5	1871.49	1867.5	1868.07	14703.0
2009-08-24 13:00:00	NQ	Futures	1867.79	1868.07	1857.82	1863.8	35790.0
2009-08-24 14:00:00	NQ	Futures	1863.8	1868.07	1862.66	1863.8	17547.0
2009-08-24 15:00:00	NQ	Futures	1863.51	1866.36	1855.54	1861.81	48044.0
2009-08-24 16:00:00	NQ	Futures	1862.09	1864.94	1859.81	1860.38	6711.0
2009-08-24 17:00:00	NQ	Futures	1860.38	1860.67	1858.67	1859.24	150.0
2009-08-24 18:00:00	NQ	Futures	1859.24	1860.1	1857.82	1857.82	134.0
2009-08-24 19:00:00	NQ	Futures	1857.82	1858.39	1856.68	1856.96	229.0
2009-08-24 20:00:00	NQ	Futures	1856.96	1857.82	1856.11	1856.39	416.0
2009-08-24 21:00:00	NQ	Futures	1856.39	1864.37	1856.39	1857.82	1874.0
2009-08-24 22:00:00	NQ	Futures	1857.82	1858.39	1853.55	1854.97	744.0
2009-08-24 23:00:00	NQ	Futures	1855.26	1858.1	1854.4	1857.25	294.0
2009-08-24 00:00:00	YM	Futures	8831.2	8833.1	8820.1	8824.8	419.0
2009-08-24 01:00:00	YM	Futures	8824.8	8839.5	8819.2	8834.0	336.0

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

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