PREVIEW / futures_1hour / 2014-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-20.parquet
  size:    50 KB
  rows:    1,533

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-11-20 00:00:00	ES	Futures	2141.32	2142.11	2141.06	2141.32	1866.0
2014-11-20 01:00:00	ES	Futures	2141.32	2143.42	2141.06	2143.16	2646.0
2014-11-20 02:00:00	ES	Futures	2143.16	2143.94	2140.8	2141.85	6123.0
2014-11-20 03:00:00	ES	Futures	2141.85	2142.11	2137.39	2137.65	28799.0
2014-11-20 04:00:00	ES	Futures	2137.39	2138.7	2136.34	2138.18	20633.0
2014-11-20 05:00:00	ES	Futures	2138.44	2138.44	2135.56	2136.61	13162.0
2014-11-20 06:00:00	ES	Futures	2136.61	2138.18	2134.25	2135.03	24556.0
2014-11-20 07:00:00	ES	Futures	2135.03	2137.65	2134.51	2136.87	15993.0
2014-11-20 08:00:00	ES	Futures	2137.13	2138.18	2133.72	2134.51	35158.0
2014-11-20 09:00:00	ES	Futures	2134.25	2141.85	2132.68	2141.06	172739.0
2014-11-20 10:00:00	ES	Futures	2141.06	2148.39	2140.8	2147.08	233669.0
2014-11-20 11:00:00	ES	Futures	2147.08	2150.23	2146.82	2148.13	122871.0
2014-11-20 12:00:00	ES	Futures	2148.13	2149.7	2146.82	2147.61	73581.0
2014-11-20 13:00:00	ES	Futures	2147.61	2148.92	2146.3	2148.13	52568.0
2014-11-20 14:00:00	ES	Futures	2148.13	2149.44	2146.3	2146.3	55925.0
2014-11-20 15:00:00	ES	Futures	2146.56	2149.44	2145.25	2149.18	164212.0
2014-11-20 16:00:00	ES	Futures	2149.18	2151.01	2148.66	2150.75	68229.0
2014-11-20 17:00:00	ES	Futures	2150.75	2150.75	2150.23	2150.49	1411.0
2014-11-20 18:00:00	ES	Futures	2150.49	2150.49	2148.66	2148.92	6267.0
2014-11-20 19:00:00	ES	Futures	2148.92	2149.7	2147.87	2149.18	5659.0
2014-11-20 20:00:00	ES	Futures	2149.44	2149.7	2148.66	2149.18	3226.0
2014-11-20 21:00:00	ES	Futures	2148.92	2149.44	2148.66	2149.18	1399.0
2014-11-20 22:00:00	ES	Futures	2149.44	2151.28	2149.18	2150.23	3361.0
2014-11-20 23:00:00	ES	Futures	2150.23	2151.28	2149.7	2151.01	2431.0
2014-11-20 00:00:00	NQ	Futures	4945.06	4947.11	4943.01	4943.3	705.0
2014-11-20 01:00:00	NQ	Futures	4943.59	4949.16	4943.59	4948.57	287.0
2014-11-20 02:00:00	NQ	Futures	4947.99	4950.04	4943.3	4945.06	777.0
2014-11-20 03:00:00	NQ	Futures	4945.06	4945.06	4933.04	4933.04	4655.0
2014-11-20 04:00:00	NQ	Futures	4933.04	4935.1	4928.94	4931.58	3271.0
2014-11-20 05:00:00	NQ	Futures	4931.87	4932.46	4927.18	4928.06	2473.0
2014-11-20 06:00:00	NQ	Futures	4928.36	4932.75	4924.84	4928.06	4589.0
2014-11-20 07:00:00	NQ	Futures	4928.06	4932.75	4926.6	4930.7	2483.0
2014-11-20 08:00:00	NQ	Futures	4930.99	4935.68	4927.48	4928.65	7187.0
2014-11-20 09:00:00	NQ	Futures	4928.65	4953.55	4924.55	4953.26	44760.0
2014-11-20 10:00:00	NQ	Futures	4952.97	4967.62	4948.87	4965.86	45964.0
2014-11-20 11:00:00	NQ	Futures	4965.86	4975.24	4965.57	4970.55	21247.0
2014-11-20 12:00:00	NQ	Futures	4970.55	4975.53	4966.74	4973.19	15479.0
2014-11-20 13:00:00	NQ	Futures	4973.19	4974.07	4966.15	4971.43	12125.0
2014-11-20 14:00:00	NQ	Futures	4971.43	4977.0	4967.62	4967.91	12455.0
2014-11-20 15:00:00	NQ	Futures	4967.91	4973.77	4965.27	4973.48	24238.0
2014-11-20 16:00:00	NQ	Futures	4973.19	4979.05	4970.55	4976.41	6997.0
2014-11-20 17:00:00	NQ	Futures	4976.7	4977.29	4975.24	4975.53	260.0
2014-11-20 18:00:00	NQ	Futures	4975.82	4976.12	4970.84	4971.14	898.0
2014-11-20 19:00:00	NQ	Futures	4971.14	4972.31	4967.91	4971.72	2030.0
2014-11-20 20:00:00	NQ	Futures	4971.72	4972.31	4970.26	4970.55	345.0
2014-11-20 21:00:00	NQ	Futures	4971.14	4972.31	4970.26	4971.72	273.0
2014-11-20 22:00:00	NQ	Futures	4971.43	4976.12	4971.43	4974.07	788.0
2014-11-20 23:00:00	NQ	Futures	4974.07	4977.87	4973.19	4977.29	586.0
2014-11-20 00:00:00	YM	Futures	18331.0	18337.3	18328.9	18328.9	426.0
2014-11-20 01:00:00	YM	Futures	18330.0	18345.6	18327.9	18341.4	381.0

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

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