PREVIEW / stock_5min / 2011-04-28

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-28.parquet
  size:    4.8 MB
  rows:    325,375
  symbols: 3,566

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-28 04:20:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-04-28 05:25:00	AAPL	Stock	12.4993	12.4993	12.4993	12.4993	12600.0
2011-04-28 05:45:00	AAPL	Stock	12.4943	12.4943	12.4911	12.4911	9800.0
2011-04-28 06:05:00	AAPL	Stock	12.4918	12.4918	12.4918	12.4918	2800.0
2011-04-28 06:35:00	AAPL	Stock	12.4918	12.4918	12.4918	12.4918	3248.0
2011-04-28 06:40:00	AAPL	Stock	12.4911	12.4911	12.4911	12.4911	5600.0
2011-04-28 06:50:00	AAPL	Stock	12.4679	12.4679	12.4679	12.4679	2800.0
2011-04-28 07:00:00	AAPL	Stock	12.48	12.48	12.48	12.48	8400.0
2011-04-28 07:10:00	AAPL	Stock	12.4675	12.4675	12.4643	12.4668	32928.0
2011-04-28 07:20:00	AAPL	Stock	12.4643	12.4643	12.4643	12.4643	14000.0
2011-04-28 07:25:00	AAPL	Stock	12.4643	12.4643	12.4643	12.4643	14000.0
2011-04-28 07:30:00	AAPL	Stock	12.4561	12.4561	12.4561	12.4561	5600.0
2011-04-28 07:35:00	AAPL	Stock	12.4468	12.4921	12.4468	12.4921	43596.0
2011-04-28 07:50:00	AAPL	Stock	12.465	12.465	12.4468	12.4468	32872.0
2011-04-28 07:55:00	AAPL	Stock	12.4532	12.4536	12.4468	12.4529	85400.0
2011-04-28 08:00:00	AAPL	Stock	12.4468	12.4554	12.4457	12.4554	215320.0
2011-04-28 08:05:00	AAPL	Stock	12.4504	12.4561	12.45	12.4557	77280.0
2011-04-28 08:10:00	AAPL	Stock	12.4643	12.4711	12.4625	12.4696	61600.0
2011-04-28 08:15:00	AAPL	Stock	12.4696	12.4714	12.4696	12.4714	104972.0
2011-04-28 08:20:00	AAPL	Stock	12.4732	12.4743	12.4554	12.4554	485436.0
2011-04-28 08:25:00	AAPL	Stock	12.4643	12.4643	12.4446	12.4464	413952.0
2011-04-28 08:30:00	AAPL	Stock	12.44	12.4464	12.4218	12.4261	561596.0
2011-04-28 08:35:00	AAPL	Stock	12.4257	12.4286	12.4143	12.4182	281036.0
2011-04-28 08:40:00	AAPL	Stock	12.4196	12.4286	12.4196	12.4254	128044.0
2011-04-28 08:45:00	AAPL	Stock	12.4218	12.4268	12.4111	12.4111	216328.0
2011-04-28 08:50:00	AAPL	Stock	12.4143	12.4182	12.4125	12.4182	100324.0
2011-04-28 08:55:00	AAPL	Stock	12.4179	12.4214	12.4107	12.4107	175196.0
2011-04-28 09:00:00	AAPL	Stock	12.4118	12.4179	12.3982	12.3996	190540.0
2011-04-28 09:05:00	AAPL	Stock	12.4	12.4	12.3768	12.3989	681324.0
2011-04-28 09:10:00	AAPL	Stock	12.3929	12.3996	12.3929	12.395	398300.0
2011-04-28 09:15:00	AAPL	Stock	12.3964	12.3975	12.3825	12.3839	563696.0
2011-04-28 09:20:00	AAPL	Stock	12.3807	12.3839	12.3475	12.3639	1683276.0
2011-04-28 09:25:00	AAPL	Stock	12.3611	12.3711	12.3521	12.3632	2238600.0
2011-04-28 09:30:00	AAPL	Stock	12.3621	12.4107	12.3611	12.3904	20416116.0
2011-04-28 09:35:00	AAPL	Stock	12.3894	12.3936	12.3754	12.3849	8078336.0
2011-04-28 09:40:00	AAPL	Stock	12.3843	12.4257	12.3843	12.4199	11404344.0
2011-04-28 09:45:00	AAPL	Stock	12.4179	12.4396	12.4061	12.4386	9788380.0
2011-04-28 09:50:00	AAPL	Stock	12.4376	12.4893	12.4304	12.4839	11620448.0
2011-04-28 09:55:00	AAPL	Stock	12.4836	12.4911	12.4486	12.4582	9023028.0
2011-04-28 10:00:00	AAPL	Stock	12.4575	12.4696	12.4489	12.4696	5909456.0
2011-04-28 10:05:00	AAPL	Stock	12.4696	12.4732	12.4564	12.4689	3834852.0
2011-04-28 10:10:00	AAPL	Stock	12.4704	12.4704	12.4479	12.4679	4192776.0
2011-04-28 10:15:00	AAPL	Stock	12.4675	12.4675	12.4396	12.4479	4071564.0
2011-04-28 10:20:00	AAPL	Stock	12.45	12.4514	12.4218	12.4325	4856432.0
2011-04-28 10:25:00	AAPL	Stock	12.4325	12.4471	12.4268	12.44	3459680.0
2011-04-28 10:30:00	AAPL	Stock	12.4404	12.4461	12.4164	12.4339	3927924.0
2011-04-28 10:35:00	AAPL	Stock	12.4339	12.4354	12.4132	12.4295	3129504.0
2011-04-28 10:40:00	AAPL	Stock	12.4294	12.4411	12.4294	12.4336	3198580.0
2011-04-28 10:45:00	AAPL	Stock	12.4336	12.4554	12.4329	12.4507	4040568.0
2011-04-28 10:50:00	AAPL	Stock	12.4514	12.4599	12.4379	12.4489	3005212.0

> showing 50 of 325,375 rows — these rows as CSV

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