PREVIEW / futures_1hour / 2015-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-09.parquet
  size:    44 KB
  rows:    1,288

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-09 00:00:00	ES	Futures	2159.95	2160.74	2158.9	2160.48	2361.0
2015-01-09 01:00:00	ES	Futures	2160.74	2161.0	2159.16	2159.69	2057.0
2015-01-09 02:00:00	ES	Futures	2159.69	2161.0	2157.58	2158.37	10734.0
2015-01-09 03:00:00	ES	Futures	2158.37	2161.53	2157.58	2161.0	18913.0
2015-01-09 04:00:00	ES	Futures	2160.74	2163.11	2158.37	2158.9	15916.0
2015-01-09 05:00:00	ES	Futures	2159.16	2160.74	2158.37	2160.21	10955.0
2015-01-09 06:00:00	ES	Futures	2160.21	2161.53	2154.95	2156.53	20709.0
2015-01-09 07:00:00	ES	Futures	2156.53	2158.37	2154.69	2155.21	25324.0
2015-01-09 08:00:00	ES	Futures	2155.48	2170.48	2153.9	2165.48	146324.0
2015-01-09 09:00:00	ES	Futures	2165.48	2169.42	2152.32	2154.42	284864.0
2015-01-09 10:00:00	ES	Futures	2154.42	2160.21	2143.11	2148.11	332455.0
2015-01-09 11:00:00	ES	Futures	2148.11	2149.16	2138.11	2148.63	286353.0
2015-01-09 12:00:00	ES	Futures	2148.63	2152.58	2143.64	2144.16	155430.0
2015-01-09 13:00:00	ES	Futures	2144.16	2150.48	2142.58	2147.32	124048.0
2015-01-09 14:00:00	ES	Futures	2147.32	2150.21	2144.42	2148.37	127461.0
2015-01-09 15:00:00	ES	Futures	2148.63	2154.69	2144.95	2144.95	235543.0
2015-01-09 16:00:00	ES	Futures	2145.21	2145.21	2141.53	2141.79	84659.0
2015-01-09 17:00:00	ES	Futures	2141.79	2142.06	2140.48	2140.48	1489.0
2015-01-09 00:00:00	NQ	Futures	4970.09	4972.44	4967.74	4972.44	598.0
2015-01-09 01:00:00	NQ	Futures	4972.73	4973.32	4968.91	4970.38	312.0
2015-01-09 02:00:00	NQ	Futures	4970.38	4972.73	4965.1	4966.86	1157.0
2015-01-09 03:00:00	NQ	Futures	4966.86	4975.08	4964.51	4973.61	3629.0
2015-01-09 04:00:00	NQ	Futures	4974.2	4977.72	4965.39	4967.45	1888.0
2015-01-09 05:00:00	NQ	Futures	4968.03	4970.38	4965.39	4968.62	1252.0
2015-01-09 06:00:00	NQ	Futures	4968.62	4972.73	4960.4	4963.92	3093.0
2015-01-09 07:00:00	NQ	Futures	4964.21	4968.03	4959.22	4960.4	2582.0
2015-01-09 08:00:00	NQ	Futures	4960.69	4995.64	4958.05	4985.65	22410.0
2015-01-09 09:00:00	NQ	Futures	4985.65	4990.94	4960.69	4966.86	48670.0
2015-01-09 10:00:00	NQ	Futures	4967.15	4978.61	4930.44	4942.48	63346.0
2015-01-09 11:00:00	NQ	Futures	4942.19	4945.13	4911.64	4943.66	55859.0
2015-01-09 12:00:00	NQ	Futures	4943.36	4961.28	4936.61	4937.78	35172.0
2015-01-09 13:00:00	NQ	Futures	4937.78	4953.94	4933.38	4947.18	22832.0
2015-01-09 14:00:00	NQ	Futures	4946.59	4955.4	4941.01	4954.52	20457.0
2015-01-09 15:00:00	NQ	Futures	4954.23	4966.56	4939.84	4940.43	42668.0
2015-01-09 16:00:00	NQ	Futures	4940.72	4940.72	4934.26	4935.73	10204.0
2015-01-09 17:00:00	NQ	Futures	4935.73	4935.73	4932.5	4932.5	418.0
2015-01-09 00:00:00	YM	Futures	18582.1	18590.4	18573.7	18590.4	351.0
2015-01-09 01:00:00	YM	Futures	18590.4	18592.5	18576.8	18581.0	378.0
2015-01-09 02:00:00	YM	Futures	18580.0	18589.4	18561.2	18564.3	1127.0
2015-01-09 03:00:00	YM	Futures	18565.4	18592.5	18559.1	18584.1	3505.0
2015-01-09 04:00:00	YM	Futures	18584.1	18597.7	18556.0	18565.4	3617.0
2015-01-09 05:00:00	YM	Futures	18565.4	18577.9	18558.1	18568.5	2377.0
2015-01-09 06:00:00	YM	Futures	18568.5	18577.9	18535.1	18547.6	3868.0
2015-01-09 07:00:00	YM	Futures	18548.7	18562.2	18535.1	18538.2	3528.0
2015-01-09 08:00:00	YM	Futures	18538.2	18647.8	18525.7	18612.3	14980.0
2015-01-09 09:00:00	YM	Futures	18609.2	18636.3	18499.6	18519.4	27579.0
2015-01-09 10:00:00	YM	Futures	18517.3	18571.6	18428.6	18470.4	33696.0
2015-01-09 11:00:00	YM	Futures	18468.3	18474.5	18384.8	18468.3	26532.0
2015-01-09 12:00:00	YM	Futures	18467.2	18499.6	18431.7	18434.9	15524.0
2015-01-09 13:00:00	YM	Futures	18433.8	18492.3	18426.5	18463.1	14831.0

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

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