PREVIEW / stock_5min / 2012-07-18

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-18.parquet
  size:    4.7 MB
  rows:    315,291
  symbols: 3,480

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-18 05:15:00	AAPL	Stock	21.6289	21.6289	21.6289	21.6289	2800.0
2012-07-18 05:45:00	AAPL	Stock	21.625	21.625	21.625	21.625	7000.0
2012-07-18 05:50:00	AAPL	Stock	21.625	21.6286	21.625	21.6286	8400.0
2012-07-18 06:00:00	AAPL	Stock	21.6214	21.6214	21.6214	21.6214	11200.0
2012-07-18 07:00:00	AAPL	Stock	21.6429	21.6429	21.6071	21.6071	53452.0
2012-07-18 07:10:00	AAPL	Stock	21.6429	21.6429	21.6429	21.6429	2800.0
2012-07-18 07:15:00	AAPL	Stock	21.6289	21.6289	21.625	21.625	16800.0
2012-07-18 07:40:00	AAPL	Stock	21.6364	21.6364	21.6364	21.6364	2800.0
2012-07-18 07:45:00	AAPL	Stock	21.6429	21.6439	21.6429	21.6429	25060.0
2012-07-18 07:55:00	AAPL	Stock	21.66	21.6607	21.66	21.6607	80080.0
2012-07-18 08:00:00	AAPL	Stock	21.6511	21.6729	21.6375	21.6643	99820.0
2012-07-18 08:05:00	AAPL	Stock	21.6582	21.6632	21.6568	21.6607	25928.0
2012-07-18 08:15:00	AAPL	Stock	21.6607	21.6607	21.6571	21.6571	9408.0
2012-07-18 08:20:00	AAPL	Stock	21.6657	21.6657	21.6511	21.6525	39228.0
2012-07-18 08:25:00	AAPL	Stock	21.6586	21.6714	21.6586	21.6714	25200.0
2012-07-18 08:30:00	AAPL	Stock	21.6757	21.6946	21.6646	21.6696	165312.0
2012-07-18 08:35:00	AAPL	Stock	21.6782	21.7	21.6714	21.6714	243684.0
2012-07-18 08:40:00	AAPL	Stock	21.6696	21.6968	21.6696	21.6864	227024.0
2012-07-18 08:45:00	AAPL	Stock	21.6857	21.6921	21.6804	21.6804	45668.0
2012-07-18 08:50:00	AAPL	Stock	21.6811	21.6811	21.6586	21.6661	98000.0
2012-07-18 08:55:00	AAPL	Stock	21.6682	21.6771	21.6564	21.6664	107016.0
2012-07-18 09:00:00	AAPL	Stock	21.6607	21.6607	21.6357	21.6382	113344.0
2012-07-18 09:05:00	AAPL	Stock	21.6389	21.6429	21.6268	21.6268	62020.0
2012-07-18 09:10:00	AAPL	Stock	21.6271	21.6407	21.6232	21.6289	151536.0
2012-07-18 09:15:00	AAPL	Stock	21.6264	21.6464	21.625	21.6429	165760.0
2012-07-18 09:20:00	AAPL	Stock	21.6536	21.6696	21.6536	21.6696	21000.0
2012-07-18 09:25:00	AAPL	Stock	21.6518	21.6679	21.6518	21.6679	37520.0
2012-07-18 09:30:00	AAPL	Stock	21.67	21.7018	21.6357	21.6989	7490168.0
2012-07-18 09:35:00	AAPL	Stock	21.6975	21.7264	21.6543	21.6632	8389752.0
2012-07-18 09:40:00	AAPL	Stock	21.6661	21.7143	21.6659	21.6771	4672556.0
2012-07-18 09:45:00	AAPL	Stock	21.675	21.6929	21.645	21.6584	5123048.0
2012-07-18 09:50:00	AAPL	Stock	21.6607	21.6614	21.5993	21.6339	8246420.0
2012-07-18 09:55:00	AAPL	Stock	21.6311	21.6418	21.605	21.6318	7371700.0
2012-07-18 10:00:00	AAPL	Stock	21.6336	21.7143	21.6323	21.6893	8197924.0
2012-07-18 10:05:00	AAPL	Stock	21.6875	21.7	21.6657	21.6811	5335064.0
2012-07-18 10:10:00	AAPL	Stock	21.6864	21.7	21.6482	21.6668	3600212.0
2012-07-18 10:15:00	AAPL	Stock	21.6654	21.6857	21.6554	21.6761	2999472.0
2012-07-18 10:20:00	AAPL	Stock	21.6732	21.6811	21.6557	21.6604	2626484.0
2012-07-18 10:25:00	AAPL	Stock	21.6611	21.6793	21.6357	21.6432	3533432.0
2012-07-18 10:30:00	AAPL	Stock	21.6446	21.6517	21.6114	21.6236	4343668.0
2012-07-18 10:35:00	AAPL	Stock	21.6236	21.6568	21.6236	21.6443	3331916.0
2012-07-18 10:40:00	AAPL	Stock	21.6443	21.6693	21.6443	21.6582	3421320.0
2012-07-18 10:45:00	AAPL	Stock	21.6571	21.6632	21.6161	21.6214	3260852.0
2012-07-18 10:50:00	AAPL	Stock	21.6246	21.6429	21.6161	21.6425	3314640.0
2012-07-18 10:55:00	AAPL	Stock	21.6401	21.6607	21.64	21.6554	2932384.0
2012-07-18 11:00:00	AAPL	Stock	21.6518	21.6607	21.6186	21.6225	2865072.0
2012-07-18 11:05:00	AAPL	Stock	21.6213	21.6375	21.6189	21.6329	2602124.0
2012-07-18 11:10:00	AAPL	Stock	21.6332	21.65	21.6326	21.6464	1668912.0
2012-07-18 11:15:00	AAPL	Stock	21.6495	21.6514	21.6307	21.6446	1731296.0
2012-07-18 11:20:00	AAPL	Stock	21.6464	21.6682	21.6413	21.6525	2736076.0

> showing 50 of 315,291 rows — these rows as CSV

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