PREVIEW / stock_5min / 2012-07-26

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-26.parquet
  size:    4.8 MB
  rows:    319,447
  symbols: 3,490

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-07-26 04:00:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	45780.0
2012-07-26 04:05:00	AAPL	Stock	20.6071	20.6071	20.5643	20.5643	25200.0
2012-07-26 04:10:00	AAPL	Stock	20.5643	20.5643	20.5536	20.5539	11200.0
2012-07-26 04:15:00	AAPL	Stock	20.5536	20.5536	20.5536	20.5536	2800.0
2012-07-26 04:35:00	AAPL	Stock	20.5714	20.5714	20.5714	20.5714	2800.0
2012-07-26 05:05:00	AAPL	Stock	20.5536	20.5536	20.5536	20.5536	2800.0
2012-07-26 05:40:00	AAPL	Stock	20.5646	20.5646	20.5646	20.5646	8400.0
2012-07-26 05:55:00	AAPL	Stock	20.5607	20.5607	20.5432	20.5432	36400.0
2012-07-26 06:05:00	AAPL	Stock	20.5411	20.5411	20.5411	20.5411	5600.0
2012-07-26 06:10:00	AAPL	Stock	20.5586	20.5646	20.5429	20.5646	37268.0
2012-07-26 06:15:00	AAPL	Stock	20.5646	20.5711	20.5646	20.5711	44520.0
2012-07-26 06:20:00	AAPL	Stock	20.5893	20.6071	20.5893	20.6071	52808.0
2012-07-26 06:25:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	5600.0
2012-07-26 06:30:00	AAPL	Stock	20.6057	20.6057	20.6057	20.6057	2800.0
2012-07-26 06:35:00	AAPL	Stock	20.6071	20.6161	20.6071	20.6161	5600.0
2012-07-26 06:40:00	AAPL	Stock	20.6571	20.6571	20.6571	20.6571	6720.0
2012-07-26 06:45:00	AAPL	Stock	20.6379	20.6379	20.625	20.625	31752.0
2012-07-26 06:50:00	AAPL	Stock	20.625	20.625	20.6093	20.625	14000.0
2012-07-26 06:55:00	AAPL	Stock	20.625	20.625	20.625	20.625	15400.0
2012-07-26 07:00:00	AAPL	Stock	20.625	20.6779	20.625	20.6779	61320.0
2012-07-26 07:05:00	AAPL	Stock	20.6768	20.7221	20.6764	20.7039	330960.0
2012-07-26 07:10:00	AAPL	Stock	20.7039	20.7121	20.6593	20.6875	191128.0
2012-07-26 07:15:00	AAPL	Stock	20.6875	20.7139	20.6875	20.7104	76300.0
2012-07-26 07:20:00	AAPL	Stock	20.7	20.7136	20.6975	20.7	162400.0
2012-07-26 07:25:00	AAPL	Stock	20.6964	20.6964	20.6757	20.6786	205436.0
2012-07-26 07:30:00	AAPL	Stock	20.6761	20.7061	20.675	20.7061	81536.0
2012-07-26 07:35:00	AAPL	Stock	20.7018	20.7411	20.7018	20.7411	178640.0
2012-07-26 07:40:00	AAPL	Stock	20.7357	20.7407	20.7179	20.7196	31696.0
2012-07-26 07:45:00	AAPL	Stock	20.7293	20.7389	20.7293	20.7321	134932.0
2012-07-26 07:50:00	AAPL	Stock	20.7314	20.7375	20.7089	20.7089	210000.0
2012-07-26 07:55:00	AAPL	Stock	20.7125	20.7246	20.6964	20.7071	141736.0
2012-07-26 08:00:00	AAPL	Stock	20.7079	20.7321	20.6818	20.6961	302680.0
2012-07-26 08:05:00	AAPL	Stock	20.6936	20.7064	20.6786	20.6911	231140.0
2012-07-26 08:10:00	AAPL	Stock	20.6893	20.6929	20.6429	20.6429	304024.0
2012-07-26 08:15:00	AAPL	Stock	20.6393	20.675	20.6393	20.675	148120.0
2012-07-26 08:20:00	AAPL	Stock	20.6786	20.6804	20.6718	20.6804	142044.0
2012-07-26 08:25:00	AAPL	Stock	20.6818	20.6911	20.6479	20.6504	228452.0
2012-07-26 08:30:00	AAPL	Stock	20.6571	20.6704	20.5357	20.5907	1982596.0
2012-07-26 08:35:00	AAPL	Stock	20.5907	20.6286	20.5775	20.6029	787220.0
2012-07-26 08:40:00	AAPL	Stock	20.5982	20.6071	20.5804	20.5932	446992.0
2012-07-26 08:45:00	AAPL	Stock	20.5957	20.5957	20.5346	20.5754	487396.0
2012-07-26 08:50:00	AAPL	Stock	20.5818	20.5857	20.5536	20.5829	277004.0
2012-07-26 08:55:00	AAPL	Stock	20.5804	20.5804	20.5536	20.5789	227024.0
2012-07-26 09:00:00	AAPL	Stock	20.5771	20.5786	20.5632	20.5671	209216.0
2012-07-26 09:05:00	AAPL	Stock	20.5679	20.5714	20.5543	20.5621	180208.0
2012-07-26 09:10:00	AAPL	Stock	20.5607	20.5839	20.5571	20.5786	255892.0
2012-07-26 09:15:00	AAPL	Stock	20.5761	20.6071	20.5754	20.6054	388444.0
2012-07-26 09:20:00	AAPL	Stock	20.605	20.6311	20.6004	20.6286	487564.0
2012-07-26 09:25:00	AAPL	Stock	20.6268	20.7307	20.6146	20.7079	2297736.0
2012-07-26 09:30:00	AAPL	Stock	20.7054	20.7286	20.5957	20.6254	17082072.0

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

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