PREVIEW / stock_5min / 2012-07-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-17.parquet
  size:    4.7 MB
  rows:    318,958
  symbols: 3,490

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-17 04:10:00	AAPL	Stock	21.7682	21.7682	21.7682	21.7682	2800.0
2012-07-17 04:40:00	AAPL	Stock	21.8029	21.8029	21.8	21.8	5600.0
2012-07-17 05:55:00	AAPL	Stock	21.8	21.8	21.8	21.8	2800.0
2012-07-17 06:05:00	AAPL	Stock	21.7964	21.7964	21.7964	21.7964	14700.0
2012-07-17 06:10:00	AAPL	Stock	21.8036	21.8036	21.8036	21.8036	8400.0
2012-07-17 06:40:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	2800.0
2012-07-17 06:55:00	AAPL	Stock	21.7918	21.7918	21.7911	21.7911	8400.0
2012-07-17 07:00:00	AAPL	Stock	21.7718	21.7825	21.7593	21.7804	58100.0
2012-07-17 07:10:00	AAPL	Stock	21.7618	21.7618	21.7596	21.7596	5600.0
2012-07-17 07:15:00	AAPL	Stock	21.7593	21.7804	21.7525	21.7679	218288.0
2012-07-17 07:20:00	AAPL	Stock	21.7821	21.7821	21.7821	21.7821	2800.0
2012-07-17 07:25:00	AAPL	Stock	21.7643	21.7643	21.7643	21.7643	5600.0
2012-07-17 07:30:00	AAPL	Stock	21.7643	21.7704	21.7643	21.7704	41776.0
2012-07-17 07:35:00	AAPL	Stock	21.775	21.775	21.775	21.775	3052.0
2012-07-17 07:40:00	AAPL	Stock	21.7839	21.7857	21.7829	21.7857	22400.0
2012-07-17 07:45:00	AAPL	Stock	21.7721	21.7907	21.7718	21.7857	32480.0
2012-07-17 07:50:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	11200.0
2012-07-17 07:55:00	AAPL	Stock	21.7925	21.8036	21.7925	21.8036	53088.0
2012-07-17 08:00:00	AAPL	Stock	21.7979	21.7979	21.7679	21.7746	446992.0
2012-07-17 08:05:00	AAPL	Stock	21.7746	21.7786	21.7682	21.7714	67592.0
2012-07-17 08:10:00	AAPL	Stock	21.77	21.7779	21.7696	21.775	79520.0
2012-07-17 08:15:00	AAPL	Stock	21.7757	21.7804	21.7757	21.7782	88172.0
2012-07-17 08:20:00	AAPL	Stock	21.7786	21.7811	21.77	21.7771	95256.0
2012-07-17 08:25:00	AAPL	Stock	21.775	21.7804	21.7704	21.7714	65100.0
2012-07-17 08:30:00	AAPL	Stock	21.7704	21.7761	21.7575	21.7761	150220.0
2012-07-17 08:35:00	AAPL	Stock	21.7689	21.7825	21.7679	21.7782	110936.0
2012-07-17 08:40:00	AAPL	Stock	21.7839	21.7893	21.7821	21.7893	161000.0
2012-07-17 08:45:00	AAPL	Stock	21.7929	21.81	21.7929	21.8032	177548.0
2012-07-17 08:50:00	AAPL	Stock	21.8036	21.8175	21.8036	21.8036	374640.0
2012-07-17 08:55:00	AAPL	Stock	21.8043	21.8343	21.8043	21.8279	371364.0
2012-07-17 09:00:00	AAPL	Stock	21.8268	21.83	21.8211	21.8268	190792.0
2012-07-17 09:05:00	AAPL	Stock	21.8221	21.8261	21.8057	21.8057	158480.0
2012-07-17 09:10:00	AAPL	Stock	21.8071	21.8257	21.8068	21.8214	170016.0
2012-07-17 09:15:00	AAPL	Stock	21.825	21.8254	21.8146	21.8154	298704.0
2012-07-17 09:20:00	AAPL	Stock	21.8146	21.8296	21.8146	21.8282	111720.0
2012-07-17 09:25:00	AAPL	Stock	21.8296	21.8296	21.8071	21.8175	439516.0
2012-07-17 09:30:00	AAPL	Stock	21.8139	21.8393	21.7643	21.7721	14368536.0
2012-07-17 09:35:00	AAPL	Stock	21.7736	21.8214	21.75	21.7861	8880312.0
2012-07-17 09:40:00	AAPL	Stock	21.7814	21.7971	21.7164	21.7389	8950396.0
2012-07-17 09:45:00	AAPL	Stock	21.7446	21.7768	21.7164	21.7193	6827380.0
2012-07-17 09:50:00	AAPL	Stock	21.72	21.7443	21.6989	21.7211	5183668.0
2012-07-17 09:55:00	AAPL	Stock	21.7239	21.7518	21.7214	21.7404	2476572.0
2012-07-17 10:00:00	AAPL	Stock	21.7396	21.7396	21.6429	21.6543	9068220.0
2012-07-17 10:05:00	AAPL	Stock	21.6529	21.6571	21.6114	21.6139	9102772.0
2012-07-17 10:10:00	AAPL	Stock	21.6182	21.67	21.5814	21.6611	9308488.0
2012-07-17 10:15:00	AAPL	Stock	21.6611	21.7036	21.6479	21.6929	6808788.0
2012-07-17 10:20:00	AAPL	Stock	21.6886	21.6993	21.6482	21.6818	3796800.0
2012-07-17 10:25:00	AAPL	Stock	21.6852	21.69	21.6464	21.6568	3476004.0
2012-07-17 10:30:00	AAPL	Stock	21.6518	21.6531	21.6171	21.6393	3893316.0
2012-07-17 10:35:00	AAPL	Stock	21.64	21.6521	21.5536	21.555	6616820.0

> showing 50 of 318,958 rows — these rows as CSV

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