PREVIEW / futures_1hour / 2013-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-28.parquet
  size:    44 KB
  rows:    1,263

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-28 00:00:00	ES	Futures	1663.67	1665.48	1662.64	1665.22	4307.0
2013-06-28 01:00:00	ES	Futures	1664.97	1665.74	1663.93	1664.97	5411.0
2013-06-28 02:00:00	ES	Futures	1664.97	1666.52	1663.16	1666.52	10572.0
2013-06-28 03:00:00	ES	Futures	1666.26	1669.36	1665.48	1668.07	29408.0
2013-06-28 04:00:00	ES	Futures	1667.81	1668.07	1664.97	1666.0	15516.0
2013-06-28 05:00:00	ES	Futures	1666.26	1668.58	1665.22	1666.77	15092.0
2013-06-28 06:00:00	ES	Futures	1666.77	1667.03	1663.16	1664.19	16973.0
2013-06-28 07:00:00	ES	Futures	1664.19	1667.29	1662.9	1666.77	26024.0
2013-06-28 08:00:00	ES	Futures	1666.77	1666.77	1658.24	1660.05	70529.0
2013-06-28 09:00:00	ES	Futures	1660.05	1660.05	1649.71	1649.97	254843.0
2013-06-28 10:00:00	ES	Futures	1649.97	1660.83	1648.42	1659.54	318216.0
2013-06-28 11:00:00	ES	Futures	1659.54	1664.45	1658.24	1661.6	288727.0
2013-06-28 12:00:00	ES	Futures	1661.6	1661.86	1654.88	1658.76	150692.0
2013-06-28 13:00:00	ES	Futures	1659.02	1663.16	1657.47	1662.38	123671.0
2013-06-28 14:00:00	ES	Futures	1662.38	1664.45	1660.05	1661.35	114701.0
2013-06-28 15:00:00	ES	Futures	1661.35	1664.19	1651.26	1651.78	457123.0
2013-06-28 16:00:00	ES	Futures	1651.52	1655.14	1648.68	1651.26	204606.0
2013-06-28 17:00:00	ES	Futures	1651.26	1653.07	1649.97	1650.49	8563.0
2013-06-28 00:00:00	NQ	Futures	3394.61	3397.83	3393.15	3397.83	501.0
2013-06-28 01:00:00	NQ	Futures	3397.83	3399.87	3395.49	3397.24	516.0
2013-06-28 02:00:00	NQ	Futures	3396.95	3399.58	3394.9	3399.58	550.0
2013-06-28 03:00:00	NQ	Futures	3399.58	3405.13	3397.53	3403.96	3629.0
2013-06-28 04:00:00	NQ	Futures	3403.67	3403.67	3399.29	3401.04	1858.0
2013-06-28 05:00:00	NQ	Futures	3401.33	3403.67	3398.7	3400.16	1673.0
2013-06-28 06:00:00	NQ	Futures	3400.16	3400.46	3392.27	3394.03	1814.0
2013-06-28 07:00:00	NQ	Futures	3394.03	3399.87	3391.69	3399.58	1844.0
2013-06-28 08:00:00	NQ	Futures	3399.0	3399.0	3382.34	3385.84	8847.0
2013-06-28 09:00:00	NQ	Futures	3385.84	3390.81	3375.32	3376.49	37338.0
2013-06-28 10:00:00	NQ	Futures	3376.79	3399.0	3371.53	3397.24	40332.0
2013-06-28 11:00:00	NQ	Futures	3397.24	3407.18	3393.74	3399.0	33897.0
2013-06-28 12:00:00	NQ	Futures	3399.0	3399.58	3387.31	3395.49	17324.0
2013-06-28 13:00:00	NQ	Futures	3395.2	3408.64	3393.15	3407.18	13768.0
2013-06-28 14:00:00	NQ	Futures	3407.18	3413.61	3403.67	3405.72	18103.0
2013-06-28 15:00:00	NQ	Futures	3405.42	3415.65	3392.27	3392.27	43178.0
2013-06-28 16:00:00	NQ	Futures	3392.57	3395.78	3389.35	3390.81	11415.0
2013-06-28 17:00:00	NQ	Futures	3390.81	3392.57	3388.77	3388.77	272.0
2013-06-28 00:00:00	YM	Futures	15193.6	15206.8	15186.5	15205.8	456.0
2013-06-28 01:00:00	YM	Futures	15206.8	15212.9	15197.6	15204.7	665.0
2013-06-28 02:00:00	YM	Futures	15203.7	15212.9	15194.6	15212.9	1020.0
2013-06-28 03:00:00	YM	Futures	15213.9	15237.3	15206.8	15228.1	3132.0
2013-06-28 04:00:00	YM	Futures	15229.1	15229.1	15202.7	15210.8	1372.0
2013-06-28 05:00:00	YM	Futures	15211.9	15229.1	15202.7	15214.9	1285.0
2013-06-28 06:00:00	YM	Futures	15213.9	15216.9	15189.5	15194.6	1110.0
2013-06-28 07:00:00	YM	Futures	15194.6	15212.9	15185.5	15207.8	1634.0
2013-06-28 08:00:00	YM	Futures	15207.8	15208.8	15142.8	15150.9	5694.0
2013-06-28 09:00:00	YM	Futures	15150.9	15151.9	15058.5	15060.5	24057.0
2013-06-28 10:00:00	YM	Futures	15061.5	15146.9	15039.2	15139.7	30923.0
2013-06-28 11:00:00	YM	Futures	15139.7	15197.6	15136.7	15166.2	27485.0
2013-06-28 12:00:00	YM	Futures	15166.2	15169.2	15100.1	15126.5	16989.0
2013-06-28 13:00:00	YM	Futures	15126.5	15156.0	15110.3	15150.9	12129.0

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

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