PREVIEW / futures_1hour / 2013-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-18.parquet
  size:    50 KB
  rows:    1,522

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-18 00:00:00	ES	Futures	1730.11	1730.62	1729.59	1730.36	1296.0
2013-07-18 01:00:00	ES	Futures	1730.62	1730.88	1729.59	1730.11	2714.0
2013-07-18 02:00:00	ES	Futures	1730.36	1730.88	1729.07	1729.85	4295.0
2013-07-18 03:00:00	ES	Futures	1729.85	1732.17	1729.07	1731.92	18096.0
2013-07-18 04:00:00	ES	Futures	1731.92	1733.72	1731.66	1733.47	15294.0
2013-07-18 05:00:00	ES	Futures	1733.47	1734.76	1732.69	1734.24	8218.0
2013-07-18 06:00:00	ES	Futures	1733.98	1734.76	1733.21	1733.98	8932.0
2013-07-18 07:00:00	ES	Futures	1733.72	1735.02	1733.47	1733.98	13189.0
2013-07-18 08:00:00	ES	Futures	1733.98	1736.83	1733.21	1736.31	34576.0
2013-07-18 09:00:00	ES	Futures	1736.31	1739.41	1734.5	1738.38	150793.0
2013-07-18 10:00:00	ES	Futures	1738.12	1745.87	1737.86	1744.84	271990.0
2013-07-18 11:00:00	ES	Futures	1744.84	1745.62	1742.51	1743.29	164293.0
2013-07-18 12:00:00	ES	Futures	1743.03	1745.36	1740.45	1741.48	133288.0
2013-07-18 13:00:00	ES	Futures	1741.48	1742.26	1739.15	1741.74	111810.0
2013-07-18 14:00:00	ES	Futures	1741.74	1744.32	1741.22	1743.29	82087.0
2013-07-18 15:00:00	ES	Futures	1743.29	1743.29	1739.67	1742.0	161905.0
2013-07-18 16:00:00	ES	Futures	1742.0	1742.26	1735.53	1737.09	128157.0
2013-07-18 17:00:00	ES	Futures	1737.34	1738.12	1737.09	1737.09	4139.0
2013-07-18 18:00:00	ES	Futures	1737.09	1737.6	1736.31	1736.57	5898.0
2013-07-18 19:00:00	ES	Futures	1736.57	1737.6	1736.57	1737.09	1852.0
2013-07-18 20:00:00	ES	Futures	1737.09	1737.6	1736.05	1736.05	3595.0
2013-07-18 21:00:00	ES	Futures	1736.31	1736.57	1732.17	1733.72	20952.0
2013-07-18 22:00:00	ES	Futures	1733.72	1735.02	1733.47	1733.72	5352.0
2013-07-18 23:00:00	ES	Futures	1733.98	1734.24	1733.21	1733.72	2901.0
2013-07-18 00:00:00	NQ	Futures	3590.12	3591.29	3589.53	3591.29	312.0
2013-07-18 01:00:00	NQ	Futures	3590.99	3591.29	3589.24	3590.41	480.0
2013-07-18 02:00:00	NQ	Futures	3590.41	3591.29	3588.07	3589.83	728.0
2013-07-18 03:00:00	NQ	Futures	3589.83	3594.5	3588.66	3593.92	2491.0
2013-07-18 04:00:00	NQ	Futures	3593.92	3597.13	3593.62	3596.84	1700.0
2013-07-18 05:00:00	NQ	Futures	3597.13	3598.88	3595.38	3598.3	1084.0
2013-07-18 06:00:00	NQ	Futures	3598.59	3598.59	3596.25	3597.42	1525.0
2013-07-18 07:00:00	NQ	Futures	3597.42	3598.3	3594.79	3595.38	2521.0
2013-07-18 08:00:00	NQ	Futures	3595.38	3601.51	3594.5	3601.22	4162.0
2013-07-18 09:00:00	NQ	Futures	3601.51	3602.68	3591.58	3594.21	20040.0
2013-07-18 10:00:00	NQ	Futures	3594.21	3608.53	3592.46	3605.02	28192.0
2013-07-18 11:00:00	NQ	Futures	3605.31	3607.07	3596.55	3597.72	17916.0
2013-07-18 12:00:00	NQ	Futures	3598.01	3601.81	3586.9	3589.24	23483.0
2013-07-18 13:00:00	NQ	Futures	3589.53	3592.46	3584.27	3592.16	13801.0
2013-07-18 14:00:00	NQ	Futures	3592.16	3598.59	3591.29	3595.38	13032.0
2013-07-18 15:00:00	NQ	Futures	3595.38	3595.38	3589.24	3590.7	19377.0
2013-07-18 16:00:00	NQ	Futures	3590.7	3594.21	3560.6	3564.99	25930.0
2013-07-18 17:00:00	NQ	Futures	3564.69	3564.99	3562.94	3563.52	343.0
2013-07-18 18:00:00	NQ	Futures	3564.11	3564.11	3560.02	3560.6	959.0
2013-07-18 19:00:00	NQ	Futures	3560.6	3562.94	3560.31	3562.65	602.0
2013-07-18 20:00:00	NQ	Futures	3562.36	3563.23	3560.6	3561.19	693.0
2013-07-18 21:00:00	NQ	Futures	3561.77	3562.06	3557.39	3559.14	2634.0
2013-07-18 22:00:00	NQ	Futures	3559.14	3560.89	3558.26	3559.14	688.0
2013-07-18 23:00:00	NQ	Futures	3559.73	3561.77	3558.85	3560.6	691.0
2013-07-18 00:00:00	YM	Futures	15648.6	15651.6	15646.6	15651.6	320.0
2013-07-18 01:00:00	YM	Futures	15650.6	15653.7	15644.5	15652.7	420.0

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

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