PREVIEW / stock_5min / 2010-08-27

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-08-27.parquet
  size:    4.6 MB
  rows:    318,660
  symbols: 3,465

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
2010-08-27 06:45:00	AAPL	Stock	8.6232	8.6243	8.6232	8.6243	18200.0
2010-08-27 06:55:00	AAPL	Stock	8.6214	8.6429	8.6214	8.6429	39200.0
2010-08-27 07:00:00	AAPL	Stock	8.6046	8.6179	8.5993	8.6179	22400.0
2010-08-27 07:05:00	AAPL	Stock	8.6375	8.6375	8.6375	8.6375	5600.0
2010-08-27 07:10:00	AAPL	Stock	8.6421	8.6429	8.6407	8.6411	89600.0
2010-08-27 07:15:00	AAPL	Stock	8.6357	8.6357	8.6357	8.6357	8400.0
2010-08-27 07:25:00	AAPL	Stock	8.6243	8.6311	8.6243	8.6311	61600.0
2010-08-27 07:30:00	AAPL	Stock	8.6304	8.6418	8.6304	8.6339	51800.0
2010-08-27 07:35:00	AAPL	Stock	8.6411	8.6411	8.6271	8.6271	8400.0
2010-08-27 07:40:00	AAPL	Stock	8.6271	8.6271	8.6271	8.6271	2800.0
2010-08-27 07:45:00	AAPL	Stock	8.6246	8.6246	8.6111	8.6232	16800.0
2010-08-27 07:50:00	AAPL	Stock	8.6196	8.6196	8.6196	8.6196	11200.0
2010-08-27 07:55:00	AAPL	Stock	8.6268	8.6286	8.6268	8.6275	154000.0
2010-08-27 08:00:00	AAPL	Stock	8.6218	8.6232	8.6071	8.6143	226940.0
2010-08-27 08:05:00	AAPL	Stock	8.6143	8.6143	8.6071	8.6118	40320.0
2010-08-27 08:10:00	AAPL	Stock	8.6071	8.6089	8.6	8.6	62944.0
2010-08-27 08:15:00	AAPL	Stock	8.6	8.6089	8.6	8.6089	37940.0
2010-08-27 08:20:00	AAPL	Stock	8.6004	8.6004	8.5936	8.5936	54376.0
2010-08-27 08:25:00	AAPL	Stock	8.5943	8.6	8.5925	8.5975	95060.0
2010-08-27 08:30:00	AAPL	Stock	8.5996	8.6729	8.5996	8.6536	1526784.0
2010-08-27 08:35:00	AAPL	Stock	8.6507	8.6593	8.6429	8.6443	338940.0
2010-08-27 08:40:00	AAPL	Stock	8.6482	8.65	8.6393	8.6496	191044.0
2010-08-27 08:45:00	AAPL	Stock	8.6471	8.6554	8.6443	8.6511	143948.0
2010-08-27 08:50:00	AAPL	Stock	8.6514	8.6514	8.6393	8.6414	228060.0
2010-08-27 08:55:00	AAPL	Stock	8.64	8.6429	8.6357	8.6421	243348.0
2010-08-27 09:00:00	AAPL	Stock	8.6396	8.6446	8.6357	8.6393	130536.0
2010-08-27 09:05:00	AAPL	Stock	8.6421	8.6421	8.6275	8.6275	68040.0
2010-08-27 09:10:00	AAPL	Stock	8.6343	8.6407	8.6304	8.6354	122024.0
2010-08-27 09:15:00	AAPL	Stock	8.6404	8.6479	8.635	8.6429	86800.0
2010-08-27 09:20:00	AAPL	Stock	8.6464	8.6525	8.6464	8.6525	39200.0
2010-08-27 09:25:00	AAPL	Stock	8.6507	8.6507	8.6179	8.6354	385560.0
2010-08-27 09:30:00	AAPL	Stock	8.635	8.6646	8.625	8.6356	14750512.0
2010-08-27 09:35:00	AAPL	Stock	8.6333	8.6503	8.6171	8.6186	10102540.0
2010-08-27 09:40:00	AAPL	Stock	8.6193	8.6207	8.5857	8.5907	7831740.0
2010-08-27 09:45:00	AAPL	Stock	8.5907	8.6014	8.5786	8.5889	9331196.0
2010-08-27 09:50:00	AAPL	Stock	8.5889	8.6029	8.5843	8.5907	6180832.0
2010-08-27 09:55:00	AAPL	Stock	8.5939	8.61	8.5071	8.5111	20568380.0
2010-08-27 10:00:00	AAPL	Stock	8.5132	8.5407	8.4129	8.4582	42954352.0
2010-08-27 10:05:00	AAPL	Stock	8.4576	8.5	8.4375	8.4914	27334860.0
2010-08-27 10:10:00	AAPL	Stock	8.4911	8.5414	8.4857	8.5286	22322076.0
2010-08-27 10:15:00	AAPL	Stock	8.5311	8.5691	8.5239	8.5464	18037124.0
2010-08-27 10:20:00	AAPL	Stock	8.5443	8.5832	8.5254	8.555	14580692.0
2010-08-27 10:25:00	AAPL	Stock	8.5586	8.5957	8.555	8.5693	14675780.0
2010-08-27 10:30:00	AAPL	Stock	8.5696	8.5854	8.5586	8.5629	11305840.0
2010-08-27 10:35:00	AAPL	Stock	8.5629	8.5996	8.5557	8.5814	10604832.0
2010-08-27 10:40:00	AAPL	Stock	8.5825	8.5946	8.5604	8.5636	9322068.0
2010-08-27 10:45:00	AAPL	Stock	8.5646	8.5786	8.5607	8.5661	4984420.0
2010-08-27 10:50:00	AAPL	Stock	8.5657	8.5786	8.5643	8.5671	3695216.0
2010-08-27 10:55:00	AAPL	Stock	8.5668	8.5668	8.5457	8.5589	6979952.0
2010-08-27 11:00:00	AAPL	Stock	8.5589	8.575	8.5568	8.5692	4327008.0

> showing 50 of 318,660 rows — these rows as CSV

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