PREVIEW / stock_5min / 2011-06-14

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-14.parquet
  size:    4.9 MB
  rows:    341,174
  symbols: 3,563

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
2011-06-14 04:00:00	AAPL	Stock	11.7182	11.7182	11.7182	11.7182	2800.0
2011-06-14 04:10:00	AAPL	Stock	11.7	11.7	11.7	11.7	2800.0
2011-06-14 05:50:00	AAPL	Stock	11.7321	11.7321	11.7321	11.7321	5600.0
2011-06-14 06:00:00	AAPL	Stock	11.7493	11.7493	11.7493	11.7493	4200.0
2011-06-14 06:30:00	AAPL	Stock	11.7493	11.7493	11.7464	11.7464	8400.0
2011-06-14 07:00:00	AAPL	Stock	11.7471	11.7471	11.7471	11.7471	2800.0
2011-06-14 07:05:00	AAPL	Stock	11.7407	11.7407	11.7407	11.7407	2800.0
2011-06-14 07:10:00	AAPL	Stock	11.7321	11.7332	11.7321	11.7332	15260.0
2011-06-14 07:15:00	AAPL	Stock	11.7339	11.7339	11.7339	11.7339	2800.0
2011-06-14 07:20:00	AAPL	Stock	11.7339	11.7339	11.7279	11.7279	5600.0
2011-06-14 07:25:00	AAPL	Stock	11.7336	11.7429	11.7336	11.7429	50400.0
2011-06-14 07:30:00	AAPL	Stock	11.7457	11.7489	11.7457	11.7489	52052.0
2011-06-14 07:35:00	AAPL	Stock	11.7586	11.7636	11.7575	11.7636	30800.0
2011-06-14 07:40:00	AAPL	Stock	11.7589	11.7589	11.7554	11.7554	14056.0
2011-06-14 07:45:00	AAPL	Stock	11.7554	11.7554	11.7554	11.7554	44044.0
2011-06-14 07:50:00	AAPL	Stock	11.7529	11.7529	11.7529	11.7529	2800.0
2011-06-14 07:55:00	AAPL	Stock	11.7536	11.7536	11.7536	11.7536	2800.0
2011-06-14 08:00:00	AAPL	Stock	11.7604	11.7604	11.7379	11.745	163772.0
2011-06-14 08:05:00	AAPL	Stock	11.7493	11.7604	11.7479	11.7554	47320.0
2011-06-14 08:10:00	AAPL	Stock	11.7554	11.7586	11.7471	11.7518	86128.0
2011-06-14 08:15:00	AAPL	Stock	11.7468	11.7536	11.7464	11.75	67088.0
2011-06-14 08:20:00	AAPL	Stock	11.7511	11.7511	11.7482	11.75	33600.0
2011-06-14 08:25:00	AAPL	Stock	11.75	11.7518	11.75	11.75	25200.0
2011-06-14 08:30:00	AAPL	Stock	11.75	11.7786	11.75	11.7786	351680.0
2011-06-14 08:35:00	AAPL	Stock	11.7786	11.7929	11.7786	11.7893	395724.0
2011-06-14 08:40:00	AAPL	Stock	11.7875	11.7893	11.7829	11.7857	256284.0
2011-06-14 08:45:00	AAPL	Stock	11.7875	11.7964	11.7839	11.7964	296772.0
2011-06-14 08:50:00	AAPL	Stock	11.7986	11.8179	11.79	11.8175	438704.0
2011-06-14 08:55:00	AAPL	Stock	11.8175	11.8179	11.8125	11.8139	278404.0
2011-06-14 09:00:00	AAPL	Stock	11.8125	11.8125	11.8036	11.8061	142800.0
2011-06-14 09:05:00	AAPL	Stock	11.8082	11.8086	11.8	11.8075	220976.0
2011-06-14 09:10:00	AAPL	Stock	11.8036	11.8096	11.8011	11.8036	153804.0
2011-06-14 09:15:00	AAPL	Stock	11.8007	11.8057	11.7975	11.8036	113932.0
2011-06-14 09:20:00	AAPL	Stock	11.8036	11.8079	11.8	11.8071	140280.0
2011-06-14 09:25:00	AAPL	Stock	11.8082	11.8143	11.7857	11.7857	509628.0
2011-06-14 09:30:00	AAPL	Stock	11.7864	11.7957	11.7611	11.7846	13814808.0
2011-06-14 09:35:00	AAPL	Stock	11.7857	11.8207	11.7821	11.8029	14546700.0
2011-06-14 09:40:00	AAPL	Stock	11.8029	11.8104	11.7964	11.7989	7718788.0
2011-06-14 09:45:00	AAPL	Stock	11.7989	11.8114	11.7914	11.8114	6162016.0
2011-06-14 09:50:00	AAPL	Stock	11.8104	11.8186	11.8	11.8145	5392576.0
2011-06-14 09:55:00	AAPL	Stock	11.8145	11.8429	11.8131	11.8361	11466140.0
2011-06-14 10:00:00	AAPL	Stock	11.8357	11.8536	11.8257	11.8514	6671644.0
2011-06-14 10:05:00	AAPL	Stock	11.8511	11.8625	11.8507	11.8536	9025296.0
2011-06-14 10:10:00	AAPL	Stock	11.8546	11.8646	11.85	11.8621	4173512.0
2011-06-14 10:15:00	AAPL	Stock	11.8618	11.865	11.8396	11.8482	5322044.0
2011-06-14 10:20:00	AAPL	Stock	11.8486	11.8543	11.8396	11.8439	2675316.0
2011-06-14 10:25:00	AAPL	Stock	11.8454	11.8518	11.8375	11.8464	3004148.0
2011-06-14 10:30:00	AAPL	Stock	11.8479	11.8725	11.8439	11.8634	5411924.0
2011-06-14 10:35:00	AAPL	Stock	11.8632	11.8671	11.8507	11.8545	3864700.0
2011-06-14 10:40:00	AAPL	Stock	11.8532	11.8546	11.8393	11.8434	4283888.0

> showing 50 of 341,174 rows — these rows as CSV

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