PREVIEW / futures_1hour / 2009-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-14.parquet
  size:    36 KB
  rows:    1,013

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-14 00:00:00	ES	Futures	976.48	978.41	976.24	977.2	2430.0
2009-08-14 01:00:00	ES	Futures	976.96	977.69	975.76	976.0	2806.0
2009-08-14 02:00:00	ES	Futures	976.0	976.72	975.27	975.76	4630.0
2009-08-14 03:00:00	ES	Futures	975.76	979.62	974.79	979.37	16452.0
2009-08-14 04:00:00	ES	Futures	979.13	979.37	977.45	978.17	10881.0
2009-08-14 05:00:00	ES	Futures	977.93	978.89	975.52	976.24	12716.0
2009-08-14 06:00:00	ES	Futures	976.24	977.45	976.0	976.24	6566.0
2009-08-14 07:00:00	ES	Futures	976.24	979.13	976.24	977.69	14965.0
2009-08-14 08:00:00	ES	Futures	977.69	978.89	974.79	975.52	50498.0
2009-08-14 09:00:00	ES	Futures	975.52	977.69	964.9	966.11	277881.0
2009-08-14 10:00:00	ES	Futures	966.11	966.35	958.88	961.29	424930.0
2009-08-14 11:00:00	ES	Futures	961.05	962.25	957.19	959.36	207050.0
2009-08-14 12:00:00	ES	Futures	959.36	961.53	958.39	961.29	114464.0
2009-08-14 13:00:00	ES	Futures	961.05	961.77	958.88	960.56	102338.0
2009-08-14 14:00:00	ES	Futures	960.8	962.25	959.12	961.29	124942.0
2009-08-14 15:00:00	ES	Futures	961.29	967.56	959.84	967.56	296847.0
2009-08-14 16:00:00	ES	Futures	967.32	971.42	967.32	970.93	136699.0
2009-08-14 00:00:00	NQ	Futures	1856.68	1859.53	1855.82	1856.68	265.0
2009-08-14 01:00:00	NQ	Futures	1856.68	1857.53	1853.26	1854.4	229.0
2009-08-14 02:00:00	NQ	Futures	1854.69	1855.54	1852.98	1853.55	322.0
2009-08-14 03:00:00	NQ	Futures	1854.12	1861.52	1851.27	1860.1	1449.0
2009-08-14 04:00:00	NQ	Futures	1860.1	1860.38	1855.82	1857.25	789.0
2009-08-14 05:00:00	NQ	Futures	1857.53	1858.67	1852.98	1853.83	669.0
2009-08-14 06:00:00	NQ	Futures	1853.83	1856.11	1853.26	1854.4	576.0
2009-08-14 07:00:00	NQ	Futures	1854.12	1859.24	1854.12	1856.68	1313.0
2009-08-14 08:00:00	NQ	Futures	1856.96	1858.1	1843.86	1845.29	8871.0
2009-08-14 09:00:00	NQ	Futures	1845.57	1850.13	1826.49	1831.33	63008.0
2009-08-14 10:00:00	NQ	Futures	1831.33	1831.33	1819.94	1824.5	65504.0
2009-08-14 11:00:00	NQ	Futures	1824.5	1827.06	1817.09	1819.08	35843.0
2009-08-14 12:00:00	NQ	Futures	1818.8	1824.21	1817.94	1823.64	20794.0
2009-08-14 13:00:00	NQ	Futures	1823.64	1824.78	1819.94	1824.78	15313.0
2009-08-14 14:00:00	NQ	Futures	1824.78	1826.77	1821.08	1823.36	20570.0
2009-08-14 15:00:00	NQ	Futures	1823.36	1835.32	1822.5	1834.18	45442.0
2009-08-14 16:00:00	NQ	Futures	1833.89	1844.15	1833.32	1840.44	16262.0
2009-08-14 00:00:00	YM	Futures	8670.3	8684.2	8668.5	8673.1	217.0
2009-08-14 01:00:00	YM	Futures	8674.0	8676.8	8662.9	8662.9	198.0
2009-08-14 02:00:00	YM	Futures	8666.6	8672.2	8659.2	8661.1	439.0
2009-08-14 03:00:00	YM	Futures	8662.9	8693.5	8651.8	8688.8	1127.0
2009-08-14 04:00:00	YM	Futures	8689.8	8690.7	8673.1	8679.6	756.0
2009-08-14 05:00:00	YM	Futures	8679.6	8686.1	8662.9	8665.7	649.0
2009-08-14 06:00:00	YM	Futures	8665.7	8675.9	8663.9	8667.6	487.0
2009-08-14 07:00:00	YM	Futures	8666.6	8686.1	8665.7	8673.1	863.0
2009-08-14 08:00:00	YM	Futures	8674.0	8687.0	8650.9	8657.4	2614.0
2009-08-14 09:00:00	YM	Futures	8657.4	8675.9	8579.7	8589.9	22051.0
2009-08-14 10:00:00	YM	Futures	8589.9	8589.9	8524.2	8545.5	34563.0
2009-08-14 11:00:00	YM	Futures	8545.5	8552.9	8508.5	8527.0	16183.0
2009-08-14 12:00:00	YM	Futures	8527.0	8546.4	8516.8	8541.8	7993.0
2009-08-14 13:00:00	YM	Futures	8543.7	8546.4	8527.0	8538.1	7493.0
2009-08-14 14:00:00	YM	Futures	8538.1	8550.1	8523.3	8544.6	7917.0
2009-08-14 15:00:00	YM	Futures	8544.6	8592.7	8530.7	8589.9	18276.0

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

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