PREVIEW / futures_1hour / 2009-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-04.parquet
  size:    35 KB
  rows:    972

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-04 00:00:00	ES	Futures	965.63	966.83	965.15	965.87	1998.0
2009-09-04 01:00:00	ES	Futures	966.11	966.59	965.15	965.39	1734.0
2009-09-04 02:00:00	ES	Futures	965.39	966.11	964.66	965.63	5456.0
2009-09-04 03:00:00	ES	Futures	965.63	970.21	965.39	968.76	30145.0
2009-09-04 04:00:00	ES	Futures	968.52	971.42	968.28	970.93	18286.0
2009-09-04 05:00:00	ES	Futures	970.93	971.42	968.76	968.76	8737.0
2009-09-04 06:00:00	ES	Futures	968.76	969.49	968.52	969.0	5257.0
2009-09-04 07:00:00	ES	Futures	969.25	971.17	969.0	970.45	14718.0
2009-09-04 08:00:00	ES	Futures	970.69	974.07	964.66	968.28	182930.0
2009-09-04 09:00:00	ES	Futures	968.04	971.17	965.39	966.35	279539.0
2009-09-04 10:00:00	ES	Futures	966.59	972.62	966.35	971.9	188342.0
2009-09-04 11:00:00	ES	Futures	971.9	973.1	968.52	972.86	139742.0
2009-09-04 12:00:00	ES	Futures	973.1	977.93	972.62	977.45	198065.0
2009-09-04 13:00:00	ES	Futures	977.45	979.86	976.48	976.72	114271.0
2009-09-04 14:00:00	ES	Futures	976.72	979.13	975.76	978.65	92384.0
2009-09-04 15:00:00	ES	Futures	978.65	980.34	976.72	979.86	211273.0
2009-09-04 16:00:00	ES	Futures	980.1	980.34	977.69	978.17	75343.0
2009-09-04 00:00:00	NQ	Futures	1826.77	1829.34	1826.49	1828.2	377.0
2009-09-04 01:00:00	NQ	Futures	1828.2	1829.05	1825.92	1825.92	268.0
2009-09-04 02:00:00	NQ	Futures	1825.92	1827.34	1825.35	1826.2	333.0
2009-09-04 03:00:00	NQ	Futures	1826.49	1835.32	1825.92	1833.04	2462.0
2009-09-04 04:00:00	NQ	Futures	1833.04	1837.31	1832.47	1836.46	1268.0
2009-09-04 05:00:00	NQ	Futures	1836.46	1837.03	1832.76	1833.04	624.0
2009-09-04 06:00:00	NQ	Futures	1833.04	1834.18	1832.47	1834.18	370.0
2009-09-04 07:00:00	NQ	Futures	1834.18	1837.88	1833.89	1836.74	1024.0
2009-09-04 08:00:00	NQ	Futures	1836.74	1842.72	1823.36	1831.9	14750.0
2009-09-04 09:00:00	NQ	Futures	1832.19	1842.15	1828.77	1830.48	37401.0
2009-09-04 10:00:00	NQ	Futures	1830.48	1847.0	1829.62	1846.43	42915.0
2009-09-04 11:00:00	NQ	Futures	1846.71	1850.98	1839.31	1850.98	28764.0
2009-09-04 12:00:00	NQ	Futures	1850.98	1864.94	1850.41	1863.8	55816.0
2009-09-04 13:00:00	NQ	Futures	1863.8	1868.93	1859.81	1860.1	26157.0
2009-09-04 14:00:00	NQ	Futures	1860.1	1864.08	1857.53	1864.08	17507.0
2009-09-04 15:00:00	NQ	Futures	1863.8	1866.93	1858.96	1866.65	33985.0
2009-09-04 16:00:00	NQ	Futures	1866.65	1867.79	1863.51	1864.37	12710.0
2009-09-04 00:00:00	YM	Futures	8616.7	8628.7	8614.9	8622.3	255.0
2009-09-04 01:00:00	YM	Futures	8622.3	8626.9	8617.6	8619.5	353.0
2009-09-04 02:00:00	YM	Futures	8619.5	8622.3	8614.9	8621.3	340.0
2009-09-04 03:00:00	YM	Futures	8622.3	8655.5	8618.6	8644.4	1636.0
2009-09-04 04:00:00	YM	Futures	8644.4	8662.9	8640.7	8660.2	912.0
2009-09-04 05:00:00	YM	Futures	8661.1	8662.9	8642.6	8642.6	482.0
2009-09-04 06:00:00	YM	Futures	8644.4	8649.1	8642.6	8645.4	311.0
2009-09-04 07:00:00	YM	Futures	8647.2	8661.1	8647.2	8658.3	667.0
2009-09-04 08:00:00	YM	Futures	8657.4	8687.0	8621.3	8645.4	11286.0
2009-09-04 09:00:00	YM	Futures	8644.4	8665.7	8613.0	8622.3	22211.0
2009-09-04 10:00:00	YM	Futures	8622.3	8675.9	8621.3	8663.9	16657.0
2009-09-04 11:00:00	YM	Futures	8663.9	8673.1	8638.0	8672.2	12350.0
2009-09-04 12:00:00	YM	Futures	8673.1	8723.0	8669.4	8711.0	21442.0
2009-09-04 13:00:00	YM	Futures	8710.1	8730.4	8702.7	8703.6	12121.0
2009-09-04 14:00:00	YM	Futures	8705.5	8722.1	8693.5	8719.3	9128.0
2009-09-04 15:00:00	YM	Futures	8718.4	8727.7	8702.7	8724.0	15265.0

> showing 50 of 972 rows — these rows as CSV

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