PREVIEW / futures_1hour / 2013-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-26.parquet
  size:    45 KB
  rows:    1,394

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-26 00:00:00	ES	Futures	1721.83	1723.64	1721.58	1721.83	5832.0
2013-08-26 01:00:00	ES	Futures	1721.83	1721.83	1720.28	1720.28	3256.0
2013-08-26 02:00:00	ES	Futures	1720.28	1721.32	1720.02	1720.28	3003.0
2013-08-26 03:00:00	ES	Futures	1720.28	1720.54	1716.66	1716.92	10431.0
2013-08-26 04:00:00	ES	Futures	1717.18	1717.7	1715.89	1716.66	15103.0
2013-08-26 05:00:00	ES	Futures	1716.66	1717.7	1715.89	1716.15	6549.0
2013-08-26 06:00:00	ES	Futures	1716.15	1716.66	1714.6	1716.15	6720.0
2013-08-26 07:00:00	ES	Futures	1716.15	1717.7	1715.89	1716.41	12095.0
2013-08-26 08:00:00	ES	Futures	1716.15	1719.25	1715.11	1718.21	42357.0
2013-08-26 09:00:00	ES	Futures	1718.21	1721.06	1716.15	1718.99	157811.0
2013-08-26 10:00:00	ES	Futures	1718.99	1723.13	1718.21	1722.87	157965.0
2013-08-26 11:00:00	ES	Futures	1722.87	1724.16	1721.58	1722.09	111299.0
2013-08-26 12:00:00	ES	Futures	1722.09	1722.87	1720.54	1722.09	81121.0
2013-08-26 13:00:00	ES	Futures	1722.09	1723.13	1718.73	1720.02	84110.0
2013-08-26 14:00:00	ES	Futures	1720.02	1720.54	1718.99	1720.28	61941.0
2013-08-26 15:00:00	ES	Futures	1720.28	1720.8	1709.68	1710.46	344506.0
2013-08-26 16:00:00	ES	Futures	1710.46	1711.75	1709.43	1710.72	84773.0
2013-08-26 17:00:00	ES	Futures	1710.98	1711.24	1710.72	1710.98	1841.0
2013-08-26 18:00:00	ES	Futures	1710.72	1711.75	1706.84	1707.88	7139.0
2013-08-26 19:00:00	ES	Futures	1707.88	1708.91	1707.62	1708.65	4612.0
2013-08-26 20:00:00	ES	Futures	1708.91	1709.43	1707.88	1708.39	5127.0
2013-08-26 21:00:00	ES	Futures	1708.13	1708.65	1707.88	1708.65	4051.0
2013-08-26 22:00:00	ES	Futures	1708.39	1709.68	1707.62	1707.62	3123.0
2013-08-26 23:00:00	ES	Futures	1707.88	1709.43	1707.62	1709.17	2770.0
2013-08-26 00:00:00	NQ	Futures	3657.04	3662.01	3656.75	3657.04	930.0
2013-08-26 01:00:00	NQ	Futures	3657.04	3657.04	3654.41	3654.99	355.0
2013-08-26 02:00:00	NQ	Futures	3655.29	3657.04	3654.41	3655.29	331.0
2013-08-26 03:00:00	NQ	Futures	3654.99	3654.99	3647.1	3647.69	1171.0
2013-08-26 04:00:00	NQ	Futures	3647.69	3649.44	3645.35	3648.56	2691.0
2013-08-26 05:00:00	NQ	Futures	3648.56	3650.61	3646.81	3647.69	1369.0
2013-08-26 06:00:00	NQ	Futures	3647.4	3649.15	3645.64	3648.56	901.0
2013-08-26 07:00:00	NQ	Futures	3648.56	3651.78	3648.56	3649.44	1582.0
2013-08-26 08:00:00	NQ	Futures	3649.15	3654.12	3647.1	3652.95	3807.0
2013-08-26 09:00:00	NQ	Futures	3652.95	3665.81	3649.44	3660.25	26747.0
2013-08-26 10:00:00	NQ	Futures	3660.25	3670.19	3659.38	3669.61	21267.0
2013-08-26 11:00:00	NQ	Futures	3669.31	3675.74	3669.02	3672.53	19485.0
2013-08-26 12:00:00	NQ	Futures	3672.24	3677.5	3669.61	3676.62	19602.0
2013-08-26 13:00:00	NQ	Futures	3676.62	3678.96	3667.56	3670.48	14970.0
2013-08-26 14:00:00	NQ	Futures	3670.48	3673.7	3666.68	3671.65	14465.0
2013-08-26 15:00:00	NQ	Futures	3671.65	3671.94	3643.89	3649.44	50126.0
2013-08-26 16:00:00	NQ	Futures	3649.44	3652.07	3647.1	3650.61	6830.0
2013-08-26 17:00:00	NQ	Futures	3650.32	3651.19	3650.03	3650.9	119.0
2013-08-26 18:00:00	NQ	Futures	3651.19	3652.66	3643.3	3644.77	855.0
2013-08-26 19:00:00	NQ	Futures	3645.06	3647.1	3644.47	3646.52	369.0
2013-08-26 20:00:00	NQ	Futures	3646.23	3647.4	3645.35	3646.23	837.0
2013-08-26 21:00:00	NQ	Futures	3645.93	3647.1	3645.35	3646.52	501.0
2013-08-26 22:00:00	NQ	Futures	3646.52	3649.15	3645.64	3645.64	664.0
2013-08-26 23:00:00	NQ	Futures	3645.64	3648.56	3645.06	3647.98	354.0
2013-08-26 00:00:00	YM	Futures	15255.5	15268.7	15254.5	15254.5	639.0
2013-08-26 01:00:00	YM	Futures	15254.5	15256.5	15242.3	15243.3	505.0

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

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