PREVIEW / stock_30min / 2012-11-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-21.parquet
  size:    1.4 MB
  rows:    71,946
  symbols: 3,453

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-11-21 04:00:00	AAPL	Stock	20.125	20.1607	20.125	20.1429	34720.0
2012-11-21 04:30:00	AAPL	Stock	20.125	20.125	20.125	20.125	2800.0
2012-11-21 05:00:00	AAPL	Stock	20.1071	20.1071	20.0893	20.0893	25200.0
2012-11-21 05:30:00	AAPL	Stock	20.0982	20.1071	20.0893	20.0896	47600.0
2012-11-21 06:00:00	AAPL	Stock	20.1071	20.1071	20.1071	20.1071	33320.0
2012-11-21 06:30:00	AAPL	Stock	20.1339	20.1425	20.125	20.1425	36400.0
2012-11-21 07:00:00	AAPL	Stock	20.1318	20.1318	20.0982	20.1214	173740.0
2012-11-21 07:30:00	AAPL	Stock	20.1164	20.1214	20.0718	20.0718	281540.0
2012-11-21 08:00:00	AAPL	Stock	20.0714	20.1136	20.0464	20.0771	979216.0
2012-11-21 08:30:00	AAPL	Stock	20.0786	20.1336	20.0768	20.1318	1098104.0
2012-11-21 09:00:00	AAPL	Stock	20.1279	20.1518	20.0821	20.1518	2704016.0
2012-11-21 09:30:00	AAPL	Stock	20.1518	20.2632	20.045	20.095	79609012.0
2012-11-21 10:00:00	AAPL	Stock	20.1018	20.105	19.9304	19.9543	48730332.0
2012-11-21 10:30:00	AAPL	Stock	19.9593	20.0168	19.8786	19.9439	39416972.0
2012-11-21 11:00:00	AAPL	Stock	19.9443	20.0629	19.9293	20.0086	28685944.0
2012-11-21 11:30:00	AAPL	Stock	20.0071	20.0157	19.9318	19.9354	19578412.0
2012-11-21 12:00:00	AAPL	Stock	19.9389	20.0875	19.9357	20.0482	19668628.0
2012-11-21 12:30:00	AAPL	Stock	20.0484	20.1357	20.0429	20.1096	20552000.0
2012-11-21 13:00:00	AAPL	Stock	20.1121	20.1229	20.0214	20.0625	15603868.0
2012-11-21 13:30:00	AAPL	Stock	20.0596	20.1043	20.05	20.0879	10075296.0
2012-11-21 14:00:00	AAPL	Stock	20.0853	20.1214	20.0407	20.0671	14477680.0
2012-11-21 14:30:00	AAPL	Stock	20.0743	20.1179	20.0579	20.0909	10236352.0
2012-11-21 15:00:00	AAPL	Stock	20.0939	20.1136	20.0614	20.0657	14459116.0
2012-11-21 15:30:00	AAPL	Stock	20.0668	20.0818	20.0282	20.0611	29385496.0
2012-11-21 16:00:00	AAPL	Stock	20.0607	20.08	20.0543	20.08	6982360.0
2012-11-21 16:30:00	AAPL	Stock	20.0786	20.0857	20.0642	20.0846	528052.0
2012-11-21 17:00:00	AAPL	Stock	20.0836	20.0946	20.0832	20.0839	276836.0
2012-11-21 17:30:00	AAPL	Stock	20.0886	20.0886	20.0796	20.0854	27216.0
2012-11-21 18:00:00	AAPL	Stock	20.0775	20.0911	20.0768	20.0911	49672.0
2012-11-21 18:30:00	AAPL	Stock	20.0839	20.0911	20.0821	20.0911	43848.0
2012-11-21 19:00:00	AAPL	Stock	20.0893	20.0929	20.0861	20.0868	50232.0
2012-11-21 19:30:00	AAPL	Stock	20.0893	20.0961	20.0811	20.0821	131096.0
2012-11-21 07:00:00	MSFT	Stock	26.7	26.7	26.7	26.7	3500.0
2012-11-21 08:00:00	MSFT	Stock	26.72	26.74	26.71	26.71	6060.0
2012-11-21 08:30:00	MSFT	Stock	26.71	26.75	26.71	26.75	10650.0
2012-11-21 09:00:00	MSFT	Stock	26.75	26.76	26.66	26.67	243085.0
2012-11-21 09:30:00	MSFT	Stock	26.71	27.02	26.67	27.005	6478938.0
2012-11-21 10:00:00	MSFT	Stock	27.01	27.02	26.82	26.91	3662274.0
2012-11-21 10:30:00	MSFT	Stock	26.905	26.91	26.815	26.86	2684409.0
2012-11-21 11:00:00	MSFT	Stock	26.86	26.99	26.85	26.98	1886093.0
2012-11-21 11:30:00	MSFT	Stock	26.989	26.99	26.91	26.93	2147801.0
2012-11-21 12:00:00	MSFT	Stock	26.93	26.99	26.9	26.926	2045591.0
2012-11-21 12:30:00	MSFT	Stock	26.925	26.99	26.9	26.99	2133842.0
2012-11-21 13:00:00	MSFT	Stock	26.985	27.02	26.97	27.0	1935034.0
2012-11-21 13:30:00	MSFT	Stock	27.01	27.02	26.98	27.01	1460376.0
2012-11-21 14:00:00	MSFT	Stock	27.005	27.02	26.99	27.005	1068896.0
2012-11-21 14:30:00	MSFT	Stock	27.0	27.02	26.99	27.0	1342152.0
2012-11-21 15:00:00	MSFT	Stock	27.01	27.01	26.97	27.0	2862982.0
2012-11-21 15:30:00	MSFT	Stock	26.99	27.01	26.94	26.95	5290036.0
2012-11-21 16:00:00	MSFT	Stock	26.95	26.97	26.93	26.95	4917353.0

> showing 50 of 71,946 rows — these rows as CSV

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