PREVIEW / futures_1hour / 2014-12-15

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-15.parquet
  size:    51 KB
  rows:    1,544

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
2014-12-15 00:00:00	ES	Futures	2103.9	2104.43	2102.32	2102.85	3471.0
2014-12-15 01:00:00	ES	Futures	2103.11	2104.16	2100.48	2101.53	3900.0
2014-12-15 02:00:00	ES	Futures	2101.79	2105.21	2101.53	2104.16	11224.0
2014-12-15 03:00:00	ES	Futures	2104.16	2111.0	2103.9	2110.21	29305.0
2014-12-15 04:00:00	ES	Futures	2110.48	2114.16	2109.43	2113.64	20851.0
2014-12-15 05:00:00	ES	Futures	2113.64	2114.16	2109.95	2111.0	13667.0
2014-12-15 06:00:00	ES	Futures	2111.0	2112.58	2107.85	2110.74	17440.0
2014-12-15 07:00:00	ES	Futures	2110.48	2111.27	2108.37	2109.16	16516.0
2014-12-15 08:00:00	ES	Futures	2108.9	2111.53	2105.74	2107.32	43096.0
2014-12-15 09:00:00	ES	Futures	2107.32	2118.11	2107.06	2113.64	255803.0
2014-12-15 10:00:00	ES	Futures	2113.37	2113.9	2095.48	2101.79	333734.0
2014-12-15 11:00:00	ES	Futures	2102.06	2102.06	2078.37	2080.48	451014.0
2014-12-15 12:00:00	ES	Futures	2080.22	2100.74	2079.95	2098.64	315562.0
2014-12-15 13:00:00	ES	Futures	2098.64	2100.48	2088.64	2091.0	153510.0
2014-12-15 14:00:00	ES	Futures	2090.74	2099.69	2087.85	2090.74	214159.0
2014-12-15 15:00:00	ES	Futures	2090.74	2096.27	2085.22	2085.74	259220.0
2014-12-15 16:00:00	ES	Futures	2085.74	2091.0	2084.43	2086.27	90601.0
2014-12-15 17:00:00	ES	Futures	2086.27	2088.9	2086.27	2087.85	3014.0
2014-12-15 18:00:00	ES	Futures	2088.9	2091.0	2087.85	2090.74	6514.0
2014-12-15 19:00:00	ES	Futures	2090.74	2093.11	2089.43	2090.74	8043.0
2014-12-15 20:00:00	ES	Futures	2091.0	2094.95	2090.74	2093.11	7704.0
2014-12-15 21:00:00	ES	Futures	2093.11	2094.69	2091.27	2092.85	4656.0
2014-12-15 22:00:00	ES	Futures	2092.85	2093.11	2091.0	2091.27	4077.0
2014-12-15 23:00:00	ES	Futures	2091.0	2094.69	2090.48	2094.16	5732.0
2014-12-15 00:00:00	NQ	Futures	4936.31	4939.55	4933.97	4936.02	788.0
2014-12-15 01:00:00	NQ	Futures	4936.31	4938.96	4928.09	4930.15	538.0
2014-12-15 02:00:00	NQ	Futures	4930.73	4939.84	4930.44	4938.08	1051.0
2014-12-15 03:00:00	NQ	Futures	4937.49	4953.35	4937.2	4952.17	2953.0
2014-12-15 04:00:00	NQ	Futures	4952.76	4965.68	4951.88	4962.75	3401.0
2014-12-15 05:00:00	NQ	Futures	4962.16	4964.8	4956.58	4958.34	2197.0
2014-12-15 06:00:00	NQ	Futures	4958.63	4961.87	4951.59	4957.17	2575.0
2014-12-15 07:00:00	NQ	Futures	4956.87	4960.69	4952.47	4955.4	2615.0
2014-12-15 08:00:00	NQ	Futures	4955.4	4960.69	4943.07	4948.36	7295.0
2014-12-15 09:00:00	NQ	Futures	4948.06	4973.91	4946.3	4954.82	49538.0
2014-12-15 10:00:00	NQ	Futures	4954.82	4956.29	4906.36	4928.09	66114.0
2014-12-15 11:00:00	NQ	Futures	4928.68	4928.68	4864.65	4868.18	85752.0
2014-12-15 12:00:00	NQ	Futures	4867.89	4920.46	4867.3	4915.17	52554.0
2014-12-15 13:00:00	NQ	Futures	4915.17	4922.22	4884.04	4890.79	34640.0
2014-12-15 14:00:00	NQ	Futures	4890.5	4913.99	4882.57	4891.67	39819.0
2014-12-15 15:00:00	NQ	Futures	4891.67	4904.6	4873.47	4880.81	60584.0
2014-12-15 16:00:00	NQ	Futures	4880.81	4892.26	4876.7	4882.28	11141.0
2014-12-15 17:00:00	NQ	Futures	4882.57	4887.86	4881.98	4884.92	318.0
2014-12-15 18:00:00	NQ	Futures	4889.62	4893.44	4884.33	4892.85	1438.0
2014-12-15 19:00:00	NQ	Futures	4892.85	4899.02	4888.74	4893.14	2103.0
2014-12-15 20:00:00	NQ	Futures	4892.85	4901.66	4892.56	4896.67	1839.0
2014-12-15 21:00:00	NQ	Futures	4896.37	4900.19	4892.85	4895.79	1477.0
2014-12-15 22:00:00	NQ	Futures	4895.79	4897.55	4891.97	4892.85	1334.0
2014-12-15 23:00:00	NQ	Futures	4892.85	4899.31	4891.38	4898.14	1652.0
2014-12-15 00:00:00	YM	Futures	18007.9	18016.3	17990.2	18000.6	2051.0
2014-12-15 01:00:00	YM	Futures	18001.7	18009.0	17982.9	17991.2	1312.0

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

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