PREVIEW / futures_1hour / 2013-08-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1689.52	1690.81	1689.01	1690.56	2417.0
2013-08-22 01:00:00	ES	Futures	1690.81	1690.81	1688.75	1690.04	3723.0
2013-08-22 02:00:00	ES	Futures	1690.04	1693.66	1689.78	1692.88	12336.0
2013-08-22 03:00:00	ES	Futures	1692.88	1699.6	1692.88	1699.09	47030.0
2013-08-22 04:00:00	ES	Futures	1699.09	1700.64	1698.83	1700.12	24581.0
2013-08-22 05:00:00	ES	Futures	1700.12	1701.15	1698.05	1698.57	17680.0
2013-08-22 06:00:00	ES	Futures	1698.57	1699.86	1697.79	1698.57	14370.0
2013-08-22 07:00:00	ES	Futures	1698.31	1699.86	1696.5	1696.76	26288.0
2013-08-22 08:00:00	ES	Futures	1696.76	1701.93	1696.5	1700.38	47099.0
2013-08-22 09:00:00	ES	Futures	1700.38	1705.55	1698.83	1704.51	225653.0
2013-08-22 10:00:00	ES	Futures	1704.51	1710.46	1703.22	1708.13	294853.0
2013-08-22 11:00:00	ES	Futures	1708.13	1709.17	1704.77	1707.36	184658.0
2013-08-22 12:00:00	ES	Futures	1707.36	1708.91	1703.48	1704.51	115154.0
2013-08-22 13:00:00	ES	Futures	1704.51	1709.43	1704.0	1708.91	90363.0
2013-08-22 14:00:00	ES	Futures	1708.65	1710.98	1707.88	1708.65	80729.0
2013-08-22 15:00:00	ES	Futures	1708.65	1714.08	1707.88	1710.72	208127.0
2013-08-22 16:00:00	ES	Futures	1710.46	1713.05	1710.46	1712.01	91008.0
2013-08-22 17:00:00	ES	Futures	1711.75	1712.27	1711.75	1711.75	1584.0
2013-08-22 18:00:00	ES	Futures	1711.75	1712.79	1710.72	1712.53	3777.0
2013-08-22 19:00:00	ES	Futures	1712.53	1713.56	1712.27	1712.79	2847.0
2013-08-22 20:00:00	ES	Futures	1712.79	1713.05	1711.24	1712.27	3648.0
2013-08-22 21:00:00	ES	Futures	1712.27	1714.34	1712.27	1713.82	7069.0
2013-08-22 22:00:00	ES	Futures	1714.08	1714.34	1712.79	1713.56	3927.0
2013-08-22 23:00:00	ES	Futures	1713.56	1714.08	1713.05	1713.3	2365.0
2013-08-22 00:00:00	NQ	Futures	3577.26	3580.18	3576.97	3579.89	340.0
2013-08-22 01:00:00	NQ	Futures	3580.47	3580.47	3576.09	3580.18	442.0
2013-08-22 02:00:00	NQ	Futures	3579.6	3586.61	3579.3	3585.73	1577.0
2013-08-22 03:00:00	NQ	Futures	3585.73	3600.93	3584.86	3599.18	6315.0
2013-08-22 04:00:00	NQ	Futures	3599.18	3603.56	3599.18	3601.81	3799.0
2013-08-22 05:00:00	NQ	Futures	3602.1	3604.14	3598.88	3599.18	1923.0
2013-08-22 06:00:00	NQ	Futures	3599.18	3601.81	3598.3	3600.05	1809.0
2013-08-22 07:00:00	NQ	Futures	3599.76	3601.81	3596.84	3597.13	2267.0
2013-08-22 08:00:00	NQ	Futures	3597.13	3605.9	3596.25	3604.44	4047.0
2013-08-22 09:00:00	NQ	Futures	3603.85	3621.09	3602.39	3616.42	33368.0
2013-08-22 10:00:00	NQ	Futures	3616.13	3628.11	3611.16	3623.43	32053.0
2013-08-22 11:00:00	NQ	Futures	3623.72	3625.77	3614.67	3617.59	21176.0
2013-08-22 12:00:00	NQ	Futures	3617.59	3618.17	3602.68	3604.73	14625.0
2013-08-22 13:00:00	NQ	Futures	3604.44	3617.88	3602.98	3615.54	13376.0
2013-08-22 14:00:00	NQ	Futures	3616.13	3622.26	3615.54	3617.0	6991.0
2013-08-22 15:00:00	NQ	Futures	3617.0	3627.23	3616.42	3625.19	31454.0
2013-08-22 16:00:00	NQ	Futures	3624.89	3631.91	3624.89	3629.57	8524.0
2013-08-22 17:00:00	NQ	Futures	3629.28	3629.86	3628.98	3629.86	103.0
2013-08-22 18:00:00	NQ	Futures	3627.82	3631.62	3627.82	3631.03	288.0
2013-08-22 19:00:00	NQ	Futures	3631.03	3633.08	3630.74	3631.91	294.0
2013-08-22 20:00:00	NQ	Futures	3632.2	3632.49	3628.98	3631.03	307.0
2013-08-22 21:00:00	NQ	Futures	3630.74	3634.83	3630.74	3634.25	648.0
2013-08-22 22:00:00	NQ	Futures	3634.25	3635.12	3632.78	3634.83	463.0
2013-08-22 23:00:00	NQ	Futures	3634.54	3635.12	3633.95	3634.25	306.0
2013-08-22 00:00:00	YM	Futures	15050.4	15060.5	15048.3	15059.5	379.0
2013-08-22 01:00:00	YM	Futures	15058.5	15060.5	15046.3	15055.4	506.0

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

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