PREVIEW / futures_1hour / 2013-08-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1746.13	1746.65	1745.62	1746.13	3004.0
2013-08-13 01:00:00	ES	Futures	1746.13	1747.17	1746.13	1746.13	3803.0
2013-08-13 02:00:00	ES	Futures	1746.13	1747.42	1746.13	1746.91	6695.0
2013-08-13 03:00:00	ES	Futures	1746.91	1749.49	1746.13	1747.94	24788.0
2013-08-13 04:00:00	ES	Futures	1747.94	1751.04	1747.94	1751.04	18112.0
2013-08-13 05:00:00	ES	Futures	1750.79	1751.56	1749.49	1750.01	15628.0
2013-08-13 06:00:00	ES	Futures	1750.01	1750.79	1748.72	1748.98	13585.0
2013-08-13 07:00:00	ES	Futures	1748.98	1749.23	1747.68	1748.46	18655.0
2013-08-13 08:00:00	ES	Futures	1748.46	1749.23	1745.62	1747.17	45961.0
2013-08-13 09:00:00	ES	Futures	1747.42	1748.46	1742.26	1743.81	233410.0
2013-08-13 10:00:00	ES	Futures	1743.55	1743.81	1736.31	1738.64	337537.0
2013-08-13 11:00:00	ES	Futures	1738.64	1743.29	1738.12	1741.74	168005.0
2013-08-13 12:00:00	ES	Futures	1741.74	1749.23	1740.96	1748.2	172533.0
2013-08-13 13:00:00	ES	Futures	1748.2	1752.08	1747.42	1749.23	160934.0
2013-08-13 14:00:00	ES	Futures	1749.23	1750.79	1747.68	1749.49	115845.0
2013-08-13 15:00:00	ES	Futures	1749.49	1751.3	1747.94	1748.72	170639.0
2013-08-13 16:00:00	ES	Futures	1748.72	1750.01	1747.94	1748.2	73045.0
2013-08-13 17:00:00	ES	Futures	1748.2	1748.46	1747.94	1748.2	1437.0
2013-08-13 18:00:00	ES	Futures	1748.98	1750.01	1748.2	1749.75	4100.0
2013-08-13 19:00:00	ES	Futures	1749.75	1750.01	1748.2	1748.2	1661.0
2013-08-13 20:00:00	ES	Futures	1748.2	1748.46	1746.65	1747.94	7916.0
2013-08-13 21:00:00	ES	Futures	1747.68	1747.94	1746.65	1746.65	5312.0
2013-08-13 22:00:00	ES	Futures	1746.65	1746.91	1745.87	1746.39	4841.0
2013-08-13 23:00:00	ES	Futures	1746.39	1746.39	1745.36	1745.62	3800.0
2013-08-13 00:00:00	NQ	Futures	3656.16	3657.33	3655.87	3656.75	434.0
2013-08-13 01:00:00	NQ	Futures	3657.04	3658.21	3656.16	3657.33	335.0
2013-08-13 02:00:00	NQ	Futures	3657.33	3660.25	3657.33	3659.67	840.0
2013-08-13 03:00:00	NQ	Futures	3659.09	3665.51	3656.46	3662.3	4000.0
2013-08-13 04:00:00	NQ	Futures	3662.3	3665.51	3662.01	3665.22	2375.0
2013-08-13 05:00:00	NQ	Futures	3665.22	3667.56	3663.76	3664.35	2373.0
2013-08-13 06:00:00	NQ	Futures	3664.35	3665.51	3661.42	3661.42	1716.0
2013-08-13 07:00:00	NQ	Futures	3661.72	3661.72	3659.09	3660.25	1646.0
2013-08-13 08:00:00	NQ	Futures	3659.96	3660.55	3654.41	3656.46	3866.0
2013-08-13 09:00:00	NQ	Futures	3656.75	3661.13	3645.06	3649.73	34757.0
2013-08-13 10:00:00	NQ	Futures	3649.44	3649.73	3629.28	3639.51	48419.0
2013-08-13 11:00:00	NQ	Futures	3639.51	3652.36	3638.04	3647.69	21085.0
2013-08-13 12:00:00	NQ	Futures	3647.69	3664.05	3644.47	3659.96	22570.0
2013-08-13 13:00:00	NQ	Futures	3659.96	3670.19	3659.09	3663.76	21424.0
2013-08-13 14:00:00	NQ	Futures	3664.05	3675.45	3662.88	3672.82	26190.0
2013-08-13 15:00:00	NQ	Futures	3673.11	3679.83	3669.02	3670.77	38391.0
2013-08-13 16:00:00	NQ	Futures	3670.48	3671.94	3667.56	3668.73	6416.0
2013-08-13 17:00:00	NQ	Futures	3668.44	3668.44	3668.14	3668.14	364.0
2013-08-13 18:00:00	NQ	Futures	3669.02	3672.53	3668.73	3671.65	453.0
2013-08-13 19:00:00	NQ	Futures	3671.65	3672.24	3668.73	3669.31	468.0
2013-08-13 20:00:00	NQ	Futures	3669.02	3669.31	3666.98	3668.44	744.0
2013-08-13 21:00:00	NQ	Futures	3668.14	3668.14	3665.81	3666.68	554.0
2013-08-13 22:00:00	NQ	Futures	3666.68	3666.68	3664.93	3665.51	317.0
2013-08-13 23:00:00	NQ	Futures	3665.22	3666.1	3664.93	3665.51	358.0
2013-08-13 00:00:00	YM	Futures	15639.5	15648.6	15639.5	15647.6	459.0
2013-08-13 01:00:00	YM	Futures	15648.6	15655.7	15644.5	15653.7	755.0

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

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