PREVIEW / stock_5min / 2012-07-19

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-19.parquet
  size:    4.6 MB
  rows:    310,594
  symbols: 3,485

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-19 04:00:00	AAPL	Stock	21.7839	21.7839	21.7839	21.7839	2800.0
2012-07-19 04:05:00	AAPL	Stock	21.8032	21.8032	21.8032	21.8032	3220.0
2012-07-19 05:35:00	AAPL	Stock	21.7843	21.7843	21.7843	21.7843	2800.0
2012-07-19 05:40:00	AAPL	Stock	21.7843	21.7843	21.7843	21.7843	2800.0
2012-07-19 05:55:00	AAPL	Stock	21.7843	21.7846	21.7843	21.7846	14000.0
2012-07-19 06:00:00	AAPL	Stock	21.8	21.8	21.8	21.8	3360.0
2012-07-19 06:05:00	AAPL	Stock	21.8	21.8143	21.8	21.8143	16240.0
2012-07-19 06:10:00	AAPL	Stock	21.8143	21.8143	21.8143	21.8143	5600.0
2012-07-19 06:35:00	AAPL	Stock	21.7893	21.7893	21.7786	21.7786	43540.0
2012-07-19 06:40:00	AAPL	Stock	21.7554	21.7554	21.7554	21.7554	2800.0
2012-07-19 06:50:00	AAPL	Stock	21.7821	21.7821	21.7821	21.7821	2800.0
2012-07-19 06:55:00	AAPL	Stock	21.7821	21.7821	21.7821	21.7821	5600.0
2012-07-19 07:00:00	AAPL	Stock	21.7786	21.7804	21.7682	21.7714	17780.0
2012-07-19 07:05:00	AAPL	Stock	21.7779	21.7804	21.7779	21.7804	28000.0
2012-07-19 07:10:00	AAPL	Stock	21.7679	21.7679	21.7607	21.7607	8400.0
2012-07-19 07:20:00	AAPL	Stock	21.75	21.75	21.7418	21.75	20132.0
2012-07-19 07:25:00	AAPL	Stock	21.7464	21.75	21.7446	21.75	38668.0
2012-07-19 07:30:00	AAPL	Stock	21.7464	21.75	21.7464	21.75	32200.0
2012-07-19 07:35:00	AAPL	Stock	21.7404	21.7404	21.7404	21.7404	2800.0
2012-07-19 07:40:00	AAPL	Stock	21.7411	21.75	21.7286	21.75	36512.0
2012-07-19 07:45:00	AAPL	Stock	21.75	21.7818	21.75	21.7818	61320.0
2012-07-19 07:50:00	AAPL	Stock	21.7818	21.7857	21.7611	21.7857	266756.0
2012-07-19 07:55:00	AAPL	Stock	21.7857	21.7857	21.7786	21.7786	53704.0
2012-07-19 08:00:00	AAPL	Stock	21.7721	21.7857	21.75	21.7625	250040.0
2012-07-19 08:05:00	AAPL	Stock	21.7679	21.7929	21.7661	21.7814	264040.0
2012-07-19 08:10:00	AAPL	Stock	21.7821	21.79	21.7786	21.79	131600.0
2012-07-19 08:15:00	AAPL	Stock	21.7857	21.8032	21.7857	21.7929	136192.0
2012-07-19 08:20:00	AAPL	Stock	21.7911	21.8125	21.7911	21.8036	250740.0
2012-07-19 08:25:00	AAPL	Stock	21.8004	21.8043	21.7925	21.7954	130704.0
2012-07-19 08:30:00	AAPL	Stock	21.7857	21.7957	21.7636	21.7821	612696.0
2012-07-19 08:35:00	AAPL	Stock	21.7821	21.7889	21.7821	21.7889	278880.0
2012-07-19 08:40:00	AAPL	Stock	21.7889	21.7918	21.7821	21.7821	180656.0
2012-07-19 08:45:00	AAPL	Stock	21.7854	21.8129	21.7846	21.7996	335748.0
2012-07-19 08:50:00	AAPL	Stock	21.8	21.8082	21.7929	21.7929	219016.0
2012-07-19 08:55:00	AAPL	Stock	21.7946	21.8071	21.7904	21.7946	210700.0
2012-07-19 09:00:00	AAPL	Stock	21.7996	21.8036	21.7857	21.7975	425376.0
2012-07-19 09:05:00	AAPL	Stock	21.7957	21.8107	21.7957	21.8107	189000.0
2012-07-19 09:10:00	AAPL	Stock	21.8093	21.875	21.8089	21.8736	864584.0
2012-07-19 09:15:00	AAPL	Stock	21.8729	21.8857	21.8286	21.8289	717108.0
2012-07-19 09:20:00	AAPL	Stock	21.835	21.8639	21.8282	21.8611	439516.0
2012-07-19 09:25:00	AAPL	Stock	21.8607	21.875	21.8321	21.8336	580860.0
2012-07-19 09:30:00	AAPL	Stock	21.8329	21.8739	21.7889	21.793	21630588.0
2012-07-19 09:35:00	AAPL	Stock	21.7936	21.8179	21.7539	21.7718	12287296.0
2012-07-19 09:40:00	AAPL	Stock	21.7679	21.8143	21.7639	21.7846	8515220.0
2012-07-19 09:45:00	AAPL	Stock	21.7818	21.7889	21.7232	21.7539	8983212.0
2012-07-19 09:50:00	AAPL	Stock	21.7532	21.7579	21.7346	21.7511	4532360.0
2012-07-19 09:55:00	AAPL	Stock	21.7514	21.7657	21.7375	21.7643	4312868.0
2012-07-19 10:00:00	AAPL	Stock	21.7632	21.7818	21.7439	21.7815	7009212.0
2012-07-19 10:05:00	AAPL	Stock	21.7771	21.7771	21.7411	21.7611	5306896.0
2012-07-19 10:10:00	AAPL	Stock	21.7582	21.7839	21.7468	21.7839	6487656.0

> showing 50 of 310,594 rows — these rows as CSV

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