PREVIEW / stock_30min / 2013-09-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-09.parquet
  size:    1.5 MB
  rows:    81,549
  symbols: 3,531

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-09 04:00:00	AAPL	Stock	18.0268	18.0543	17.9757	18.0225	206472.0
2013-09-09 04:30:00	AAPL	Stock	18.0357	18.1036	18.0354	18.0393	97300.0
2013-09-09 05:00:00	AAPL	Stock	18.0354	18.0354	18.0168	18.0179	78596.0
2013-09-09 05:30:00	AAPL	Stock	18.0179	18.0193	18.0039	18.0193	17024.0
2013-09-09 06:00:00	AAPL	Stock	18.0193	18.0357	18.0132	18.0286	74452.0
2013-09-09 06:30:00	AAPL	Stock	18.0229	18.0229	17.9857	17.9911	134428.0
2013-09-09 07:00:00	AAPL	Stock	17.9807	18.0229	17.9679	18.0132	968016.0
2013-09-09 07:30:00	AAPL	Stock	18.0136	18.0225	17.975	17.9807	960484.0
2013-09-09 08:00:00	AAPL	Stock	17.9996	18.0411	17.9646	18.0046	3042368.0
2013-09-09 08:30:00	AAPL	Stock	18.0068	18.0579	18.005	18.0579	2900772.0
2013-09-09 09:00:00	AAPL	Stock	18.055	18.0875	18.0318	18.0354	4172168.0
2013-09-09 09:30:00	AAPL	Stock	18.0286	18.1157	17.9814	17.9969	86876020.0
2013-09-09 10:00:00	AAPL	Stock	17.9971	18.0407	17.9868	18.0282	31256316.0
2013-09-09 10:30:00	AAPL	Stock	18.0268	18.0568	18.0018	18.0236	20160840.0
2013-09-09 11:00:00	AAPL	Stock	18.0215	18.0686	18.0193	18.0471	17403680.0
2013-09-09 11:30:00	AAPL	Stock	18.0464	18.0907	18.0382	18.0652	15401624.0
2013-09-09 12:00:00	AAPL	Stock	18.0629	18.1339	18.0557	18.1339	20783756.0
2013-09-09 12:30:00	AAPL	Stock	18.1318	18.1339	18.0846	18.0946	18350136.0
2013-09-09 13:00:00	AAPL	Stock	18.095	18.1121	18.0896	18.1057	6853336.0
2013-09-09 13:30:00	AAPL	Stock	18.1054	18.1118	18.0893	18.1082	10596180.0
2013-09-09 14:00:00	AAPL	Stock	18.1082	18.14	18.1057	18.1175	15668044.0
2013-09-09 14:30:00	AAPL	Stock	18.1236	18.1261	18.0571	18.0584	17346812.0
2013-09-09 15:00:00	AAPL	Stock	18.0579	18.1064	18.0432	18.0878	16394616.0
2013-09-09 15:30:00	AAPL	Stock	18.087	18.0971	18.0607	18.0782	30416064.0
2013-09-09 16:00:00	AAPL	Stock	18.0782	18.0904	18.0632	18.0889	11277420.0
2013-09-09 16:30:00	AAPL	Stock	18.0893	18.0911	18.0353	18.0779	752136.0
2013-09-09 17:00:00	AAPL	Stock	18.0854	18.0857	18.0054	18.0429	880516.0
2013-09-09 17:30:00	AAPL	Stock	18.0489	18.0779	18.0196	18.0357	1615768.0
2013-09-09 18:00:00	AAPL	Stock	18.0357	18.0779	18.0289	18.0607	280168.0
2013-09-09 18:30:00	AAPL	Stock	18.0643	18.0696	18.0536	18.0643	178892.0
2013-09-09 19:00:00	AAPL	Stock	18.0614	18.0746	18.0357	18.0607	276052.0
2013-09-09 19:30:00	AAPL	Stock	18.0571	18.0804	18.0436	18.0782	401492.0
2013-09-09 04:30:00	MSFT	Stock	31.27	31.41	31.27	31.39	1600.0
2013-09-09 06:30:00	MSFT	Stock	31.37	31.37	31.37	31.37	100.0
2013-09-09 07:00:00	MSFT	Stock	31.37	31.37	31.28	31.28	2400.0
2013-09-09 07:30:00	MSFT	Stock	31.28	31.28	31.28	31.28	2500.0
2013-09-09 08:00:00	MSFT	Stock	31.29	31.35	31.26	31.26	11136.0
2013-09-09 08:30:00	MSFT	Stock	31.25	31.26	31.24	31.24	30050.0
2013-09-09 09:00:00	MSFT	Stock	31.24	31.25	31.21	31.21	14999.0
2013-09-09 09:30:00	MSFT	Stock	31.22	31.48	31.2	31.455	7242334.0
2013-09-09 10:00:00	MSFT	Stock	31.46	31.48	31.33	31.43	5278545.0
2013-09-09 10:30:00	MSFT	Stock	31.43	31.43	31.34	31.37	2979717.0
2013-09-09 11:00:00	MSFT	Stock	31.369	31.4	31.34	31.4	2021894.0
2013-09-09 11:30:00	MSFT	Stock	31.4	31.49	31.39	31.45	2431259.0
2013-09-09 12:00:00	MSFT	Stock	31.45	31.6	31.45	31.573	3524372.0
2013-09-09 12:30:00	MSFT	Stock	31.58	31.63	31.56	31.599	2287643.0
2013-09-09 13:00:00	MSFT	Stock	31.59	31.6	31.56	31.585	2199289.0
2013-09-09 13:30:00	MSFT	Stock	31.585	31.62	31.57	31.6	2273753.0
2013-09-09 14:00:00	MSFT	Stock	31.6	31.74	31.55	31.653	4110717.0
2013-09-09 14:30:00	MSFT	Stock	31.655	31.73	31.457	31.65	2477145.0

> showing 50 of 81,549 rows — these rows as CSV

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