PREVIEW / stock_5min / 2013-07-25

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-25.parquet
  size:    5.2 MB
  rows:    346,993
  symbols: 3,495

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
2013-07-25 04:00:00	AAPL	Stock	15.7714	15.7857	15.7714	15.7857	8400.0
2013-07-25 04:35:00	AAPL	Stock	15.7589	15.7589	15.7589	15.7589	2800.0
2013-07-25 05:15:00	AAPL	Stock	15.7493	15.7493	15.7321	15.7321	12516.0
2013-07-25 05:25:00	AAPL	Stock	15.7318	15.7318	15.7143	15.7143	13188.0
2013-07-25 05:30:00	AAPL	Stock	15.7143	15.7143	15.7143	15.7143	2800.0
2013-07-25 05:35:00	AAPL	Stock	15.6839	15.6839	15.6839	15.6839	2800.0
2013-07-25 05:45:00	AAPL	Stock	15.6839	15.6839	15.6786	15.6786	11816.0
2013-07-25 06:15:00	AAPL	Stock	15.6786	15.6786	15.6786	15.6786	16800.0
2013-07-25 06:50:00	AAPL	Stock	15.7036	15.7036	15.7036	15.7036	2800.0
2013-07-25 07:00:00	AAPL	Stock	15.6911	15.7143	15.6893	15.7018	98224.0
2013-07-25 07:15:00	AAPL	Stock	15.6968	15.6968	15.6968	15.6968	3024.0
2013-07-25 07:20:00	AAPL	Stock	15.7054	15.7143	15.7054	15.7143	22456.0
2013-07-25 07:25:00	AAPL	Stock	15.7054	15.7143	15.7054	15.7143	23520.0
2013-07-25 07:30:00	AAPL	Stock	15.7168	15.7168	15.7168	15.7168	2800.0
2013-07-25 07:35:00	AAPL	Stock	15.7229	15.73	15.7229	15.7293	30576.0
2013-07-25 07:40:00	AAPL	Stock	15.7243	15.7311	15.7232	15.7246	72940.0
2013-07-25 07:45:00	AAPL	Stock	15.7296	15.7314	15.7246	15.7246	32536.0
2013-07-25 07:50:00	AAPL	Stock	15.7261	15.7279	15.7157	15.7279	85400.0
2013-07-25 07:55:00	AAPL	Stock	15.7218	15.7268	15.7218	15.7268	14280.0
2013-07-25 08:00:00	AAPL	Stock	15.7214	15.7414	15.7036	15.7411	118804.0
2013-07-25 08:05:00	AAPL	Stock	15.74	15.7679	15.6786	15.7357	262920.0
2013-07-25 08:10:00	AAPL	Stock	15.7357	15.7357	15.7229	15.725	77700.0
2013-07-25 08:15:00	AAPL	Stock	15.725	15.725	15.6932	15.6932	126616.0
2013-07-25 08:20:00	AAPL	Stock	15.7004	15.7246	15.7004	15.7054	117348.0
2013-07-25 08:25:00	AAPL	Stock	15.71	15.725	15.71	15.7239	102508.0
2013-07-25 08:30:00	AAPL	Stock	15.7214	15.7411	15.7214	15.7411	43680.0
2013-07-25 08:35:00	AAPL	Stock	15.7418	15.7475	15.7411	15.7446	44100.0
2013-07-25 08:40:00	AAPL	Stock	15.7429	15.75	15.7421	15.7421	115080.0
2013-07-25 08:45:00	AAPL	Stock	15.7439	15.7564	15.7439	15.7564	115920.0
2013-07-25 08:50:00	AAPL	Stock	15.7571	15.7571	15.7471	15.7536	81200.0
2013-07-25 08:55:00	AAPL	Stock	15.7568	15.7593	15.7536	15.7536	67200.0
2013-07-25 09:00:00	AAPL	Stock	15.7539	15.7564	15.75	15.7564	65800.0
2013-07-25 09:05:00	AAPL	Stock	15.7554	15.7568	15.7532	15.7568	67060.0
2013-07-25 09:10:00	AAPL	Stock	15.7525	15.7575	15.75	15.75	142240.0
2013-07-25 09:15:00	AAPL	Stock	15.7518	15.7518	15.7354	15.7496	241220.0
2013-07-25 09:20:00	AAPL	Stock	15.7464	15.7546	15.7411	15.7546	209076.0
2013-07-25 09:25:00	AAPL	Stock	15.7529	15.7575	15.7286	15.7379	159852.0
2013-07-25 09:30:00	AAPL	Stock	15.7396	15.7643	15.6611	15.7432	12920852.0
2013-07-25 09:35:00	AAPL	Stock	15.7459	15.7486	15.6086	15.6339	16573480.0
2013-07-25 09:40:00	AAPL	Stock	15.6354	15.6471	15.5851	15.6046	8084748.0
2013-07-25 09:45:00	AAPL	Stock	15.6075	15.6279	15.6	15.6175	5826632.0
2013-07-25 09:50:00	AAPL	Stock	15.6125	15.6571	15.5871	15.6432	9129400.0
2013-07-25 09:55:00	AAPL	Stock	15.6479	15.6507	15.6175	15.6414	4191824.0
2013-07-25 10:00:00	AAPL	Stock	15.6429	15.6568	15.6107	15.6343	5056408.0
2013-07-25 10:05:00	AAPL	Stock	15.6332	15.6361	15.5754	15.5833	8657180.0
2013-07-25 10:10:00	AAPL	Stock	15.585	15.6046	15.5671	15.5764	6576920.0
2013-07-25 10:15:00	AAPL	Stock	15.5801	15.5954	15.5646	15.585	5367068.0
2013-07-25 10:20:00	AAPL	Stock	15.5848	15.6164	15.5845	15.6118	3628996.0
2013-07-25 10:25:00	AAPL	Stock	15.6125	15.6296	15.5918	15.6018	3218152.0
2013-07-25 10:30:00	AAPL	Stock	15.6019	15.6107	15.5831	15.5868	1881124.0

> showing 50 of 346,993 rows — these rows as CSV

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