PREVIEW / futures_1hour / 2013-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-15.parquet
  size:    51 KB
  rows:    1,518

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-08-15 00:00:00	ES	Futures	1737.86	1738.12	1736.57	1737.09	1877.0
2013-08-15 01:00:00	ES	Futures	1736.83	1737.09	1735.53	1736.31	3229.0
2013-08-15 02:00:00	ES	Futures	1736.31	1737.6	1735.79	1737.09	7057.0
2013-08-15 03:00:00	ES	Futures	1737.34	1737.34	1734.5	1736.05	18082.0
2013-08-15 04:00:00	ES	Futures	1735.79	1738.12	1735.79	1737.09	13174.0
2013-08-15 05:00:00	ES	Futures	1737.09	1737.34	1735.79	1736.05	8212.0
2013-08-15 06:00:00	ES	Futures	1736.05	1736.31	1730.11	1731.92	43783.0
2013-08-15 07:00:00	ES	Futures	1732.17	1732.69	1728.3	1729.33	56382.0
2013-08-15 08:00:00	ES	Futures	1729.33	1730.36	1722.87	1726.23	113409.0
2013-08-15 09:00:00	ES	Futures	1725.97	1726.49	1716.92	1717.7	364438.0
2013-08-15 10:00:00	ES	Futures	1717.7	1719.25	1712.79	1715.37	484808.0
2013-08-15 11:00:00	ES	Futures	1715.37	1721.58	1714.85	1718.73	249240.0
2013-08-15 12:00:00	ES	Futures	1718.99	1721.83	1717.7	1717.96	145068.0
2013-08-15 13:00:00	ES	Futures	1718.21	1718.99	1713.82	1715.89	192521.0
2013-08-15 14:00:00	ES	Futures	1715.89	1718.99	1712.01	1716.41	221873.0
2013-08-15 15:00:00	ES	Futures	1716.41	1717.44	1712.79	1714.6	276370.0
2013-08-15 16:00:00	ES	Futures	1714.6	1714.85	1711.49	1711.75	151157.0
2013-08-15 17:00:00	ES	Futures	1712.01	1712.53	1710.46	1710.72	4615.0
2013-08-15 18:00:00	ES	Futures	1710.98	1714.85	1710.72	1714.6	8291.0
2013-08-15 19:00:00	ES	Futures	1714.85	1714.85	1713.82	1714.08	2791.0
2013-08-15 20:00:00	ES	Futures	1714.08	1714.6	1712.53	1712.79	6193.0
2013-08-15 21:00:00	ES	Futures	1712.53	1714.08	1712.27	1712.53	6263.0
2013-08-15 22:00:00	ES	Futures	1712.79	1713.05	1711.75	1712.79	5406.0
2013-08-15 23:00:00	ES	Futures	1712.53	1715.37	1712.53	1715.11	10975.0
2013-08-15 00:00:00	NQ	Futures	3638.92	3638.92	3636.29	3636.88	173.0
2013-08-15 01:00:00	NQ	Futures	3636.88	3637.17	3634.25	3635.71	393.0
2013-08-15 02:00:00	NQ	Futures	3635.71	3638.92	3634.83	3638.63	545.0
2013-08-15 03:00:00	NQ	Futures	3638.92	3639.21	3631.32	3634.25	2733.0
2013-08-15 04:00:00	NQ	Futures	3634.25	3640.67	3634.25	3638.34	1568.0
2013-08-15 05:00:00	NQ	Futures	3638.34	3639.21	3637.17	3637.46	1012.0
2013-08-15 06:00:00	NQ	Futures	3636.88	3638.04	3626.94	3631.32	3295.0
2013-08-15 07:00:00	NQ	Futures	3631.32	3632.78	3624.31	3625.77	3582.0
2013-08-15 08:00:00	NQ	Futures	3625.77	3627.23	3613.79	3615.83	11970.0
2013-08-15 09:00:00	NQ	Futures	3616.13	3618.46	3595.67	3598.59	62747.0
2013-08-15 10:00:00	NQ	Futures	3598.3	3601.81	3584.57	3595.09	66560.0
2013-08-15 11:00:00	NQ	Futures	3595.09	3611.45	3593.62	3608.82	31641.0
2013-08-15 12:00:00	NQ	Futures	3608.82	3613.79	3603.56	3603.56	18242.0
2013-08-15 13:00:00	NQ	Futures	3603.56	3605.31	3592.46	3596.55	23082.0
2013-08-15 14:00:00	NQ	Futures	3596.25	3604.44	3587.49	3599.47	26968.0
2013-08-15 15:00:00	NQ	Futures	3599.18	3600.05	3589.24	3595.67	36388.0
2013-08-15 16:00:00	NQ	Futures	3595.67	3597.13	3590.7	3591.87	10755.0
2013-08-15 17:00:00	NQ	Futures	3591.58	3593.04	3589.53	3589.53	197.0
2013-08-15 18:00:00	NQ	Futures	3590.7	3596.84	3590.12	3596.25	838.0
2013-08-15 19:00:00	NQ	Futures	3596.25	3596.55	3593.62	3593.92	691.0
2013-08-15 20:00:00	NQ	Futures	3594.21	3594.79	3590.41	3590.41	688.0
2013-08-15 21:00:00	NQ	Futures	3590.99	3594.21	3589.83	3590.41	993.0
2013-08-15 22:00:00	NQ	Futures	3590.12	3590.99	3587.78	3590.41	863.0
2013-08-15 23:00:00	NQ	Futures	3590.7	3597.72	3590.12	3596.55	1364.0
2013-08-15 00:00:00	YM	Futures	15531.8	15531.8	15521.6	15524.7	227.0
2013-08-15 01:00:00	YM	Futures	15524.7	15526.7	15513.5	15518.6	361.0

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

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