PREVIEW / futures_1hour / 2013-07-16

all futures 1-hour files

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

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-07-16 00:00:00	ES	Futures	1733.98	1734.5	1733.47	1734.24	1155.0
2013-07-16 01:00:00	ES	Futures	1734.24	1734.76	1733.72	1734.24	2274.0
2013-07-16 02:00:00	ES	Futures	1734.5	1735.53	1734.24	1735.53	3885.0
2013-07-16 03:00:00	ES	Futures	1735.53	1735.79	1732.43	1732.95	23231.0
2013-07-16 04:00:00	ES	Futures	1733.21	1733.98	1731.14	1733.72	13848.0
2013-07-16 05:00:00	ES	Futures	1733.72	1735.28	1732.95	1734.76	10542.0
2013-07-16 06:00:00	ES	Futures	1734.76	1735.79	1734.5	1734.76	11561.0
2013-07-16 07:00:00	ES	Futures	1734.76	1735.79	1733.21	1733.47	20615.0
2013-07-16 08:00:00	ES	Futures	1733.72	1735.02	1732.17	1734.5	33551.0
2013-07-16 09:00:00	ES	Futures	1734.5	1736.57	1731.4	1731.66	144969.0
2013-07-16 10:00:00	ES	Futures	1731.92	1734.5	1729.85	1729.85	158478.0
2013-07-16 11:00:00	ES	Futures	1729.85	1730.36	1724.68	1726.23	222797.0
2013-07-16 12:00:00	ES	Futures	1726.23	1728.04	1725.45	1726.23	79318.0
2013-07-16 13:00:00	ES	Futures	1725.97	1726.75	1723.13	1726.75	107001.0
2013-07-16 14:00:00	ES	Futures	1726.75	1729.33	1726.49	1727.0	90077.0
2013-07-16 15:00:00	ES	Futures	1726.75	1728.3	1724.42	1727.78	159976.0
2013-07-16 16:00:00	ES	Futures	1728.04	1729.33	1727.26	1728.81	71036.0
2013-07-16 17:00:00	ES	Futures	1728.55	1728.81	1728.3	1728.3	1088.0
2013-07-16 18:00:00	ES	Futures	1728.55	1729.59	1728.04	1728.55	3416.0
2013-07-16 19:00:00	ES	Futures	1728.55	1728.81	1728.04	1728.81	696.0
2013-07-16 20:00:00	ES	Futures	1728.81	1728.81	1728.04	1728.04	1865.0
2013-07-16 21:00:00	ES	Futures	1728.04	1728.55	1726.75	1727.0	3613.0
2013-07-16 22:00:00	ES	Futures	1727.0	1728.55	1726.75	1728.04	2850.0
2013-07-16 23:00:00	ES	Futures	1728.3	1729.07	1728.04	1728.81	1602.0
2013-07-16 00:00:00	NQ	Futures	3592.46	3594.79	3592.46	3594.5	226.0
2013-07-16 01:00:00	NQ	Futures	3594.21	3594.79	3593.33	3594.21	294.0
2013-07-16 02:00:00	NQ	Futures	3594.21	3596.25	3594.21	3595.96	525.0
2013-07-16 03:00:00	NQ	Futures	3595.67	3596.55	3591.29	3593.04	3030.0
2013-07-16 04:00:00	NQ	Futures	3592.75	3594.5	3590.41	3594.21	1849.0
2013-07-16 05:00:00	NQ	Futures	3593.92	3596.25	3593.04	3594.79	1417.0
2013-07-16 06:00:00	NQ	Futures	3594.79	3596.25	3593.92	3594.21	1344.0
2013-07-16 07:00:00	NQ	Futures	3594.21	3596.25	3593.62	3594.5	2402.0
2013-07-16 08:00:00	NQ	Futures	3594.21	3596.84	3592.75	3595.96	3603.0
2013-07-16 09:00:00	NQ	Futures	3595.96	3599.47	3592.75	3593.92	22275.0
2013-07-16 10:00:00	NQ	Futures	3594.21	3600.64	3590.99	3590.99	20311.0
2013-07-16 11:00:00	NQ	Futures	3590.99	3591.58	3581.93	3584.57	24904.0
2013-07-16 12:00:00	NQ	Futures	3584.27	3590.7	3583.4	3586.61	12325.0
2013-07-16 13:00:00	NQ	Futures	3586.9	3590.7	3581.64	3590.7	13678.0
2013-07-16 14:00:00	NQ	Futures	3590.41	3595.09	3586.61	3586.9	12615.0
2013-07-16 15:00:00	NQ	Futures	3586.9	3592.46	3581.35	3590.99	19089.0
2013-07-16 16:00:00	NQ	Futures	3590.99	3595.38	3590.41	3592.75	5690.0
2013-07-16 17:00:00	NQ	Futures	3592.16	3592.46	3591.87	3592.46	27.0
2013-07-16 18:00:00	NQ	Futures	3592.46	3592.75	3591.87	3592.46	67.0
2013-07-16 19:00:00	NQ	Futures	3592.46	3592.46	3590.99	3591.87	61.0
2013-07-16 20:00:00	NQ	Futures	3591.87	3592.75	3590.41	3590.41	374.0
2013-07-16 21:00:00	NQ	Futures	3590.41	3591.87	3589.53	3590.41	479.0
2013-07-16 22:00:00	NQ	Futures	3590.41	3594.21	3590.41	3593.33	365.0
2013-07-16 23:00:00	NQ	Futures	3593.33	3594.5	3593.04	3593.92	221.0
2013-07-16 00:00:00	YM	Futures	15655.7	15659.8	15653.7	15657.7	180.0
2013-07-16 01:00:00	YM	Futures	15658.8	15661.8	15656.7	15661.8	368.0

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

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