PREVIEW / futures_1hour / 2013-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-06.parquet
  size:    43 KB
  rows:    1,231

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-06 00:00:00	ES	Futures	1707.62	1708.91	1707.36	1708.39	4892.0
2013-09-06 01:00:00	ES	Futures	1708.39	1708.65	1706.84	1707.36	6596.0
2013-09-06 02:00:00	ES	Futures	1707.36	1710.2	1707.1	1709.94	6250.0
2013-09-06 03:00:00	ES	Futures	1709.94	1712.01	1708.13	1709.17	25527.0
2013-09-06 04:00:00	ES	Futures	1709.17	1710.46	1708.13	1709.94	17562.0
2013-09-06 05:00:00	ES	Futures	1709.94	1710.2	1708.13	1708.39	11059.0
2013-09-06 06:00:00	ES	Futures	1708.39	1709.94	1708.13	1709.68	10230.0
2013-09-06 07:00:00	ES	Futures	1709.43	1712.79	1709.17	1712.27	28306.0
2013-09-06 08:00:00	ES	Futures	1712.27	1720.02	1712.01	1718.99	186136.0
2013-09-06 09:00:00	ES	Futures	1718.99	1719.25	1698.05	1701.67	545237.0
2013-09-06 10:00:00	ES	Futures	1701.67	1713.56	1694.43	1712.79	570701.0
2013-09-06 11:00:00	ES	Futures	1712.79	1716.92	1712.79	1715.63	285884.0
2013-09-06 12:00:00	ES	Futures	1715.89	1716.92	1712.27	1714.34	130064.0
2013-09-06 13:00:00	ES	Futures	1714.34	1719.77	1714.08	1718.47	140969.0
2013-09-06 14:00:00	ES	Futures	1718.47	1720.54	1716.41	1717.18	136470.0
2013-09-06 15:00:00	ES	Futures	1716.92	1717.96	1708.91	1710.2	316224.0
2013-09-06 16:00:00	ES	Futures	1709.94	1710.98	1708.65	1710.2	82251.0
2013-09-06 17:00:00	ES	Futures	1710.2	1710.72	1709.94	1710.2	715.0
2013-09-06 00:00:00	NQ	Futures	3654.99	3656.16	3654.41	3654.99	528.0
2013-09-06 01:00:00	NQ	Futures	3654.99	3656.16	3653.53	3655.29	492.0
2013-09-06 02:00:00	NQ	Futures	3655.29	3661.13	3654.41	3660.55	749.0
2013-09-06 03:00:00	NQ	Futures	3660.84	3664.64	3657.04	3658.79	2955.0
2013-09-06 04:00:00	NQ	Futures	3658.79	3662.01	3656.75	3661.42	1626.0
2013-09-06 05:00:00	NQ	Futures	3661.42	3662.01	3657.04	3657.62	1183.0
2013-09-06 06:00:00	NQ	Futures	3657.33	3662.01	3656.75	3662.01	1624.0
2013-09-06 07:00:00	NQ	Futures	3661.72	3666.39	3661.42	3666.1	3826.0
2013-09-06 08:00:00	NQ	Futures	3665.81	3676.91	3665.22	3673.7	17191.0
2013-09-06 09:00:00	NQ	Futures	3673.7	3674.57	3631.91	3636.88	62142.0
2013-09-06 10:00:00	NQ	Futures	3636.29	3669.31	3619.63	3667.56	68435.0
2013-09-06 11:00:00	NQ	Futures	3667.56	3674.57	3666.68	3669.9	29467.0
2013-09-06 12:00:00	NQ	Futures	3670.19	3673.99	3665.22	3669.31	11836.0
2013-09-06 13:00:00	NQ	Futures	3669.61	3682.46	3669.31	3678.67	19571.0
2013-09-06 14:00:00	NQ	Futures	3678.67	3681.3	3673.4	3675.74	14246.0
2013-09-06 15:00:00	NQ	Futures	3675.74	3676.62	3660.84	3662.3	36337.0
2013-09-06 16:00:00	NQ	Futures	3662.01	3664.64	3658.21	3664.05	5497.0
2013-09-06 17:00:00	NQ	Futures	3664.05	3664.05	3662.3	3662.3	45.0
2013-09-06 00:00:00	YM	Futures	15132.6	15141.8	15131.6	15137.7	357.0
2013-09-06 01:00:00	YM	Futures	15139.7	15139.7	15129.6	15135.7	719.0
2013-09-06 02:00:00	YM	Futures	15133.7	15152.9	15131.6	15151.9	464.0
2013-09-06 03:00:00	YM	Futures	15151.9	15165.1	15133.7	15142.8	2331.0
2013-09-06 04:00:00	YM	Futures	15141.8	15151.9	15135.7	15148.9	1133.0
2013-09-06 05:00:00	YM	Futures	15147.9	15147.9	15131.6	15133.7	1425.0
2013-09-06 06:00:00	YM	Futures	15133.7	15143.8	15130.6	15142.8	1201.0
2013-09-06 07:00:00	YM	Futures	15142.8	15170.2	15141.8	15167.2	2742.0
2013-09-06 08:00:00	YM	Futures	15168.2	15234.2	15165.1	15228.1	13879.0
2013-09-06 09:00:00	YM	Futures	15228.1	15230.1	15037.2	15050.4	44309.0
2013-09-06 10:00:00	YM	Futures	15050.4	15160.1	15007.7	15155.0	45316.0
2013-09-06 11:00:00	YM	Futures	15155.0	15212.9	15155.0	15195.6	24244.0
2013-09-06 12:00:00	YM	Futures	15194.6	15208.8	15170.2	15180.4	9261.0
2013-09-06 13:00:00	YM	Futures	15179.4	15237.3	15179.4	15225.1	11094.0

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

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