PREVIEW / stock_5min / 2013-04-01

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-04-01.parquet
  size:    5.0 MB
  rows:    339,109
  symbols: 3,471

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-04-01 07:30:00	AAPL	Stock	15.7657	15.7786	15.7657	15.7786	8400.0
2013-04-01 07:40:00	AAPL	Stock	15.7786	15.785	15.7786	15.785	32508.0
2013-04-01 07:45:00	AAPL	Stock	15.7846	15.7857	15.7846	15.7857	23548.0
2013-04-01 08:00:00	AAPL	Stock	15.7682	15.8093	15.7679	15.8093	224504.0
2013-04-01 08:05:00	AAPL	Stock	15.8093	15.8096	15.8036	15.8096	102144.0
2013-04-01 08:10:00	AAPL	Stock	15.8204	15.8318	15.8125	15.8318	78596.0
2013-04-01 08:15:00	AAPL	Stock	15.8282	15.8386	15.8232	15.8286	83804.0
2013-04-01 08:20:00	AAPL	Stock	15.8239	15.8489	15.8239	15.8489	74424.0
2013-04-01 08:25:00	AAPL	Stock	15.8411	15.8429	15.8389	15.8429	155120.0
2013-04-01 08:30:00	AAPL	Stock	15.8429	15.8429	15.8304	15.8386	115976.0
2013-04-01 08:35:00	AAPL	Stock	15.8375	15.8393	15.8314	15.8386	53200.0
2013-04-01 08:40:00	AAPL	Stock	15.8411	15.8443	15.8382	15.8382	14000.0
2013-04-01 08:45:00	AAPL	Stock	15.8357	15.8479	15.8343	15.845	123200.0
2013-04-01 08:50:00	AAPL	Stock	15.8393	15.8482	15.8393	15.8393	136024.0
2013-04-01 08:55:00	AAPL	Stock	15.8429	15.8479	15.8375	15.8375	76804.0
2013-04-01 09:00:00	AAPL	Stock	15.8357	15.8357	15.8214	15.8214	361900.0
2013-04-01 09:05:00	AAPL	Stock	15.82	15.8214	15.8061	15.8096	44212.0
2013-04-01 09:10:00	AAPL	Stock	15.8054	15.8129	15.8054	15.8129	41860.0
2013-04-01 09:15:00	AAPL	Stock	15.8132	15.8214	15.8132	15.8214	31668.0
2013-04-01 09:20:00	AAPL	Stock	15.8296	15.8318	15.8236	15.8236	14000.0
2013-04-01 09:25:00	AAPL	Stock	15.8236	15.8354	15.7818	15.7818	202664.0
2013-04-01 09:30:00	AAPL	Stock	15.7857	15.8464	15.7446	15.8107	17796576.0
2013-04-01 09:35:00	AAPL	Stock	15.8125	15.8157	15.6679	15.7159	16542540.0
2013-04-01 09:40:00	AAPL	Stock	15.7172	15.7394	15.6261	15.6314	12007604.0
2013-04-01 09:45:00	AAPL	Stock	15.6371	15.6424	15.5775	15.5804	12960164.0
2013-04-01 09:50:00	AAPL	Stock	15.5836	15.6186	15.5825	15.6143	8721384.0
2013-04-01 09:55:00	AAPL	Stock	15.6143	15.6346	15.5861	15.5943	6676992.0
2013-04-01 10:00:00	AAPL	Stock	15.5971	15.6061	15.5268	15.5343	14939148.0
2013-04-01 10:05:00	AAPL	Stock	15.5321	15.5821	15.53	15.5643	9194192.0
2013-04-01 10:10:00	AAPL	Stock	15.562	15.5729	15.5418	15.5554	5548872.0
2013-04-01 10:15:00	AAPL	Stock	15.5586	15.5675	15.4957	15.5043	8258096.0
2013-04-01 10:20:00	AAPL	Stock	15.5057	15.525	15.4818	15.5143	8951264.0
2013-04-01 10:25:00	AAPL	Stock	15.5164	15.5514	15.5118	15.5411	7045360.0
2013-04-01 10:30:00	AAPL	Stock	15.5407	15.5407	15.5014	15.5018	6954108.0
2013-04-01 10:35:00	AAPL	Stock	15.5032	15.5204	15.4839	15.4871	4846884.0
2013-04-01 10:40:00	AAPL	Stock	15.484	15.5429	15.475	15.5393	6800808.0
2013-04-01 10:45:00	AAPL	Stock	15.5429	15.5621	15.5343	15.5572	4805052.0
2013-04-01 10:50:00	AAPL	Stock	15.5554	15.5775	15.5339	15.5511	6057548.0
2013-04-01 10:55:00	AAPL	Stock	15.5489	15.5661	15.5286	15.5379	3067456.0
2013-04-01 11:00:00	AAPL	Stock	15.5396	15.5407	15.5154	15.5329	4680872.0
2013-04-01 11:05:00	AAPL	Stock	15.5329	15.56	15.5271	15.5518	4856460.0
2013-04-01 11:10:00	AAPL	Stock	15.5543	15.5625	15.5389	15.5625	2049124.0
2013-04-01 11:15:00	AAPL	Stock	15.5622	15.5875	15.5536	15.5539	2872464.0
2013-04-01 11:20:00	AAPL	Stock	15.5539	15.5629	15.55	15.5585	2256800.0
2013-04-01 11:25:00	AAPL	Stock	15.5579	15.5625	15.5354	15.5504	3935624.0
2013-04-01 11:30:00	AAPL	Stock	15.5493	15.5621	15.5411	15.5475	1666056.0
2013-04-01 11:35:00	AAPL	Stock	15.5489	15.5504	15.5189	15.5279	2536352.0
2013-04-01 11:40:00	AAPL	Stock	15.53	15.5425	15.53	15.5359	1260476.0
2013-04-01 11:45:00	AAPL	Stock	15.5361	15.5625	15.5284	15.5596	1514128.0
2013-04-01 11:50:00	AAPL	Stock	15.5618	15.5618	15.5407	15.5419	927528.0

> showing 50 of 339,109 rows — these rows as CSV

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