PREVIEW / stock_30min / 2013-09-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-20.parquet
  size:    1.6 MB
  rows:    82,671
  symbols: 3,537

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-09-20 04:00:00	AAPL	Stock	16.8264	16.87	16.8182	16.8568	22400.0
2013-09-20 04:30:00	AAPL	Stock	16.8375	16.8375	16.8257	16.8257	22400.0
2013-09-20 05:00:00	AAPL	Stock	16.8396	16.8396	16.8396	16.8396	2800.0
2013-09-20 05:30:00	AAPL	Stock	16.8514	16.8679	16.8514	16.8679	37800.0
2013-09-20 06:00:00	AAPL	Stock	16.8907	16.8925	16.8907	16.8925	8400.0
2013-09-20 06:30:00	AAPL	Stock	16.9275	16.9375	16.9246	16.9268	40320.0
2013-09-20 07:00:00	AAPL	Stock	16.9225	16.9286	16.8893	16.9018	342020.0
2013-09-20 07:30:00	AAPL	Stock	16.9036	17.1104	16.9036	17.0807	1953700.0
2013-09-20 08:00:00	AAPL	Stock	17.0807	17.1529	16.9904	17.1382	6149808.0
2013-09-20 08:30:00	AAPL	Stock	17.1457	17.1518	17.075	17.0936	3770928.0
2013-09-20 09:00:00	AAPL	Stock	17.09	17.1171	17.0679	17.0714	2876020.0
2013-09-20 09:30:00	AAPL	Stock	17.0671	17.0911	16.8811	16.9121	122798592.0
2013-09-20 10:00:00	AAPL	Stock	16.9068	16.9946	16.9018	16.9696	32828740.0
2013-09-20 10:30:00	AAPL	Stock	16.9664	17.0196	16.9525	17.0129	22387176.0
2013-09-20 11:00:00	AAPL	Stock	17.0165	17.0171	16.9504	16.9579	18404148.0
2013-09-20 11:30:00	AAPL	Stock	16.9636	16.9902	16.8932	16.9082	25138876.0
2013-09-20 12:00:00	AAPL	Stock	16.9079	16.9254	16.8489	16.8593	27167784.0
2013-09-20 12:30:00	AAPL	Stock	16.8582	16.8979	16.8525	16.8643	15987832.0
2013-09-20 13:00:00	AAPL	Stock	16.865	16.875	16.7975	16.8375	23623852.0
2013-09-20 13:30:00	AAPL	Stock	16.8393	16.8479	16.7632	16.8071	23028124.0
2013-09-20 14:00:00	AAPL	Stock	16.8043	16.8132	16.7868	16.805	15757448.0
2013-09-20 14:30:00	AAPL	Stock	16.8064	16.8407	16.7729	16.8271	24536512.0
2013-09-20 15:00:00	AAPL	Stock	16.8271	16.8375	16.7857	16.805	31241756.0
2013-09-20 15:30:00	AAPL	Stock	16.8043	16.8361	16.6429	16.6779	99230012.0
2013-09-20 16:00:00	AAPL	Stock	16.6779	16.8877	16.6745	16.6925	143934924.0
2013-09-20 16:30:00	AAPL	Stock	16.6832	16.8045	16.6607	16.6643	42374304.0
2013-09-20 17:00:00	AAPL	Stock	16.6607	16.6779	16.6286	16.6486	1004192.0
2013-09-20 17:30:00	AAPL	Stock	16.6561	16.6932	16.6321	16.6536	424984.0
2013-09-20 18:00:00	AAPL	Stock	16.6607	16.6786	16.6539	16.6764	258132.0
2013-09-20 18:30:00	AAPL	Stock	16.6779	16.6814	16.6779	16.6789	29512.0
2013-09-20 19:00:00	AAPL	Stock	16.6836	16.6929	16.6693	16.6868	305312.0
2013-09-20 19:30:00	AAPL	Stock	16.6843	16.6879	16.6843	16.6879	424536.0
2013-09-20 07:00:00	MSFT	Stock	33.5	33.6	33.35	33.55	66300.0
2013-09-20 07:30:00	MSFT	Stock	33.55	33.68	33.4	33.51	74700.0
2013-09-20 08:00:00	MSFT	Stock	33.55	33.55	33.38	33.38	126680.0
2013-09-20 08:30:00	MSFT	Stock	33.38	33.38	33.2	33.29	130880.0
2013-09-20 09:00:00	MSFT	Stock	33.29	33.54	33.26	33.44	516957.0
2013-09-20 09:30:00	MSFT	Stock	33.44	33.48	32.954	33.05	24928146.0
2013-09-20 10:00:00	MSFT	Stock	33.05	33.12	33.0	33.05	5203436.0
2013-09-20 10:30:00	MSFT	Stock	33.045	33.05	32.91	32.94	4183756.0
2013-09-20 11:00:00	MSFT	Stock	32.94	32.941	32.685	32.81	6225867.0
2013-09-20 11:30:00	MSFT	Stock	32.815	32.84	32.71	32.73	2984821.0
2013-09-20 12:00:00	MSFT	Stock	32.73	32.87	32.72	32.76	3171618.0
2013-09-20 12:30:00	MSFT	Stock	32.76	32.87	32.73	32.855	2404346.0
2013-09-20 13:00:00	MSFT	Stock	32.855	32.87	32.7	32.745	3314480.0
2013-09-20 13:30:00	MSFT	Stock	32.75	32.87	32.743	32.84	2143334.0
2013-09-20 14:00:00	MSFT	Stock	32.84	32.965	32.77	32.93	2873161.0
2013-09-20 14:30:00	MSFT	Stock	32.93	32.94	32.83	32.865	2678543.0
2013-09-20 15:00:00	MSFT	Stock	32.865	32.94	32.85	32.87	3765587.0
2013-09-20 15:30:00	MSFT	Stock	32.875	32.965	32.74	32.76	13179888.0

> showing 50 of 82,671 rows — these rows as CSV

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