PREVIEW / futures_1hour / 2009-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-31.parquet
  size:    39 KB
  rows:    1,179

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-31 00:00:00	ES	Futures	986.37	986.85	985.64	986.61	3706.0
2009-08-31 01:00:00	ES	Futures	986.61	986.85	985.16	985.4	2569.0
2009-08-31 02:00:00	ES	Futures	985.4	985.4	984.2	984.68	9269.0
2009-08-31 03:00:00	ES	Futures	984.68	986.13	983.47	984.68	14932.0
2009-08-31 04:00:00	ES	Futures	984.68	986.13	983.23	985.4	12299.0
2009-08-31 05:00:00	ES	Futures	985.4	987.09	984.68	985.16	9515.0
2009-08-31 06:00:00	ES	Futures	984.92	986.37	984.2	984.92	6248.0
2009-08-31 07:00:00	ES	Futures	984.68	986.37	984.2	984.68	8252.0
2009-08-31 08:00:00	ES	Futures	984.68	985.4	983.47	984.92	17799.0
2009-08-31 09:00:00	ES	Futures	984.92	985.16	977.45	980.34	324274.0
2009-08-31 10:00:00	ES	Futures	980.34	983.47	978.41	982.27	274116.0
2009-08-31 11:00:00	ES	Futures	982.27	982.51	979.62	981.06	134946.0
2009-08-31 12:00:00	ES	Futures	980.82	982.03	978.65	979.62	115530.0
2009-08-31 13:00:00	ES	Futures	979.62	980.82	978.65	980.58	77903.0
2009-08-31 14:00:00	ES	Futures	980.58	983.72	979.37	982.03	111449.0
2009-08-31 15:00:00	ES	Futures	982.03	985.16	978.89	984.68	340323.0
2009-08-31 16:00:00	ES	Futures	984.44	985.4	982.27	984.2	132997.0
2009-08-31 17:00:00	ES	Futures	984.2	984.68	984.2	984.44	1133.0
2009-08-31 18:00:00	ES	Futures	984.44	985.4	984.2	984.92	2148.0
2009-08-31 19:00:00	ES	Futures	984.92	985.16	983.96	984.2	2154.0
2009-08-31 20:00:00	ES	Futures	984.2	984.68	983.23	983.47	4373.0
2009-08-31 21:00:00	ES	Futures	983.47	985.89	983.47	985.4	9616.0
2009-08-31 22:00:00	ES	Futures	985.4	985.89	984.2	984.44	4646.0
2009-08-31 23:00:00	ES	Futures	984.2	986.85	983.96	986.61	5088.0
2009-08-31 00:00:00	NQ	Futures	1858.39	1859.24	1856.39	1858.39	837.0
2009-08-31 01:00:00	NQ	Futures	1858.1	1859.24	1856.11	1856.96	391.0
2009-08-31 02:00:00	NQ	Futures	1856.96	1856.96	1854.4	1855.82	951.0
2009-08-31 03:00:00	NQ	Futures	1855.54	1858.1	1853.83	1855.54	1253.0
2009-08-31 04:00:00	NQ	Futures	1855.26	1858.1	1852.69	1856.68	931.0
2009-08-31 05:00:00	NQ	Futures	1856.96	1859.53	1856.39	1857.25	816.0
2009-08-31 06:00:00	NQ	Futures	1857.53	1859.53	1855.82	1856.96	632.0
2009-08-31 07:00:00	NQ	Futures	1856.96	1859.81	1855.82	1857.25	751.0
2009-08-31 08:00:00	NQ	Futures	1857.25	1857.82	1853.55	1855.82	2142.0
2009-08-31 09:00:00	NQ	Futures	1855.54	1860.1	1841.01	1844.72	47024.0
2009-08-31 10:00:00	NQ	Futures	1844.43	1852.41	1840.73	1848.99	47320.0
2009-08-31 11:00:00	NQ	Futures	1848.99	1849.27	1841.58	1845.57	26200.0
2009-08-31 12:00:00	NQ	Futures	1845.29	1848.13	1843.01	1843.58	18145.0
2009-08-31 13:00:00	NQ	Futures	1843.86	1845.0	1841.87	1844.43	13210.0
2009-08-31 14:00:00	NQ	Futures	1844.15	1850.13	1842.15	1847.28	16684.0
2009-08-31 15:00:00	NQ	Futures	1847.28	1852.98	1841.87	1852.41	43692.0
2009-08-31 16:00:00	NQ	Futures	1852.69	1853.26	1846.14	1850.13	14768.0
2009-08-31 17:00:00	NQ	Futures	1850.41	1850.7	1849.84	1850.13	181.0
2009-08-31 18:00:00	NQ	Futures	1850.13	1852.12	1850.13	1850.98	154.0
2009-08-31 19:00:00	NQ	Futures	1850.7	1851.84	1850.7	1851.84	437.0
2009-08-31 20:00:00	NQ	Futures	1851.84	1852.12	1849.84	1850.41	715.0
2009-08-31 21:00:00	NQ	Futures	1850.7	1854.97	1850.13	1854.97	1470.0
2009-08-31 22:00:00	NQ	Futures	1854.69	1855.54	1852.41	1853.26	483.0
2009-08-31 23:00:00	NQ	Futures	1852.98	1857.53	1852.98	1856.96	551.0
2009-08-31 00:00:00	YM	Futures	8769.3	8771.1	8764.6	8771.1	486.0
2009-08-31 01:00:00	YM	Futures	8770.2	8772.0	8760.0	8761.9	580.0

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

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