PREVIEW / futures_1hour / 2013-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-06.parquet
  size:    45 KB
  rows:    1,427

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
2013-05-06 00:00:00	ES	Futures	1658.07	1658.33	1657.3	1657.56	1456.0
2013-05-06 01:00:00	ES	Futures	1657.3	1658.07	1657.3	1657.81	2180.0
2013-05-06 02:00:00	ES	Futures	1657.56	1658.84	1657.3	1657.81	6893.0
2013-05-06 03:00:00	ES	Futures	1657.81	1659.36	1657.56	1658.59	7091.0
2013-05-06 04:00:00	ES	Futures	1658.59	1660.13	1658.33	1658.84	8127.0
2013-05-06 05:00:00	ES	Futures	1658.84	1659.36	1657.3	1658.07	6106.0
2013-05-06 06:00:00	ES	Futures	1657.81	1658.07	1656.01	1656.52	10799.0
2013-05-06 07:00:00	ES	Futures	1656.27	1657.3	1656.27	1657.04	8467.0
2013-05-06 08:00:00	ES	Futures	1657.04	1659.1	1656.78	1658.59	26414.0
2013-05-06 09:00:00	ES	Futures	1658.59	1661.16	1657.81	1658.59	146482.0
2013-05-06 10:00:00	ES	Futures	1658.59	1662.45	1658.59	1659.36	179899.0
2013-05-06 11:00:00	ES	Futures	1659.36	1662.19	1658.59	1661.68	124011.0
2013-05-06 12:00:00	ES	Futures	1661.42	1662.96	1661.42	1661.93	79518.0
2013-05-06 13:00:00	ES	Futures	1661.93	1664.25	1661.42	1663.99	89718.0
2013-05-06 14:00:00	ES	Futures	1663.74	1664.25	1662.96	1663.22	66052.0
2013-05-06 15:00:00	ES	Futures	1663.22	1663.48	1660.9	1662.19	120056.0
2013-05-06 16:00:00	ES	Futures	1662.19	1662.71	1661.42	1661.93	56021.0
2013-05-06 17:00:00	ES	Futures	1661.68	1662.19	1661.42	1661.68	1857.0
2013-05-06 18:00:00	ES	Futures	1661.42	1661.68	1660.13	1660.65	4024.0
2013-05-06 19:00:00	ES	Futures	1660.39	1660.9	1659.36	1659.62	3772.0
2013-05-06 20:00:00	ES	Futures	1659.87	1659.87	1658.59	1659.62	8033.0
2013-05-06 21:00:00	ES	Futures	1659.62	1659.87	1658.07	1659.1	6436.0
2013-05-06 22:00:00	ES	Futures	1659.36	1660.65	1659.1	1659.62	4687.0
2013-05-06 23:00:00	ES	Futures	1659.62	1660.9	1659.1	1660.65	3421.0
2013-05-06 00:00:00	NQ	Futures	3431.77	3432.06	3430.31	3430.31	159.0
2013-05-06 01:00:00	NQ	Futures	3430.31	3431.47	3430.02	3430.6	271.0
2013-05-06 02:00:00	NQ	Futures	3430.89	3432.64	3430.31	3430.89	605.0
2013-05-06 03:00:00	NQ	Futures	3431.18	3433.22	3430.31	3432.35	736.0
2013-05-06 04:00:00	NQ	Futures	3432.35	3434.97	3430.02	3430.6	1689.0
2013-05-06 05:00:00	NQ	Futures	3430.6	3432.35	3428.27	3429.72	979.0
2013-05-06 06:00:00	NQ	Futures	3429.72	3430.02	3426.52	3427.39	1068.0
2013-05-06 07:00:00	NQ	Futures	3427.39	3428.56	3426.52	3428.56	1125.0
2013-05-06 08:00:00	NQ	Futures	3428.56	3435.27	3428.56	3433.81	3975.0
2013-05-06 09:00:00	NQ	Futures	3433.81	3441.1	3431.47	3436.43	26249.0
2013-05-06 10:00:00	NQ	Futures	3436.43	3442.85	3432.06	3433.22	23614.0
2013-05-06 11:00:00	NQ	Futures	3432.93	3442.85	3431.47	3442.27	15431.0
2013-05-06 12:00:00	NQ	Futures	3442.27	3444.31	3439.06	3441.1	15994.0
2013-05-06 13:00:00	NQ	Futures	3441.1	3446.35	3439.64	3445.77	8837.0
2013-05-06 14:00:00	NQ	Futures	3445.47	3446.35	3441.68	3442.27	8340.0
2013-05-06 15:00:00	NQ	Futures	3442.27	3444.89	3439.35	3441.39	17275.0
2013-05-06 16:00:00	NQ	Futures	3441.1	3441.39	3437.31	3439.64	3852.0
2013-05-06 17:00:00	NQ	Futures	3439.64	3439.93	3438.77	3439.06	108.0
2013-05-06 18:00:00	NQ	Futures	3438.77	3438.77	3436.14	3437.02	368.0
2013-05-06 19:00:00	NQ	Futures	3436.72	3437.6	3434.97	3435.27	434.0
2013-05-06 20:00:00	NQ	Futures	3435.56	3436.72	3433.81	3436.14	574.0
2013-05-06 21:00:00	NQ	Futures	3436.14	3436.43	3434.1	3435.85	498.0
2013-05-06 22:00:00	NQ	Futures	3435.85	3438.18	3435.27	3436.72	384.0
2013-05-06 23:00:00	NQ	Futures	3436.14	3438.18	3435.56	3437.6	302.0
2013-05-06 00:00:00	YM	Futures	15073.2	15074.2	15069.1	15071.2	153.0
2013-05-06 01:00:00	YM	Futures	15071.2	15076.2	15070.2	15074.2	198.0

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

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