PREVIEW / futures_1hour / 2013-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-04.parquet
  size:    49 KB
  rows:    1,500

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-04 00:00:00	ES	Futures	1695.47	1697.54	1695.21	1697.54	5117.0
2013-09-04 01:00:00	ES	Futures	1697.28	1698.05	1697.28	1697.54	4828.0
2013-09-04 02:00:00	ES	Futures	1697.79	1697.79	1696.24	1696.76	5950.0
2013-09-04 03:00:00	ES	Futures	1697.02	1697.54	1692.11	1692.88	25755.0
2013-09-04 04:00:00	ES	Futures	1693.14	1694.95	1691.59	1693.4	17668.0
2013-09-04 05:00:00	ES	Futures	1693.4	1694.95	1691.85	1692.37	19617.0
2013-09-04 06:00:00	ES	Futures	1692.11	1694.69	1691.85	1694.43	15027.0
2013-09-04 07:00:00	ES	Futures	1694.17	1695.73	1693.14	1693.14	16538.0
2013-09-04 08:00:00	ES	Futures	1693.4	1693.66	1690.56	1692.62	34399.0
2013-09-04 09:00:00	ES	Futures	1692.62	1699.6	1690.81	1698.31	225401.0
2013-09-04 10:00:00	ES	Futures	1698.57	1704.0	1698.31	1703.48	251545.0
2013-09-04 11:00:00	ES	Futures	1703.48	1709.68	1702.96	1709.43	258648.0
2013-09-04 12:00:00	ES	Futures	1709.43	1709.94	1708.13	1708.65	127433.0
2013-09-04 13:00:00	ES	Futures	1708.91	1710.98	1707.36	1708.13	126336.0
2013-09-04 14:00:00	ES	Futures	1708.13	1709.68	1706.84	1709.17	107388.0
2013-09-04 15:00:00	ES	Futures	1708.91	1710.46	1705.55	1707.88	252989.0
2013-09-04 16:00:00	ES	Futures	1707.88	1710.72	1707.36	1710.72	83537.0
2013-09-04 17:00:00	ES	Futures	1710.46	1711.49	1710.46	1711.24	4567.0
2013-09-04 18:00:00	ES	Futures	1710.98	1711.24	1710.2	1710.46	2789.0
2013-09-04 19:00:00	ES	Futures	1710.72	1711.24	1710.2	1710.98	1870.0
2013-09-04 20:00:00	ES	Futures	1710.98	1710.98	1709.43	1709.94	4455.0
2013-09-04 21:00:00	ES	Futures	1709.68	1710.2	1709.17	1709.43	3355.0
2013-09-04 22:00:00	ES	Futures	1709.43	1710.2	1709.17	1709.94	1927.0
2013-09-04 23:00:00	ES	Futures	1709.94	1710.46	1709.68	1709.94	1852.0
2013-09-04 00:00:00	NQ	Futures	3613.79	3617.88	3612.62	3617.59	685.0
2013-09-04 01:00:00	NQ	Futures	3617.3	3619.34	3617.0	3618.76	657.0
2013-09-04 02:00:00	NQ	Futures	3618.76	3619.05	3614.67	3616.13	1057.0
2013-09-04 03:00:00	NQ	Futures	3616.13	3616.71	3605.31	3607.94	4240.0
2013-09-04 04:00:00	NQ	Futures	3607.94	3612.33	3604.14	3608.53	3245.0
2013-09-04 05:00:00	NQ	Futures	3608.24	3610.57	3605.02	3605.9	3066.0
2013-09-04 06:00:00	NQ	Futures	3605.9	3612.04	3605.02	3611.74	3316.0
2013-09-04 07:00:00	NQ	Futures	3611.74	3617.3	3611.16	3616.42	4145.0
2013-09-04 08:00:00	NQ	Futures	3616.13	3616.71	3609.7	3616.13	4994.0
2013-09-04 09:00:00	NQ	Futures	3616.42	3632.49	3614.08	3630.45	33943.0
2013-09-04 10:00:00	NQ	Futures	3630.45	3643.3	3630.45	3641.55	30936.0
2013-09-04 11:00:00	NQ	Futures	3641.84	3656.75	3640.97	3654.7	29169.0
2013-09-04 12:00:00	NQ	Futures	3654.99	3655.58	3648.56	3651.78	18600.0
2013-09-04 13:00:00	NQ	Futures	3651.78	3657.92	3650.9	3653.24	11423.0
2013-09-04 14:00:00	NQ	Futures	3653.24	3656.75	3650.61	3654.99	10199.0
2013-09-04 15:00:00	NQ	Futures	3655.29	3657.33	3645.35	3652.07	43801.0
2013-09-04 16:00:00	NQ	Futures	3652.07	3660.55	3650.32	3659.96	10472.0
2013-09-04 17:00:00	NQ	Futures	3659.96	3661.13	3659.67	3661.13	155.0
2013-09-04 18:00:00	NQ	Futures	3660.55	3660.55	3659.09	3659.09	251.0
2013-09-04 19:00:00	NQ	Futures	3659.38	3662.01	3659.09	3660.84	334.0
2013-09-04 20:00:00	NQ	Futures	3661.13	3661.13	3657.92	3659.38	467.0
2013-09-04 21:00:00	NQ	Futures	3659.09	3660.25	3658.5	3658.5	270.0
2013-09-04 22:00:00	NQ	Futures	3658.5	3659.96	3658.21	3659.96	235.0
2013-09-04 23:00:00	NQ	Futures	3659.96	3659.96	3658.79	3659.09	193.0
2013-09-04 00:00:00	YM	Futures	15063.6	15079.8	15060.5	15077.8	775.0
2013-09-04 01:00:00	YM	Futures	15076.8	15080.8	15075.8	15078.8	667.0

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

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