PREVIEW / futures_1hour / 2013-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-09.parquet
  size:    49 KB
  rows:    1,544

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-09 00:00:00	ES	Futures	1707.96	1709.25	1707.44	1708.73	2957.0
2013-10-09 01:00:00	ES	Futures	1708.73	1709.25	1707.96	1708.47	4010.0
2013-10-09 02:00:00	ES	Futures	1708.21	1709.76	1707.96	1708.47	7259.0
2013-10-09 03:00:00	ES	Futures	1708.21	1709.25	1706.67	1707.7	20026.0
2013-10-09 04:00:00	ES	Futures	1707.7	1709.25	1706.41	1707.96	15375.0
2013-10-09 05:00:00	ES	Futures	1707.96	1711.05	1707.96	1708.21	18219.0
2013-10-09 06:00:00	ES	Futures	1708.21	1709.76	1707.96	1709.25	17425.0
2013-10-09 07:00:00	ES	Futures	1709.25	1710.54	1706.67	1706.67	27975.0
2013-10-09 08:00:00	ES	Futures	1706.67	1708.21	1704.34	1705.89	58121.0
2013-10-09 09:00:00	ES	Futures	1705.89	1707.7	1699.19	1703.57	299764.0
2013-10-09 10:00:00	ES	Futures	1703.83	1705.38	1696.61	1697.38	414612.0
2013-10-09 11:00:00	ES	Futures	1697.38	1699.96	1692.22	1698.93	369039.0
2013-10-09 12:00:00	ES	Futures	1699.19	1701.51	1697.12	1697.64	167887.0
2013-10-09 13:00:00	ES	Futures	1697.9	1707.44	1697.64	1706.15	324510.0
2013-10-09 14:00:00	ES	Futures	1705.89	1709.5	1703.83	1709.25	267649.0
2013-10-09 15:00:00	ES	Futures	1708.99	1709.5	1700.73	1703.05	291418.0
2013-10-09 16:00:00	ES	Futures	1703.31	1703.31	1700.22	1701.25	109758.0
2013-10-09 17:00:00	ES	Futures	1701.25	1701.51	1700.48	1700.48	1339.0
2013-10-09 18:00:00	ES	Futures	1700.99	1706.15	1700.48	1705.89	10543.0
2013-10-09 19:00:00	ES	Futures	1705.89	1706.41	1704.34	1704.6	3514.0
2013-10-09 20:00:00	ES	Futures	1704.34	1705.63	1704.09	1705.38	6110.0
2013-10-09 21:00:00	ES	Futures	1705.63	1707.18	1704.86	1706.67	6833.0
2013-10-09 22:00:00	ES	Futures	1706.67	1707.44	1705.38	1705.63	8368.0
2013-10-09 23:00:00	ES	Futures	1705.63	1708.47	1705.63	1707.96	6954.0
2013-10-09 00:00:00	NQ	Futures	3669.61	3671.36	3667.87	3670.2	813.0
2013-10-09 01:00:00	NQ	Futures	3670.2	3670.78	3667.58	3668.16	706.0
2013-10-09 02:00:00	NQ	Futures	3668.16	3671.07	3667.0	3667.87	1618.0
2013-10-09 03:00:00	NQ	Futures	3667.58	3671.07	3664.1	3669.91	3220.0
2013-10-09 04:00:00	NQ	Futures	3669.61	3673.68	3667.29	3671.94	2493.0
2013-10-09 05:00:00	NQ	Futures	3672.23	3675.71	3671.07	3671.07	2574.0
2013-10-09 06:00:00	NQ	Futures	3671.07	3674.55	3669.32	3672.23	1805.0
2013-10-09 07:00:00	NQ	Futures	3672.52	3674.84	3667.0	3667.87	2491.0
2013-10-09 08:00:00	NQ	Futures	3667.87	3671.07	3663.52	3667.0	5441.0
2013-10-09 09:00:00	NQ	Futures	3667.0	3669.61	3636.8	3647.83	62219.0
2013-10-09 10:00:00	NQ	Futures	3647.83	3653.64	3630.41	3631.86	77564.0
2013-10-09 11:00:00	NQ	Futures	3631.57	3635.63	3613.85	3625.18	65610.0
2013-10-09 12:00:00	NQ	Futures	3625.18	3633.6	3618.21	3621.98	34329.0
2013-10-09 13:00:00	NQ	Futures	3621.69	3650.45	3621.69	3646.09	52925.0
2013-10-09 14:00:00	NQ	Futures	3645.8	3656.84	3639.41	3655.67	57231.0
2013-10-09 15:00:00	NQ	Futures	3655.96	3658.29	3637.96	3642.31	52227.0
2013-10-09 16:00:00	NQ	Futures	3642.6	3644.35	3638.54	3640.28	9838.0
2013-10-09 17:00:00	NQ	Futures	3640.57	3641.15	3639.99	3639.99	99.0
2013-10-09 18:00:00	NQ	Futures	3639.41	3649.28	3639.41	3648.7	903.0
2013-10-09 19:00:00	NQ	Futures	3648.99	3649.57	3644.35	3644.93	493.0
2013-10-09 20:00:00	NQ	Futures	3644.64	3647.83	3643.77	3646.67	1042.0
2013-10-09 21:00:00	NQ	Futures	3646.67	3649.57	3645.22	3648.41	1247.0
2013-10-09 22:00:00	NQ	Futures	3648.41	3649.57	3645.51	3646.09	803.0
2013-10-09 23:00:00	NQ	Futures	3646.09	3651.03	3646.09	3650.45	1205.0
2013-10-09 00:00:00	YM	Futures	15060.3	15069.5	15057.3	15065.4	286.0
2013-10-09 01:00:00	YM	Futures	15066.5	15068.5	15060.3	15063.4	558.0

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

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