PREVIEW / futures_30min / 2013-08-28

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-08-28.parquet
  size:    77 KB
  rows:    2,873

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-08-28 00:00:00	ES	Futures	1685.13	1686.16	1684.09	1685.39	2859.0
2013-08-28 00:30:00	ES	Futures	1685.64	1685.64	1683.32	1683.58	2658.0
2013-08-28 01:00:00	ES	Futures	1683.84	1686.94	1683.32	1686.94	3385.0
2013-08-28 01:30:00	ES	Futures	1686.94	1687.97	1686.42	1687.2	3429.0
2013-08-28 02:00:00	ES	Futures	1687.2	1688.23	1685.9	1687.2	5091.0
2013-08-28 02:30:00	ES	Futures	1687.2	1687.97	1684.87	1687.45	4843.0
2013-08-28 03:00:00	ES	Futures	1687.45	1689.26	1686.42	1688.23	19306.0
2013-08-28 03:30:00	ES	Futures	1688.49	1690.3	1687.97	1689.26	16956.0
2013-08-28 04:00:00	ES	Futures	1689.26	1689.52	1687.45	1688.49	10282.0
2013-08-28 04:30:00	ES	Futures	1688.23	1689.01	1686.42	1687.71	9925.0
2013-08-28 05:00:00	ES	Futures	1687.45	1687.71	1685.13	1686.16	10595.0
2013-08-28 05:30:00	ES	Futures	1685.9	1686.42	1684.09	1684.87	8717.0
2013-08-28 06:00:00	ES	Futures	1684.87	1685.64	1683.58	1683.84	10053.0
2013-08-28 06:30:00	ES	Futures	1683.84	1685.39	1682.8	1684.61	14370.0
2013-08-28 07:00:00	ES	Futures	1684.35	1684.61	1683.06	1683.84	10306.0
2013-08-28 07:30:00	ES	Futures	1683.58	1683.58	1680.99	1681.77	26182.0
2013-08-28 08:00:00	ES	Futures	1681.51	1685.64	1681.51	1685.39	18099.0
2013-08-28 08:30:00	ES	Futures	1685.64	1685.9	1683.32	1683.58	20267.0
2013-08-28 09:00:00	ES	Futures	1683.84	1684.61	1682.28	1682.54	34316.0
2013-08-28 09:30:00	ES	Futures	1682.28	1687.71	1679.96	1684.87	235266.0
2013-08-28 10:00:00	ES	Futures	1684.87	1688.49	1683.58	1686.94	146714.0
2013-08-28 10:30:00	ES	Futures	1686.94	1690.04	1685.9	1689.52	120994.0
2013-08-28 11:00:00	ES	Futures	1689.52	1690.81	1688.75	1688.75	105599.0
2013-08-28 11:30:00	ES	Futures	1689.01	1692.88	1687.97	1692.11	100185.0
2013-08-28 12:00:00	ES	Futures	1692.11	1693.4	1691.07	1692.88	65971.0
2013-08-28 12:30:00	ES	Futures	1692.88	1694.69	1692.37	1693.66	62057.0
2013-08-28 13:00:00	ES	Futures	1693.66	1694.95	1692.11	1693.92	57693.0
2013-08-28 13:30:00	ES	Futures	1693.66	1694.43	1692.11	1694.17	41113.0
2013-08-28 14:00:00	ES	Futures	1694.17	1694.43	1690.3	1690.81	64137.0
2013-08-28 14:30:00	ES	Futures	1690.81	1691.33	1688.23	1690.04	84100.0
2013-08-28 15:00:00	ES	Futures	1690.04	1693.92	1689.26	1692.62	84883.0
2013-08-28 15:30:00	ES	Futures	1692.88	1693.92	1688.23	1689.01	112450.0
2013-08-28 16:00:00	ES	Futures	1689.01	1690.81	1687.2	1687.45	70815.0
2013-08-28 16:30:00	ES	Futures	1686.68	1686.94	1685.13	1685.64	14282.0
2013-08-28 17:00:00	ES	Futures	1685.9	1686.16	1685.64	1685.9	1789.0
2013-08-28 18:00:00	ES	Futures	1685.9	1686.94	1685.9	1686.42	3919.0
2013-08-28 18:30:00	ES	Futures	1686.68	1686.68	1686.16	1686.42	2405.0
2013-08-28 19:00:00	ES	Futures	1686.68	1686.94	1685.64	1686.16	1908.0
2013-08-28 19:30:00	ES	Futures	1685.9	1685.9	1684.61	1685.64	2532.0
2013-08-28 20:00:00	ES	Futures	1685.9	1686.68	1685.64	1686.16	2574.0
2013-08-28 20:30:00	ES	Futures	1686.16	1686.16	1685.13	1685.9	2539.0
2013-08-28 21:00:00	ES	Futures	1686.16	1686.94	1685.9	1686.16	3749.0
2013-08-28 21:30:00	ES	Futures	1686.42	1686.68	1685.13	1685.64	2157.0
2013-08-28 22:00:00	ES	Futures	1685.64	1686.16	1685.39	1685.64	1072.0
2013-08-28 22:30:00	ES	Futures	1685.64	1686.68	1685.13	1685.39	1588.0
2013-08-28 23:00:00	ES	Futures	1685.39	1686.68	1685.13	1686.42	1225.0
2013-08-28 23:30:00	ES	Futures	1686.42	1686.68	1686.16	1686.42	513.0
2013-08-28 00:00:00	NQ	Futures	3580.18	3581.93	3577.84	3580.77	196.0
2013-08-28 00:30:00	NQ	Futures	3580.18	3580.77	3574.92	3576.09	530.0
2013-08-28 01:00:00	NQ	Futures	3575.51	3583.1	3574.92	3582.23	285.0

> showing 50 of 2,873 rows — these rows as CSV

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