PREVIEW / futures_1hour / 2013-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-18.parquet
  size:    33 KB
  rows:    1,017

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-02-18 00:00:00	ES	Futures	1557.76	1558.28	1557.25	1557.76	2097.0
2013-02-18 01:00:00	ES	Futures	1557.51	1559.05	1557.51	1558.79	2297.0
2013-02-18 02:00:00	ES	Futures	1558.79	1558.79	1557.76	1558.02	4414.0
2013-02-18 03:00:00	ES	Futures	1557.76	1558.53	1555.97	1558.53	17630.0
2013-02-18 04:00:00	ES	Futures	1558.28	1559.05	1556.22	1556.22	15284.0
2013-02-18 05:00:00	ES	Futures	1556.48	1558.02	1556.22	1557.25	7318.0
2013-02-18 06:00:00	ES	Futures	1557.25	1557.76	1556.22	1557.51	6457.0
2013-02-18 07:00:00	ES	Futures	1557.25	1558.02	1556.99	1557.25	6799.0
2013-02-18 08:00:00	ES	Futures	1557.25	1557.51	1555.97	1557.51	8858.0
2013-02-18 09:00:00	ES	Futures	1557.51	1557.76	1556.22	1556.74	10049.0
2013-02-18 10:00:00	ES	Futures	1556.99	1557.51	1556.74	1556.99	5933.0
2013-02-18 11:00:00	ES	Futures	1556.99	1558.28	1556.99	1558.28	5520.0
2013-02-18 18:00:00	ES	Futures	1558.02	1558.02	1556.48	1556.74	2864.0
2013-02-18 19:00:00	ES	Futures	1556.99	1557.25	1555.97	1556.74	3989.0
2013-02-18 20:00:00	ES	Futures	1556.99	1557.76	1556.74	1557.51	1698.0
2013-02-18 21:00:00	ES	Futures	1557.51	1558.02	1557.25	1558.02	2887.0
2013-02-18 22:00:00	ES	Futures	1557.76	1558.02	1556.99	1557.51	2359.0
2013-02-18 23:00:00	ES	Futures	1557.51	1558.02	1557.51	1557.76	1466.0
2013-02-18 00:00:00	NQ	Futures	3216.02	3216.9	3215.44	3216.02	122.0
2013-02-18 01:00:00	NQ	Futures	3215.73	3217.48	3215.73	3216.6	143.0
2013-02-18 02:00:00	NQ	Futures	3216.9	3217.48	3215.44	3215.44	273.0
2013-02-18 03:00:00	NQ	Futures	3215.44	3216.31	3212.53	3216.02	996.0
2013-02-18 04:00:00	NQ	Futures	3216.02	3217.19	3212.53	3212.82	943.0
2013-02-18 05:00:00	NQ	Futures	3212.82	3215.44	3212.53	3213.4	481.0
2013-02-18 06:00:00	NQ	Futures	3213.69	3215.44	3212.82	3213.98	538.0
2013-02-18 07:00:00	NQ	Futures	3213.69	3215.44	3213.11	3213.4	468.0
2013-02-18 08:00:00	NQ	Futures	3213.4	3215.15	3211.95	3214.86	505.0
2013-02-18 09:00:00	NQ	Futures	3215.15	3217.77	3214.86	3215.73	1227.0
2013-02-18 10:00:00	NQ	Futures	3216.02	3218.06	3215.44	3217.77	638.0
2013-02-18 11:00:00	NQ	Futures	3218.06	3219.22	3216.9	3218.93	483.0
2013-02-18 18:00:00	NQ	Futures	3217.77	3218.64	3215.44	3216.31	228.0
2013-02-18 19:00:00	NQ	Futures	3216.31	3216.9	3214.86	3216.02	266.0
2013-02-18 20:00:00	NQ	Futures	3216.02	3218.06	3215.73	3217.48	133.0
2013-02-18 21:00:00	NQ	Futures	3217.19	3218.06	3216.6	3217.48	167.0
2013-02-18 22:00:00	NQ	Futures	3217.48	3218.06	3216.02	3217.19	122.0
2013-02-18 23:00:00	NQ	Futures	3216.6	3217.19	3216.6	3216.9	40.0
2013-02-18 00:00:00	YM	Futures	14036.1	14041.1	14033.0	14036.1	183.0
2013-02-18 01:00:00	YM	Futures	14036.1	14044.1	14035.1	14043.1	202.0
2013-02-18 02:00:00	YM	Futures	14043.1	14045.1	14038.1	14041.1	513.0
2013-02-18 03:00:00	YM	Futures	14041.1	14043.1	14026.0	14040.1	1251.0
2013-02-18 04:00:00	YM	Futures	14041.1	14046.1	14029.0	14031.0	917.0
2013-02-18 05:00:00	YM	Futures	14030.0	14040.1	14029.0	14032.0	703.0
2013-02-18 06:00:00	YM	Futures	14033.0	14035.1	14026.0	14032.0	720.0
2013-02-18 07:00:00	YM	Futures	14032.0	14039.1	14031.0	14033.0	365.0
2013-02-18 08:00:00	YM	Futures	14034.0	14036.1	14025.0	14031.0	682.0
2013-02-18 09:00:00	YM	Futures	14032.0	14036.1	14027.0	14029.0	767.0
2013-02-18 10:00:00	YM	Futures	14029.0	14034.0	14028.0	14032.0	380.0
2013-02-18 11:00:00	YM	Futures	14033.0	14041.1	14032.0	14038.1	316.0
2013-02-18 18:00:00	YM	Futures	14038.1	14038.1	14029.0	14030.0	139.0
2013-02-18 19:00:00	YM	Futures	14030.0	14033.0	14026.0	14031.0	348.0

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

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