PREVIEW / futures_1hour / 2013-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-29.parquet
  size:    48 KB
  rows:    1,491

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-29 00:00:00	ES	Futures	1740.19	1742.26	1739.67	1740.19	2124.0
2013-07-29 01:00:00	ES	Futures	1739.93	1741.74	1739.41	1740.7	4804.0
2013-07-29 02:00:00	ES	Futures	1740.45	1741.22	1738.89	1739.67	9070.0
2013-07-29 03:00:00	ES	Futures	1739.93	1743.55	1739.93	1740.7	17921.0
2013-07-29 04:00:00	ES	Futures	1740.45	1740.7	1737.86	1739.93	19269.0
2013-07-29 05:00:00	ES	Futures	1739.93	1742.0	1738.64	1739.15	11289.0
2013-07-29 06:00:00	ES	Futures	1739.15	1741.48	1738.12	1740.96	12295.0
2013-07-29 07:00:00	ES	Futures	1740.96	1741.48	1738.89	1740.7	15497.0
2013-07-29 08:00:00	ES	Futures	1740.96	1740.96	1739.41	1740.19	15939.0
2013-07-29 09:00:00	ES	Futures	1740.19	1743.55	1738.64	1741.48	134024.0
2013-07-29 10:00:00	ES	Futures	1741.48	1742.0	1737.34	1739.67	188884.0
2013-07-29 11:00:00	ES	Futures	1739.67	1740.19	1733.47	1735.28	168730.0
2013-07-29 12:00:00	ES	Futures	1735.28	1737.86	1734.5	1737.09	85766.0
2013-07-29 13:00:00	ES	Futures	1737.09	1738.12	1735.53	1736.83	72171.0
2013-07-29 14:00:00	ES	Futures	1737.09	1741.22	1736.83	1739.67	99173.0
2013-07-29 15:00:00	ES	Futures	1739.67	1740.19	1736.57	1738.38	156509.0
2013-07-29 16:00:00	ES	Futures	1738.38	1740.19	1738.12	1739.67	56754.0
2013-07-29 17:00:00	ES	Futures	1739.41	1740.19	1739.41	1739.67	2003.0
2013-07-29 18:00:00	ES	Futures	1739.41	1739.67	1739.15	1739.67	1120.0
2013-07-29 19:00:00	ES	Futures	1739.41	1740.45	1739.15	1740.19	2281.0
2013-07-29 20:00:00	ES	Futures	1740.19	1742.26	1739.93	1741.48	8108.0
2013-07-29 21:00:00	ES	Futures	1741.48	1743.03	1741.22	1742.51	4849.0
2013-07-29 22:00:00	ES	Futures	1742.26	1742.51	1740.96	1741.74	2881.0
2013-07-29 23:00:00	ES	Futures	1741.74	1742.77	1741.74	1742.26	2583.0
2013-07-29 00:00:00	NQ	Futures	3583.69	3584.86	3582.81	3583.4	367.0
2013-07-29 01:00:00	NQ	Futures	3583.1	3586.03	3582.23	3583.69	678.0
2013-07-29 02:00:00	NQ	Futures	3583.4	3585.15	3581.64	3583.4	986.0
2013-07-29 03:00:00	NQ	Futures	3583.69	3591.58	3583.69	3585.73	4077.0
2013-07-29 04:00:00	NQ	Futures	3585.44	3585.44	3578.43	3582.81	3664.0
2013-07-29 05:00:00	NQ	Futures	3582.81	3587.2	3580.18	3581.06	2298.0
2013-07-29 06:00:00	NQ	Futures	3581.35	3584.57	3579.01	3584.27	2250.0
2013-07-29 07:00:00	NQ	Futures	3583.98	3584.27	3580.18	3583.4	2414.0
2013-07-29 08:00:00	NQ	Futures	3583.69	3585.15	3581.64	3582.81	2760.0
2013-07-29 09:00:00	NQ	Futures	3582.81	3598.59	3580.47	3593.62	29368.0
2013-07-29 10:00:00	NQ	Futures	3593.62	3594.79	3584.27	3589.53	38713.0
2013-07-29 11:00:00	NQ	Futures	3589.53	3590.99	3573.17	3576.38	30645.0
2013-07-29 12:00:00	NQ	Futures	3576.38	3582.52	3574.34	3581.06	14042.0
2013-07-29 13:00:00	NQ	Futures	3581.35	3583.69	3576.67	3581.35	10852.0
2013-07-29 14:00:00	NQ	Futures	3581.35	3589.53	3581.35	3585.73	14052.0
2013-07-29 15:00:00	NQ	Futures	3585.44	3587.2	3576.97	3582.23	24010.0
2013-07-29 16:00:00	NQ	Futures	3582.23	3587.2	3580.47	3586.32	4754.0
2013-07-29 17:00:00	NQ	Futures	3586.32	3586.32	3585.15	3585.15	81.0
2013-07-29 18:00:00	NQ	Futures	3583.98	3585.44	3583.98	3584.86	103.0
2013-07-29 19:00:00	NQ	Futures	3584.57	3585.73	3583.4	3585.44	194.0
2013-07-29 20:00:00	NQ	Futures	3585.73	3587.78	3585.44	3587.2	615.0
2013-07-29 21:00:00	NQ	Futures	3587.49	3591.58	3587.2	3590.7	867.0
2013-07-29 22:00:00	NQ	Futures	3590.41	3590.7	3588.36	3590.12	285.0
2013-07-29 23:00:00	NQ	Futures	3590.41	3592.16	3589.53	3590.99	423.0
2013-07-29 00:00:00	YM	Futures	15709.5	15716.7	15707.5	15708.5	449.0
2013-07-29 01:00:00	YM	Futures	15708.5	15718.7	15703.4	15709.5	917.0

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

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