PREVIEW / stock_5min / 2011-04-01

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-01.parquet
  size:    5.0 MB
  rows:    336,025
  symbols: 3,534

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
2011-04-01 05:00:00	AAPL	Stock	12.4786	12.4786	12.4786	12.4786	2800.0
2011-04-01 06:10:00	AAPL	Stock	12.4707	12.4707	12.4707	12.4707	2800.0
2011-04-01 07:00:00	AAPL	Stock	12.4796	12.5179	12.4796	12.5179	46900.0
2011-04-01 07:05:00	AAPL	Stock	12.5093	12.5093	12.4857	12.4964	17780.0
2011-04-01 07:15:00	AAPL	Stock	12.5079	12.5079	12.4964	12.4964	5600.0
2011-04-01 07:20:00	AAPL	Stock	12.4996	12.5036	12.4996	12.5036	13300.0
2011-04-01 07:25:00	AAPL	Stock	12.5	12.5	12.4968	12.4968	47600.0
2011-04-01 07:30:00	AAPL	Stock	12.4968	12.4996	12.4893	12.4996	67200.0
2011-04-01 07:35:00	AAPL	Stock	12.4914	12.4914	12.4732	12.4732	36820.0
2011-04-01 07:40:00	AAPL	Stock	12.475	12.4857	12.475	12.4857	5600.0
2011-04-01 07:50:00	AAPL	Stock	12.4911	12.4911	12.4911	12.4911	11228.0
2011-04-01 07:55:00	AAPL	Stock	12.4907	12.4907	12.4907	12.4907	3500.0
2011-04-01 08:00:00	AAPL	Stock	12.4893	12.5	12.4446	12.4896	586992.0
2011-04-01 08:05:00	AAPL	Stock	12.4875	12.4946	12.4857	12.4946	102536.0
2011-04-01 08:10:00	AAPL	Stock	12.4946	12.4964	12.4446	12.4964	175784.0
2011-04-01 08:15:00	AAPL	Stock	12.4957	12.4964	12.4861	12.4964	62888.0
2011-04-01 08:20:00	AAPL	Stock	12.4961	12.4961	12.4839	12.4857	53200.0
2011-04-01 08:25:00	AAPL	Stock	12.4857	12.4857	12.4768	12.4857	46480.0
2011-04-01 08:30:00	AAPL	Stock	12.4907	12.5079	12.4875	12.5071	546168.0
2011-04-01 08:35:00	AAPL	Stock	12.5079	12.5407	12.5039	12.5361	463708.0
2011-04-01 08:40:00	AAPL	Stock	12.5325	12.5386	12.5218	12.5268	287000.0
2011-04-01 08:45:00	AAPL	Stock	12.5271	12.5536	12.5271	12.5464	479696.0
2011-04-01 08:50:00	AAPL	Stock	12.5457	12.5468	12.54	12.5411	312760.0
2011-04-01 08:55:00	AAPL	Stock	12.54	12.5443	12.5332	12.5332	173040.0
2011-04-01 09:00:00	AAPL	Stock	12.5329	12.5414	12.5179	12.5232	324464.0
2011-04-01 09:05:00	AAPL	Stock	12.5236	12.5307	12.4446	12.5304	151564.0
2011-04-01 09:10:00	AAPL	Stock	12.53	12.5357	12.5286	12.5286	155540.0
2011-04-01 09:15:00	AAPL	Stock	12.5293	12.5389	12.5286	12.5357	291704.0
2011-04-01 09:20:00	AAPL	Stock	12.5382	12.5482	12.5382	12.5429	178920.0
2011-04-01 09:25:00	AAPL	Stock	12.5439	12.5439	12.5364	12.5396	287364.0
2011-04-01 09:30:00	AAPL	Stock	12.5396	12.5567	12.4693	12.4956	21450268.0
2011-04-01 09:35:00	AAPL	Stock	12.4954	12.4964	12.4732	12.4911	10769108.0
2011-04-01 09:40:00	AAPL	Stock	12.4914	12.5061	12.47	12.4811	9379944.0
2011-04-01 09:45:00	AAPL	Stock	12.4811	12.4829	12.4543	12.461	9275868.0
2011-04-01 09:50:00	AAPL	Stock	12.4611	12.4668	12.4336	12.4464	8740648.0
2011-04-01 09:55:00	AAPL	Stock	12.4471	12.4643	12.4375	12.4529	6208860.0
2011-04-01 10:00:00	AAPL	Stock	12.4545	12.475	12.4511	12.4687	5077856.0
2011-04-01 10:05:00	AAPL	Stock	12.47	12.4814	12.4525	12.4725	5920964.0
2011-04-01 10:10:00	AAPL	Stock	12.4725	12.4893	12.4711	12.4739	5722556.0
2011-04-01 10:15:00	AAPL	Stock	12.4754	12.4893	12.4664	12.4843	3956176.0
2011-04-01 10:20:00	AAPL	Stock	12.4832	12.4864	12.4696	12.4771	4609472.0
2011-04-01 10:25:00	AAPL	Stock	12.4771	12.4836	12.4704	12.478	3680908.0
2011-04-01 10:30:00	AAPL	Stock	12.4779	12.4929	12.4779	12.4811	5128032.0
2011-04-01 10:35:00	AAPL	Stock	12.4814	12.4843	12.4721	12.4795	3147480.0
2011-04-01 10:40:00	AAPL	Stock	12.4796	12.48	12.4596	12.4625	4487700.0
2011-04-01 10:45:00	AAPL	Stock	12.4612	12.4621	12.44	12.4443	4989712.0
2011-04-01 10:50:00	AAPL	Stock	12.4443	12.461	12.4419	12.4564	3793720.0
2011-04-01 10:55:00	AAPL	Stock	12.4561	12.4643	12.4521	12.4643	2784684.0
2011-04-01 11:00:00	AAPL	Stock	12.4639	12.4714	12.4582	12.4664	2716560.0
2011-04-01 11:05:00	AAPL	Stock	12.4667	12.4673	12.4586	12.4621	2270464.0

> showing 50 of 336,025 rows — these rows as CSV

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