PREVIEW / stock_5min / 2012-05-31

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-05-31.parquet
  size:    5.1 MB
  rows:    337,520
  symbols: 3,548

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-05-31 04:10:00	AAPL	Stock	20.7321	20.7321	20.7321	20.7321	2800.0
2012-05-31 04:25:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	11200.0
2012-05-31 04:30:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	2800.0
2012-05-31 04:40:00	AAPL	Stock	20.7036	20.7036	20.7036	20.7036	14000.0
2012-05-31 05:10:00	AAPL	Stock	20.7321	20.7429	20.7321	20.7429	5600.0
2012-05-31 05:20:00	AAPL	Stock	20.725	20.7321	20.725	20.7321	33600.0
2012-05-31 05:25:00	AAPL	Stock	20.7143	20.7143	20.7143	20.7143	4900.0
2012-05-31 05:30:00	AAPL	Stock	20.7321	20.75	20.7143	20.75	25200.0
2012-05-31 05:35:00	AAPL	Stock	20.7732	20.7732	20.7411	20.7411	30800.0
2012-05-31 05:45:00	AAPL	Stock	20.7679	20.7679	20.7679	20.7679	5600.0
2012-05-31 06:15:00	AAPL	Stock	20.7679	20.7679	20.7679	20.7679	11200.0
2012-05-31 06:40:00	AAPL	Stock	20.7457	20.7457	20.7457	20.7457	14000.0
2012-05-31 06:50:00	AAPL	Stock	20.7321	20.7321	20.7321	20.7321	2800.0
2012-05-31 06:55:00	AAPL	Stock	20.7268	20.7268	20.7268	20.7268	5880.0
2012-05-31 07:00:00	AAPL	Stock	20.7268	20.7657	20.7268	20.7657	58240.0
2012-05-31 07:05:00	AAPL	Stock	20.75	20.75	20.7464	20.75	21000.0
2012-05-31 07:10:00	AAPL	Stock	20.75	20.7714	20.75	20.7714	62244.0
2012-05-31 07:15:00	AAPL	Stock	20.7746	20.775	20.7504	20.7614	64484.0
2012-05-31 07:20:00	AAPL	Stock	20.7607	20.7607	20.7421	20.7464	61656.0
2012-05-31 07:25:00	AAPL	Stock	20.7464	20.7489	20.7357	20.7357	14728.0
2012-05-31 07:30:00	AAPL	Stock	20.7364	20.7411	20.7268	20.7339	150836.0
2012-05-31 07:35:00	AAPL	Stock	20.7254	20.7321	20.7232	20.7318	62160.0
2012-05-31 07:40:00	AAPL	Stock	20.7321	20.74	20.7318	20.7318	51800.0
2012-05-31 07:45:00	AAPL	Stock	20.7286	20.7286	20.7232	20.7286	22400.0
2012-05-31 07:50:00	AAPL	Stock	20.7321	20.7354	20.7254	20.7254	59220.0
2012-05-31 07:55:00	AAPL	Stock	20.7264	20.74	20.7264	20.74	77000.0
2012-05-31 08:00:00	AAPL	Stock	20.7407	20.7607	20.6846	20.7571	572768.0
2012-05-31 08:05:00	AAPL	Stock	20.7586	20.7821	20.7571	20.7821	718536.0
2012-05-31 08:10:00	AAPL	Stock	20.7821	20.8071	20.7821	20.7911	603540.0
2012-05-31 08:15:00	AAPL	Stock	20.7929	20.8125	20.7718	20.8036	548296.0
2012-05-31 08:20:00	AAPL	Stock	20.8039	20.8054	20.7904	20.7982	234584.0
2012-05-31 08:25:00	AAPL	Stock	20.7943	20.7975	20.7857	20.7889	1053248.0
2012-05-31 08:30:00	AAPL	Stock	20.7889	20.8071	20.7714	20.8036	1173452.0
2012-05-31 08:35:00	AAPL	Stock	20.8025	20.8029	20.7714	20.7714	322700.0
2012-05-31 08:40:00	AAPL	Stock	20.7714	20.7786	20.7375	20.7514	595672.0
2012-05-31 08:45:00	AAPL	Stock	20.7504	20.7504	20.6846	20.7418	199304.0
2012-05-31 08:50:00	AAPL	Stock	20.7336	20.7704	20.7289	20.7686	343588.0
2012-05-31 08:55:00	AAPL	Stock	20.7686	20.7893	20.7589	20.7893	312732.0
2012-05-31 09:00:00	AAPL	Stock	20.795	20.7964	20.7771	20.7804	290780.0
2012-05-31 09:05:00	AAPL	Stock	20.7771	20.785	20.7625	20.7636	192864.0
2012-05-31 09:10:00	AAPL	Stock	20.7614	20.7839	20.7614	20.7807	110600.0
2012-05-31 09:15:00	AAPL	Stock	20.7821	20.7911	20.7764	20.7768	165984.0
2012-05-31 09:20:00	AAPL	Stock	20.7796	20.7911	20.7771	20.7911	127456.0
2012-05-31 09:25:00	AAPL	Stock	20.7904	20.8	20.7357	20.7446	974148.0
2012-05-31 09:30:00	AAPL	Stock	20.74	20.7679	20.6271	20.6632	19499900.0
2012-05-31 09:35:00	AAPL	Stock	20.6636	20.6636	20.6118	20.6396	11894428.0
2012-05-31 09:40:00	AAPL	Stock	20.6396	20.6996	20.6386	20.6707	10912440.0
2012-05-31 09:45:00	AAPL	Stock	20.6746	20.68	20.5829	20.5891	10807468.0
2012-05-31 09:50:00	AAPL	Stock	20.5861	20.6093	20.5621	20.5768	9041564.0
2012-05-31 09:55:00	AAPL	Stock	20.5819	20.6329	20.5743	20.6068	7505176.0

> showing 50 of 337,520 rows — these rows as CSV

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