PREVIEW / futures_1hour / 2013-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-01.parquet
  size:    51 KB
  rows:    1,536

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-01 00:00:00	ES	Futures	1745.87	1746.39	1745.1	1746.13	2997.0
2013-08-01 01:00:00	ES	Futures	1746.13	1746.91	1745.62	1746.91	3038.0
2013-08-01 02:00:00	ES	Futures	1746.65	1747.68	1746.39	1746.91	8010.0
2013-08-01 03:00:00	ES	Futures	1746.91	1748.46	1745.87	1747.42	19652.0
2013-08-01 04:00:00	ES	Futures	1747.68	1747.94	1745.1	1747.68	11986.0
2013-08-01 05:00:00	ES	Futures	1747.94	1751.56	1747.68	1751.04	25358.0
2013-08-01 06:00:00	ES	Futures	1750.79	1751.04	1748.98	1749.49	17865.0
2013-08-01 07:00:00	ES	Futures	1749.49	1750.27	1748.72	1749.23	20169.0
2013-08-01 08:00:00	ES	Futures	1749.49	1752.08	1749.23	1750.27	48045.0
2013-08-01 09:00:00	ES	Futures	1750.27	1756.21	1749.49	1753.89	263608.0
2013-08-01 10:00:00	ES	Futures	1753.89	1758.54	1753.89	1755.18	289545.0
2013-08-01 11:00:00	ES	Futures	1755.44	1757.25	1754.15	1756.47	135013.0
2013-08-01 12:00:00	ES	Futures	1756.47	1758.54	1754.92	1756.73	91347.0
2013-08-01 13:00:00	ES	Futures	1756.73	1758.28	1755.7	1757.76	65350.0
2013-08-01 14:00:00	ES	Futures	1757.76	1760.35	1757.51	1759.32	127808.0
2013-08-01 15:00:00	ES	Futures	1759.32	1761.64	1756.47	1759.57	235992.0
2013-08-01 16:00:00	ES	Futures	1759.83	1760.61	1757.25	1760.35	112458.0
2013-08-01 17:00:00	ES	Futures	1760.09	1760.35	1759.83	1760.35	2155.0
2013-08-01 18:00:00	ES	Futures	1760.09	1760.35	1757.76	1758.8	6127.0
2013-08-01 19:00:00	ES	Futures	1758.8	1759.57	1758.28	1759.32	1668.0
2013-08-01 20:00:00	ES	Futures	1759.32	1759.83	1758.02	1759.32	3282.0
2013-08-01 21:00:00	ES	Futures	1759.57	1760.35	1759.06	1760.09	4007.0
2013-08-01 22:00:00	ES	Futures	1760.09	1760.35	1759.06	1759.57	1406.0
2013-08-01 23:00:00	ES	Futures	1759.57	1759.57	1758.54	1758.8	2966.0
2013-08-01 00:00:00	NQ	Futures	3618.46	3619.93	3617.3	3619.34	495.0
2013-08-01 01:00:00	NQ	Futures	3619.34	3620.22	3618.17	3620.22	447.0
2013-08-01 02:00:00	NQ	Futures	3619.93	3622.26	3619.93	3621.97	1146.0
2013-08-01 03:00:00	NQ	Futures	3621.68	3625.19	3620.22	3622.85	2737.0
2013-08-01 04:00:00	NQ	Futures	3622.85	3624.89	3619.05	3624.6	2484.0
2013-08-01 05:00:00	NQ	Futures	3624.31	3630.45	3624.02	3629.57	2693.0
2013-08-01 06:00:00	NQ	Futures	3629.28	3630.15	3625.48	3626.06	2078.0
2013-08-01 07:00:00	NQ	Futures	3626.06	3628.4	3625.19	3627.23	2932.0
2013-08-01 08:00:00	NQ	Futures	3627.23	3632.78	3626.94	3629.86	5071.0
2013-08-01 09:00:00	NQ	Futures	3629.57	3638.92	3627.82	3631.62	26991.0
2013-08-01 10:00:00	NQ	Futures	3631.62	3640.67	3631.32	3635.12	26529.0
2013-08-01 11:00:00	NQ	Futures	3635.12	3638.63	3632.2	3636.88	13058.0
2013-08-01 12:00:00	NQ	Futures	3636.58	3640.38	3633.08	3635.71	9608.0
2013-08-01 13:00:00	NQ	Futures	3635.71	3639.21	3633.37	3638.63	7415.0
2013-08-01 14:00:00	NQ	Futures	3638.34	3645.35	3637.46	3643.3	12509.0
2013-08-01 15:00:00	NQ	Futures	3643.6	3651.19	3639.8	3645.64	26129.0
2013-08-01 16:00:00	NQ	Futures	3645.93	3646.81	3640.67	3645.64	6854.0
2013-08-01 17:00:00	NQ	Futures	3645.64	3646.23	3645.35	3645.35	110.0
2013-08-01 18:00:00	NQ	Futures	3645.06	3646.23	3642.14	3642.72	385.0
2013-08-01 19:00:00	NQ	Futures	3642.72	3644.47	3642.14	3644.47	248.0
2013-08-01 20:00:00	NQ	Futures	3644.47	3645.64	3642.14	3644.77	547.0
2013-08-01 21:00:00	NQ	Futures	3645.06	3646.81	3644.77	3646.23	791.0
2013-08-01 22:00:00	NQ	Futures	3645.64	3646.23	3644.77	3645.64	258.0
2013-08-01 23:00:00	NQ	Futures	3645.35	3646.52	3644.18	3644.47	341.0
2013-08-01 00:00:00	YM	Futures	15744.1	15748.1	15739.0	15746.1	334.0
2013-08-01 01:00:00	YM	Futures	15747.1	15750.2	15742.0	15749.2	365.0

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

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