PREVIEW / stock_5min / 2009-04-24

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-24.parquet
  size:    4.4 MB
  rows:    306,531
  symbols: 3,337

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-24 07:00:00	AAPL	Stock	4.47	4.47	4.47	4.47	2800.0
2009-04-24 07:05:00	AAPL	Stock	4.4964	4.5	4.4964	4.5	19600.0
2009-04-24 07:10:00	AAPL	Stock	4.5036	4.5036	4.5036	4.5036	5600.0
2009-04-24 07:15:00	AAPL	Stock	4.5036	4.5036	4.5	4.5036	21336.0
2009-04-24 07:20:00	AAPL	Stock	4.5004	4.5004	4.5004	4.5004	2800.0
2009-04-24 07:30:00	AAPL	Stock	4.5007	4.5007	4.5	4.5	22400.0
2009-04-24 07:45:00	AAPL	Stock	4.5107	4.5107	4.5	4.5	8400.0
2009-04-24 08:00:00	AAPL	Stock	4.5	4.5068	4.4679	4.4782	93408.0
2009-04-24 08:05:00	AAPL	Stock	4.4821	4.4875	4.4821	4.4821	76300.0
2009-04-24 08:10:00	AAPL	Stock	4.4821	4.4857	4.4786	4.4821	145656.0
2009-04-24 08:15:00	AAPL	Stock	4.4821	4.4911	4.4821	4.4911	63000.0
2009-04-24 08:20:00	AAPL	Stock	4.4829	4.4861	4.4821	4.4861	31640.0
2009-04-24 08:30:00	AAPL	Stock	4.4893	4.4896	4.4768	4.4857	92120.0
2009-04-24 08:35:00	AAPL	Stock	4.4786	4.4857	4.4786	4.4829	120904.0
2009-04-24 08:40:00	AAPL	Stock	4.4839	4.4854	4.4786	4.4821	144900.0
2009-04-24 08:45:00	AAPL	Stock	4.4786	4.4857	4.4786	4.4857	45920.0
2009-04-24 08:50:00	AAPL	Stock	4.4875	4.4875	4.4875	4.4875	19600.0
2009-04-24 08:55:00	AAPL	Stock	4.4857	4.4857	4.4839	4.4857	20160.0
2009-04-24 09:00:00	AAPL	Stock	4.4857	4.49	4.4857	4.4864	78904.0
2009-04-24 09:05:00	AAPL	Stock	4.4839	4.4843	4.4786	4.4821	65800.0
2009-04-24 09:10:00	AAPL	Stock	4.48	4.4804	4.4732	4.4732	398216.0
2009-04-24 09:15:00	AAPL	Stock	4.4704	4.4768	4.4696	4.4696	169848.0
2009-04-24 09:20:00	AAPL	Stock	4.4696	4.4707	4.4482	4.45	232316.0
2009-04-24 09:25:00	AAPL	Stock	4.45	4.4571	4.45	4.4539	192584.0
2009-04-24 09:30:00	AAPL	Stock	4.4514	4.4693	4.4293	4.4397	19814116.0
2009-04-24 09:35:00	AAPL	Stock	4.4421	4.4493	4.4225	4.4387	16823072.0
2009-04-24 09:40:00	AAPL	Stock	4.4375	4.4461	4.425	4.43	10686676.0
2009-04-24 09:45:00	AAPL	Stock	4.43	4.4446	4.4189	4.4361	12865216.0
2009-04-24 09:50:00	AAPL	Stock	4.4343	4.4618	4.4286	4.4425	9952012.0
2009-04-24 09:55:00	AAPL	Stock	4.4414	4.445	4.4268	4.435	7573524.0
2009-04-24 10:00:00	AAPL	Stock	4.4364	4.4482	4.4329	4.4411	12037788.0
2009-04-24 10:05:00	AAPL	Stock	4.4407	4.4429	4.4275	4.4314	9112404.0
2009-04-24 10:10:00	AAPL	Stock	4.4311	4.4464	4.4214	4.4446	7702800.0
2009-04-24 10:15:00	AAPL	Stock	4.4441	4.4486	4.4254	4.4304	8260672.0
2009-04-24 10:20:00	AAPL	Stock	4.4307	4.4368	4.4221	4.4289	6631464.0
2009-04-24 10:25:00	AAPL	Stock	4.4296	4.4475	4.4279	4.4386	6532428.0
2009-04-24 10:30:00	AAPL	Stock	4.4379	4.4589	4.4375	4.4579	6825196.0
2009-04-24 10:35:00	AAPL	Stock	4.4575	4.4607	4.4468	4.4497	5104988.0
2009-04-24 10:40:00	AAPL	Stock	4.4496	4.4514	4.4296	4.4307	4906608.0
2009-04-24 10:45:00	AAPL	Stock	4.4311	4.445	4.4286	4.4401	4933404.0
2009-04-24 10:50:00	AAPL	Stock	4.4407	4.445	4.4357	4.4371	2191448.0
2009-04-24 10:55:00	AAPL	Stock	4.4361	4.4425	4.4321	4.4343	2557296.0
2009-04-24 11:00:00	AAPL	Stock	4.4339	4.4475	4.4339	4.4408	3881752.0
2009-04-24 11:05:00	AAPL	Stock	4.4396	4.4411	4.425	4.4371	6059144.0
2009-04-24 11:10:00	AAPL	Stock	4.4371	4.4429	4.4339	4.4396	3009804.0
2009-04-24 11:15:00	AAPL	Stock	4.4396	4.4479	4.4357	4.4387	3313184.0
2009-04-24 11:20:00	AAPL	Stock	4.4404	4.4404	4.4296	4.4314	2777852.0
2009-04-24 11:25:00	AAPL	Stock	4.4329	4.4411	4.4289	4.4371	3634680.0
2009-04-24 11:30:00	AAPL	Stock	4.4382	4.4489	4.4368	4.4475	4073328.0
2009-04-24 11:35:00	AAPL	Stock	4.4468	4.4539	4.4429	4.4525	4728164.0

> showing 50 of 306,531 rows — these rows as CSV

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