PREVIEW / futures_1hour / 2013-02-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	1558.02	1558.53	1556.48	1558.02	7212.0
2013-02-28 01:00:00	ES	Futures	1558.02	1558.53	1556.99	1556.99	4060.0
2013-02-28 02:00:00	ES	Futures	1557.25	1557.51	1555.71	1556.48	11206.0
2013-02-28 03:00:00	ES	Futures	1556.48	1558.79	1555.71	1558.28	27637.0
2013-02-28 04:00:00	ES	Futures	1558.28	1558.28	1555.46	1557.25	28330.0
2013-02-28 05:00:00	ES	Futures	1557.25	1558.02	1555.97	1556.99	20926.0
2013-02-28 06:00:00	ES	Futures	1556.99	1559.3	1556.48	1558.79	26413.0
2013-02-28 07:00:00	ES	Futures	1558.53	1559.3	1556.74	1557.25	32092.0
2013-02-28 08:00:00	ES	Futures	1557.51	1557.51	1554.94	1556.74	56731.0
2013-02-28 09:00:00	ES	Futures	1556.48	1560.59	1553.15	1558.02	327782.0
2013-02-28 10:00:00	ES	Futures	1558.28	1559.05	1553.4	1554.94	351859.0
2013-02-28 11:00:00	ES	Futures	1554.94	1558.79	1553.92	1557.25	208902.0
2013-02-28 12:00:00	ES	Futures	1557.25	1559.82	1556.48	1558.53	92309.0
2013-02-28 13:00:00	ES	Futures	1558.53	1563.41	1558.53	1562.9	196898.0
2013-02-28 14:00:00	ES	Futures	1562.64	1564.69	1560.33	1560.84	171680.0
2013-02-28 15:00:00	ES	Futures	1560.59	1561.1	1551.35	1551.61	375026.0
2013-02-28 16:00:00	ES	Futures	1551.61	1552.89	1548.53	1548.78	199052.0
2013-02-28 17:00:00	ES	Futures	1549.04	1552.63	1548.78	1552.12	8712.0
2013-02-28 18:00:00	ES	Futures	1552.38	1552.63	1546.99	1548.53	18592.0
2013-02-28 19:00:00	ES	Futures	1548.53	1551.09	1548.53	1548.78	8329.0
2013-02-28 20:00:00	ES	Futures	1549.04	1549.55	1548.27	1549.55	6004.0
2013-02-28 21:00:00	ES	Futures	1549.55	1550.58	1549.3	1550.07	2644.0
2013-02-28 22:00:00	ES	Futures	1549.81	1551.09	1549.55	1550.84	3767.0
2013-02-28 23:00:00	ES	Futures	1551.09	1551.86	1550.84	1551.09	2949.0
2013-02-28 00:00:00	NQ	Futures	3195.65	3196.81	3193.32	3196.23	411.0
2013-02-28 01:00:00	NQ	Futures	3196.23	3196.81	3194.48	3195.07	499.0
2013-02-28 02:00:00	NQ	Futures	3195.07	3196.23	3193.03	3194.77	1296.0
2013-02-28 03:00:00	NQ	Futures	3194.77	3198.85	3193.32	3197.1	2110.0
2013-02-28 04:00:00	NQ	Futures	3197.1	3197.68	3190.99	3195.36	1995.0
2013-02-28 05:00:00	NQ	Futures	3195.07	3196.81	3193.03	3195.07	1105.0
2013-02-28 06:00:00	NQ	Futures	3195.07	3197.98	3194.19	3197.1	2091.0
2013-02-28 07:00:00	NQ	Futures	3196.81	3198.27	3193.61	3194.19	3008.0
2013-02-28 08:00:00	NQ	Futures	3194.19	3196.81	3191.28	3196.23	4971.0
2013-02-28 09:00:00	NQ	Futures	3196.23	3209.91	3190.12	3204.96	39046.0
2013-02-28 10:00:00	NQ	Futures	3204.96	3212.53	3195.07	3198.27	65944.0
2013-02-28 11:00:00	NQ	Futures	3198.27	3205.83	3196.23	3201.47	23174.0
2013-02-28 12:00:00	NQ	Futures	3201.76	3206.42	3200.6	3203.22	9398.0
2013-02-28 13:00:00	NQ	Futures	3203.51	3212.53	3202.34	3210.49	16568.0
2013-02-28 14:00:00	NQ	Futures	3210.49	3215.15	3204.38	3205.54	20967.0
2013-02-28 15:00:00	NQ	Futures	3205.83	3206.13	3186.04	3186.92	41189.0
2013-02-28 16:00:00	NQ	Futures	3186.62	3189.24	3181.39	3182.26	11405.0
2013-02-28 17:00:00	NQ	Futures	3181.97	3188.66	3181.68	3188.66	347.0
2013-02-28 18:00:00	NQ	Futures	3187.79	3189.53	3177.6	3180.22	1050.0
2013-02-28 19:00:00	NQ	Futures	3180.8	3184.88	3180.22	3180.8	826.0
2013-02-28 20:00:00	NQ	Futures	3181.09	3181.97	3179.93	3181.97	474.0
2013-02-28 21:00:00	NQ	Futures	3182.26	3184.3	3181.68	3183.42	173.0
2013-02-28 22:00:00	NQ	Futures	3183.42	3186.04	3183.13	3185.75	244.0
2013-02-28 23:00:00	NQ	Futures	3186.04	3189.53	3185.46	3188.08	1023.0
2013-02-28 00:00:00	YM	Futures	14160.8	14167.8	14151.8	14164.8	619.0
2013-02-28 01:00:00	YM	Futures	14164.8	14167.8	14155.8	14156.8	302.0

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

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