PREVIEW / futures_1hour / 2013-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-03.parquet
  size:    48 KB
  rows:    1,469

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-09-03 00:00:00	ES	Futures	1703.74	1704.0	1702.19	1702.71	6336.0
2013-09-03 01:00:00	ES	Futures	1702.71	1704.51	1702.71	1704.26	2462.0
2013-09-03 02:00:00	ES	Futures	1704.26	1705.03	1704.0	1704.51	8278.0
2013-09-03 03:00:00	ES	Futures	1704.26	1704.51	1702.19	1704.51	26748.0
2013-09-03 04:00:00	ES	Futures	1704.26	1704.51	1698.31	1699.09	45009.0
2013-09-03 05:00:00	ES	Futures	1699.09	1702.71	1698.05	1698.83	47486.0
2013-09-03 06:00:00	ES	Futures	1698.83	1702.96	1698.83	1701.93	16022.0
2013-09-03 07:00:00	ES	Futures	1701.93	1702.96	1698.31	1700.64	25524.0
2013-09-03 08:00:00	ES	Futures	1700.64	1702.71	1699.34	1701.93	32902.0
2013-09-03 09:00:00	ES	Futures	1701.93	1706.07	1701.41	1702.45	256769.0
2013-09-03 10:00:00	ES	Futures	1702.71	1704.77	1699.6	1700.64	283344.0
2013-09-03 11:00:00	ES	Futures	1700.64	1702.71	1691.85	1693.92	330767.0
2013-09-03 12:00:00	ES	Futures	1693.92	1695.21	1688.75	1689.52	200792.0
2013-09-03 13:00:00	ES	Futures	1689.52	1691.07	1686.94	1687.97	179098.0
2013-09-03 14:00:00	ES	Futures	1688.23	1691.07	1686.16	1690.56	201063.0
2013-09-03 15:00:00	ES	Futures	1690.56	1695.21	1689.78	1693.66	318058.0
2013-09-03 16:00:00	ES	Futures	1693.66	1695.73	1692.62	1694.17	97668.0
2013-09-03 17:00:00	ES	Futures	1694.43	1694.69	1693.14	1693.4	2012.0
2013-09-03 18:00:00	ES	Futures	1693.66	1693.66	1691.59	1693.4	6373.0
2013-09-03 19:00:00	ES	Futures	1693.4	1693.92	1692.37	1693.14	1766.0
2013-09-03 20:00:00	ES	Futures	1693.14	1693.66	1692.62	1692.88	1883.0
2013-09-03 21:00:00	ES	Futures	1693.14	1694.43	1692.62	1694.43	5838.0
2013-09-03 22:00:00	ES	Futures	1694.17	1694.43	1693.66	1694.17	2695.0
2013-09-03 23:00:00	ES	Futures	1694.17	1695.47	1693.92	1695.47	2966.0
2013-09-03 00:00:00	NQ	Futures	3635.71	3636.0	3632.78	3633.37	437.0
2013-09-03 01:00:00	NQ	Futures	3633.66	3636.0	3633.37	3634.83	278.0
2013-09-03 02:00:00	NQ	Futures	3634.83	3636.88	3634.54	3636.29	700.0
2013-09-03 03:00:00	NQ	Futures	3636.29	3636.29	3630.45	3633.95	3965.0
2013-09-03 04:00:00	NQ	Futures	3633.95	3634.25	3615.83	3617.59	6702.0
2013-09-03 05:00:00	NQ	Futures	3617.0	3621.68	3614.37	3614.67	5957.0
2013-09-03 06:00:00	NQ	Futures	3614.67	3624.6	3613.79	3621.09	3300.0
2013-09-03 07:00:00	NQ	Futures	3621.09	3622.26	3613.79	3615.54	4259.0
2013-09-03 08:00:00	NQ	Futures	3615.83	3621.97	3614.67	3621.39	5040.0
2013-09-03 09:00:00	NQ	Futures	3621.39	3636.88	3619.63	3632.78	39241.0
2013-09-03 10:00:00	NQ	Futures	3632.78	3638.92	3623.72	3631.32	41057.0
2013-09-03 11:00:00	NQ	Futures	3631.62	3637.75	3612.33	3616.13	40452.0
2013-09-03 12:00:00	NQ	Futures	3616.13	3622.56	3605.02	3605.61	31779.0
2013-09-03 13:00:00	NQ	Futures	3605.31	3609.7	3595.67	3598.3	24599.0
2013-09-03 14:00:00	NQ	Futures	3598.59	3608.82	3596.25	3608.53	21715.0
2013-09-03 15:00:00	NQ	Futures	3608.82	3619.05	3605.61	3612.33	45558.0
2013-09-03 16:00:00	NQ	Futures	3612.33	3613.5	3608.24	3610.87	11027.0
2013-09-03 17:00:00	NQ	Futures	3611.45	3611.74	3609.41	3609.41	48.0
2013-09-03 18:00:00	NQ	Futures	3609.41	3611.16	3606.19	3609.11	470.0
2013-09-03 19:00:00	NQ	Futures	3609.11	3610.57	3608.24	3609.41	189.0
2013-09-03 20:00:00	NQ	Futures	3609.99	3610.28	3607.65	3608.53	360.0
2013-09-03 21:00:00	NQ	Futures	3608.53	3611.74	3607.65	3611.74	458.0
2013-09-03 22:00:00	NQ	Futures	3611.45	3611.74	3610.28	3610.28	254.0
2013-09-03 23:00:00	NQ	Futures	3610.28	3614.08	3610.28	3613.79	252.0
2013-09-03 00:00:00	YM	Futures	15151.9	15154.0	15141.8	15144.8	425.0
2013-09-03 01:00:00	YM	Futures	15144.8	15157.0	15144.8	15155.0	628.0

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

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