PREVIEW / futures_1hour / 2013-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-16.parquet
  size:    50 KB
  rows:    1,543

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-10-16 00:00:00	ES	Futures	1755.16	1755.42	1753.36	1754.65	3718.0
2013-10-16 01:00:00	ES	Futures	1754.65	1755.42	1752.33	1753.61	7306.0
2013-10-16 02:00:00	ES	Futures	1753.61	1755.42	1753.36	1753.87	13496.0
2013-10-16 03:00:00	ES	Futures	1753.87	1755.42	1751.04	1753.61	23468.0
2013-10-16 04:00:00	ES	Futures	1753.36	1754.13	1752.07	1753.36	10132.0
2013-10-16 05:00:00	ES	Futures	1753.61	1754.39	1752.33	1753.36	7409.0
2013-10-16 06:00:00	ES	Futures	1753.1	1753.36	1750.78	1752.33	13270.0
2013-10-16 07:00:00	ES	Futures	1752.07	1754.13	1751.55	1752.07	22183.0
2013-10-16 08:00:00	ES	Futures	1752.33	1758.0	1752.07	1757.23	40584.0
2013-10-16 09:00:00	ES	Futures	1757.48	1768.06	1755.42	1766.25	339905.0
2013-10-16 10:00:00	ES	Futures	1766.25	1769.61	1762.64	1769.35	353773.0
2013-10-16 11:00:00	ES	Futures	1769.35	1771.67	1767.03	1769.35	221367.0
2013-10-16 12:00:00	ES	Futures	1769.35	1771.67	1766.25	1767.54	172821.0
2013-10-16 13:00:00	ES	Futures	1767.54	1770.38	1766.0	1767.54	87711.0
2013-10-16 14:00:00	ES	Futures	1767.8	1768.06	1764.45	1766.0	88920.0
2013-10-16 15:00:00	ES	Futures	1766.0	1771.41	1764.19	1770.64	193764.0
2013-10-16 16:00:00	ES	Futures	1770.64	1770.9	1766.51	1766.77	100126.0
2013-10-16 17:00:00	ES	Futures	1766.51	1767.54	1766.51	1767.29	3052.0
2013-10-16 18:00:00	ES	Futures	1766.51	1766.77	1765.22	1766.25	13039.0
2013-10-16 19:00:00	ES	Futures	1766.51	1769.87	1766.51	1768.83	9684.0
2013-10-16 20:00:00	ES	Futures	1768.83	1769.35	1768.06	1768.58	6929.0
2013-10-16 21:00:00	ES	Futures	1768.58	1769.35	1767.8	1767.8	4285.0
2013-10-16 22:00:00	ES	Futures	1767.8	1769.09	1764.45	1766.25	14360.0
2013-10-16 23:00:00	ES	Futures	1766.25	1767.54	1764.97	1767.03	4583.0
2013-10-16 00:00:00	NQ	Futures	3779.11	3779.4	3775.33	3778.24	584.0
2013-10-16 01:00:00	NQ	Futures	3777.95	3779.4	3773.3	3776.49	1052.0
2013-10-16 02:00:00	NQ	Futures	3776.49	3781.43	3776.2	3776.49	1429.0
2013-10-16 03:00:00	NQ	Futures	3776.49	3777.37	3769.81	3773.01	3213.0
2013-10-16 04:00:00	NQ	Futures	3772.72	3773.88	3769.81	3772.72	1835.0
2013-10-16 05:00:00	NQ	Futures	3772.43	3774.17	3767.78	3769.81	1503.0
2013-10-16 06:00:00	NQ	Futures	3769.52	3770.1	3766.62	3769.23	1751.0
2013-10-16 07:00:00	NQ	Futures	3768.94	3777.07	3768.36	3773.88	3638.0
2013-10-16 08:00:00	NQ	Futures	3773.88	3784.63	3773.3	3783.17	4687.0
2013-10-16 09:00:00	NQ	Futures	3783.46	3798.28	3776.49	3795.66	41907.0
2013-10-16 10:00:00	NQ	Futures	3795.66	3802.63	3789.56	3801.76	45670.0
2013-10-16 11:00:00	NQ	Futures	3801.47	3806.41	3797.99	3801.76	25232.0
2013-10-16 12:00:00	NQ	Futures	3801.76	3805.83	3797.99	3800.89	25000.0
2013-10-16 13:00:00	NQ	Futures	3800.89	3802.92	3797.11	3797.99	12760.0
2013-10-16 14:00:00	NQ	Futures	3797.7	3800.31	3793.92	3797.11	11817.0
2013-10-16 15:00:00	NQ	Futures	3796.82	3805.54	3793.34	3803.79	23306.0
2013-10-16 16:00:00	NQ	Futures	3803.79	3804.09	3789.27	3790.43	8423.0
2013-10-16 17:00:00	NQ	Futures	3791.02	3792.47	3791.02	3791.89	200.0
2013-10-16 18:00:00	NQ	Futures	3787.53	3791.02	3787.53	3790.14	1023.0
2013-10-16 19:00:00	NQ	Futures	3790.14	3797.11	3790.14	3795.37	811.0
2013-10-16 20:00:00	NQ	Futures	3795.95	3796.82	3793.92	3795.37	721.0
2013-10-16 21:00:00	NQ	Futures	3795.37	3797.11	3793.05	3794.21	599.0
2013-10-16 22:00:00	NQ	Futures	3793.92	3796.53	3787.53	3791.89	1357.0
2013-10-16 23:00:00	NQ	Futures	3791.6	3794.5	3789.27	3793.34	620.0
2013-10-16 00:00:00	YM	Futures	15483.1	15483.1	15469.9	15479.0	438.0
2013-10-16 01:00:00	YM	Futures	15477.0	15483.1	15457.6	15470.9	881.0

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

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