PREVIEW / futures_1hour / 2015-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-09.parquet
  size:    51 KB
  rows:    1,572

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-02-09 00:00:00	ES	Futures	2151.0	2153.11	2150.74	2152.32	2213.0
2015-02-09 01:00:00	ES	Futures	2152.58	2154.16	2152.06	2152.85	3429.0
2015-02-09 02:00:00	ES	Futures	2152.85	2154.69	2152.06	2154.16	7344.0
2015-02-09 03:00:00	ES	Futures	2154.42	2154.69	2146.79	2148.37	35981.0
2015-02-09 04:00:00	ES	Futures	2148.37	2150.21	2147.85	2148.9	16312.0
2015-02-09 05:00:00	ES	Futures	2148.63	2153.11	2147.32	2151.0	11604.0
2015-02-09 06:00:00	ES	Futures	2151.0	2152.32	2147.06	2147.06	12179.0
2015-02-09 07:00:00	ES	Futures	2147.06	2152.58	2146.79	2151.53	15671.0
2015-02-09 08:00:00	ES	Futures	2151.53	2152.32	2146.0	2149.69	32529.0
2015-02-09 09:00:00	ES	Futures	2149.69	2159.42	2148.63	2156.53	213675.0
2015-02-09 10:00:00	ES	Futures	2156.53	2158.11	2149.69	2150.21	188787.0
2015-02-09 11:00:00	ES	Futures	2150.21	2158.63	2149.95	2155.74	129382.0
2015-02-09 12:00:00	ES	Futures	2155.74	2159.69	2153.9	2155.74	108296.0
2015-02-09 13:00:00	ES	Futures	2156.0	2157.32	2150.74	2153.11	88767.0
2015-02-09 14:00:00	ES	Futures	2153.11	2153.37	2147.85	2148.37	121236.0
2015-02-09 15:00:00	ES	Futures	2148.37	2152.32	2143.64	2148.37	202498.0
2015-02-09 16:00:00	ES	Futures	2148.63	2151.27	2147.58	2150.21	46503.0
2015-02-09 17:00:00	ES	Futures	2150.48	2151.53	2149.95	2151.27	2550.0
2015-02-09 18:00:00	ES	Futures	2151.27	2153.37	2151.0	2152.32	4638.0
2015-02-09 19:00:00	ES	Futures	2152.32	2153.37	2151.0	2152.32	3505.0
2015-02-09 20:00:00	ES	Futures	2152.06	2153.63	2151.53	2151.79	2752.0
2015-02-09 21:00:00	ES	Futures	2152.06	2152.58	2151.53	2152.58	699.0
2015-02-09 22:00:00	ES	Futures	2152.58	2153.11	2151.27	2151.79	2681.0
2015-02-09 23:00:00	ES	Futures	2151.79	2152.06	2151.0	2151.27	1723.0
2015-02-09 00:00:00	NQ	Futures	4946.89	4953.94	4946.59	4952.76	605.0
2015-02-09 01:00:00	NQ	Futures	4952.76	4956.29	4952.76	4954.52	612.0
2015-02-09 02:00:00	NQ	Futures	4953.94	4957.17	4951.0	4955.99	694.0
2015-02-09 03:00:00	NQ	Futures	4956.29	4957.75	4936.9	4941.89	5406.0
2015-02-09 04:00:00	NQ	Futures	4941.6	4944.54	4937.49	4940.13	2734.0
2015-02-09 05:00:00	NQ	Futures	4939.84	4951.59	4936.9	4946.59	2004.0
2015-02-09 06:00:00	NQ	Futures	4946.3	4948.36	4936.31	4936.61	1979.0
2015-02-09 07:00:00	NQ	Futures	4936.31	4949.53	4936.31	4947.47	2586.0
2015-02-09 08:00:00	NQ	Futures	4947.77	4950.12	4935.73	4942.78	6528.0
2015-02-09 09:00:00	NQ	Futures	4943.07	4964.21	4940.13	4956.29	37031.0
2015-02-09 10:00:00	NQ	Futures	4956.58	4960.98	4936.02	4938.37	31763.0
2015-02-09 11:00:00	NQ	Futures	4938.66	4963.33	4937.78	4956.58	18204.0
2015-02-09 12:00:00	NQ	Futures	4956.58	4971.56	4953.35	4965.39	15174.0
2015-02-09 13:00:00	NQ	Futures	4965.68	4969.21	4953.64	4957.75	13723.0
2015-02-09 14:00:00	NQ	Futures	4957.75	4959.81	4945.42	4946.3	16011.0
2015-02-09 15:00:00	NQ	Futures	4946.3	4959.22	4938.37	4947.47	31335.0
2015-02-09 16:00:00	NQ	Futures	4947.47	4954.82	4946.01	4953.94	4964.0
2015-02-09 17:00:00	NQ	Futures	4953.94	4955.99	4953.35	4954.82	90.0
2015-02-09 18:00:00	NQ	Futures	4956.29	4959.52	4956.29	4958.63	542.0
2015-02-09 19:00:00	NQ	Futures	4958.93	4960.4	4953.94	4956.87	541.0
2015-02-09 20:00:00	NQ	Futures	4956.87	4959.81	4955.7	4956.29	615.0
2015-02-09 21:00:00	NQ	Futures	4956.29	4958.05	4955.4	4957.75	297.0
2015-02-09 22:00:00	NQ	Futures	4958.05	4958.34	4953.05	4955.11	668.0
2015-02-09 23:00:00	NQ	Futures	4954.82	4955.99	4952.76	4954.52	209.0
2015-02-09 00:00:00	YM	Futures	18488.1	18510.0	18488.1	18502.7	352.0
2015-02-09 01:00:00	YM	Futures	18506.9	18517.3	18503.8	18506.9	501.0

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

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