PREVIEW / futures_1hour / 2013-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-28.parquet
  size:    50 KB
  rows:    1,541

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	1683.32	1683.58	5517.0
2013-08-28 01:00:00	ES	Futures	1683.84	1687.97	1683.32	1687.2	6814.0
2013-08-28 02:00:00	ES	Futures	1687.2	1688.23	1684.87	1687.45	9934.0
2013-08-28 03:00:00	ES	Futures	1687.45	1690.3	1686.42	1689.26	36262.0
2013-08-28 04:00:00	ES	Futures	1689.26	1689.52	1686.42	1687.71	20207.0
2013-08-28 05:00:00	ES	Futures	1687.45	1687.71	1684.09	1684.87	19312.0
2013-08-28 06:00:00	ES	Futures	1684.87	1685.64	1682.8	1684.61	24423.0
2013-08-28 07:00:00	ES	Futures	1684.35	1684.61	1680.99	1681.77	36488.0
2013-08-28 08:00:00	ES	Futures	1681.51	1685.9	1681.51	1683.58	38366.0
2013-08-28 09:00:00	ES	Futures	1683.84	1687.71	1679.96	1684.87	269582.0
2013-08-28 10:00:00	ES	Futures	1684.87	1690.04	1683.58	1689.52	267708.0
2013-08-28 11:00:00	ES	Futures	1689.52	1692.88	1687.97	1692.11	205784.0
2013-08-28 12:00:00	ES	Futures	1692.11	1694.69	1691.07	1693.66	128028.0
2013-08-28 13:00:00	ES	Futures	1693.66	1694.95	1692.11	1694.17	98806.0
2013-08-28 14:00:00	ES	Futures	1694.17	1694.43	1688.23	1690.04	148237.0
2013-08-28 15:00:00	ES	Futures	1690.04	1693.92	1688.23	1689.01	197333.0
2013-08-28 16:00:00	ES	Futures	1689.01	1690.81	1685.13	1685.64	85097.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	6324.0
2013-08-28 19:00:00	ES	Futures	1686.68	1686.94	1684.61	1685.64	4440.0
2013-08-28 20:00:00	ES	Futures	1685.9	1686.68	1685.13	1685.9	5113.0
2013-08-28 21:00:00	ES	Futures	1686.16	1686.94	1685.13	1685.64	5906.0
2013-08-28 22:00:00	ES	Futures	1685.64	1686.68	1685.13	1685.39	2660.0
2013-08-28 23:00:00	ES	Futures	1685.39	1686.68	1685.13	1686.42	1738.0
2013-08-28 00:00:00	NQ	Futures	3580.18	3581.93	3574.92	3576.09	726.0
2013-08-28 01:00:00	NQ	Futures	3575.51	3584.57	3574.92	3583.4	746.0
2013-08-28 02:00:00	NQ	Futures	3583.4	3584.57	3579.3	3583.98	2026.0
2013-08-28 03:00:00	NQ	Futures	3583.98	3588.66	3581.35	3587.2	4162.0
2013-08-28 04:00:00	NQ	Futures	3587.2	3587.2	3581.93	3584.57	2788.0
2013-08-28 05:00:00	NQ	Futures	3584.27	3584.86	3579.6	3580.77	2488.0
2013-08-28 06:00:00	NQ	Futures	3580.47	3582.52	3577.55	3580.77	3101.0
2013-08-28 07:00:00	NQ	Futures	3580.77	3580.77	3573.46	3574.34	4463.0
2013-08-28 08:00:00	NQ	Futures	3574.34	3583.69	3574.04	3578.43	4329.0
2013-08-28 09:00:00	NQ	Futures	3578.14	3591.87	3572.29	3586.32	40507.0
2013-08-28 10:00:00	NQ	Futures	3586.61	3595.38	3579.6	3593.92	28329.0
2013-08-28 11:00:00	NQ	Futures	3593.92	3597.42	3586.32	3596.25	19034.0
2013-08-28 12:00:00	NQ	Futures	3595.96	3604.44	3593.92	3602.39	12337.0
2013-08-28 13:00:00	NQ	Futures	3602.39	3605.9	3599.18	3604.14	10632.0
2013-08-28 14:00:00	NQ	Futures	3604.44	3605.61	3591.58	3594.79	14827.0
2013-08-28 15:00:00	NQ	Futures	3595.09	3605.02	3589.83	3590.7	27987.0
2013-08-28 16:00:00	NQ	Futures	3590.7	3593.33	3584.27	3584.27	5436.0
2013-08-28 17:00:00	NQ	Futures	3584.86	3585.73	3584.57	3585.73	95.0
2013-08-28 18:00:00	NQ	Futures	3586.61	3586.9	3584.57	3585.44	491.0
2013-08-28 19:00:00	NQ	Futures	3585.73	3586.32	3581.64	3584.86	461.0
2013-08-28 20:00:00	NQ	Futures	3585.15	3586.32	3583.4	3585.73	606.0
2013-08-28 21:00:00	NQ	Futures	3585.73	3588.07	3585.15	3585.15	695.0
2013-08-28 22:00:00	NQ	Futures	3586.03	3588.07	3584.86	3585.44	458.0
2013-08-28 23:00:00	NQ	Futures	3585.44	3588.66	3585.15	3588.07	229.0
2013-08-28 00:00:00	YM	Futures	14996.5	15003.6	14983.3	14985.4	968.0
2013-08-28 01:00:00	YM	Futures	14984.3	15018.9	14981.3	15015.8	994.0

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

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