PREVIEW / stock_5min / 2009-01-20

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-01-20.parquet
  size:    4.4 MB
  rows:    306,418
  symbols: 3,306

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-01-20 07:15:00	AAPL	Stock	2.9004	2.9004	2.9004	2.9004	28000.0
2009-01-20 07:30:00	AAPL	Stock	2.9179	2.9179	2.9179	2.9179	25200.0
2009-01-20 08:00:00	AAPL	Stock	2.9179	2.9236	2.9107	2.9107	90384.0
2009-01-20 08:05:00	AAPL	Stock	2.9143	2.9143	2.9021	2.9039	67200.0
2009-01-20 08:10:00	AAPL	Stock	2.9039	2.9039	2.8982	2.8982	140000.0
2009-01-20 08:15:00	AAPL	Stock	2.8971	2.8982	2.8857	2.8857	185360.0
2009-01-20 08:20:00	AAPL	Stock	2.8889	2.8929	2.8875	2.8929	272300.0
2009-01-20 08:25:00	AAPL	Stock	2.8929	2.8929	2.8925	2.8929	47600.0
2009-01-20 08:30:00	AAPL	Stock	2.8929	2.8929	2.8864	2.8864	75460.0
2009-01-20 08:35:00	AAPL	Stock	2.8879	2.8911	2.8864	2.8911	99176.0
2009-01-20 08:40:00	AAPL	Stock	2.8907	2.8957	2.8893	2.8946	276108.0
2009-01-20 08:45:00	AAPL	Stock	2.8946	2.9	2.8946	2.8996	238056.0
2009-01-20 08:50:00	AAPL	Stock	2.9	2.9	2.8989	2.8989	372680.0
2009-01-20 08:55:00	AAPL	Stock	2.8996	2.9	2.8996	2.8996	28280.0
2009-01-20 09:00:00	AAPL	Stock	2.8996	2.9	2.8986	2.8989	39900.0
2009-01-20 09:05:00	AAPL	Stock	2.8989	2.9	2.8975	2.8975	110180.0
2009-01-20 09:10:00	AAPL	Stock	2.8996	2.9	2.8889	2.8893	170240.0
2009-01-20 09:15:00	AAPL	Stock	2.8918	2.8954	2.8904	2.8936	89180.0
2009-01-20 09:20:00	AAPL	Stock	2.8936	2.9	2.8925	2.9	75600.0
2009-01-20 09:25:00	AAPL	Stock	2.9	2.9286	2.8932	2.9239	1269128.0
2009-01-20 09:30:00	AAPL	Stock	2.9239	2.9286	2.8793	2.8879	21541016.0
2009-01-20 09:35:00	AAPL	Stock	2.8886	2.9064	2.875	2.8786	18201372.0
2009-01-20 09:40:00	AAPL	Stock	2.8786	2.9021	2.875	2.8929	12551056.0
2009-01-20 09:45:00	AAPL	Stock	2.8929	2.9079	2.8864	2.9071	15397396.0
2009-01-20 09:50:00	AAPL	Stock	2.9068	2.9229	2.8896	2.8929	19347608.0
2009-01-20 09:55:00	AAPL	Stock	2.8929	2.9057	2.8836	2.885	15794352.0
2009-01-20 10:00:00	AAPL	Stock	2.8854	2.8857	2.8589	2.8596	30725996.0
2009-01-20 10:05:00	AAPL	Stock	2.8596	2.8707	2.8543	2.8604	24894380.0
2009-01-20 10:10:00	AAPL	Stock	2.8611	2.8814	2.8582	2.8786	16054052.0
2009-01-20 10:15:00	AAPL	Stock	2.8789	2.8868	2.8682	2.8689	13684412.0
2009-01-20 10:20:00	AAPL	Stock	2.8693	2.8804	2.8661	2.8729	10459876.0
2009-01-20 10:25:00	AAPL	Stock	2.8725	2.8839	2.8689	2.8832	9452884.0
2009-01-20 10:30:00	AAPL	Stock	2.8829	2.8836	2.8679	2.8711	9217236.0
2009-01-20 10:35:00	AAPL	Stock	2.8712	2.8712	2.8564	2.86	12868380.0
2009-01-20 10:40:00	AAPL	Stock	2.86	2.8604	2.8375	2.8421	21056896.0
2009-01-20 10:45:00	AAPL	Stock	2.8414	2.8529	2.8318	2.8482	13532092.0
2009-01-20 10:50:00	AAPL	Stock	2.8471	2.8511	2.8404	2.8479	8661800.0
2009-01-20 10:55:00	AAPL	Stock	2.8475	2.8539	2.8454	2.8489	9502500.0
2009-01-20 11:00:00	AAPL	Stock	2.8493	2.8625	2.8464	2.8557	10844036.0
2009-01-20 11:05:00	AAPL	Stock	2.8554	2.8561	2.8482	2.8507	4624564.0
2009-01-20 11:10:00	AAPL	Stock	2.8511	2.8571	2.8464	2.8479	5049380.0
2009-01-20 11:15:00	AAPL	Stock	2.848	2.8593	2.8457	2.8571	5497464.0
2009-01-20 11:20:00	AAPL	Stock	2.8564	2.8571	2.8393	2.8393	8541092.0
2009-01-20 11:25:00	AAPL	Stock	2.8393	2.8489	2.8393	2.845	10079832.0
2009-01-20 11:30:00	AAPL	Stock	2.845	2.8525	2.8446	2.8493	6642440.0
2009-01-20 11:35:00	AAPL	Stock	2.8493	2.8696	2.8489	2.8661	6348944.0
2009-01-20 11:40:00	AAPL	Stock	2.8668	2.8757	2.8643	2.865	6123712.0
2009-01-20 11:45:00	AAPL	Stock	2.865	2.8675	2.8618	2.8639	3385508.0
2009-01-20 11:50:00	AAPL	Stock	2.8639	2.865	2.8546	2.8589	5389356.0
2009-01-20 11:55:00	AAPL	Stock	2.8579	2.8618	2.8471	2.8489	5482064.0

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

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