PREVIEW / stock_5min / 2009-06-22

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-22.parquet
  size:    4.7 MB
  rows:    323,867
  symbols: 3,350

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-06-22 04:15:00	AAPL	Stock	4.9811	4.9857	4.9811	4.9857	19600.0
2009-06-22 06:00:00	AAPL	Stock	4.9343	4.9482	4.9325	4.9482	19180.0
2009-06-22 06:05:00	AAPL	Stock	4.9496	4.9496	4.9496	4.9496	2800.0
2009-06-22 06:15:00	AAPL	Stock	4.9457	4.9457	4.9457	4.9457	5600.0
2009-06-22 06:25:00	AAPL	Stock	4.935	4.935	4.9325	4.9325	16800.0
2009-06-22 07:00:00	AAPL	Stock	4.9325	4.9429	4.9286	4.9429	51100.0
2009-06-22 07:05:00	AAPL	Stock	4.9379	4.9621	4.9329	4.9379	11200.0
2009-06-22 07:15:00	AAPL	Stock	4.9325	4.9325	4.9325	4.9325	8400.0
2009-06-22 07:20:00	AAPL	Stock	4.9393	4.9393	4.9393	4.9393	2800.0
2009-06-22 07:25:00	AAPL	Stock	4.9393	4.9393	4.9325	4.9325	44072.0
2009-06-22 07:30:00	AAPL	Stock	4.9264	4.9286	4.9204	4.9286	51352.0
2009-06-22 07:35:00	AAPL	Stock	4.9264	4.9286	4.9264	4.9286	19600.0
2009-06-22 07:40:00	AAPL	Stock	4.93	4.93	4.93	4.93	27636.0
2009-06-22 07:45:00	AAPL	Stock	4.9314	4.9314	4.9314	4.9314	5600.0
2009-06-22 07:50:00	AAPL	Stock	4.9321	4.9321	4.9321	4.9321	5600.0
2009-06-22 07:55:00	AAPL	Stock	4.9382	4.9382	4.9382	4.9382	2800.0
2009-06-22 08:00:00	AAPL	Stock	4.9371	4.945	4.9339	4.9429	69440.0
2009-06-22 08:05:00	AAPL	Stock	4.9429	4.9429	4.9221	4.9225	395192.0
2009-06-22 08:10:00	AAPL	Stock	4.9286	4.95	4.925	4.9304	759556.0
2009-06-22 08:15:00	AAPL	Stock	4.9321	4.9321	4.9268	4.9296	167552.0
2009-06-22 08:20:00	AAPL	Stock	4.9289	4.9304	4.9257	4.9257	153720.0
2009-06-22 08:25:00	AAPL	Stock	4.9254	4.9314	4.9221	4.9304	90608.0
2009-06-22 08:30:00	AAPL	Stock	4.9314	5.0282	4.9314	4.9929	3346784.0
2009-06-22 08:35:00	AAPL	Stock	4.9939	5.0121	4.9861	5.01	1141840.0
2009-06-22 08:40:00	AAPL	Stock	5.0104	5.0164	5.0036	5.0036	773724.0
2009-06-22 08:45:00	AAPL	Stock	5.0043	5.025	5.0043	5.0186	1066912.0
2009-06-22 08:50:00	AAPL	Stock	5.0204	5.0214	5.0	5.0054	554680.0
2009-06-22 08:55:00	AAPL	Stock	5.0061	5.0143	5.0043	5.0079	593544.0
2009-06-22 09:00:00	AAPL	Stock	5.0071	5.0086	4.9864	4.9882	1357020.0
2009-06-22 09:05:00	AAPL	Stock	4.9893	4.9964	4.9875	4.9929	600824.0
2009-06-22 09:10:00	AAPL	Stock	4.9929	5.0214	4.9907	5.0196	1511552.0
2009-06-22 09:15:00	AAPL	Stock	5.0193	5.0232	5.0064	5.0196	767340.0
2009-06-22 09:20:00	AAPL	Stock	5.0186	5.0357	5.0182	5.0289	1150492.0
2009-06-22 09:25:00	AAPL	Stock	5.0296	5.0339	5.0214	5.0243	2696456.0
2009-06-22 09:30:00	AAPL	Stock	5.0232	5.0557	5.0179	5.0379	38788736.0
2009-06-22 09:35:00	AAPL	Stock	5.0379	5.0425	5.0036	5.0287	22904112.0
2009-06-22 09:40:00	AAPL	Stock	5.0282	5.0307	4.9846	4.9861	22659168.0
2009-06-22 09:45:00	AAPL	Stock	4.9864	5.0096	4.9832	4.9971	16961840.0
2009-06-22 09:50:00	AAPL	Stock	4.9982	5.0032	4.9893	4.9904	9736496.0
2009-06-22 09:55:00	AAPL	Stock	4.9904	4.9918	4.9654	4.9746	16690548.0
2009-06-22 10:00:00	AAPL	Stock	4.9746	4.975	4.9418	4.9508	17924340.0
2009-06-22 10:05:00	AAPL	Stock	4.9518	4.965	4.9482	4.9554	11939536.0
2009-06-22 10:10:00	AAPL	Stock	4.9545	4.9575	4.9386	4.9418	10569860.0
2009-06-22 10:15:00	AAPL	Stock	4.9417	4.9521	4.9218	4.9239	14416472.0
2009-06-22 10:20:00	AAPL	Stock	4.9239	4.9311	4.9189	4.9289	12732580.0
2009-06-22 10:25:00	AAPL	Stock	4.9289	4.9382	4.9279	4.9375	8067724.0
2009-06-22 10:30:00	AAPL	Stock	4.9382	4.9386	4.925	4.9257	7068432.0
2009-06-22 10:35:00	AAPL	Stock	4.925	4.9293	4.9114	4.9182	10561824.0
2009-06-22 10:40:00	AAPL	Stock	4.9184	4.9221	4.8929	4.8982	13604836.0
2009-06-22 10:45:00	AAPL	Stock	4.8982	4.9196	4.8929	4.9175	10749648.0

> showing 50 of 323,867 rows — these rows as CSV

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