PREVIEW / futures_1hour / 2013-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-29.parquet
  size:    49 KB
  rows:    1,513

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.97	1686.42	1687.71	4104.0
2013-08-29 01:00:00	ES	Futures	1687.71	1688.23	1686.68	1687.71	5244.0
2013-08-29 02:00:00	ES	Futures	1687.45	1691.85	1687.45	1691.07	14981.0
2013-08-29 03:00:00	ES	Futures	1690.81	1692.62	1688.23	1691.59	27107.0
2013-08-29 04:00:00	ES	Futures	1691.59	1693.4	1691.07	1692.11	11178.0
2013-08-29 05:00:00	ES	Futures	1692.37	1692.62	1689.78	1690.3	10143.0
2013-08-29 06:00:00	ES	Futures	1690.56	1690.56	1688.23	1690.04	14163.0
2013-08-29 07:00:00	ES	Futures	1690.3	1694.17	1690.04	1693.4	25219.0
2013-08-29 08:00:00	ES	Futures	1693.4	1694.43	1689.26	1690.56	72028.0
2013-08-29 09:00:00	ES	Futures	1690.3	1694.17	1683.06	1691.85	327261.0
2013-08-29 10:00:00	ES	Futures	1692.11	1699.86	1691.59	1698.57	343223.0
2013-08-29 11:00:00	ES	Futures	1698.31	1700.64	1697.54	1700.38	184913.0
2013-08-29 12:00:00	ES	Futures	1700.12	1700.64	1696.24	1697.79	123118.0
2013-08-29 13:00:00	ES	Futures	1697.79	1699.34	1692.88	1694.17	147111.0
2013-08-29 14:00:00	ES	Futures	1693.92	1697.54	1693.4	1696.5	132272.0
2013-08-29 15:00:00	ES	Futures	1696.5	1696.76	1689.78	1691.33	207721.0
2013-08-29 16:00:00	ES	Futures	1691.33	1693.66	1690.81	1693.4	63074.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.14	1693.66	5497.0
2013-08-29 19:00:00	ES	Futures	1693.66	1694.43	1693.4	1694.17	4256.0
2013-08-29 20:00:00	ES	Futures	1694.43	1694.69	1692.88	1693.4	8859.0
2013-08-29 21:00:00	ES	Futures	1693.14	1694.17	1691.85	1693.92	6339.0
2013-08-29 22:00:00	ES	Futures	1693.92	1694.69	1692.37	1694.69	7233.0
2013-08-29 23:00:00	ES	Futures	1694.69	1698.05	1694.43	1697.28	14759.0
2013-08-29 00:00:00	NQ	Futures	3588.07	3591.29	3587.78	3591.29	372.0
2013-08-29 01:00:00	NQ	Futures	3591.29	3592.46	3589.53	3590.99	613.0
2013-08-29 02:00:00	NQ	Futures	3591.29	3600.05	3591.29	3598.88	1335.0
2013-08-29 03:00:00	NQ	Futures	3598.59	3602.68	3593.33	3600.64	4570.0
2013-08-29 04:00:00	NQ	Futures	3600.64	3603.85	3599.47	3601.22	1611.0
2013-08-29 05:00:00	NQ	Futures	3601.22	3602.98	3595.96	3597.13	1665.0
2013-08-29 06:00:00	NQ	Futures	3597.42	3598.3	3592.75	3597.42	2581.0
2013-08-29 07:00:00	NQ	Futures	3597.42	3605.31	3597.42	3603.56	2666.0
2013-08-29 08:00:00	NQ	Futures	3603.56	3605.31	3595.67	3599.18	4858.0
2013-08-29 09:00:00	NQ	Futures	3598.88	3614.96	3584.86	3610.57	49212.0
2013-08-29 10:00:00	NQ	Futures	3610.57	3631.91	3610.57	3626.94	44438.0
2013-08-29 11:00:00	NQ	Futures	3626.65	3633.66	3626.06	3633.37	20133.0
2013-08-29 12:00:00	NQ	Futures	3633.37	3634.25	3623.43	3627.82	15471.0
2013-08-29 13:00:00	NQ	Futures	3628.11	3631.32	3616.13	3619.05	22625.0
2013-08-29 14:00:00	NQ	Futures	3619.34	3628.4	3617.59	3626.65	16643.0
2013-08-29 15:00:00	NQ	Futures	3626.65	3627.23	3612.91	3614.67	41748.0
2013-08-29 16:00:00	NQ	Futures	3614.67	3616.13	3609.41	3615.25	12480.0
2013-08-29 17:00:00	NQ	Futures	3615.25	3616.71	3614.67	3616.13	251.0
2013-08-29 18:00:00	NQ	Futures	3616.13	3618.46	3614.67	3615.54	504.0
2013-08-29 19:00:00	NQ	Futures	3615.25	3617.3	3614.67	3616.42	1013.0
2013-08-29 20:00:00	NQ	Futures	3616.71	3617.3	3614.08	3615.25	1273.0
2013-08-29 21:00:00	NQ	Futures	3614.37	3616.71	3611.74	3615.83	758.0
2013-08-29 22:00:00	NQ	Futures	3615.83	3617.88	3613.79	3617.59	459.0
2013-08-29 23:00:00	NQ	Futures	3617.3	3622.85	3617.3	3622.26	1788.0
2013-08-29 00:00:00	YM	Futures	15030.1	15041.2	15030.1	15041.2	375.0
2013-08-29 01:00:00	YM	Futures	15041.2	15046.3	15035.1	15041.2	1034.0

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

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