PREVIEW / futures_1hour / 2013-05-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1681.51	1682.03	1681.0	1681.25	2793.0
2013-05-14 01:00:00	ES	Futures	1681.25	1682.54	1681.0	1682.28	2702.0
2013-05-14 02:00:00	ES	Futures	1682.28	1682.28	1681.25	1682.28	4601.0
2013-05-14 03:00:00	ES	Futures	1682.28	1682.28	1677.65	1678.42	32823.0
2013-05-14 04:00:00	ES	Futures	1678.42	1678.42	1676.87	1677.65	19493.0
2013-05-14 05:00:00	ES	Futures	1677.65	1677.9	1676.36	1677.65	16728.0
2013-05-14 06:00:00	ES	Futures	1677.65	1677.9	1675.84	1676.87	14859.0
2013-05-14 07:00:00	ES	Futures	1676.62	1682.03	1676.62	1681.25	51000.0
2013-05-14 08:00:00	ES	Futures	1681.51	1683.83	1681.0	1681.0	70884.0
2013-05-14 09:00:00	ES	Futures	1681.25	1687.95	1680.22	1687.18	292941.0
2013-05-14 10:00:00	ES	Futures	1687.18	1695.16	1687.18	1694.65	412271.0
2013-05-14 11:00:00	ES	Futures	1694.65	1696.45	1693.1	1695.16	222213.0
2013-05-14 12:00:00	ES	Futures	1695.16	1697.48	1694.39	1694.39	163634.0
2013-05-14 13:00:00	ES	Futures	1694.39	1696.45	1693.1	1693.62	163734.0
2013-05-14 14:00:00	ES	Futures	1693.87	1695.94	1692.59	1692.84	170403.0
2013-05-14 15:00:00	ES	Futures	1692.59	1698.77	1692.33	1697.74	250564.0
2013-05-14 16:00:00	ES	Futures	1698.0	1698.51	1696.97	1697.74	88115.0
2013-05-14 17:00:00	ES	Futures	1697.74	1698.51	1697.74	1698.51	3455.0
2013-05-14 18:00:00	ES	Futures	1697.48	1697.74	1696.45	1696.97	5542.0
2013-05-14 19:00:00	ES	Futures	1696.71	1697.48	1696.45	1696.71	2797.0
2013-05-14 20:00:00	ES	Futures	1696.71	1696.97	1695.42	1695.68	5962.0
2013-05-14 21:00:00	ES	Futures	1695.68	1696.97	1695.16	1696.45	7638.0
2013-05-14 22:00:00	ES	Futures	1696.71	1696.97	1696.45	1696.71	3389.0
2013-05-14 23:00:00	ES	Futures	1696.71	1697.48	1696.45	1696.45	1488.0
2013-05-14 00:00:00	NQ	Futures	3481.06	3482.52	3480.47	3480.47	168.0
2013-05-14 01:00:00	NQ	Futures	3481.06	3483.68	3480.77	3483.39	207.0
2013-05-14 02:00:00	NQ	Futures	3483.1	3483.1	3481.35	3482.81	315.0
2013-05-14 03:00:00	NQ	Futures	3482.81	3482.81	3472.31	3473.47	2739.0
2013-05-14 04:00:00	NQ	Futures	3473.47	3473.47	3469.68	3470.56	2029.0
2013-05-14 05:00:00	NQ	Futures	3470.27	3471.43	3467.93	3471.14	1516.0
2013-05-14 06:00:00	NQ	Futures	3470.85	3470.85	3466.47	3467.93	1493.0
2013-05-14 07:00:00	NQ	Futures	3468.22	3476.97	3467.64	3476.68	4079.0
2013-05-14 08:00:00	NQ	Futures	3476.68	3482.22	3476.39	3476.68	6153.0
2013-05-14 09:00:00	NQ	Futures	3476.68	3490.39	3474.06	3487.47	25673.0
2013-05-14 10:00:00	NQ	Futures	3487.77	3502.06	3486.6	3501.77	30028.0
2013-05-14 11:00:00	NQ	Futures	3501.77	3504.68	3498.27	3500.89	22684.0
2013-05-14 12:00:00	NQ	Futures	3500.89	3505.85	3494.18	3494.77	16634.0
2013-05-14 13:00:00	NQ	Futures	3494.47	3501.18	3486.89	3489.52	21445.0
2013-05-14 14:00:00	NQ	Futures	3489.52	3493.31	3483.68	3484.27	22721.0
2013-05-14 15:00:00	NQ	Futures	3484.56	3497.1	3482.22	3494.47	25996.0
2013-05-14 16:00:00	NQ	Futures	3494.47	3496.81	3492.43	3496.52	5253.0
2013-05-14 17:00:00	NQ	Futures	3496.81	3496.81	3496.22	3496.22	140.0
2013-05-14 18:00:00	NQ	Futures	3495.06	3495.64	3493.31	3493.89	399.0
2013-05-14 19:00:00	NQ	Futures	3493.6	3495.06	3493.6	3493.89	163.0
2013-05-14 20:00:00	NQ	Futures	3493.89	3493.89	3491.85	3492.14	510.0
2013-05-14 21:00:00	NQ	Futures	3491.85	3494.77	3491.27	3494.47	514.0
2013-05-14 22:00:00	NQ	Futures	3494.77	3495.06	3493.89	3494.47	219.0
2013-05-14 23:00:00	NQ	Futures	3494.47	3496.22	3494.47	3494.47	270.0
2013-05-14 00:00:00	YM	Futures	15230.9	15236.0	15228.9	15228.9	221.0
2013-05-14 01:00:00	YM	Futures	15228.9	15241.0	15228.9	15241.0	281.0

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

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