PREVIEW / futures_1hour / 2013-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-27.parquet
  size:    51 KB
  rows:    1,564

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-27 00:00:00	ES	Futures	1531.08	1531.34	1530.31	1530.31	4461.0
2013-02-27 01:00:00	ES	Futures	1530.57	1531.34	1530.31	1530.31	4483.0
2013-02-27 02:00:00	ES	Futures	1530.31	1533.13	1530.31	1532.36	12003.0
2013-02-27 03:00:00	ES	Futures	1532.36	1533.39	1530.82	1531.85	35115.0
2013-02-27 04:00:00	ES	Futures	1531.85	1532.11	1529.28	1531.59	33039.0
2013-02-27 05:00:00	ES	Futures	1531.85	1533.9	1530.82	1531.85	41188.0
2013-02-27 06:00:00	ES	Futures	1531.85	1533.64	1531.34	1533.64	16725.0
2013-02-27 07:00:00	ES	Futures	1533.39	1536.47	1532.88	1535.95	37691.0
2013-02-27 08:00:00	ES	Futures	1535.7	1535.95	1531.34	1532.62	77762.0
2013-02-27 09:00:00	ES	Futures	1532.36	1540.06	1531.85	1538.78	323680.0
2013-02-27 10:00:00	ES	Futures	1538.78	1546.22	1538.26	1543.65	436980.0
2013-02-27 11:00:00	ES	Futures	1543.65	1549.04	1543.65	1547.76	302482.0
2013-02-27 12:00:00	ES	Futures	1548.01	1553.4	1547.5	1551.35	277937.0
2013-02-27 13:00:00	ES	Futures	1551.61	1552.89	1549.81	1551.61	133151.0
2013-02-27 14:00:00	ES	Futures	1551.86	1556.99	1551.35	1556.74	221742.0
2013-02-27 15:00:00	ES	Futures	1556.74	1559.3	1554.43	1554.94	335777.0
2013-02-27 16:00:00	ES	Futures	1554.69	1556.99	1554.43	1556.22	102507.0
2013-02-27 17:00:00	ES	Futures	1556.22	1556.48	1555.2	1556.48	4307.0
2013-02-27 18:00:00	ES	Futures	1556.22	1556.74	1554.94	1556.22	9001.0
2013-02-27 19:00:00	ES	Futures	1556.22	1556.74	1554.94	1556.22	8292.0
2013-02-27 20:00:00	ES	Futures	1556.22	1556.48	1555.46	1555.71	3884.0
2013-02-27 21:00:00	ES	Futures	1555.71	1556.74	1555.71	1556.48	3658.0
2013-02-27 22:00:00	ES	Futures	1556.48	1557.51	1555.97	1557.51	6502.0
2013-02-27 23:00:00	ES	Futures	1557.25	1558.28	1556.99	1558.02	5012.0
2013-02-27 00:00:00	NQ	Futures	3153.73	3153.73	3151.11	3151.4	221.0
2013-02-27 01:00:00	NQ	Futures	3151.4	3153.73	3151.11	3151.4	206.0
2013-02-27 02:00:00	NQ	Futures	3151.11	3156.64	3151.11	3155.19	729.0
2013-02-27 03:00:00	NQ	Futures	3154.9	3154.9	3150.82	3151.7	2627.0
2013-02-27 04:00:00	NQ	Futures	3151.7	3151.99	3147.33	3149.66	3182.0
2013-02-27 05:00:00	NQ	Futures	3149.95	3153.73	3147.91	3150.53	2897.0
2013-02-27 06:00:00	NQ	Futures	3150.24	3155.19	3149.37	3154.9	2146.0
2013-02-27 07:00:00	NQ	Futures	3154.9	3161.01	3154.32	3159.85	2849.0
2013-02-27 08:00:00	NQ	Futures	3159.85	3160.14	3153.73	3156.64	4558.0
2013-02-27 09:00:00	NQ	Futures	3156.64	3167.7	3154.32	3164.5	37741.0
2013-02-27 10:00:00	NQ	Futures	3164.5	3186.92	3160.72	3180.8	52463.0
2013-02-27 11:00:00	NQ	Futures	3180.8	3195.94	3180.51	3190.41	33622.0
2013-02-27 12:00:00	NQ	Futures	3190.41	3202.92	3188.37	3194.77	37627.0
2013-02-27 13:00:00	NQ	Futures	3195.07	3198.27	3187.5	3193.03	20341.0
2013-02-27 14:00:00	NQ	Futures	3193.32	3210.78	3192.15	3209.33	22814.0
2013-02-27 15:00:00	NQ	Futures	3209.62	3210.78	3190.41	3190.99	43645.0
2013-02-27 16:00:00	NQ	Futures	3190.7	3193.9	3187.79	3192.15	9398.0
2013-02-27 17:00:00	NQ	Futures	3191.86	3192.45	3189.83	3191.86	267.0
2013-02-27 18:00:00	NQ	Futures	3191.28	3192.45	3189.53	3191.86	439.0
2013-02-27 19:00:00	NQ	Futures	3191.86	3193.03	3190.12	3192.74	623.0
2013-02-27 20:00:00	NQ	Futures	3193.03	3193.03	3191.86	3191.86	265.0
2013-02-27 21:00:00	NQ	Futures	3191.57	3193.61	3191.57	3193.32	370.0
2013-02-27 22:00:00	NQ	Futures	3193.03	3195.07	3192.45	3194.48	415.0
2013-02-27 23:00:00	NQ	Futures	3194.19	3195.94	3194.19	3195.65	276.0
2013-02-27 00:00:00	YM	Futures	13945.5	13945.5	13936.5	13937.5	290.0
2013-02-27 01:00:00	YM	Futures	13937.5	13942.5	13935.5	13937.5	253.0

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

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