PREVIEW / futures_1hour / 2009-08-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	964.18	967.32	964.18	967.07	7227.0
2009-08-20 01:00:00	ES	Futures	967.07	967.56	966.59	966.83	8060.0
2009-08-20 02:00:00	ES	Futures	967.07	967.07	965.63	966.11	11450.0
2009-08-20 03:00:00	ES	Futures	966.35	967.56	965.39	966.59	22908.0
2009-08-20 04:00:00	ES	Futures	966.59	968.28	966.11	968.04	17961.0
2009-08-20 05:00:00	ES	Futures	967.8	968.04	966.35	966.83	11352.0
2009-08-20 06:00:00	ES	Futures	967.07	967.07	964.66	965.87	14311.0
2009-08-20 07:00:00	ES	Futures	965.87	966.35	962.98	965.87	16890.0
2009-08-20 08:00:00	ES	Futures	965.87	966.83	960.8	961.77	73818.0
2009-08-20 09:00:00	ES	Futures	961.53	967.32	959.12	967.32	240422.0
2009-08-20 10:00:00	ES	Futures	967.07	969.25	963.94	968.04	285604.0
2009-08-20 11:00:00	ES	Futures	968.04	968.52	965.87	966.83	149078.0
2009-08-20 12:00:00	ES	Futures	966.83	968.76	966.35	967.8	96047.0
2009-08-20 13:00:00	ES	Futures	968.04	969.0	967.07	968.04	93030.0
2009-08-20 14:00:00	ES	Futures	968.04	969.0	966.59	967.8	133727.0
2009-08-20 15:00:00	ES	Futures	967.8	972.14	967.8	970.21	333749.0
2009-08-20 16:00:00	ES	Futures	970.21	970.93	968.76	969.0	92339.0
2009-08-20 17:00:00	ES	Futures	969.0	969.25	968.28	968.28	1436.0
2009-08-20 18:00:00	ES	Futures	968.28	968.76	968.28	968.28	1531.0
2009-08-20 19:00:00	ES	Futures	968.28	968.76	968.04	968.52	1179.0
2009-08-20 20:00:00	ES	Futures	968.52	968.52	967.07	968.04	3992.0
2009-08-20 21:00:00	ES	Futures	968.04	968.28	965.87	966.11	7787.0
2009-08-20 22:00:00	ES	Futures	966.11	968.04	965.87	967.07	3787.0
2009-08-20 23:00:00	ES	Futures	966.83	967.07	961.77	961.77	13957.0
2009-08-20 00:00:00	NQ	Futures	1825.07	1830.76	1824.78	1828.48	982.0
2009-08-20 01:00:00	NQ	Futures	1828.2	1830.19	1827.91	1829.05	344.0
2009-08-20 02:00:00	NQ	Futures	1829.05	1829.05	1826.2	1827.34	766.0
2009-08-20 03:00:00	NQ	Futures	1827.63	1829.91	1825.92	1827.34	1518.0
2009-08-20 04:00:00	NQ	Futures	1827.34	1831.62	1825.63	1831.05	1804.0
2009-08-20 05:00:00	NQ	Futures	1830.76	1831.05	1828.48	1829.62	972.0
2009-08-20 06:00:00	NQ	Futures	1829.91	1829.91	1825.35	1826.77	958.0
2009-08-20 07:00:00	NQ	Futures	1826.77	1827.06	1820.22	1825.92	3197.0
2009-08-20 08:00:00	NQ	Futures	1825.35	1828.77	1817.09	1817.66	8896.0
2009-08-20 09:00:00	NQ	Futures	1817.94	1837.31	1812.53	1836.74	44628.0
2009-08-20 10:00:00	NQ	Futures	1836.74	1839.31	1828.77	1834.46	48218.0
2009-08-20 11:00:00	NQ	Futures	1834.46	1836.17	1829.34	1830.48	30952.0
2009-08-20 12:00:00	NQ	Futures	1830.19	1835.89	1830.19	1834.75	19433.0
2009-08-20 13:00:00	NQ	Futures	1834.75	1837.6	1833.61	1835.03	14007.0
2009-08-20 14:00:00	NQ	Futures	1835.03	1836.74	1832.19	1834.75	16546.0
2009-08-20 15:00:00	NQ	Futures	1834.75	1845.86	1834.46	1839.59	51760.0
2009-08-20 16:00:00	NQ	Futures	1839.59	1840.16	1837.6	1838.17	10063.0
2009-08-20 17:00:00	NQ	Futures	1838.17	1838.45	1837.31	1837.88	112.0
2009-08-20 18:00:00	NQ	Futures	1837.88	1838.45	1837.31	1837.6	149.0
2009-08-20 19:00:00	NQ	Futures	1837.88	1838.17	1837.03	1837.6	166.0
2009-08-20 20:00:00	NQ	Futures	1837.31	1837.31	1834.75	1836.74	504.0
2009-08-20 21:00:00	NQ	Futures	1836.46	1836.46	1831.62	1831.9	637.0
2009-08-20 22:00:00	NQ	Futures	1831.9	1835.6	1831.9	1833.32	337.0
2009-08-20 23:00:00	NQ	Futures	1833.32	1833.61	1824.21	1824.78	859.0
2009-08-20 00:00:00	YM	Futures	8592.7	8619.5	8592.7	8616.7	741.0
2009-08-20 01:00:00	YM	Futures	8616.7	8619.5	8613.0	8617.6	457.0

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

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