PREVIEW / futures_1hour / 2013-06-27

all futures 1-hour files

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

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-06-27 00:00:00	ES	Futures	1650.23	1652.82	1650.23	1652.82	2783.0
2013-06-27 01:00:00	ES	Futures	1652.82	1653.33	1651.26	1652.82	3875.0
2013-06-27 02:00:00	ES	Futures	1652.82	1654.37	1650.75	1650.75	7374.0
2013-06-27 03:00:00	ES	Futures	1651.01	1653.07	1649.71	1652.04	20801.0
2013-06-27 04:00:00	ES	Futures	1651.78	1653.33	1650.49	1651.52	14365.0
2013-06-27 05:00:00	ES	Futures	1651.52	1653.85	1650.49	1653.59	11893.0
2013-06-27 06:00:00	ES	Futures	1653.59	1654.37	1652.3	1652.56	11554.0
2013-06-27 07:00:00	ES	Futures	1652.56	1659.28	1652.04	1657.47	41649.0
2013-06-27 08:00:00	ES	Futures	1657.47	1661.09	1656.95	1660.05	50685.0
2013-06-27 09:00:00	ES	Futures	1660.05	1666.26	1659.54	1665.22	218914.0
2013-06-27 10:00:00	ES	Futures	1665.48	1669.1	1661.86	1666.26	318808.0
2013-06-27 11:00:00	ES	Futures	1666.26	1668.84	1662.64	1665.48	167541.0
2013-06-27 12:00:00	ES	Futures	1665.48	1666.0	1659.8	1663.16	151778.0
2013-06-27 13:00:00	ES	Futures	1663.16	1667.29	1662.12	1663.41	123229.0
2013-06-27 14:00:00	ES	Futures	1663.16	1665.48	1661.35	1662.9	138153.0
2013-06-27 15:00:00	ES	Futures	1662.64	1664.71	1660.83	1661.6	183119.0
2013-06-27 16:00:00	ES	Futures	1661.6	1662.12	1660.57	1661.09	81851.0
2013-06-27 17:00:00	ES	Futures	1661.09	1661.86	1660.57	1661.09	2008.0
2013-06-27 18:00:00	ES	Futures	1660.83	1662.64	1660.05	1661.35	4049.0
2013-06-27 19:00:00	ES	Futures	1661.35	1662.12	1660.05	1660.31	1851.0
2013-06-27 20:00:00	ES	Futures	1660.31	1661.6	1660.05	1660.57	4061.0
2013-06-27 21:00:00	ES	Futures	1660.31	1662.12	1660.31	1661.6	4067.0
2013-06-27 22:00:00	ES	Futures	1661.86	1665.74	1661.6	1664.45	8766.0
2013-06-27 23:00:00	ES	Futures	1664.45	1664.71	1662.9	1663.67	3786.0
2013-06-27 00:00:00	NQ	Futures	3371.53	3376.79	3371.53	3376.2	307.0
2013-06-27 01:00:00	NQ	Futures	3376.79	3377.66	3373.57	3377.08	385.0
2013-06-27 02:00:00	NQ	Futures	3377.08	3379.12	3373.57	3373.57	491.0
2013-06-27 03:00:00	NQ	Futures	3373.28	3377.66	3369.19	3373.86	2852.0
2013-06-27 04:00:00	NQ	Futures	3374.16	3377.66	3372.4	3374.45	2213.0
2013-06-27 05:00:00	NQ	Futures	3374.16	3378.54	3370.94	3377.95	2005.0
2013-06-27 06:00:00	NQ	Futures	3377.95	3378.54	3374.45	3374.74	1256.0
2013-06-27 07:00:00	NQ	Futures	3375.03	3388.18	3373.86	3385.55	3416.0
2013-06-27 08:00:00	NQ	Futures	3385.26	3391.69	3384.38	3387.89	4802.0
2013-06-27 09:00:00	NQ	Futures	3387.6	3404.55	3387.6	3403.38	27495.0
2013-06-27 10:00:00	NQ	Futures	3403.67	3411.27	3394.61	3405.42	31819.0
2013-06-27 11:00:00	NQ	Futures	3405.72	3409.52	3396.37	3402.21	18956.0
2013-06-27 12:00:00	NQ	Futures	3402.21	3402.5	3394.61	3397.24	15867.0
2013-06-27 13:00:00	NQ	Futures	3397.24	3403.67	3395.49	3396.95	12726.0
2013-06-27 14:00:00	NQ	Futures	3397.24	3397.53	3387.89	3391.1	18711.0
2013-06-27 15:00:00	NQ	Futures	3391.1	3396.66	3387.89	3390.23	22413.0
2013-06-27 16:00:00	NQ	Futures	3389.64	3392.27	3388.77	3389.94	4503.0
2013-06-27 17:00:00	NQ	Futures	3389.94	3391.69	3389.94	3390.52	66.0
2013-06-27 18:00:00	NQ	Futures	3388.77	3392.86	3388.18	3391.1	191.0
2013-06-27 19:00:00	NQ	Futures	3391.1	3391.4	3387.31	3388.47	237.0
2013-06-27 20:00:00	NQ	Futures	3388.47	3391.1	3388.18	3389.35	384.0
2013-06-27 21:00:00	NQ	Futures	3389.06	3392.86	3389.06	3391.98	352.0
2013-06-27 22:00:00	NQ	Futures	3391.98	3398.12	3391.98	3395.78	865.0
2013-06-27 23:00:00	NQ	Futures	3395.78	3396.37	3392.86	3394.32	330.0
2013-06-27 00:00:00	YM	Futures	15065.6	15084.9	15065.6	15083.9	565.0
2013-06-27 01:00:00	YM	Futures	15083.9	15091.0	15071.7	15086.9	712.0

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

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