PREVIEW / futures_30min / 2013-08-29

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-08-29.parquet
  size:    76 KB
  rows:    2,812

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-29 00:00:00	ES	Futures	1686.68	1687.2	1686.42	1686.94	1654.0
2013-08-29 00:30:00	ES	Futures	1686.94	1687.97	1686.94	1687.71	2450.0
2013-08-29 01:00:00	ES	Futures	1687.71	1688.23	1686.68	1687.45	3785.0
2013-08-29 01:30:00	ES	Futures	1687.2	1688.23	1687.2	1687.71	1459.0
2013-08-29 02:00:00	ES	Futures	1687.45	1690.04	1687.45	1690.04	5942.0
2013-08-29 02:30:00	ES	Futures	1690.04	1691.85	1689.52	1691.07	9039.0
2013-08-29 03:00:00	ES	Futures	1690.81	1692.37	1688.23	1690.56	17618.0
2013-08-29 03:30:00	ES	Futures	1690.3	1692.62	1690.3	1691.59	9489.0
2013-08-29 04:00:00	ES	Futures	1691.59	1693.4	1691.07	1692.88	7675.0
2013-08-29 04:30:00	ES	Futures	1692.62	1693.4	1691.59	1692.11	3503.0
2013-08-29 05:00:00	ES	Futures	1692.37	1692.62	1691.85	1692.37	2929.0
2013-08-29 05:30:00	ES	Futures	1692.11	1692.37	1689.78	1690.3	7214.0
2013-08-29 06:00:00	ES	Futures	1690.56	1690.56	1688.23	1689.26	6388.0
2013-08-29 06:30:00	ES	Futures	1689.01	1690.3	1688.23	1690.04	7775.0
2013-08-29 07:00:00	ES	Futures	1690.3	1692.37	1690.04	1692.11	10769.0
2013-08-29 07:30:00	ES	Futures	1692.37	1694.17	1692.11	1693.4	14450.0
2013-08-29 08:00:00	ES	Futures	1693.4	1694.43	1691.85	1692.37	25390.0
2013-08-29 08:30:00	ES	Futures	1692.37	1694.17	1689.26	1690.56	46638.0
2013-08-29 09:00:00	ES	Futures	1690.3	1690.56	1683.06	1685.13	91358.0
2013-08-29 09:30:00	ES	Futures	1684.87	1694.17	1683.58	1691.85	235903.0
2013-08-29 10:00:00	ES	Futures	1692.11	1695.47	1691.59	1692.88	156845.0
2013-08-29 10:30:00	ES	Futures	1693.14	1699.86	1692.62	1698.57	186378.0
2013-08-29 11:00:00	ES	Futures	1698.31	1700.64	1697.54	1699.6	106940.0
2013-08-29 11:30:00	ES	Futures	1699.6	1700.64	1698.83	1700.38	77973.0
2013-08-29 12:00:00	ES	Futures	1700.12	1700.64	1697.54	1698.57	66483.0
2013-08-29 12:30:00	ES	Futures	1698.57	1698.83	1696.24	1697.79	56635.0
2013-08-29 13:00:00	ES	Futures	1697.79	1699.34	1694.95	1695.98	65123.0
2013-08-29 13:30:00	ES	Futures	1695.98	1695.98	1692.88	1694.17	81988.0
2013-08-29 14:00:00	ES	Futures	1693.92	1696.76	1693.4	1695.73	71533.0
2013-08-29 14:30:00	ES	Futures	1695.73	1697.54	1695.47	1696.5	60739.0
2013-08-29 15:00:00	ES	Futures	1696.5	1696.76	1691.85	1692.62	74722.0
2013-08-29 15:30:00	ES	Futures	1692.62	1693.66	1689.78	1691.33	132999.0
2013-08-29 16:00:00	ES	Futures	1691.33	1693.14	1690.81	1692.37	57090.0
2013-08-29 16:30:00	ES	Futures	1692.37	1693.66	1692.11	1693.4	5984.0
2013-08-29 17:00:00	ES	Futures	1693.66	1694.17	1693.4	1693.92	2840.0
2013-08-29 18:00:00	ES	Futures	1694.69	1694.95	1693.66	1693.92	4342.0
2013-08-29 18:30:00	ES	Futures	1694.17	1694.17	1693.14	1693.66	1155.0
2013-08-29 19:00:00	ES	Futures	1693.66	1694.17	1693.4	1693.92	2268.0
2013-08-29 19:30:00	ES	Futures	1693.92	1694.43	1693.92	1694.17	1988.0
2013-08-29 20:00:00	ES	Futures	1694.43	1694.69	1693.92	1693.92	5660.0
2013-08-29 20:30:00	ES	Futures	1693.92	1694.43	1692.88	1693.4	3199.0
2013-08-29 21:00:00	ES	Futures	1693.14	1693.66	1691.85	1693.14	4424.0
2013-08-29 21:30:00	ES	Futures	1693.14	1694.17	1692.62	1693.92	1915.0
2013-08-29 22:00:00	ES	Futures	1693.92	1694.17	1692.37	1693.92	2506.0
2013-08-29 22:30:00	ES	Futures	1693.92	1694.69	1693.4	1694.69	4727.0
2013-08-29 23:00:00	ES	Futures	1694.69	1695.98	1694.43	1695.73	4221.0
2013-08-29 23:30:00	ES	Futures	1695.47	1698.05	1694.95	1697.28	10538.0
2013-08-29 00:00:00	NQ	Futures	3588.07	3588.66	3587.78	3588.36	163.0
2013-08-29 00:30:00	NQ	Futures	3588.95	3591.29	3588.95	3591.29	209.0
2013-08-29 01:00:00	NQ	Futures	3591.29	3592.46	3589.53	3590.12	352.0

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

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