PREVIEW / stock_5min / 2009-06-25

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-25.parquet
  size:    4.6 MB
  rows:    322,863
  symbols: 3,354

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-25 05:55:00	AAPL	Stock	4.8868	4.8868	4.8868	4.8868	14000.0
2009-06-25 06:15:00	AAPL	Stock	4.8943	4.8943	4.8943	4.8943	14000.0
2009-06-25 06:20:00	AAPL	Stock	4.9025	4.9025	4.9025	4.9025	14000.0
2009-06-25 07:00:00	AAPL	Stock	4.8857	4.8857	4.8857	4.8857	2800.0
2009-06-25 07:30:00	AAPL	Stock	4.8911	4.9054	4.8911	4.9	22400.0
2009-06-25 07:35:00	AAPL	Stock	4.8893	4.9	4.8893	4.9	42000.0
2009-06-25 07:40:00	AAPL	Stock	4.9	4.9	4.9	4.9	2800.0
2009-06-25 07:45:00	AAPL	Stock	4.8996	4.9032	4.8996	4.9032	8400.0
2009-06-25 07:50:00	AAPL	Stock	4.9036	4.9036	4.8932	4.8932	14000.0
2009-06-25 07:55:00	AAPL	Stock	4.9021	4.9021	4.8993	4.8993	30800.0
2009-06-25 08:00:00	AAPL	Stock	4.8936	4.8979	4.8829	4.8829	203980.0
2009-06-25 08:05:00	AAPL	Stock	4.8854	4.8854	4.875	4.8768	117992.0
2009-06-25 08:10:00	AAPL	Stock	4.875	4.8811	4.875	4.8811	118692.0
2009-06-25 08:15:00	AAPL	Stock	4.8804	4.8846	4.8804	4.8839	102900.0
2009-06-25 08:20:00	AAPL	Stock	4.8832	4.8832	4.8793	4.8793	79100.0
2009-06-25 08:25:00	AAPL	Stock	4.8811	4.8811	4.8768	4.8768	60900.0
2009-06-25 08:30:00	AAPL	Stock	4.8786	4.8786	4.8507	4.8568	152460.0
2009-06-25 08:35:00	AAPL	Stock	4.8546	4.8571	4.8454	4.85	121744.0
2009-06-25 08:40:00	AAPL	Stock	4.85	4.85	4.8375	4.8375	311864.0
2009-06-25 08:45:00	AAPL	Stock	4.8375	4.8411	4.8357	4.8357	138516.0
2009-06-25 08:50:00	AAPL	Stock	4.8357	4.8411	4.8339	4.8411	139720.0
2009-06-25 08:55:00	AAPL	Stock	4.8411	4.8432	4.8393	4.8432	174692.0
2009-06-25 09:00:00	AAPL	Stock	4.8404	4.8457	4.8389	4.8393	67200.0
2009-06-25 09:05:00	AAPL	Stock	4.8396	4.8443	4.8396	4.8439	51436.0
2009-06-25 09:10:00	AAPL	Stock	4.8436	4.8475	4.8436	4.8446	92260.0
2009-06-25 09:15:00	AAPL	Stock	4.8461	4.8461	4.8429	4.8461	84000.0
2009-06-25 09:20:00	AAPL	Stock	4.845	4.8482	4.8421	4.8454	213360.0
2009-06-25 09:25:00	AAPL	Stock	4.845	4.8536	4.8432	4.8504	264600.0
2009-06-25 09:30:00	AAPL	Stock	4.8489	4.8629	4.8357	4.8532	12471480.0
2009-06-25 09:35:00	AAPL	Stock	4.8539	4.8689	4.8289	4.8511	12981976.0
2009-06-25 09:40:00	AAPL	Stock	4.8518	4.8886	4.8486	4.8861	14750512.0
2009-06-25 09:45:00	AAPL	Stock	4.8871	4.9032	4.8839	4.8879	12868744.0
2009-06-25 09:50:00	AAPL	Stock	4.8871	4.9193	4.8811	4.9179	15254456.0
2009-06-25 09:55:00	AAPL	Stock	4.9179	4.9425	4.9171	4.9336	23674420.0
2009-06-25 10:00:00	AAPL	Stock	4.9336	4.95	4.9286	4.9404	14443632.0
2009-06-25 10:05:00	AAPL	Stock	4.9407	4.9589	4.94	4.9514	11735220.0
2009-06-25 10:10:00	AAPL	Stock	4.9518	4.9614	4.9464	4.9532	13861008.0
2009-06-25 10:15:00	AAPL	Stock	4.9536	4.9768	4.9529	4.9675	16390556.0
2009-06-25 10:20:00	AAPL	Stock	4.9675	4.9718	4.95	4.9529	12187084.0
2009-06-25 10:25:00	AAPL	Stock	4.9539	4.9607	4.9432	4.9532	8905932.0
2009-06-25 10:30:00	AAPL	Stock	4.9532	4.9539	4.9407	4.9463	6504624.0
2009-06-25 10:35:00	AAPL	Stock	4.9471	4.9618	4.9457	4.9529	6324752.0
2009-06-25 10:40:00	AAPL	Stock	4.9529	4.9546	4.9439	4.9446	4853604.0
2009-06-25 10:45:00	AAPL	Stock	4.945	4.95	4.9446	4.9493	5138952.0
2009-06-25 10:50:00	AAPL	Stock	4.9493	4.9611	4.9486	4.9593	5880924.0
2009-06-25 10:55:00	AAPL	Stock	4.9589	4.9621	4.9489	4.9618	6139560.0
2009-06-25 11:00:00	AAPL	Stock	4.9621	4.9696	4.96	4.9693	7307832.0
2009-06-25 11:05:00	AAPL	Stock	4.9696	4.9696	4.9618	4.962	4010748.0
2009-06-25 11:10:00	AAPL	Stock	4.9618	4.9632	4.9568	4.9629	3496948.0
2009-06-25 11:15:00	AAPL	Stock	4.9629	4.9643	4.9582	4.9639	2924208.0

> showing 50 of 322,863 rows — these rows as CSV

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