PREVIEW / futures_1hour / 2013-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-29.parquet
  size:    51 KB
  rows:    1,527

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-29 00:00:00	ES	Futures	1704.18	1707.01	1704.18	1706.75	4554.0
2013-05-29 01:00:00	ES	Futures	1706.75	1707.01	1701.86	1702.12	8938.0
2013-05-29 02:00:00	ES	Futures	1701.86	1703.15	1699.28	1699.8	21912.0
2013-05-29 03:00:00	ES	Futures	1699.8	1700.06	1695.94	1698.0	38061.0
2013-05-29 04:00:00	ES	Futures	1698.0	1700.83	1696.97	1697.22	16015.0
2013-05-29 05:00:00	ES	Futures	1696.97	1699.54	1696.19	1699.54	14249.0
2013-05-29 06:00:00	ES	Futures	1699.54	1699.54	1693.1	1693.62	34944.0
2013-05-29 07:00:00	ES	Futures	1693.62	1695.94	1691.56	1693.1	54989.0
2013-05-29 08:00:00	ES	Futures	1693.1	1698.0	1692.59	1696.45	73041.0
2013-05-29 09:00:00	ES	Futures	1696.71	1701.09	1694.13	1698.0	274576.0
2013-05-29 10:00:00	ES	Futures	1697.74	1701.86	1689.5	1689.75	366712.0
2013-05-29 11:00:00	ES	Futures	1689.75	1696.45	1687.69	1695.42	287032.0
2013-05-29 12:00:00	ES	Futures	1695.42	1696.97	1690.01	1691.04	155123.0
2013-05-29 13:00:00	ES	Futures	1690.78	1701.34	1689.5	1700.31	216106.0
2013-05-29 14:00:00	ES	Futures	1700.31	1702.89	1697.74	1697.74	180788.0
2013-05-29 15:00:00	ES	Futures	1697.74	1701.6	1695.68	1697.22	226474.0
2013-05-29 16:00:00	ES	Futures	1697.22	1697.74	1695.42	1695.94	90086.0
2013-05-29 17:00:00	ES	Futures	1695.68	1696.71	1695.68	1696.71	1926.0
2013-05-29 18:00:00	ES	Futures	1696.45	1696.97	1694.39	1695.42	5546.0
2013-05-29 19:00:00	ES	Futures	1695.42	1696.71	1694.65	1696.19	2966.0
2013-05-29 20:00:00	ES	Futures	1696.19	1698.77	1695.94	1698.77	8952.0
2013-05-29 21:00:00	ES	Futures	1698.77	1700.57	1698.77	1699.54	9367.0
2013-05-29 22:00:00	ES	Futures	1699.54	1700.06	1697.22	1699.28	5379.0
2013-05-29 23:00:00	ES	Futures	1699.28	1699.54	1696.97	1697.22	6605.0
2013-05-29 00:00:00	NQ	Futures	3504.97	3510.22	3504.97	3509.35	650.0
2013-05-29 01:00:00	NQ	Futures	3509.06	3509.06	3497.97	3498.27	1464.0
2013-05-29 02:00:00	NQ	Futures	3498.27	3500.31	3494.47	3494.77	1934.0
2013-05-29 03:00:00	NQ	Futures	3495.06	3495.93	3487.77	3491.85	5666.0
2013-05-29 04:00:00	NQ	Futures	3491.85	3497.1	3490.68	3490.97	2588.0
2013-05-29 05:00:00	NQ	Futures	3490.97	3497.1	3489.81	3496.81	2206.0
2013-05-29 06:00:00	NQ	Futures	3496.81	3497.1	3484.85	3486.02	3783.0
2013-05-29 07:00:00	NQ	Futures	3486.02	3488.06	3480.47	3482.22	5190.0
2013-05-29 08:00:00	NQ	Futures	3482.52	3495.06	3481.35	3492.72	7921.0
2013-05-29 09:00:00	NQ	Futures	3492.72	3500.31	3487.18	3492.43	37215.0
2013-05-29 10:00:00	NQ	Futures	3492.43	3501.47	3477.85	3479.6	36710.0
2013-05-29 11:00:00	NQ	Futures	3479.6	3494.47	3474.64	3492.72	26791.0
2013-05-29 12:00:00	NQ	Futures	3492.72	3496.22	3481.93	3483.68	22134.0
2013-05-29 13:00:00	NQ	Futures	3483.68	3503.81	3479.89	3501.18	24019.0
2013-05-29 14:00:00	NQ	Futures	3501.18	3507.6	3498.27	3498.27	24214.0
2013-05-29 15:00:00	NQ	Futures	3498.27	3505.27	3493.31	3494.77	27460.0
2013-05-29 16:00:00	NQ	Futures	3494.77	3497.68	3491.85	3493.02	6631.0
2013-05-29 17:00:00	NQ	Futures	3493.6	3494.18	3492.72	3494.18	51.0
2013-05-29 18:00:00	NQ	Futures	3494.18	3494.77	3488.93	3490.68	654.0
2013-05-29 19:00:00	NQ	Futures	3490.39	3492.72	3489.52	3491.85	357.0
2013-05-29 20:00:00	NQ	Futures	3491.85	3496.52	3491.27	3495.93	1160.0
2013-05-29 21:00:00	NQ	Futures	3496.22	3500.31	3496.22	3498.56	1507.0
2013-05-29 22:00:00	NQ	Futures	3498.56	3499.43	3494.18	3497.1	910.0
2013-05-29 23:00:00	NQ	Futures	3497.1	3497.1	3491.56	3491.56	1675.0
2013-05-29 00:00:00	YM	Futures	15537.2	15558.4	15537.2	15558.4	773.0
2013-05-29 01:00:00	YM	Futures	15553.4	15558.4	15517.0	15519.0	1197.0

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

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