PREVIEW / futures_1hour / 2013-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-03.parquet
  size:    43 KB
  rows:    1,255

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-03 00:00:00	ES	Futures	1639.78	1640.55	1639.52	1640.55	1777.0
2013-05-03 01:00:00	ES	Futures	1640.55	1640.55	1639.52	1640.04	2721.0
2013-05-03 02:00:00	ES	Futures	1640.04	1640.55	1639.01	1639.78	6523.0
2013-05-03 03:00:00	ES	Futures	1639.78	1640.04	1638.75	1639.78	14273.0
2013-05-03 04:00:00	ES	Futures	1639.78	1639.78	1638.24	1638.49	11349.0
2013-05-03 05:00:00	ES	Futures	1638.24	1640.3	1637.72	1640.3	15622.0
2013-05-03 06:00:00	ES	Futures	1640.04	1640.55	1638.75	1639.27	14141.0
2013-05-03 07:00:00	ES	Futures	1639.01	1640.3	1638.24	1639.27	25493.0
2013-05-03 08:00:00	ES	Futures	1639.27	1654.46	1638.49	1653.18	237985.0
2013-05-03 09:00:00	ES	Futures	1653.18	1660.65	1652.92	1658.33	369641.0
2013-05-03 10:00:00	ES	Futures	1658.59	1663.22	1657.04	1662.19	355973.0
2013-05-03 11:00:00	ES	Futures	1662.19	1663.22	1659.87	1660.13	191578.0
2013-05-03 12:00:00	ES	Futures	1660.13	1662.19	1660.13	1661.68	94028.0
2013-05-03 13:00:00	ES	Futures	1661.93	1662.45	1659.36	1659.62	117872.0
2013-05-03 14:00:00	ES	Futures	1659.62	1660.65	1657.56	1658.59	116910.0
2013-05-03 15:00:00	ES	Futures	1658.59	1660.9	1657.04	1657.81	241921.0
2013-05-03 16:00:00	ES	Futures	1657.56	1658.33	1656.78	1658.33	96904.0
2013-05-03 17:00:00	ES	Futures	1658.33	1658.59	1657.3	1657.81	1662.0
2013-05-03 00:00:00	NQ	Futures	3387.14	3388.6	3387.14	3388.6	151.0
2013-05-03 01:00:00	NQ	Futures	3388.31	3388.6	3386.85	3388.02	241.0
2013-05-03 02:00:00	NQ	Futures	3388.02	3389.18	3386.85	3389.18	528.0
2013-05-03 03:00:00	NQ	Futures	3388.89	3389.18	3387.14	3388.89	2079.0
2013-05-03 04:00:00	NQ	Futures	3388.89	3389.77	3385.97	3385.97	1715.0
2013-05-03 05:00:00	NQ	Futures	3385.97	3387.72	3383.64	3387.43	2028.0
2013-05-03 06:00:00	NQ	Futures	3387.43	3388.02	3384.52	3385.1	1654.0
2013-05-03 07:00:00	NQ	Futures	3384.81	3387.72	3384.52	3386.27	2311.0
2013-05-03 08:00:00	NQ	Futures	3386.27	3414.27	3384.52	3410.77	20347.0
2013-05-03 09:00:00	NQ	Futures	3410.77	3434.68	3410.47	3431.47	43857.0
2013-05-03 10:00:00	NQ	Futures	3431.47	3438.18	3426.81	3433.52	32598.0
2013-05-03 11:00:00	NQ	Futures	3433.81	3436.43	3432.06	3433.22	18595.0
2013-05-03 12:00:00	NQ	Futures	3433.22	3435.56	3432.35	3435.27	9040.0
2013-05-03 13:00:00	NQ	Futures	3435.27	3439.06	3430.02	3431.18	12661.0
2013-05-03 14:00:00	NQ	Futures	3430.89	3433.52	3427.39	3428.85	12990.0
2013-05-03 15:00:00	NQ	Futures	3428.85	3432.64	3426.22	3428.85	25536.0
2013-05-03 16:00:00	NQ	Futures	3428.27	3428.56	3425.35	3427.68	5172.0
2013-05-03 17:00:00	NQ	Futures	3427.68	3428.56	3425.93	3427.1	56.0
2013-05-03 00:00:00	YM	Futures	14915.5	14922.6	14914.5	14921.5	188.0
2013-05-03 01:00:00	YM	Futures	14921.5	14921.5	14914.5	14917.5	375.0
2013-05-03 02:00:00	YM	Futures	14916.5	14922.6	14913.5	14917.5	633.0
2013-05-03 03:00:00	YM	Futures	14917.5	14918.5	14909.4	14917.5	1471.0
2013-05-03 04:00:00	YM	Futures	14916.5	14917.5	14908.4	14909.4	1807.0
2013-05-03 05:00:00	YM	Futures	14908.4	14921.5	14903.4	14921.5	1933.0
2013-05-03 06:00:00	YM	Futures	14920.5	14922.6	14910.4	14912.5	1587.0
2013-05-03 07:00:00	YM	Futures	14912.5	14926.6	14910.4	14919.5	2150.0
2013-05-03 08:00:00	YM	Futures	14920.5	15042.9	14915.5	15036.8	20211.0
2013-05-03 09:00:00	YM	Futures	15037.8	15096.4	15037.8	15083.3	26293.0
2013-05-03 10:00:00	YM	Futures	15081.3	15116.7	15070.2	15108.6	26907.0
2013-05-03 11:00:00	YM	Futures	15108.6	15116.7	15087.3	15090.4	12411.0
2013-05-03 12:00:00	YM	Futures	15090.4	15106.6	15084.3	15103.5	6250.0
2013-05-03 13:00:00	YM	Futures	15104.5	15109.6	15083.3	15084.3	7658.0

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

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