PREVIEW / futures_1hour / 2013-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-15.parquet
  size:    48 KB
  rows:    1,474

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-15 00:00:00	ES	Futures	1730.88	1731.4	1730.36	1731.4	1101.0
2013-07-15 01:00:00	ES	Futures	1731.14	1731.66	1730.62	1731.14	2470.0
2013-07-15 02:00:00	ES	Futures	1730.88	1731.14	1729.33	1729.33	3175.0
2013-07-15 03:00:00	ES	Futures	1729.33	1732.69	1729.07	1731.4	23010.0
2013-07-15 04:00:00	ES	Futures	1731.4	1732.17	1730.36	1730.62	10060.0
2013-07-15 05:00:00	ES	Futures	1730.36	1731.14	1728.55	1728.55	11235.0
2013-07-15 06:00:00	ES	Futures	1728.55	1730.11	1728.55	1729.33	8707.0
2013-07-15 07:00:00	ES	Futures	1729.33	1730.62	1728.81	1729.85	16678.0
2013-07-15 08:00:00	ES	Futures	1729.85	1731.92	1729.59	1730.62	32335.0
2013-07-15 09:00:00	ES	Futures	1730.62	1733.72	1729.07	1731.14	161113.0
2013-07-15 10:00:00	ES	Futures	1731.14	1732.95	1730.11	1732.43	141940.0
2013-07-15 11:00:00	ES	Futures	1732.69	1734.76	1731.66	1734.24	100934.0
2013-07-15 12:00:00	ES	Futures	1734.24	1735.02	1733.21	1733.47	59847.0
2013-07-15 13:00:00	ES	Futures	1733.47	1734.76	1732.69	1734.5	53013.0
2013-07-15 14:00:00	ES	Futures	1734.24	1736.57	1734.24	1735.53	90074.0
2013-07-15 15:00:00	ES	Futures	1735.53	1736.31	1733.98	1734.24	115023.0
2013-07-15 16:00:00	ES	Futures	1734.5	1735.28	1733.98	1734.76	58120.0
2013-07-15 17:00:00	ES	Futures	1734.5	1735.02	1734.5	1734.5	1598.0
2013-07-15 18:00:00	ES	Futures	1734.76	1735.53	1733.98	1734.24	2992.0
2013-07-15 19:00:00	ES	Futures	1734.24	1734.76	1733.72	1733.98	1304.0
2013-07-15 20:00:00	ES	Futures	1733.98	1734.5	1733.21	1734.5	3731.0
2013-07-15 21:00:00	ES	Futures	1734.24	1734.76	1733.47	1734.24	3011.0
2013-07-15 22:00:00	ES	Futures	1734.24	1734.5	1733.21	1733.47	2407.0
2013-07-15 23:00:00	ES	Futures	1733.72	1734.24	1733.21	1733.72	1368.0
2013-07-15 00:00:00	NQ	Futures	3590.12	3591.58	3589.83	3590.41	251.0
2013-07-15 01:00:00	NQ	Futures	3590.41	3590.99	3589.24	3589.53	261.0
2013-07-15 02:00:00	NQ	Futures	3589.53	3590.41	3585.73	3585.73	478.0
2013-07-15 03:00:00	NQ	Futures	3585.73	3591.87	3585.44	3588.95	2545.0
2013-07-15 04:00:00	NQ	Futures	3588.95	3590.12	3587.78	3588.07	1401.0
2013-07-15 05:00:00	NQ	Futures	3588.07	3589.24	3584.57	3584.86	1434.0
2013-07-15 06:00:00	NQ	Futures	3585.15	3588.07	3584.57	3586.03	1445.0
2013-07-15 07:00:00	NQ	Futures	3586.03	3587.78	3584.86	3586.32	2013.0
2013-07-15 08:00:00	NQ	Futures	3586.03	3587.78	3584.86	3585.44	3480.0
2013-07-15 09:00:00	NQ	Futures	3585.44	3592.46	3580.47	3585.15	22943.0
2013-07-15 10:00:00	NQ	Futures	3585.44	3590.7	3583.1	3590.41	17479.0
2013-07-15 11:00:00	NQ	Futures	3590.41	3593.62	3587.78	3591.87	13816.0
2013-07-15 12:00:00	NQ	Futures	3591.87	3593.92	3589.83	3591.58	8499.0
2013-07-15 13:00:00	NQ	Futures	3591.29	3594.5	3589.83	3593.92	7032.0
2013-07-15 14:00:00	NQ	Futures	3593.92	3595.96	3592.75	3594.79	9487.0
2013-07-15 15:00:00	NQ	Futures	3594.5	3596.25	3592.16	3594.5	12625.0
2013-07-15 16:00:00	NQ	Futures	3594.21	3595.38	3591.29	3593.62	4327.0
2013-07-15 17:00:00	NQ	Futures	3593.04	3593.92	3593.04	3593.62	97.0
2013-07-15 18:00:00	NQ	Futures	3593.33	3594.5	3592.46	3592.46	81.0
2013-07-15 19:00:00	NQ	Futures	3592.46	3593.62	3592.46	3592.75	131.0
2013-07-15 20:00:00	NQ	Futures	3592.75	3593.04	3590.41	3592.16	510.0
2013-07-15 21:00:00	NQ	Futures	3592.16	3593.04	3591.29	3592.16	402.0
2013-07-15 22:00:00	NQ	Futures	3592.16	3592.16	3590.7	3591.87	318.0
2013-07-15 23:00:00	NQ	Futures	3592.16	3592.46	3591.29	3592.16	211.0
2013-07-15 00:00:00	YM	Futures	15644.5	15647.6	15641.5	15647.6	147.0
2013-07-15 01:00:00	YM	Futures	15647.6	15649.6	15641.5	15644.5	302.0

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

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