PREVIEW / stock_5min / 2009-04-27

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-27.parquet
  size:    4.5 MB
  rows:    310,424
  symbols: 3,329

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-04-27 04:15:00	AAPL	Stock	4.4107	4.4107	4.3961	4.3961	7280.0
2009-04-27 04:25:00	AAPL	Stock	4.3961	4.3961	4.3961	4.3961	2800.0
2009-04-27 06:25:00	AAPL	Stock	4.3921	4.3921	4.3921	4.3921	28000.0
2009-04-27 06:55:00	AAPL	Stock	4.365	4.365	4.365	4.365	2800.0
2009-04-27 07:05:00	AAPL	Stock	4.37	4.3718	4.37	4.3718	16800.0
2009-04-27 07:50:00	AAPL	Stock	4.3857	4.3857	4.3857	4.3857	3332.0
2009-04-27 08:00:00	AAPL	Stock	4.3779	4.4214	4.3779	4.3804	215628.0
2009-04-27 08:05:00	AAPL	Stock	4.3893	4.3893	4.3786	4.3814	39760.0
2009-04-27 08:10:00	AAPL	Stock	4.3786	4.3786	4.3775	4.3775	7840.0
2009-04-27 08:15:00	AAPL	Stock	4.375	4.3775	4.375	4.3775	7112.0
2009-04-27 08:20:00	AAPL	Stock	4.3836	4.3857	4.3836	4.3857	9800.0
2009-04-27 08:25:00	AAPL	Stock	4.3857	4.3868	4.3857	4.3861	21560.0
2009-04-27 08:30:00	AAPL	Stock	4.39	4.39	4.3836	4.3854	54600.0
2009-04-27 08:35:00	AAPL	Stock	4.3836	4.3911	4.3836	4.3911	43708.0
2009-04-27 08:40:00	AAPL	Stock	4.3925	4.3996	4.3886	4.3989	36484.0
2009-04-27 08:45:00	AAPL	Stock	4.3989	4.3989	4.3932	4.3932	10976.0
2009-04-27 08:50:00	AAPL	Stock	4.3932	4.3964	4.3875	4.3875	68992.0
2009-04-27 08:55:00	AAPL	Stock	4.3886	4.3943	4.3886	4.3943	41216.0
2009-04-27 09:00:00	AAPL	Stock	4.3929	4.3989	4.3929	4.3964	44800.0
2009-04-27 09:05:00	AAPL	Stock	4.3943	4.3943	4.3943	4.3943	2800.0
2009-04-27 09:10:00	AAPL	Stock	4.3946	4.3946	4.3929	4.3929	35000.0
2009-04-27 09:15:00	AAPL	Stock	4.3929	4.3932	4.3929	4.3929	44800.0
2009-04-27 09:20:00	AAPL	Stock	4.3929	4.3946	4.3929	4.3929	53984.0
2009-04-27 09:25:00	AAPL	Stock	4.3929	4.3975	4.3739	4.3846	1183028.0
2009-04-27 09:30:00	AAPL	Stock	4.3857	4.4036	4.3857	4.3914	15414924.0
2009-04-27 09:35:00	AAPL	Stock	4.3907	4.425	4.3807	4.425	14673204.0
2009-04-27 09:40:00	AAPL	Stock	4.4236	4.4268	4.405	4.4186	10427368.0
2009-04-27 09:45:00	AAPL	Stock	4.4189	4.4321	4.4121	4.4225	10522176.0
2009-04-27 09:50:00	AAPL	Stock	4.4225	4.4254	4.4061	4.41	6939296.0
2009-04-27 09:55:00	AAPL	Stock	4.4107	4.4107	4.3893	4.3982	9925776.0
2009-04-27 10:00:00	AAPL	Stock	4.3989	4.4107	4.3857	4.4093	8493716.0
2009-04-27 10:05:00	AAPL	Stock	4.4096	4.4139	4.3975	4.4043	5913460.0
2009-04-27 10:10:00	AAPL	Stock	4.4046	4.4054	4.3911	4.3971	7312396.0
2009-04-27 10:15:00	AAPL	Stock	4.3975	4.4375	4.3961	4.4296	12506956.0
2009-04-27 10:20:00	AAPL	Stock	4.4296	4.45	4.4221	4.45	10087504.0
2009-04-27 10:25:00	AAPL	Stock	4.45	4.4511	4.4329	4.4354	5954984.0
2009-04-27 10:30:00	AAPL	Stock	4.4357	4.4357	4.4111	4.4143	5896828.0
2009-04-27 10:35:00	AAPL	Stock	4.4139	4.4446	4.4139	4.4404	7464856.0
2009-04-27 10:40:00	AAPL	Stock	4.4404	4.4536	4.4329	4.4464	6224204.0
2009-04-27 10:45:00	AAPL	Stock	4.4475	4.4507	4.4429	4.445	3882788.0
2009-04-27 10:50:00	AAPL	Stock	4.4459	4.455	4.4418	4.4529	4731328.0
2009-04-27 10:55:00	AAPL	Stock	4.4521	4.4643	4.4496	4.4604	7309456.0
2009-04-27 11:00:00	AAPL	Stock	4.4614	4.4643	4.4543	4.4575	6488972.0
2009-04-27 11:05:00	AAPL	Stock	4.4582	4.4621	4.4554	4.4575	3523940.0
2009-04-27 11:10:00	AAPL	Stock	4.4565	4.4582	4.4464	4.4521	3792768.0
2009-04-27 11:15:00	AAPL	Stock	4.452	4.4536	4.4368	4.4396	3974852.0
2009-04-27 11:20:00	AAPL	Stock	4.4396	4.4471	4.4325	4.4425	6552728.0
2009-04-27 11:25:00	AAPL	Stock	4.4432	4.4518	4.4396	4.4486	3394132.0
2009-04-27 11:30:00	AAPL	Stock	4.4486	4.4521	4.4364	4.4446	2282000.0
2009-04-27 11:35:00	AAPL	Stock	4.4439	4.4525	4.44	4.4514	3100888.0

> showing 50 of 310,424 rows — these rows as CSV

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