PREVIEW / futures_1hour / 2013-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-07.parquet
  size:    49 KB
  rows:    1,530

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-05-07 00:00:00	ES	Futures	1660.9	1660.9	1659.87	1660.39	3186.0
2013-05-07 01:00:00	ES	Futures	1660.65	1661.42	1660.39	1661.16	3658.0
2013-05-07 02:00:00	ES	Futures	1661.16	1661.68	1659.87	1660.39	7607.0
2013-05-07 03:00:00	ES	Futures	1660.39	1661.68	1659.87	1660.9	14765.0
2013-05-07 04:00:00	ES	Futures	1660.9	1662.45	1660.9	1662.19	11540.0
2013-05-07 05:00:00	ES	Futures	1662.19	1663.74	1661.68	1663.74	13422.0
2013-05-07 06:00:00	ES	Futures	1663.74	1665.03	1663.22	1664.25	24839.0
2013-05-07 07:00:00	ES	Futures	1664.51	1665.54	1663.99	1665.03	24642.0
2013-05-07 08:00:00	ES	Futures	1665.03	1666.06	1663.99	1664.25	46404.0
2013-05-07 09:00:00	ES	Futures	1664.25	1668.37	1663.99	1668.12	226732.0
2013-05-07 10:00:00	ES	Futures	1668.12	1668.63	1660.65	1664.51	352308.0
2013-05-07 11:00:00	ES	Futures	1664.77	1667.09	1664.25	1665.28	149825.0
2013-05-07 12:00:00	ES	Futures	1665.28	1669.15	1665.28	1668.63	117001.0
2013-05-07 13:00:00	ES	Futures	1668.63	1670.69	1668.12	1669.92	136952.0
2013-05-07 14:00:00	ES	Futures	1669.92	1670.95	1668.63	1670.69	117494.0
2013-05-07 15:00:00	ES	Futures	1670.69	1670.95	1669.4	1670.43	150394.0
2013-05-07 16:00:00	ES	Futures	1670.43	1670.95	1669.15	1670.18	65215.0
2013-05-07 17:00:00	ES	Futures	1670.43	1670.69	1669.92	1670.43	2390.0
2013-05-07 18:00:00	ES	Futures	1669.92	1669.92	1667.09	1667.86	10656.0
2013-05-07 19:00:00	ES	Futures	1667.6	1668.12	1667.34	1668.12	1691.0
2013-05-07 20:00:00	ES	Futures	1667.86	1668.37	1667.6	1668.37	1865.0
2013-05-07 21:00:00	ES	Futures	1668.12	1670.18	1668.12	1669.66	5161.0
2013-05-07 22:00:00	ES	Futures	1669.66	1670.18	1668.63	1669.4	3094.0
2013-05-07 23:00:00	ES	Futures	1669.4	1669.66	1669.15	1669.4	1627.0
2013-05-07 00:00:00	NQ	Futures	3437.89	3438.47	3436.43	3437.6	248.0
2013-05-07 01:00:00	NQ	Futures	3437.6	3439.64	3437.31	3439.35	253.0
2013-05-07 02:00:00	NQ	Futures	3439.64	3440.22	3437.02	3438.47	562.0
2013-05-07 03:00:00	NQ	Futures	3438.47	3441.68	3437.02	3440.52	1527.0
2013-05-07 04:00:00	NQ	Futures	3440.81	3441.97	3440.22	3441.39	1830.0
2013-05-07 05:00:00	NQ	Futures	3441.1	3446.35	3440.52	3446.35	1973.0
2013-05-07 06:00:00	NQ	Futures	3446.06	3447.52	3444.31	3445.47	2293.0
2013-05-07 07:00:00	NQ	Futures	3445.47	3446.93	3444.6	3446.35	2226.0
2013-05-07 08:00:00	NQ	Futures	3446.35	3447.52	3443.43	3444.31	4769.0
2013-05-07 09:00:00	NQ	Futures	3444.31	3449.56	3442.27	3448.39	25574.0
2013-05-07 10:00:00	NQ	Futures	3448.68	3449.56	3426.81	3433.52	48343.0
2013-05-07 11:00:00	NQ	Futures	3433.52	3441.1	3432.64	3435.56	18089.0
2013-05-07 12:00:00	NQ	Futures	3435.56	3442.56	3435.27	3442.27	15093.0
2013-05-07 13:00:00	NQ	Futures	3441.97	3444.02	3437.89	3443.14	14166.0
2013-05-07 14:00:00	NQ	Futures	3443.14	3444.89	3437.89	3442.27	12420.0
2013-05-07 15:00:00	NQ	Futures	3442.27	3443.14	3433.52	3437.89	19983.0
2013-05-07 16:00:00	NQ	Futures	3438.18	3440.52	3437.31	3438.77	4612.0
2013-05-07 17:00:00	NQ	Futures	3438.77	3439.64	3438.47	3439.35	62.0
2013-05-07 18:00:00	NQ	Futures	3437.89	3437.89	3433.52	3435.27	631.0
2013-05-07 19:00:00	NQ	Futures	3435.27	3436.14	3434.68	3435.85	183.0
2013-05-07 20:00:00	NQ	Futures	3435.85	3437.6	3435.56	3437.31	472.0
2013-05-07 21:00:00	NQ	Futures	3437.02	3440.81	3437.02	3440.22	767.0
2013-05-07 22:00:00	NQ	Futures	3440.22	3440.81	3437.6	3439.06	505.0
2013-05-07 23:00:00	NQ	Futures	3439.35	3439.93	3438.77	3439.64	271.0
2013-05-07 00:00:00	YM	Futures	15059.0	15061.1	15053.0	15058.0	376.0
2013-05-07 01:00:00	YM	Futures	15058.0	15064.1	15057.0	15061.1	478.0

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

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