PREVIEW / stock_5min / 2012-07-10

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-10.parquet
  size:    4.7 MB
  rows:    315,573
  symbols: 3,505

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-10 04:00:00	AAPL	Stock	21.8775	21.8775	21.8775	21.8775	11200.0
2012-07-10 04:05:00	AAPL	Stock	21.8782	21.8789	21.8782	21.8789	5600.0
2012-07-10 04:20:00	AAPL	Stock	21.8775	21.8775	21.8775	21.8775	2800.0
2012-07-10 05:15:00	AAPL	Stock	21.9657	21.9657	21.9654	21.9654	14000.0
2012-07-10 05:20:00	AAPL	Stock	21.9657	21.9657	21.9654	21.9654	8400.0
2012-07-10 05:25:00	AAPL	Stock	21.9654	21.975	21.965	21.975	11200.0
2012-07-10 05:30:00	AAPL	Stock	21.975	21.9964	21.975	21.9964	16772.0
2012-07-10 05:55:00	AAPL	Stock	22.0321	22.0321	22.0321	22.0321	2800.0
2012-07-10 06:10:00	AAPL	Stock	21.9893	21.9893	21.9839	21.9893	57680.0
2012-07-10 06:15:00	AAPL	Stock	21.9893	21.9893	21.9893	21.9893	2800.0
2012-07-10 06:20:00	AAPL	Stock	21.9893	21.9893	21.9821	21.9893	51296.0
2012-07-10 06:25:00	AAPL	Stock	21.9893	21.9893	21.9893	21.9893	9100.0
2012-07-10 07:00:00	AAPL	Stock	22.0139	22.0243	21.9946	22.0179	99036.0
2012-07-10 07:05:00	AAPL	Stock	22.0179	22.0393	22.0107	22.0179	442036.0
2012-07-10 07:10:00	AAPL	Stock	22.0107	22.0129	21.9804	21.9804	164668.0
2012-07-10 07:15:00	AAPL	Stock	21.9861	21.9893	21.9625	21.9625	211932.0
2012-07-10 07:20:00	AAPL	Stock	21.9714	21.9929	21.9714	21.9907	39200.0
2012-07-10 07:25:00	AAPL	Stock	21.9893	21.9925	21.9821	21.9829	77728.0
2012-07-10 07:30:00	AAPL	Stock	21.9821	21.9925	21.9725	21.9925	68600.0
2012-07-10 07:35:00	AAPL	Stock	21.9918	21.9929	21.9893	21.9893	97496.0
2012-07-10 07:40:00	AAPL	Stock	21.9875	21.9907	21.9821	21.9907	51240.0
2012-07-10 07:45:00	AAPL	Stock	21.9907	22.0143	21.9818	22.0	246736.0
2012-07-10 07:50:00	AAPL	Stock	22.0	22.0125	21.9979	22.0071	108360.0
2012-07-10 07:55:00	AAPL	Stock	22.0071	22.0214	22.0071	22.0089	108808.0
2012-07-10 08:00:00	AAPL	Stock	22.0039	22.0464	21.9682	22.0464	839888.0
2012-07-10 08:05:00	AAPL	Stock	22.0464	22.0536	22.0357	22.0536	670236.0
2012-07-10 08:10:00	AAPL	Stock	22.0514	22.0671	22.0482	22.0582	393848.0
2012-07-10 08:15:00	AAPL	Stock	22.0579	22.0729	22.0571	22.0679	667716.0
2012-07-10 08:20:00	AAPL	Stock	22.0657	22.0739	22.0357	22.0411	1482600.0
2012-07-10 08:25:00	AAPL	Stock	22.0407	22.0536	22.0357	22.0429	459816.0
2012-07-10 08:30:00	AAPL	Stock	22.0429	22.0518	22.0089	22.0168	804720.0
2012-07-10 08:35:00	AAPL	Stock	22.0143	22.0279	22.0107	22.0268	130200.0
2012-07-10 08:40:00	AAPL	Stock	22.0286	22.0443	22.0254	22.0429	215320.0
2012-07-10 08:45:00	AAPL	Stock	22.0425	22.0425	22.0339	22.0407	103460.0
2012-07-10 08:50:00	AAPL	Stock	22.0421	22.0504	22.0364	22.0461	387380.0
2012-07-10 08:55:00	AAPL	Stock	22.0425	22.0432	22.0321	22.0357	490896.0
2012-07-10 09:00:00	AAPL	Stock	22.0346	22.0536	22.0346	22.0536	210616.0
2012-07-10 09:05:00	AAPL	Stock	22.0536	22.0714	22.0475	22.0661	382844.0
2012-07-10 09:10:00	AAPL	Stock	22.0671	22.0811	22.0625	22.0804	475440.0
2012-07-10 09:15:00	AAPL	Stock	22.0836	22.0836	22.0657	22.0757	699776.0
2012-07-10 09:20:00	AAPL	Stock	22.0754	22.0796	22.0671	22.0771	1069544.0
2012-07-10 09:25:00	AAPL	Stock	22.0757	22.0775	22.0668	22.0682	590072.0
2012-07-10 09:30:00	AAPL	Stock	22.0689	22.1382	22.0643	22.0929	27076588.0
2012-07-10 09:35:00	AAPL	Stock	22.0932	22.1139	22.0436	22.1111	17600380.0
2012-07-10 09:40:00	AAPL	Stock	22.1136	22.1225	22.0514	22.0514	14556892.0
2012-07-10 09:45:00	AAPL	Stock	22.0518	22.0839	22.0286	22.0521	12564776.0
2012-07-10 09:50:00	AAPL	Stock	22.0503	22.0982	22.0361	22.0854	8165472.0
2012-07-10 09:55:00	AAPL	Stock	22.0925	22.0979	22.0586	22.063	6335840.0
2012-07-10 10:00:00	AAPL	Stock	22.0671	22.0996	22.0593	22.0945	7402304.0
2012-07-10 10:05:00	AAPL	Stock	22.0957	22.0964	22.0221	22.0232	12292812.0

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

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