PREVIEW / futures_1hour / 2014-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-12.parquet
  size:    43 KB
  rows:    1,245

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-12-12 00:00:00	ES	Futures	2123.51	2124.82	2122.98	2124.56	2000.0
2014-12-12 01:00:00	ES	Futures	2124.56	2125.34	2121.67	2122.2	2446.0
2014-12-12 02:00:00	ES	Futures	2122.2	2127.18	2118.79	2126.39	15013.0
2014-12-12 03:00:00	ES	Futures	2126.39	2129.01	2117.22	2117.48	27607.0
2014-12-12 04:00:00	ES	Futures	2117.74	2118.53	2113.03	2115.12	29832.0
2014-12-12 05:00:00	ES	Futures	2114.86	2117.48	2113.03	2113.55	18021.0
2014-12-12 06:00:00	ES	Futures	2113.81	2117.48	2113.03	2116.96	10958.0
2014-12-12 07:00:00	ES	Futures	2116.96	2120.89	2116.43	2118.01	16583.0
2014-12-12 08:00:00	ES	Futures	2118.01	2120.89	2114.08	2116.96	35701.0
2014-12-12 09:00:00	ES	Futures	2116.96	2129.53	2114.86	2128.48	126493.0
2014-12-12 10:00:00	ES	Futures	2128.48	2129.27	2111.98	2112.77	125701.0
2014-12-12 11:00:00	ES	Futures	2113.03	2116.43	2108.05	2109.1	125008.0
2014-12-12 12:00:00	ES	Futures	2109.1	2118.01	2108.84	2114.6	61952.0
2014-12-12 13:00:00	ES	Futures	2114.86	2122.98	2111.98	2121.41	48715.0
2014-12-12 14:00:00	ES	Futures	2121.15	2121.41	2111.98	2116.17	39723.0
2014-12-12 15:00:00	ES	Futures	2116.17	2117.48	2097.83	2098.1	148511.0
2014-12-12 16:00:00	ES	Futures	2098.36	2098.62	2092.07	2094.43	78183.0
2014-12-12 17:00:00	ES	Futures	2094.43	2095.74	2094.17	2095.22	1854.0
2014-12-12 00:00:00	NQ	Futures	4953.26	4957.36	4952.97	4955.61	418.0
2014-12-12 01:00:00	NQ	Futures	4955.61	4957.95	4950.04	4950.62	253.0
2014-12-12 02:00:00	NQ	Futures	4951.21	4960.0	4942.71	4957.95	1768.0
2014-12-12 03:00:00	NQ	Futures	4957.07	4964.1	4933.34	4936.56	3194.0
2014-12-12 04:00:00	NQ	Futures	4935.39	4936.85	4915.46	4926.01	6368.0
2014-12-12 05:00:00	NQ	Futures	4925.43	4933.34	4919.27	4924.84	3252.0
2014-12-12 06:00:00	NQ	Futures	4924.25	4933.63	4923.08	4931.58	1463.0
2014-12-12 07:00:00	NQ	Futures	4931.87	4944.47	4930.99	4937.44	2319.0
2014-12-12 08:00:00	NQ	Futures	4937.73	4948.28	4925.13	4936.56	6218.0
2014-12-12 09:00:00	NQ	Futures	4937.44	4986.66	4925.43	4984.32	32592.0
2014-12-12 10:00:00	NQ	Futures	4984.61	4986.66	4943.01	4945.64	26227.0
2014-12-12 11:00:00	NQ	Futures	4945.64	4969.67	4936.27	4950.62	24895.0
2014-12-12 12:00:00	NQ	Futures	4951.21	4967.03	4946.23	4955.61	14155.0
2014-12-12 13:00:00	NQ	Futures	4955.9	4981.98	4951.21	4978.75	7608.0
2014-12-12 14:00:00	NQ	Futures	4978.17	4979.63	4953.26	4962.34	5297.0
2014-12-12 15:00:00	NQ	Futures	4962.34	4966.45	4923.08	4923.08	16420.0
2014-12-12 16:00:00	NQ	Futures	4923.08	4923.96	4908.43	4912.53	7342.0
2014-12-12 17:00:00	NQ	Futures	4911.65	4916.05	4911.36	4916.05	50.0
2014-12-12 00:00:00	YM	Futures	18236.5	18250.1	18231.3	18241.8	615.0
2014-12-12 01:00:00	YM	Futures	18242.8	18249.1	18219.8	18219.8	504.0
2014-12-12 02:00:00	YM	Futures	18221.9	18259.5	18194.8	18252.2	2168.0
2014-12-12 03:00:00	YM	Futures	18252.2	18274.1	18170.8	18174.9	6301.0
2014-12-12 04:00:00	YM	Futures	18174.9	18180.2	18138.4	18144.7	3495.0
2014-12-12 05:00:00	YM	Futures	18144.7	18167.6	18134.2	18143.6	2151.0
2014-12-12 06:00:00	YM	Futures	18142.6	18177.0	18139.5	18169.7	1918.0
2014-12-12 07:00:00	YM	Futures	18168.7	18199.0	18168.7	18173.9	2130.0
2014-12-12 08:00:00	YM	Futures	18173.9	18195.8	18146.8	18165.6	4577.0
2014-12-12 09:00:00	YM	Futures	18165.6	18269.9	18149.9	18263.7	22636.0
2014-12-12 10:00:00	YM	Futures	18264.7	18271.0	18116.5	18122.8	26318.0
2014-12-12 11:00:00	YM	Futures	18122.8	18144.7	18053.9	18058.0	25915.0
2014-12-12 12:00:00	YM	Futures	18059.1	18124.8	18054.9	18094.6	13912.0
2014-12-12 13:00:00	YM	Futures	18095.6	18144.7	18070.6	18133.2	12180.0

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

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