PREVIEW / futures_1hour / 2015-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-27.parquet
  size:    52 KB
  rows:    1,582

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
2015-01-27 00:00:00	ES	Futures	2161.27	2162.85	2160.21	2162.32	3461.0
2015-01-27 01:00:00	ES	Futures	2162.58	2162.58	2160.21	2160.74	3970.0
2015-01-27 02:00:00	ES	Futures	2160.74	2160.74	2158.63	2158.63	6668.0
2015-01-27 03:00:00	ES	Futures	2158.63	2161.79	2154.69	2156.27	21927.0
2015-01-27 04:00:00	ES	Futures	2156.27	2156.27	2152.85	2153.11	12379.0
2015-01-27 05:00:00	ES	Futures	2153.37	2155.48	2151.79	2152.32	8102.0
2015-01-27 06:00:00	ES	Futures	2152.06	2153.63	2149.42	2151.53	16270.0
2015-01-27 07:00:00	ES	Futures	2151.53	2151.79	2143.9	2145.48	35009.0
2015-01-27 08:00:00	ES	Futures	2145.48	2145.74	2131.79	2135.74	93660.0
2015-01-27 09:00:00	ES	Futures	2135.48	2137.06	2127.85	2130.74	300996.0
2015-01-27 10:00:00	ES	Futures	2130.74	2134.95	2119.16	2123.9	390142.0
2015-01-27 11:00:00	ES	Futures	2124.16	2131.79	2122.58	2126.53	228830.0
2015-01-27 12:00:00	ES	Futures	2126.53	2134.95	2126.0	2134.95	149042.0
2015-01-27 13:00:00	ES	Futures	2134.69	2140.48	2132.85	2135.74	156248.0
2015-01-27 14:00:00	ES	Futures	2135.74	2144.16	2135.48	2136.53	153156.0
2015-01-27 15:00:00	ES	Futures	2136.53	2138.9	2128.37	2129.42	230429.0
2015-01-27 16:00:00	ES	Futures	2129.42	2146.27	2129.42	2144.95	118019.0
2015-01-27 17:00:00	ES	Futures	2144.69	2144.95	2142.58	2143.64	2300.0
2015-01-27 18:00:00	ES	Futures	2143.64	2144.69	2141.0	2142.06	6250.0
2015-01-27 19:00:00	ES	Futures	2142.32	2142.58	2139.69	2142.32	6338.0
2015-01-27 20:00:00	ES	Futures	2142.32	2144.42	2141.79	2142.85	5305.0
2015-01-27 21:00:00	ES	Futures	2142.85	2144.16	2141.53	2143.9	2484.0
2015-01-27 22:00:00	ES	Futures	2143.9	2153.37	2142.85	2151.79	11800.0
2015-01-27 23:00:00	ES	Futures	2152.06	2154.16	2150.74	2151.0	7334.0
2015-01-27 00:00:00	NQ	Futures	5012.67	5017.37	5010.91	5017.08	509.0
2015-01-27 01:00:00	NQ	Futures	5016.79	5017.08	5011.21	5012.97	483.0
2015-01-27 02:00:00	NQ	Futures	5012.38	5012.67	5008.27	5008.56	963.0
2015-01-27 03:00:00	NQ	Futures	5008.56	5016.49	4999.16	5001.81	3306.0
2015-01-27 04:00:00	NQ	Futures	5002.39	5002.98	4993.88	4994.76	2048.0
2015-01-27 05:00:00	NQ	Futures	4995.05	5000.63	4990.06	4990.35	1474.0
2015-01-27 06:00:00	NQ	Futures	4990.35	4993.58	4979.49	4984.77	4808.0
2015-01-27 07:00:00	NQ	Futures	4984.77	4985.65	4964.51	4970.09	7089.0
2015-01-27 08:00:00	NQ	Futures	4970.09	4971.85	4936.31	4943.95	14496.0
2015-01-27 09:00:00	NQ	Futures	4944.54	4946.59	4904.3	4908.71	61164.0
2015-01-27 10:00:00	NQ	Futures	4908.71	4917.52	4866.71	4885.21	78087.0
2015-01-27 11:00:00	NQ	Futures	4884.92	4905.48	4881.1	4891.09	40396.0
2015-01-27 12:00:00	NQ	Futures	4891.09	4911.94	4890.21	4909.0	24493.0
2015-01-27 13:00:00	NQ	Futures	4909.0	4928.09	4906.36	4916.05	28603.0
2015-01-27 14:00:00	NQ	Futures	4915.76	4936.9	4915.17	4916.64	26463.0
2015-01-27 15:00:00	NQ	Futures	4916.93	4923.1	4881.98	4885.21	43623.0
2015-01-27 16:00:00	NQ	Futures	4885.51	4948.94	4883.74	4945.71	22159.0
2015-01-27 17:00:00	NQ	Futures	4944.83	4945.42	4937.49	4942.78	1283.0
2015-01-27 18:00:00	NQ	Futures	4941.01	4942.48	4934.55	4940.72	1782.0
2015-01-27 19:00:00	NQ	Futures	4941.01	4941.6	4935.43	4940.13	1458.0
2015-01-27 20:00:00	NQ	Futures	4940.13	4946.3	4939.84	4942.19	1715.0
2015-01-27 21:00:00	NQ	Futures	4942.48	4946.01	4940.72	4945.71	913.0
2015-01-27 22:00:00	NQ	Futures	4945.71	4969.21	4943.36	4967.15	2957.0
2015-01-27 23:00:00	NQ	Futures	4967.45	4973.91	4966.56	4968.33	2045.0
2015-01-27 00:00:00	YM	Futures	18378.5	18395.2	18375.4	18395.2	430.0
2015-01-27 01:00:00	YM	Futures	18395.2	18395.2	18376.4	18381.6	416.0

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

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