PREVIEW / stock_5min / 2012-09-04

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-04.parquet
  size:    4.7 MB
  rows:    319,067
  symbols: 3,468

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
2012-09-04 04:05:00	AAPL	Stock	23.8607	23.8625	23.8571	23.8571	11200.0
2012-09-04 04:10:00	AAPL	Stock	23.8575	23.875	23.8575	23.875	55496.0
2012-09-04 04:15:00	AAPL	Stock	23.8575	23.8589	23.8571	23.8589	30296.0
2012-09-04 04:20:00	AAPL	Stock	23.8589	23.8589	23.8589	23.8589	8400.0
2012-09-04 04:25:00	AAPL	Stock	23.8771	23.8839	23.875	23.875	29120.0
2012-09-04 04:30:00	AAPL	Stock	23.8661	23.8661	23.8661	23.8661	14000.0
2012-09-04 05:55:00	AAPL	Stock	23.8839	23.8839	23.8839	23.8839	16800.0
2012-09-04 06:00:00	AAPL	Stock	23.8839	23.8839	23.8839	23.8839	5180.0
2012-09-04 06:40:00	AAPL	Stock	23.86	23.86	23.86	23.86	2800.0
2012-09-04 07:00:00	AAPL	Stock	23.8568	23.8568	23.8304	23.8304	25340.0
2012-09-04 07:05:00	AAPL	Stock	23.8304	23.8304	23.8186	23.8239	25200.0
2012-09-04 07:10:00	AAPL	Stock	23.8225	23.8225	23.8096	23.8096	28168.0
2012-09-04 07:15:00	AAPL	Stock	23.8036	23.8107	23.8036	23.8071	44884.0
2012-09-04 07:20:00	AAPL	Stock	23.8214	23.8304	23.8211	23.8304	33768.0
2012-09-04 07:25:00	AAPL	Stock	23.8339	23.8357	23.8339	23.8357	16800.0
2012-09-04 07:30:00	AAPL	Stock	23.8357	23.8571	23.8357	23.8482	81620.0
2012-09-04 07:35:00	AAPL	Stock	23.8482	23.8668	23.8482	23.8607	120848.0
2012-09-04 07:40:00	AAPL	Stock	23.8636	23.8636	23.8482	23.8482	94108.0
2012-09-04 07:45:00	AAPL	Stock	23.8625	23.8671	23.8568	23.8671	37800.0
2012-09-04 07:50:00	AAPL	Stock	23.8529	23.8614	23.8443	23.8486	42000.0
2012-09-04 07:55:00	AAPL	Stock	23.8436	23.8571	23.8436	23.8571	48608.0
2012-09-04 08:00:00	AAPL	Stock	23.8482	23.8543	23.8214	23.8393	214844.0
2012-09-04 08:05:00	AAPL	Stock	23.8286	23.9286	23.8018	23.8146	225204.0
2012-09-04 08:10:00	AAPL	Stock	23.8107	23.8146	23.7946	23.8032	134848.0
2012-09-04 08:15:00	AAPL	Stock	23.7882	23.7932	23.7732	23.7893	166348.0
2012-09-04 08:20:00	AAPL	Stock	23.7879	23.7879	23.6964	23.765	200088.0
2012-09-04 08:25:00	AAPL	Stock	23.765	23.7679	23.7321	23.7679	209664.0
2012-09-04 08:30:00	AAPL	Stock	23.7686	23.7746	23.7586	23.7707	197792.0
2012-09-04 08:35:00	AAPL	Stock	23.7679	23.7889	23.7679	23.7889	80668.0
2012-09-04 08:40:00	AAPL	Stock	23.7861	23.7957	23.7857	23.7954	30240.0
2012-09-04 08:45:00	AAPL	Stock	23.79	23.79	23.7804	23.7804	35000.0
2012-09-04 08:50:00	AAPL	Stock	23.7854	23.7875	23.7854	23.7875	16800.0
2012-09-04 08:55:00	AAPL	Stock	23.7857	23.7857	23.7704	23.7704	35588.0
2012-09-04 09:00:00	AAPL	Stock	23.7643	23.7704	23.7582	23.7646	38360.0
2012-09-04 09:05:00	AAPL	Stock	23.7625	23.775	23.7611	23.7611	121240.0
2012-09-04 09:10:00	AAPL	Stock	23.7618	23.7764	23.7589	23.7714	99680.0
2012-09-04 09:15:00	AAPL	Stock	23.7714	23.7857	23.7714	23.7846	186340.0
2012-09-04 09:20:00	AAPL	Stock	23.7786	23.7789	23.7589	23.7589	164556.0
2012-09-04 09:25:00	AAPL	Stock	23.7589	23.7854	23.7589	23.7768	364560.0
2012-09-04 09:30:00	AAPL	Stock	23.7771	23.9079	23.7682	23.9004	16542232.0
2012-09-04 09:35:00	AAPL	Stock	23.9004	23.9225	23.8636	23.8664	11121684.0
2012-09-04 09:40:00	AAPL	Stock	23.8639	23.875	23.8254	23.8361	7952252.0
2012-09-04 09:45:00	AAPL	Stock	23.8369	23.8929	23.8307	23.8793	5574016.0
2012-09-04 09:50:00	AAPL	Stock	23.8829	23.9	23.8571	23.8929	3727920.0
2012-09-04 09:55:00	AAPL	Stock	23.8984	23.9582	23.8854	23.9518	9568692.0
2012-09-04 10:00:00	AAPL	Stock	23.9486	23.9932	23.9286	23.9634	9381372.0
2012-09-04 10:05:00	AAPL	Stock	23.9679	23.9771	23.9164	23.9246	8017716.0
2012-09-04 10:10:00	AAPL	Stock	23.9229	23.9336	23.8964	23.9286	5715808.0
2012-09-04 10:15:00	AAPL	Stock	23.9254	23.9614	23.9064	23.9371	5967444.0
2012-09-04 10:20:00	AAPL	Stock	23.9407	23.9421	23.8811	23.9032	4265436.0

> showing 50 of 319,067 rows — these rows as CSV

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