PREVIEW / stock_30min / 2012-02-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-14.parquet
  size:    1.4 MB
  rows:    74,894
  symbols: 3,527

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-02-14 04:00:00	AAPL	Stock	17.9643	18.0696	17.9643	18.0671	191380.0
2012-02-14 04:30:00	AAPL	Stock	18.0486	18.0714	18.0486	18.0714	46900.0
2012-02-14 05:00:00	AAPL	Stock	18.0779	18.1071	18.0586	18.1068	105560.0
2012-02-14 05:30:00	AAPL	Stock	18.1071	18.1071	18.0857	18.1071	60200.0
2012-02-14 06:00:00	AAPL	Stock	18.1	18.1179	18.0714	18.0893	87668.0
2012-02-14 06:30:00	AAPL	Stock	18.0893	18.0893	18.0686	18.0714	131600.0
2012-02-14 07:00:00	AAPL	Stock	18.075	18.0804	18.0529	18.0625	685440.0
2012-02-14 07:30:00	AAPL	Stock	18.0693	18.0718	18.0232	18.0232	541996.0
2012-02-14 08:00:00	AAPL	Stock	18.0336	18.075	17.9832	18.0071	2430764.0
2012-02-14 08:30:00	AAPL	Stock	18.0071	18.0143	17.9429	17.9461	2457504.0
2012-02-14 09:00:00	AAPL	Stock	17.9514	18.0179	17.9471	18.0143	2207744.0
2012-02-14 09:30:00	AAPL	Stock	18.0193	18.0439	17.9286	17.9811	84347984.0
2012-02-14 10:00:00	AAPL	Stock	17.9821	18.0075	17.9286	18.0006	37902592.0
2012-02-14 10:30:00	AAPL	Stock	17.9971	18.0034	17.9511	17.9764	22087492.0
2012-02-14 11:00:00	AAPL	Stock	17.9779	18.0	17.9629	17.9979	17619560.0
2012-02-14 11:30:00	AAPL	Stock	17.9993	18.0311	17.9868	18.0007	23608704.0
2012-02-14 12:00:00	AAPL	Stock	18.0018	18.0043	17.9757	17.9893	15069544.0
2012-02-14 12:30:00	AAPL	Stock	17.9889	18.0143	17.9729	17.9986	16703260.0
2012-02-14 13:00:00	AAPL	Stock	17.9989	18.0036	17.9625	17.9829	17516604.0
2012-02-14 13:30:00	AAPL	Stock	17.9825	18.0179	17.9821	17.9981	13295548.0
2012-02-14 14:00:00	AAPL	Stock	18.0	18.0414	17.9982	18.0004	25317656.0
2012-02-14 14:30:00	AAPL	Stock	18.0014	18.0136	17.9821	18.0036	18705736.0
2012-02-14 15:00:00	AAPL	Stock	18.0054	18.0779	18.0011	18.0289	40766376.0
2012-02-14 15:30:00	AAPL	Stock	18.0279	18.1986	18.0179	18.1934	80184188.0
2012-02-14 16:00:00	AAPL	Stock	18.1936	18.2818	17.9417	18.2707	27439496.0
2012-02-14 16:30:00	AAPL	Stock	18.2743	18.2743	18.0298	18.25	1139096.0
2012-02-14 17:00:00	AAPL	Stock	18.2536	18.2543	18.195	18.2543	1197560.0
2012-02-14 17:30:00	AAPL	Stock	18.2543	18.2714	18.25	18.2514	302428.0
2012-02-14 18:00:00	AAPL	Stock	18.2511	18.2589	18.25	18.2564	193844.0
2012-02-14 18:30:00	AAPL	Stock	18.2546	18.2768	18.2546	18.275	293384.0
2012-02-14 19:00:00	AAPL	Stock	18.275	18.2907	18.2607	18.2779	599704.0
2012-02-14 19:30:00	AAPL	Stock	18.2807	18.2832	18.2568	18.2679	681716.0
2012-02-14 07:00:00	MSFT	Stock	30.48	30.49	30.48	30.48	2900.0
2012-02-14 07:30:00	MSFT	Stock	30.45	30.48	30.38	30.38	5700.0
2012-02-14 08:00:00	MSFT	Stock	30.38	30.4	30.34	30.38	15010.0
2012-02-14 08:30:00	MSFT	Stock	30.38	30.38	30.28	30.28	16100.0
2012-02-14 09:00:00	MSFT	Stock	30.31	30.36	30.25	30.28	29935.0
2012-02-14 09:30:00	MSFT	Stock	30.28	30.46	30.22	30.26	6041926.0
2012-02-14 10:00:00	MSFT	Stock	30.27	30.29	30.17	30.21	3461961.0
2012-02-14 10:30:00	MSFT	Stock	30.21	30.21	30.07	30.08	3347112.0
2012-02-14 11:00:00	MSFT	Stock	30.077	30.1	30.05	30.1	2008060.0
2012-02-14 11:30:00	MSFT	Stock	30.1	30.15	30.07	30.078	2485687.0
2012-02-14 12:00:00	MSFT	Stock	30.08	30.1	29.97	29.983	2088735.0
2012-02-14 12:30:00	MSFT	Stock	29.99	30.0	29.9	29.901	2673969.0
2012-02-14 13:00:00	MSFT	Stock	29.902	29.98	29.85	29.94	7681646.0
2012-02-14 13:30:00	MSFT	Stock	29.95	30.05	29.93	29.999	5286765.0
2012-02-14 14:00:00	MSFT	Stock	29.995	30.04	29.97	30.004	2867094.0
2012-02-14 14:30:00	MSFT	Stock	30.01	30.09	29.995	30.08	2695151.0
2012-02-14 15:00:00	MSFT	Stock	30.09	30.12	30.04	30.04	3068476.0
2012-02-14 15:30:00	MSFT	Stock	30.045	30.27	30.02	30.25	6756810.0

> showing 50 of 74,894 rows — these rows as CSV

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