PREVIEW / stock_5min / 2005-07-27

all stock 5-min files

  file:    by_date/stock_5min/2005/2005-07-27.parquet
  size:    2.7 MB
  rows:    196,310
  symbols: 2,042

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
2005-07-27 07:30:00	AAPL	Stock	1.5564	1.5564	1.5564	1.5564	14000.0
2005-07-27 08:00:00	AAPL	Stock	1.5561	1.5561	1.5561	1.5561	25116.0
2005-07-27 08:25:00	AAPL	Stock	1.5571	1.5571	1.5571	1.5571	11200.0
2005-07-27 08:30:00	AAPL	Stock	1.5568	1.5568	1.5568	1.5568	28000.0
2005-07-27 08:35:00	AAPL	Stock	1.5571	1.5571	1.5571	1.5571	15232.0
2005-07-27 08:40:00	AAPL	Stock	1.5579	1.5579	1.5579	1.5579	112000.0
2005-07-27 08:50:00	AAPL	Stock	1.5579	1.5607	1.5571	1.5607	39200.0
2005-07-27 09:00:00	AAPL	Stock	1.5607	1.5607	1.5607	1.5607	5600.0
2005-07-27 09:25:00	AAPL	Stock	1.5611	1.5654	1.5611	1.5654	118580.0
2005-07-27 09:30:00	AAPL	Stock	1.5654	1.5668	1.5575	1.5596	5253556.0
2005-07-27 09:35:00	AAPL	Stock	1.5596	1.5618	1.5421	1.5425	7204568.0
2005-07-27 09:40:00	AAPL	Stock	1.5425	1.5475	1.5407	1.5454	6884920.0
2005-07-27 09:45:00	AAPL	Stock	1.5461	1.5464	1.5382	1.5421	7457800.0
2005-07-27 09:50:00	AAPL	Stock	1.5418	1.5457	1.5404	1.5414	4890284.0
2005-07-27 09:55:00	AAPL	Stock	1.5418	1.5421	1.5368	1.54	4488736.0
2005-07-27 10:00:00	AAPL	Stock	1.54	1.5418	1.5239	1.5239	12399688.0
2005-07-27 10:05:00	AAPL	Stock	1.5239	1.5343	1.5239	1.5343	9047136.0
2005-07-27 10:10:00	AAPL	Stock	1.5343	1.5389	1.5329	1.5364	5603864.0
2005-07-27 10:15:00	AAPL	Stock	1.5379	1.5379	1.53	1.5336	5786732.0
2005-07-27 10:20:00	AAPL	Stock	1.5336	1.5379	1.5332	1.5361	4197340.0
2005-07-27 10:25:00	AAPL	Stock	1.5361	1.5371	1.5339	1.5354	2570876.0
2005-07-27 10:30:00	AAPL	Stock	1.5354	1.5393	1.535	1.5389	4144756.0
2005-07-27 10:35:00	AAPL	Stock	1.5389	1.5471	1.5383	1.5436	6668004.0
2005-07-27 10:40:00	AAPL	Stock	1.5439	1.5461	1.5429	1.5457	3073252.0
2005-07-27 10:45:00	AAPL	Stock	1.5457	1.5529	1.5454	1.5482	5152560.0
2005-07-27 10:50:00	AAPL	Stock	1.5482	1.5493	1.5432	1.5446	4104240.0
2005-07-27 10:55:00	AAPL	Stock	1.5446	1.5464	1.5432	1.5439	2629956.0
2005-07-27 11:00:00	AAPL	Stock	1.5439	1.5482	1.5439	1.5471	3785432.0
2005-07-27 11:05:00	AAPL	Stock	1.5475	1.5489	1.5471	1.5475	2317588.0
2005-07-27 11:10:00	AAPL	Stock	1.5479	1.5479	1.545	1.5475	1927492.0
2005-07-27 11:15:00	AAPL	Stock	1.5475	1.5475	1.5454	1.5457	1933428.0
2005-07-27 11:20:00	AAPL	Stock	1.5455	1.5479	1.5454	1.5462	1526812.0
2005-07-27 11:25:00	AAPL	Stock	1.5461	1.5479	1.5461	1.5471	1136380.0
2005-07-27 11:30:00	AAPL	Stock	1.5471	1.5489	1.5471	1.5482	927780.0
2005-07-27 11:35:00	AAPL	Stock	1.5479	1.5486	1.5479	1.5486	1062012.0
2005-07-27 11:40:00	AAPL	Stock	1.5482	1.5486	1.5461	1.5464	1240456.0
2005-07-27 11:45:00	AAPL	Stock	1.5464	1.5482	1.5457	1.5479	1173788.0
2005-07-27 11:50:00	AAPL	Stock	1.5479	1.5479	1.5461	1.5461	1266860.0
2005-07-27 11:55:00	AAPL	Stock	1.5464	1.5464	1.545	1.5461	2118648.0
2005-07-27 12:00:00	AAPL	Stock	1.5464	1.552	1.5464	1.5507	3966088.0
2005-07-27 12:05:00	AAPL	Stock	1.5507	1.5529	1.5507	1.5514	1930936.0
2005-07-27 12:10:00	AAPL	Stock	1.5514	1.5521	1.5475	1.5482	3968916.0
2005-07-27 12:15:00	AAPL	Stock	1.5482	1.5518	1.5471	1.5475	3631880.0
2005-07-27 12:20:00	AAPL	Stock	1.5471	1.55	1.5457	1.5475	3776696.0
2005-07-27 12:25:00	AAPL	Stock	1.5475	1.5479	1.5446	1.5468	2161544.0
2005-07-27 12:30:00	AAPL	Stock	1.5468	1.5475	1.5464	1.5464	612528.0
2005-07-27 12:35:00	AAPL	Stock	1.5464	1.5475	1.5454	1.5471	1252972.0
2005-07-27 12:40:00	AAPL	Stock	1.5474	1.5493	1.5474	1.5482	1807736.0
2005-07-27 12:45:00	AAPL	Stock	1.5486	1.55	1.5486	1.5498	1688232.0
2005-07-27 12:50:00	AAPL	Stock	1.55	1.5518	1.5493	1.5496	1277332.0

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

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