PREVIEW / stock_5min / 2009-07-07

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-07-07.parquet
  size:    4.5 MB
  rows:    314,320
  symbols: 3,327

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-07-07 08:00:00	AAPL	Stock	4.9725	4.9725	4.9582	4.9643	160888.0
2009-07-07 08:05:00	AAPL	Stock	4.9564	4.9596	4.9529	4.9529	22400.0
2009-07-07 08:10:00	AAPL	Stock	4.9607	4.9607	4.9554	4.9554	140168.0
2009-07-07 08:15:00	AAPL	Stock	4.9554	4.9632	4.9554	4.9611	57484.0
2009-07-07 08:20:00	AAPL	Stock	4.9621	4.9621	4.9611	4.9611	75600.0
2009-07-07 08:25:00	AAPL	Stock	4.9589	4.9589	4.9561	4.9582	149324.0
2009-07-07 08:30:00	AAPL	Stock	4.96	4.96	4.9561	4.9561	44800.0
2009-07-07 08:35:00	AAPL	Stock	4.9596	4.96	4.9596	4.96	31444.0
2009-07-07 08:40:00	AAPL	Stock	4.96	4.9621	4.96	4.96	134064.0
2009-07-07 08:45:00	AAPL	Stock	4.9618	4.9618	4.9589	4.9604	49224.0
2009-07-07 08:50:00	AAPL	Stock	4.9625	4.9679	4.9618	4.9618	51716.0
2009-07-07 08:55:00	AAPL	Stock	4.9621	4.9621	4.9593	4.9607	54600.0
2009-07-07 09:00:00	AAPL	Stock	4.9614	4.9643	4.9611	4.9611	30940.0
2009-07-07 09:05:00	AAPL	Stock	4.9614	4.9614	4.9579	4.9579	190876.0
2009-07-07 09:10:00	AAPL	Stock	4.9586	4.9586	4.9554	4.9554	121520.0
2009-07-07 09:15:00	AAPL	Stock	4.9568	4.9582	4.9536	4.9536	306824.0
2009-07-07 09:20:00	AAPL	Stock	4.9504	4.9571	4.9486	4.9504	290528.0
2009-07-07 09:25:00	AAPL	Stock	4.9518	4.9557	4.9436	4.9439	448000.0
2009-07-07 09:30:00	AAPL	Stock	4.9443	4.9786	4.9325	4.9699	15382024.0
2009-07-07 09:35:00	AAPL	Stock	4.9693	4.9886	4.9629	4.9696	15624084.0
2009-07-07 09:40:00	AAPL	Stock	4.9696	4.9704	4.9511	4.9579	11401236.0
2009-07-07 09:45:00	AAPL	Stock	4.9579	4.9763	4.9564	4.9675	11076520.0
2009-07-07 09:50:00	AAPL	Stock	4.9679	4.9761	4.9654	4.9686	7263984.0
2009-07-07 09:55:00	AAPL	Stock	4.9693	4.9704	4.9425	4.9496	8980356.0
2009-07-07 10:00:00	AAPL	Stock	4.95	4.9511	4.9314	4.9399	7856464.0
2009-07-07 10:05:00	AAPL	Stock	4.9396	4.9421	4.925	4.9257	7418040.0
2009-07-07 10:10:00	AAPL	Stock	4.9261	4.9279	4.8968	4.8968	11637052.0
2009-07-07 10:15:00	AAPL	Stock	4.8968	4.9057	4.8939	4.9029	5575976.0
2009-07-07 10:20:00	AAPL	Stock	4.9021	4.9061	4.8986	4.9018	4723824.0
2009-07-07 10:25:00	AAPL	Stock	4.9018	4.9189	4.9018	4.9182	5479264.0
2009-07-07 10:30:00	AAPL	Stock	4.9175	4.9175	4.9018	4.9029	4415124.0
2009-07-07 10:35:00	AAPL	Stock	4.9032	4.9064	4.8821	4.8889	7648172.0
2009-07-07 10:40:00	AAPL	Stock	4.8882	4.9014	4.8882	4.8993	4425904.0
2009-07-07 10:45:00	AAPL	Stock	4.9	4.9075	4.8964	4.9036	3076304.0
2009-07-07 10:50:00	AAPL	Stock	4.9032	4.9068	4.8971	4.9018	2925244.0
2009-07-07 10:55:00	AAPL	Stock	4.9018	4.9032	4.8875	4.8911	4705764.0
2009-07-07 11:00:00	AAPL	Stock	4.89	4.8918	4.885	4.8896	5986288.0
2009-07-07 11:05:00	AAPL	Stock	4.89	4.8968	4.8825	4.8943	6071912.0
2009-07-07 11:10:00	AAPL	Stock	4.8936	4.8964	4.8911	4.8954	4892580.0
2009-07-07 11:15:00	AAPL	Stock	4.8954	4.8986	4.8918	4.8982	6941396.0
2009-07-07 11:20:00	AAPL	Stock	4.8979	4.8989	4.8875	4.89	4783604.0
2009-07-07 11:25:00	AAPL	Stock	4.8904	4.8911	4.875	4.875	6756596.0
2009-07-07 11:30:00	AAPL	Stock	4.875	4.8814	4.8721	4.8725	5076512.0
2009-07-07 11:35:00	AAPL	Stock	4.8729	4.875	4.8643	4.8679	6561128.0
2009-07-07 11:40:00	AAPL	Stock	4.8671	4.8704	4.8604	4.8614	6629588.0
2009-07-07 11:45:00	AAPL	Stock	4.8611	4.8636	4.8536	4.8564	7805504.0
2009-07-07 11:50:00	AAPL	Stock	4.8568	4.8639	4.8561	4.8639	4500244.0
2009-07-07 11:55:00	AAPL	Stock	4.8632	4.8725	4.8629	4.8696	4490724.0
2009-07-07 12:00:00	AAPL	Stock	4.8696	4.8704	4.8625	4.8682	5881148.0
2009-07-07 12:05:00	AAPL	Stock	4.8682	4.8689	4.8639	4.8654	2554132.0

> showing 50 of 314,320 rows — these rows as CSV

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