PREVIEW / stock_5min / 2009-09-25

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-25.parquet
  size:    4.6 MB
  rows:    317,452
  symbols: 3,390

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
2009-09-25 06:30:00	AAPL	Stock	6.4996	6.4996	6.4996	6.4996	2800.0
2009-09-25 07:00:00	AAPL	Stock	6.4661	6.4661	6.4643	6.4643	102704.0
2009-09-25 07:05:00	AAPL	Stock	6.4643	6.4732	6.4643	6.4721	36400.0
2009-09-25 07:10:00	AAPL	Stock	6.4786	6.4786	6.4786	6.4786	5600.0
2009-09-25 07:15:00	AAPL	Stock	6.4786	6.4786	6.4786	6.4786	57960.0
2009-09-25 07:20:00	AAPL	Stock	6.4786	6.4786	6.4768	6.4786	16800.0
2009-09-25 07:25:00	AAPL	Stock	6.4786	6.4786	6.4786	6.4786	14000.0
2009-09-25 07:30:00	AAPL	Stock	6.4786	6.4786	6.4786	6.4786	27440.0
2009-09-25 07:45:00	AAPL	Stock	6.4929	6.4929	6.4929	6.4929	28840.0
2009-09-25 07:50:00	AAPL	Stock	6.4929	6.5	6.4929	6.5	172480.0
2009-09-25 07:55:00	AAPL	Stock	6.5	6.5	6.4932	6.4932	70560.0
2009-09-25 08:00:00	AAPL	Stock	6.4864	6.5179	6.4857	6.5	209692.0
2009-09-25 08:05:00	AAPL	Stock	6.4996	6.5071	6.4982	6.5071	140000.0
2009-09-25 08:10:00	AAPL	Stock	6.5089	6.515	6.5	6.5	141820.0
2009-09-25 08:15:00	AAPL	Stock	6.5	6.5036	6.5	6.5	32396.0
2009-09-25 08:20:00	AAPL	Stock	6.5032	6.5032	6.4929	6.4964	67200.0
2009-09-25 08:25:00	AAPL	Stock	6.4982	6.5179	6.4982	6.5179	165060.0
2009-09-25 08:30:00	AAPL	Stock	6.5132	6.5132	6.49	6.5	491596.0
2009-09-25 08:35:00	AAPL	Stock	6.5004	6.5011	6.4804	6.4804	311836.0
2009-09-25 08:40:00	AAPL	Stock	6.4793	6.4829	6.475	6.4821	469588.0
2009-09-25 08:45:00	AAPL	Stock	6.4829	6.4946	6.4829	6.4946	158872.0
2009-09-25 08:50:00	AAPL	Stock	6.4968	6.4968	6.4929	6.4929	293160.0
2009-09-25 08:55:00	AAPL	Stock	6.4946	6.4964	6.4918	6.4929	130452.0
2009-09-25 09:00:00	AAPL	Stock	6.4929	6.4957	6.4918	6.4929	115276.0
2009-09-25 09:05:00	AAPL	Stock	6.4929	6.4954	6.4821	6.4829	576856.0
2009-09-25 09:10:00	AAPL	Stock	6.485	6.4893	6.4839	6.4846	294980.0
2009-09-25 09:15:00	AAPL	Stock	6.4839	6.4911	6.4829	6.4911	129500.0
2009-09-25 09:20:00	AAPL	Stock	6.4893	6.4925	6.4879	6.4921	94696.0
2009-09-25 09:25:00	AAPL	Stock	6.4936	6.5054	6.4936	6.5	839356.0
2009-09-25 09:30:00	AAPL	Stock	6.5004	6.5518	6.4907	6.55	22582308.0
2009-09-25 09:35:00	AAPL	Stock	6.55	6.5768	6.5282	6.545	20749680.0
2009-09-25 09:40:00	AAPL	Stock	6.5468	6.5982	6.5407	6.59	20951140.0
2009-09-25 09:45:00	AAPL	Stock	6.59	6.6014	6.5839	6.5918	19656672.0
2009-09-25 09:50:00	AAPL	Stock	6.5914	6.5979	6.5682	6.5768	11588164.0
2009-09-25 09:55:00	AAPL	Stock	6.5764	6.6193	6.5732	6.5914	15441160.0
2009-09-25 10:00:00	AAPL	Stock	6.5907	6.6104	6.5739	6.5932	11575928.0
2009-09-25 10:05:00	AAPL	Stock	6.5936	6.6057	6.5896	6.6036	6306328.0
2009-09-25 10:10:00	AAPL	Stock	6.6036	6.625	6.6021	6.605	11803036.0
2009-09-25 10:15:00	AAPL	Stock	6.6061	6.6161	6.5954	6.5986	7558992.0
2009-09-25 10:20:00	AAPL	Stock	6.5982	6.6218	6.5954	6.5975	7027636.0
2009-09-25 10:25:00	AAPL	Stock	6.5975	6.6039	6.5957	6.5975	5783316.0
2009-09-25 10:30:00	AAPL	Stock	6.5986	6.6093	6.5904	6.5904	5022948.0
2009-09-25 10:35:00	AAPL	Stock	6.5904	6.5946	6.575	6.575	5902344.0
2009-09-25 10:40:00	AAPL	Stock	6.575	6.59	6.5718	6.5757	4688656.0
2009-09-25 10:45:00	AAPL	Stock	6.5754	6.5968	6.5754	6.5911	4217724.0
2009-09-25 10:50:00	AAPL	Stock	6.5911	6.5982	6.5825	6.5918	3204236.0
2009-09-25 10:55:00	AAPL	Stock	6.5929	6.6021	6.5904	6.5971	3276112.0
2009-09-25 11:00:00	AAPL	Stock	6.5972	6.5982	6.5861	6.5936	2851128.0
2009-09-25 11:05:00	AAPL	Stock	6.5936	6.6036	6.5918	6.5969	3219580.0
2009-09-25 11:10:00	AAPL	Stock	6.5964	6.6	6.5782	6.5871	7061992.0

> showing 50 of 317,452 rows — these rows as CSV

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