PREVIEW / stock_5min / 2013-07-29

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-29.parquet
  size:    5.0 MB
  rows:    333,737
  symbols: 3,504

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-29 04:00:00	AAPL	Stock	15.7661	15.7661	15.75	15.75	11200.0
2013-07-29 05:45:00	AAPL	Stock	15.7571	15.7571	15.7571	15.7571	2800.0
2013-07-29 06:50:00	AAPL	Stock	15.75	15.75	15.75	15.75	2800.0
2013-07-29 07:05:00	AAPL	Stock	15.7571	15.7571	15.7464	15.7468	19600.0
2013-07-29 07:15:00	AAPL	Stock	15.7457	15.7582	15.7457	15.7582	27160.0
2013-07-29 07:20:00	AAPL	Stock	15.7679	15.7679	15.7679	15.7679	5600.0
2013-07-29 07:35:00	AAPL	Stock	15.7321	15.7321	15.7279	15.7279	11200.0
2013-07-29 07:40:00	AAPL	Stock	15.7321	15.7321	15.7136	15.7143	58800.0
2013-07-29 07:45:00	AAPL	Stock	15.7143	15.7143	15.7143	15.7143	8484.0
2013-07-29 07:55:00	AAPL	Stock	15.7289	15.7289	15.7289	15.7289	2800.0
2013-07-29 08:00:00	AAPL	Stock	15.7429	15.7843	15.7143	15.7143	73808.0
2013-07-29 08:05:00	AAPL	Stock	15.7232	15.7261	15.7232	15.7261	11200.0
2013-07-29 08:10:00	AAPL	Stock	15.7239	15.7239	15.7239	15.7239	5040.0
2013-07-29 08:15:00	AAPL	Stock	15.7321	15.7321	15.7232	15.7232	5600.0
2013-07-29 08:20:00	AAPL	Stock	15.7232	15.7429	15.7179	15.7429	53200.0
2013-07-29 08:30:00	AAPL	Stock	15.7443	15.7443	15.7364	15.7364	28000.0
2013-07-29 08:35:00	AAPL	Stock	15.7425	15.7429	15.7418	15.7429	28000.0
2013-07-29 08:40:00	AAPL	Stock	15.7386	15.7411	15.7325	15.7325	36400.0
2013-07-29 08:45:00	AAPL	Stock	15.7321	15.7321	15.7232	15.7286	19040.0
2013-07-29 08:50:00	AAPL	Stock	15.7254	15.7254	15.7179	15.725	45276.0
2013-07-29 08:55:00	AAPL	Stock	15.7254	15.7282	15.7254	15.7268	32172.0
2013-07-29 09:00:00	AAPL	Stock	15.7221	15.7232	15.7171	15.7171	72520.0
2013-07-29 09:05:00	AAPL	Stock	15.725	15.7279	15.7175	15.7239	98084.0
2013-07-29 09:10:00	AAPL	Stock	15.7186	15.7186	15.7168	15.7175	22764.0
2013-07-29 09:15:00	AAPL	Stock	15.7179	15.7179	15.7179	15.7179	2800.0
2013-07-29 09:20:00	AAPL	Stock	15.7229	15.7279	15.7193	15.7279	128100.0
2013-07-29 09:25:00	AAPL	Stock	15.7275	15.7729	15.7179	15.7257	426860.0
2013-07-29 09:30:00	AAPL	Stock	15.7429	15.83	15.7214	15.8118	14043372.0
2013-07-29 09:35:00	AAPL	Stock	15.8118	15.94	15.8091	15.9171	18401180.0
2013-07-29 09:40:00	AAPL	Stock	15.9175	15.9786	15.9171	15.9732	9955008.0
2013-07-29 09:45:00	AAPL	Stock	15.975	15.9776	15.9486	15.9568	5840912.0
2013-07-29 09:50:00	AAPL	Stock	15.9587	16.0157	15.9518	16.0086	9508940.0
2013-07-29 09:55:00	AAPL	Stock	16.0104	16.0264	15.9846	16.0032	6962956.0
2013-07-29 10:00:00	AAPL	Stock	16.0051	16.0279	15.9897	16.0007	5352508.0
2013-07-29 10:05:00	AAPL	Stock	16.0068	16.0143	15.985	15.985	5533752.0
2013-07-29 10:10:00	AAPL	Stock	15.9852	15.9925	15.9575	15.9611	4975152.0
2013-07-29 10:15:00	AAPL	Stock	15.9639	15.9861	15.9582	15.9768	2569672.0
2013-07-29 10:20:00	AAPL	Stock	15.9764	16.0121	15.9714	15.9921	3544828.0
2013-07-29 10:25:00	AAPL	Stock	15.9927	16.0114	15.9921	16.0	2741452.0
2013-07-29 10:30:00	AAPL	Stock	16.0029	16.0032	15.9632	15.9632	3444784.0
2013-07-29 10:35:00	AAPL	Stock	15.9632	15.9911	15.9529	15.9843	2578604.0
2013-07-29 10:40:00	AAPL	Stock	15.9855	16.0	15.9825	15.9964	2413040.0
2013-07-29 10:45:00	AAPL	Stock	15.9971	15.9971	15.9593	15.9611	1893836.0
2013-07-29 10:50:00	AAPL	Stock	15.9611	15.9882	15.9596	15.9718	1671852.0
2013-07-29 10:55:00	AAPL	Stock	15.976	15.9996	15.9727	15.9891	1502284.0
2013-07-29 11:00:00	AAPL	Stock	15.9907	16.0054	15.9879	15.9879	2363396.0
2013-07-29 11:05:00	AAPL	Stock	15.9896	15.9948	15.9579	15.9718	2332372.0
2013-07-29 11:10:00	AAPL	Stock	15.9714	15.9779	15.9579	15.9644	1735468.0
2013-07-29 11:15:00	AAPL	Stock	15.9643	15.9771	15.9607	15.9732	1465520.0
2013-07-29 11:20:00	AAPL	Stock	15.9729	15.9861	15.9682	15.9836	2537136.0

> showing 50 of 333,737 rows — these rows as CSV

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