PREVIEW / futures_1hour / 2013-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-06.parquet
  size:    50 KB
  rows:    1,502

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-06-06 00:00:00	ES	Futures	1661.42	1661.42	1659.62	1660.9	7838.0
2013-06-06 01:00:00	ES	Futures	1661.16	1662.45	1660.13	1660.65	7538.0
2013-06-06 02:00:00	ES	Futures	1660.39	1661.93	1659.36	1661.93	10038.0
2013-06-06 03:00:00	ES	Futures	1661.93	1662.96	1660.9	1662.45	22389.0
2013-06-06 04:00:00	ES	Futures	1662.45	1662.96	1661.16	1662.71	13344.0
2013-06-06 05:00:00	ES	Futures	1662.71	1662.96	1661.16	1661.42	8826.0
2013-06-06 06:00:00	ES	Futures	1661.42	1662.96	1661.16	1662.45	23798.0
2013-06-06 07:00:00	ES	Futures	1662.19	1665.28	1660.9	1664.51	41518.0
2013-06-06 08:00:00	ES	Futures	1664.51	1665.8	1657.81	1659.1	89317.0
2013-06-06 09:00:00	ES	Futures	1659.36	1661.42	1652.15	1659.87	380336.0
2013-06-06 10:00:00	ES	Futures	1660.13	1662.71	1654.21	1659.87	379670.0
2013-06-06 11:00:00	ES	Futures	1660.13	1661.93	1653.95	1654.72	294357.0
2013-06-06 12:00:00	ES	Futures	1654.98	1656.01	1644.93	1648.54	446930.0
2013-06-06 13:00:00	ES	Futures	1648.54	1658.59	1648.28	1657.3	296543.0
2013-06-06 14:00:00	ES	Futures	1657.3	1665.8	1654.21	1662.96	243023.0
2013-06-06 15:00:00	ES	Futures	1662.96	1670.95	1660.39	1670.43	297899.0
2013-06-06 16:00:00	ES	Futures	1670.69	1673.53	1669.66	1672.24	140664.0
2013-06-06 17:00:00	ES	Futures	1672.24	1672.5	1671.46	1671.46	2043.0
2013-06-06 18:00:00	ES	Futures	1671.21	1671.98	1670.69	1671.72	6566.0
2013-06-06 19:00:00	ES	Futures	1671.46	1671.98	1670.69	1671.21	3783.0
2013-06-06 20:00:00	ES	Futures	1671.21	1673.27	1670.69	1673.01	10617.0
2013-06-06 21:00:00	ES	Futures	1673.01	1673.27	1671.72	1672.5	5903.0
2013-06-06 22:00:00	ES	Futures	1672.24	1672.75	1670.69	1672.5	6282.0
2013-06-06 23:00:00	ES	Futures	1672.5	1673.27	1669.15	1669.66	13112.0
2013-06-06 00:00:00	NQ	Futures	3433.81	3434.39	3431.47	3434.39	722.0
2013-06-06 01:00:00	NQ	Futures	3434.68	3435.85	3432.35	3432.64	948.0
2013-06-06 02:00:00	NQ	Futures	3432.93	3434.97	3431.18	3434.68	668.0
2013-06-06 03:00:00	NQ	Futures	3434.68	3437.02	3433.22	3435.85	2233.0
2013-06-06 04:00:00	NQ	Futures	3435.56	3437.02	3433.52	3436.72	1547.0
2013-06-06 05:00:00	NQ	Futures	3436.43	3437.02	3433.52	3434.1	1064.0
2013-06-06 06:00:00	NQ	Futures	3433.81	3437.02	3433.52	3435.85	2401.0
2013-06-06 07:00:00	NQ	Futures	3436.14	3440.52	3433.52	3439.64	4062.0
2013-06-06 08:00:00	NQ	Futures	3439.93	3441.68	3432.64	3434.39	8418.0
2013-06-06 09:00:00	NQ	Futures	3434.39	3439.64	3424.47	3430.31	40991.0
2013-06-06 10:00:00	NQ	Futures	3430.6	3435.27	3419.22	3427.1	39592.0
2013-06-06 11:00:00	NQ	Futures	3427.39	3428.27	3413.1	3415.14	30041.0
2013-06-06 12:00:00	NQ	Futures	3415.14	3417.18	3395.6	3399.1	45491.0
2013-06-06 13:00:00	NQ	Futures	3399.1	3413.68	3398.22	3413.68	27251.0
2013-06-06 14:00:00	NQ	Futures	3413.68	3432.93	3408.14	3428.27	26680.0
2013-06-06 15:00:00	NQ	Futures	3428.56	3439.93	3422.14	3438.77	34355.0
2013-06-06 16:00:00	NQ	Futures	3439.06	3446.35	3437.02	3441.1	9063.0
2013-06-06 17:00:00	NQ	Futures	3441.1	3441.68	3439.93	3439.93	271.0
2013-06-06 18:00:00	NQ	Futures	3439.64	3439.93	3438.18	3439.64	417.0
2013-06-06 19:00:00	NQ	Futures	3439.64	3440.22	3438.18	3439.06	230.0
2013-06-06 20:00:00	NQ	Futures	3438.77	3444.02	3438.47	3442.85	1018.0
2013-06-06 21:00:00	NQ	Futures	3443.14	3444.31	3440.52	3441.97	879.0
2013-06-06 22:00:00	NQ	Futures	3441.97	3442.56	3438.47	3442.56	855.0
2013-06-06 23:00:00	NQ	Futures	3441.97	3443.14	3436.43	3437.31	1358.0
2013-06-06 00:00:00	YM	Futures	15154.1	15155.1	15142.9	15152.0	882.0
2013-06-06 01:00:00	YM	Futures	15152.0	15162.2	15148.0	15150.0	991.0

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

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