PREVIEW / futures_1hour / 2015-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-08.parquet
  size:    51 KB
  rows:    1,571

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-08 00:00:00	ES	Futures	2140.48	2141.27	2138.9	2140.48	4219.0
2015-01-08 01:00:00	ES	Futures	2139.95	2142.58	2139.95	2141.0	3489.0
2015-01-08 02:00:00	ES	Futures	2140.74	2141.53	2138.37	2140.21	10983.0
2015-01-08 03:00:00	ES	Futures	2140.48	2141.79	2137.32	2139.42	21115.0
2015-01-08 04:00:00	ES	Futures	2139.42	2140.74	2138.9	2139.42	11283.0
2015-01-08 05:00:00	ES	Futures	2139.69	2141.0	2138.37	2140.48	11887.0
2015-01-08 06:00:00	ES	Futures	2140.21	2146.27	2139.16	2144.42	27264.0
2015-01-08 07:00:00	ES	Futures	2144.69	2148.37	2142.85	2143.11	35740.0
2015-01-08 08:00:00	ES	Futures	2143.37	2145.74	2140.74	2142.58	39770.0
2015-01-08 09:00:00	ES	Futures	2142.32	2152.06	2141.53	2151.79	207163.0
2015-01-08 10:00:00	ES	Futures	2151.79	2159.42	2151.79	2159.16	286655.0
2015-01-08 11:00:00	ES	Futures	2159.42	2162.85	2158.9	2161.0	199484.0
2015-01-08 12:00:00	ES	Futures	2161.0	2161.79	2156.53	2161.27	104250.0
2015-01-08 13:00:00	ES	Futures	2161.27	2164.42	2158.11	2159.16	115081.0
2015-01-08 14:00:00	ES	Futures	2159.16	2166.79	2158.11	2164.16	127145.0
2015-01-08 15:00:00	ES	Futures	2164.16	2166.27	2160.74	2163.9	191647.0
2015-01-08 16:00:00	ES	Futures	2164.16	2164.69	2161.0	2161.27	77905.0
2015-01-08 17:00:00	ES	Futures	2161.53	2162.85	2161.27	2162.06	2292.0
2015-01-08 18:00:00	ES	Futures	2161.79	2162.85	2161.0	2161.79	3816.0
2015-01-08 19:00:00	ES	Futures	2162.06	2162.06	2160.74	2161.53	3745.0
2015-01-08 20:00:00	ES	Futures	2161.79	2161.79	2158.9	2159.95	5932.0
2015-01-08 21:00:00	ES	Futures	2159.95	2161.53	2159.69	2161.0	2216.0
2015-01-08 22:00:00	ES	Futures	2161.0	2161.53	2160.48	2161.0	2777.0
2015-01-08 23:00:00	ES	Futures	2161.0	2161.0	2158.9	2159.95	2719.0
2015-01-08 00:00:00	NQ	Futures	4915.76	4918.11	4911.06	4913.11	1562.0
2015-01-08 01:00:00	NQ	Futures	4912.82	4918.4	4912.53	4915.17	500.0
2015-01-08 02:00:00	NQ	Futures	4915.17	4915.76	4909.3	4913.41	1250.0
2015-01-08 03:00:00	NQ	Futures	4913.41	4918.4	4906.95	4912.23	2630.0
2015-01-08 04:00:00	NQ	Futures	4911.94	4916.34	4911.06	4913.41	1175.0
2015-01-08 05:00:00	NQ	Futures	4913.99	4917.22	4909.88	4914.88	1282.0
2015-01-08 06:00:00	NQ	Futures	4915.17	4926.92	4913.11	4921.34	3797.0
2015-01-08 07:00:00	NQ	Futures	4921.92	4930.15	4918.69	4920.16	3888.0
2015-01-08 08:00:00	NQ	Futures	4919.87	4923.1	4912.53	4916.93	5832.0
2015-01-08 09:00:00	NQ	Futures	4916.93	4943.36	4914.58	4943.07	44241.0
2015-01-08 10:00:00	NQ	Futures	4943.07	4969.21	4942.48	4969.21	48373.0
2015-01-08 11:00:00	NQ	Futures	4969.21	4976.55	4961.87	4969.5	33563.0
2015-01-08 12:00:00	NQ	Futures	4969.8	4975.38	4958.93	4973.91	18931.0
2015-01-08 13:00:00	NQ	Futures	4973.61	4984.19	4969.21	4972.44	23584.0
2015-01-08 14:00:00	NQ	Futures	4972.73	4984.19	4969.5	4978.02	18423.0
2015-01-08 15:00:00	NQ	Futures	4978.02	4982.72	4968.62	4974.2	36087.0
2015-01-08 16:00:00	NQ	Futures	4973.91	4975.08	4967.74	4969.8	10505.0
2015-01-08 17:00:00	NQ	Futures	4970.38	4973.91	4970.38	4973.32	379.0
2015-01-08 18:00:00	NQ	Futures	4971.85	4973.91	4970.38	4971.56	666.0
2015-01-08 19:00:00	NQ	Futures	4972.44	4973.61	4970.09	4973.03	554.0
2015-01-08 20:00:00	NQ	Futures	4972.73	4972.73	4967.74	4971.26	1734.0
2015-01-08 21:00:00	NQ	Futures	4971.26	4975.67	4970.97	4973.91	1147.0
2015-01-08 22:00:00	NQ	Futures	4973.61	4974.79	4972.44	4972.44	455.0
2015-01-08 23:00:00	NQ	Futures	4972.73	4972.73	4968.33	4970.09	566.0
2015-01-08 00:00:00	YM	Futures	18404.6	18410.9	18394.2	18404.6	679.0
2015-01-08 01:00:00	YM	Futures	18403.6	18422.3	18401.5	18410.9	567.0

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

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