PREVIEW / stock_5min / 2013-07-02

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-02.parquet
  size:    5.1 MB
  rows:    341,856
  symbols: 3,503

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-02 04:25:00	AAPL	Stock	14.6829	14.6829	14.6829	14.6829	16800.0
2013-07-02 04:30:00	AAPL	Stock	14.6875	14.6875	14.6875	14.6875	2800.0
2013-07-02 04:40:00	AAPL	Stock	14.6882	14.6882	14.6882	14.6882	2800.0
2013-07-02 04:50:00	AAPL	Stock	14.6893	14.6893	14.6893	14.6893	2800.0
2013-07-02 05:30:00	AAPL	Stock	14.6821	14.6821	14.6821	14.6821	2800.0
2013-07-02 06:00:00	AAPL	Stock	14.655	14.655	14.6518	14.655	11200.0
2013-07-02 06:45:00	AAPL	Stock	14.6779	14.6779	14.6779	14.6779	2800.0
2013-07-02 07:00:00	AAPL	Stock	14.6729	14.6729	14.6729	14.6729	2800.0
2013-07-02 07:05:00	AAPL	Stock	14.6729	14.6732	14.6607	14.6707	25200.0
2013-07-02 07:10:00	AAPL	Stock	14.6675	14.6675	14.6643	14.6643	14000.0
2013-07-02 07:15:00	AAPL	Stock	14.6643	14.67	14.6643	14.67	30800.0
2013-07-02 07:20:00	AAPL	Stock	14.67	14.7132	14.67	14.7132	123900.0
2013-07-02 07:25:00	AAPL	Stock	14.7118	14.7311	14.7114	14.7307	171472.0
2013-07-02 07:30:00	AAPL	Stock	14.7311	14.7357	14.7143	14.7232	152964.0
2013-07-02 07:35:00	AAPL	Stock	14.7243	14.7243	14.7054	14.7071	25200.0
2013-07-02 07:40:00	AAPL	Stock	14.6986	14.7225	14.6986	14.7196	83048.0
2013-07-02 07:45:00	AAPL	Stock	14.6975	14.6979	14.6964	14.6964	28140.0
2013-07-02 07:50:00	AAPL	Stock	14.7036	14.7036	14.6929	14.6929	27832.0
2013-07-02 07:55:00	AAPL	Stock	14.6929	14.6964	14.6632	14.6804	179200.0
2013-07-02 08:00:00	AAPL	Stock	14.6843	14.7321	14.6464	14.6536	394380.0
2013-07-02 08:05:00	AAPL	Stock	14.6536	14.6586	14.6464	14.6568	180124.0
2013-07-02 08:10:00	AAPL	Stock	14.655	14.655	14.6257	14.6407	314384.0
2013-07-02 08:15:00	AAPL	Stock	14.6373	14.6425	14.615	14.6246	112000.0
2013-07-02 08:20:00	AAPL	Stock	14.62	14.6375	14.5939	14.6225	197512.0
2013-07-02 08:25:00	AAPL	Stock	14.6143	14.6261	14.6021	14.6107	220248.0
2013-07-02 08:30:00	AAPL	Stock	14.5971	14.6071	14.5875	14.6071	88200.0
2013-07-02 08:35:00	AAPL	Stock	14.6211	14.6307	14.6125	14.6307	139496.0
2013-07-02 08:40:00	AAPL	Stock	14.6286	14.6357	14.625	14.6282	328384.0
2013-07-02 08:45:00	AAPL	Stock	14.6311	14.6314	14.6075	14.6139	221284.0
2013-07-02 08:50:00	AAPL	Stock	14.6143	14.6207	14.6025	14.6118	160216.0
2013-07-02 08:55:00	AAPL	Stock	14.6079	14.6375	14.6075	14.6375	245784.0
2013-07-02 09:00:00	AAPL	Stock	14.6375	14.65	14.6289	14.6464	222348.0
2013-07-02 09:05:00	AAPL	Stock	14.6475	14.6589	14.625	14.625	552160.0
2013-07-02 09:10:00	AAPL	Stock	14.6279	14.6418	14.6196	14.6196	223860.0
2013-07-02 09:15:00	AAPL	Stock	14.625	14.6364	14.6214	14.625	165760.0
2013-07-02 09:20:00	AAPL	Stock	14.6221	14.63	14.6204	14.6293	64064.0
2013-07-02 09:25:00	AAPL	Stock	14.6179	14.6429	14.6143	14.6364	227976.0
2013-07-02 09:30:00	AAPL	Stock	14.6364	14.7314	14.6239	14.7107	21695240.0
2013-07-02 09:35:00	AAPL	Stock	14.7107	14.7964	14.7018	14.7929	17609368.0
2013-07-02 09:40:00	AAPL	Stock	14.7929	14.8489	14.7814	14.8179	18720968.0
2013-07-02 09:45:00	AAPL	Stock	14.8211	14.8714	14.8089	14.8479	10194716.0
2013-07-02 09:50:00	AAPL	Stock	14.8479	14.9089	14.8436	14.8996	11479748.0
2013-07-02 09:55:00	AAPL	Stock	14.8993	14.9139	14.8661	14.9007	11199748.0
2013-07-02 10:00:00	AAPL	Stock	14.9029	14.9136	14.8846	14.8914	9635892.0
2013-07-02 10:05:00	AAPL	Stock	14.8939	14.9561	14.8914	14.9145	14078736.0
2013-07-02 10:10:00	AAPL	Stock	14.9179	14.9446	14.9111	14.9379	6256880.0
2013-07-02 10:15:00	AAPL	Stock	14.9359	14.9632	14.9143	14.9543	8143044.0
2013-07-02 10:20:00	AAPL	Stock	14.9552	14.9811	14.9514	14.9768	10114776.0
2013-07-02 10:25:00	AAPL	Stock	14.9761	14.9786	14.9429	14.9507	8945776.0
2013-07-02 10:30:00	AAPL	Stock	14.9579	14.9579	14.9339	14.9516	5651660.0

> showing 50 of 341,856 rows — these rows as CSV

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