PREVIEW / futures_1hour / 2013-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-05.parquet
  size:    47 KB
  rows:    1,460

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-05 00:00:00	ES	Futures	1759.83	1760.61	1759.83	1760.09	697.0
2013-08-05 01:00:00	ES	Futures	1760.09	1760.61	1759.57	1760.35	2240.0
2013-08-05 02:00:00	ES	Futures	1760.35	1761.13	1759.57	1760.61	4609.0
2013-08-05 03:00:00	ES	Futures	1760.61	1762.42	1760.35	1761.9	14054.0
2013-08-05 04:00:00	ES	Futures	1761.9	1762.68	1761.13	1761.9	11073.0
2013-08-05 05:00:00	ES	Futures	1761.64	1762.42	1761.13	1761.64	7269.0
2013-08-05 06:00:00	ES	Futures	1761.38	1761.64	1759.83	1760.61	8595.0
2013-08-05 07:00:00	ES	Futures	1760.61	1761.38	1760.09	1760.61	13538.0
2013-08-05 08:00:00	ES	Futures	1760.61	1760.87	1758.8	1759.06	24963.0
2013-08-05 09:00:00	ES	Futures	1759.32	1759.83	1756.47	1759.32	134226.0
2013-08-05 10:00:00	ES	Futures	1759.57	1762.93	1758.8	1761.64	150758.0
2013-08-05 11:00:00	ES	Futures	1761.38	1762.68	1759.83	1760.61	82576.0
2013-08-05 12:00:00	ES	Futures	1760.35	1761.64	1759.32	1759.83	69274.0
2013-08-05 13:00:00	ES	Futures	1759.83	1760.61	1757.25	1759.83	86544.0
2013-08-05 14:00:00	ES	Futures	1759.57	1760.09	1758.28	1759.83	58672.0
2013-08-05 15:00:00	ES	Futures	1759.83	1761.38	1758.8	1760.35	118065.0
2013-08-05 16:00:00	ES	Futures	1760.35	1761.13	1759.32	1759.83	53009.0
2013-08-05 17:00:00	ES	Futures	1759.83	1760.09	1759.32	1759.57	1511.0
2013-08-05 18:00:00	ES	Futures	1759.06	1759.32	1756.73	1757.51	6010.0
2013-08-05 19:00:00	ES	Futures	1757.51	1758.28	1757.25	1757.76	995.0
2013-08-05 20:00:00	ES	Futures	1758.02	1758.02	1755.96	1756.21	6674.0
2013-08-05 21:00:00	ES	Futures	1756.21	1756.47	1755.7	1755.96	4373.0
2013-08-05 22:00:00	ES	Futures	1756.21	1756.47	1755.18	1755.96	4425.0
2013-08-05 23:00:00	ES	Futures	1755.7	1757.25	1755.44	1756.99	3342.0
2013-08-05 00:00:00	NQ	Futures	3664.64	3665.51	3664.35	3664.64	152.0
2013-08-05 01:00:00	NQ	Futures	3664.93	3665.51	3663.76	3665.22	163.0
2013-08-05 02:00:00	NQ	Futures	3665.22	3666.39	3663.76	3665.51	500.0
2013-08-05 03:00:00	NQ	Futures	3665.22	3669.61	3665.22	3668.44	2454.0
2013-08-05 04:00:00	NQ	Futures	3668.73	3669.9	3667.27	3668.44	1919.0
2013-08-05 05:00:00	NQ	Futures	3668.44	3669.02	3667.27	3668.14	922.0
2013-08-05 06:00:00	NQ	Futures	3667.85	3668.44	3664.93	3666.68	1762.0
2013-08-05 07:00:00	NQ	Futures	3666.39	3668.14	3665.51	3666.39	1747.0
2013-08-05 08:00:00	NQ	Futures	3666.39	3666.98	3662.88	3663.47	2631.0
2013-08-05 09:00:00	NQ	Futures	3663.47	3664.64	3658.5	3663.76	15934.0
2013-08-05 10:00:00	NQ	Futures	3663.47	3670.77	3662.3	3668.44	20883.0
2013-08-05 11:00:00	NQ	Futures	3668.44	3669.31	3659.96	3662.3	15031.0
2013-08-05 12:00:00	NQ	Futures	3662.3	3665.81	3658.5	3662.3	9443.0
2013-08-05 13:00:00	NQ	Futures	3662.3	3666.98	3656.46	3664.64	10560.0
2013-08-05 14:00:00	NQ	Futures	3664.64	3664.64	3660.25	3662.3	8398.0
2013-08-05 15:00:00	NQ	Futures	3662.3	3668.14	3660.25	3667.56	16270.0
2013-08-05 16:00:00	NQ	Futures	3667.27	3668.14	3666.1	3666.39	3013.0
2013-08-05 17:00:00	NQ	Futures	3666.39	3666.68	3665.81	3666.68	176.0
2013-08-05 18:00:00	NQ	Futures	3665.81	3665.81	3659.38	3661.13	476.0
2013-08-05 19:00:00	NQ	Futures	3660.84	3664.05	3660.84	3663.76	270.0
2013-08-05 20:00:00	NQ	Futures	3663.47	3663.76	3659.38	3659.38	643.0
2013-08-05 21:00:00	NQ	Futures	3660.25	3660.84	3658.79	3659.96	575.0
2013-08-05 22:00:00	NQ	Futures	3660.25	3660.55	3658.21	3659.96	470.0
2013-08-05 23:00:00	NQ	Futures	3659.96	3661.72	3659.09	3661.42	678.0
2013-08-05 00:00:00	YM	Futures	15823.3	15825.3	15822.3	15825.3	55.0
2013-08-05 01:00:00	YM	Futures	15824.3	15825.3	15818.2	15824.3	238.0

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

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