PREVIEW / futures_1hour / 2013-08-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1756.73	1757.51	1756.47	1757.25	2925.0
2013-08-06 01:00:00	ES	Futures	1757.25	1757.76	1756.47	1757.76	2870.0
2013-08-06 02:00:00	ES	Futures	1757.51	1758.8	1757.51	1758.28	4223.0
2013-08-06 03:00:00	ES	Futures	1758.28	1760.35	1757.76	1759.32	17392.0
2013-08-06 04:00:00	ES	Futures	1759.57	1760.61	1759.32	1760.09	8506.0
2013-08-06 05:00:00	ES	Futures	1759.83	1761.38	1759.06	1759.57	12467.0
2013-08-06 06:00:00	ES	Futures	1759.57	1759.57	1756.99	1756.99	14482.0
2013-08-06 07:00:00	ES	Futures	1757.25	1758.02	1756.47	1757.25	16017.0
2013-08-06 08:00:00	ES	Futures	1757.51	1758.8	1756.47	1757.51	20590.0
2013-08-06 09:00:00	ES	Futures	1757.51	1758.28	1753.11	1754.66	175645.0
2013-08-06 10:00:00	ES	Futures	1754.92	1754.92	1746.65	1746.65	341680.0
2013-08-06 11:00:00	ES	Futures	1746.91	1750.79	1746.13	1750.53	151032.0
2013-08-06 12:00:00	ES	Futures	1750.53	1752.34	1748.72	1752.34	77704.0
2013-08-06 13:00:00	ES	Futures	1752.34	1752.59	1749.49	1749.75	64011.0
2013-08-06 14:00:00	ES	Futures	1750.01	1751.3	1748.2	1750.01	96681.0
2013-08-06 15:00:00	ES	Futures	1750.01	1752.08	1748.98	1750.53	161351.0
2013-08-06 16:00:00	ES	Futures	1750.53	1752.08	1750.27	1751.04	74865.0
2013-08-06 17:00:00	ES	Futures	1751.04	1751.04	1750.01	1750.01	2382.0
2013-08-06 18:00:00	ES	Futures	1750.27	1751.04	1749.49	1749.75	3089.0
2013-08-06 19:00:00	ES	Futures	1749.75	1750.01	1748.72	1749.49	2082.0
2013-08-06 20:00:00	ES	Futures	1749.49	1749.75	1748.72	1748.98	3509.0
2013-08-06 21:00:00	ES	Futures	1748.72	1748.98	1746.91	1747.94	6628.0
2013-08-06 22:00:00	ES	Futures	1747.94	1748.72	1747.17	1748.2	3255.0
2013-08-06 23:00:00	ES	Futures	1748.2	1748.98	1747.68	1747.94	2262.0
2013-08-06 00:00:00	NQ	Futures	3661.72	3662.88	3660.84	3662.3	307.0
2013-08-06 01:00:00	NQ	Futures	3662.01	3662.01	3660.55	3662.01	234.0
2013-08-06 02:00:00	NQ	Futures	3662.01	3664.64	3661.72	3663.76	415.0
2013-08-06 03:00:00	NQ	Futures	3664.05	3668.14	3663.76	3667.27	2375.0
2013-08-06 04:00:00	NQ	Futures	3667.56	3669.02	3666.98	3668.14	972.0
2013-08-06 05:00:00	NQ	Futures	3667.85	3669.9	3665.51	3666.39	1864.0
2013-08-06 06:00:00	NQ	Futures	3666.68	3666.68	3662.59	3663.18	1969.0
2013-08-06 07:00:00	NQ	Futures	3663.47	3665.22	3662.59	3663.47	1749.0
2013-08-06 08:00:00	NQ	Futures	3663.47	3667.27	3662.01	3664.05	2728.0
2013-08-06 09:00:00	NQ	Futures	3664.05	3666.1	3653.24	3657.62	23430.0
2013-08-06 10:00:00	NQ	Futures	3657.62	3658.5	3633.08	3633.37	42183.0
2013-08-06 11:00:00	NQ	Futures	3633.37	3644.47	3631.03	3643.3	21531.0
2013-08-06 12:00:00	NQ	Futures	3643.3	3649.73	3642.43	3649.15	10536.0
2013-08-06 13:00:00	NQ	Futures	3649.15	3649.73	3641.55	3641.55	8169.0
2013-08-06 14:00:00	NQ	Futures	3641.84	3644.47	3636.0	3641.55	11872.0
2013-08-06 15:00:00	NQ	Futures	3641.55	3648.27	3641.55	3645.35	26248.0
2013-08-06 16:00:00	NQ	Futures	3645.64	3647.69	3644.18	3644.47	5180.0
2013-08-06 17:00:00	NQ	Futures	3644.47	3644.77	3643.89	3644.47	91.0
2013-08-06 18:00:00	NQ	Futures	3644.47	3646.52	3642.43	3642.72	335.0
2013-08-06 19:00:00	NQ	Futures	3643.01	3643.6	3641.55	3643.3	189.0
2013-08-06 20:00:00	NQ	Futures	3643.6	3643.6	3640.67	3641.84	593.0
2013-08-06 21:00:00	NQ	Futures	3641.55	3641.55	3638.04	3640.09	944.0
2013-08-06 22:00:00	NQ	Futures	3639.8	3642.14	3638.92	3640.97	554.0
2013-08-06 23:00:00	NQ	Futures	3641.55	3642.43	3640.67	3640.97	207.0
2013-08-06 00:00:00	YM	Futures	15772.5	15777.6	15769.5	15776.6	298.0
2013-08-06 01:00:00	YM	Futures	15775.6	15778.6	15769.5	15778.6	377.0

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

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