PREVIEW / stock_30min / 2012-11-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-15.parquet
  size:    1.5 MB
  rows:    77,390
  symbols: 3,489

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-15 04:00:00	AAPL	Stock	19.1896	19.2146	19.1875	19.2146	38920.0
2012-11-15 04:30:00	AAPL	Stock	19.2464	19.25	19.2464	19.25	71400.0
2012-11-15 05:00:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	19600.0
2012-11-15 05:30:00	AAPL	Stock	19.2321	19.25	19.2321	19.25	27412.0
2012-11-15 06:00:00	AAPL	Stock	19.22	19.2286	19.1957	19.2286	100100.0
2012-11-15 06:30:00	AAPL	Stock	19.2321	19.25	19.2321	19.25	55664.0
2012-11-15 07:00:00	AAPL	Stock	19.2543	19.2636	19.1829	19.1875	314356.0
2012-11-15 07:30:00	AAPL	Stock	19.1893	19.2321	19.1857	19.2143	364728.0
2012-11-15 08:00:00	AAPL	Stock	19.2086	19.2571	19.1857	19.2196	833280.0
2012-11-15 08:30:00	AAPL	Stock	19.2146	19.24	19.1761	19.2232	2311008.0
2012-11-15 09:00:00	AAPL	Stock	19.2282	19.2814	19.1886	19.1964	2396884.0
2012-11-15 09:30:00	AAPL	Stock	19.1979	19.2679	18.9482	18.9807	101928512.0
2012-11-15 10:00:00	AAPL	Stock	18.9775	19.1568	18.9036	19.0068	94221876.0
2012-11-15 10:30:00	AAPL	Stock	19.0125	19.0286	18.8489	18.8729	66103408.0
2012-11-15 11:00:00	AAPL	Stock	18.8714	18.9275	18.7714	18.8275	60056612.0
2012-11-15 11:30:00	AAPL	Stock	18.835	18.8996	18.7589	18.7875	47239472.0
2012-11-15 12:00:00	AAPL	Stock	18.7864	18.8886	18.7679	18.8586	48463352.0
2012-11-15 12:30:00	AAPL	Stock	18.8507	18.9643	18.8393	18.8579	45734724.0
2012-11-15 13:00:00	AAPL	Stock	18.8579	19.0089	18.8551	19.0046	37540524.0
2012-11-15 13:30:00	AAPL	Stock	19.0061	19.0429	18.9504	18.9572	35239204.0
2012-11-15 14:00:00	AAPL	Stock	18.9561	18.9732	18.8643	18.9007	33133156.0
2012-11-15 14:30:00	AAPL	Stock	18.9061	18.9175	18.8071	18.8196	32708368.0
2012-11-15 15:00:00	AAPL	Stock	18.8218	18.83	18.6696	18.6784	65476768.0
2012-11-15 15:30:00	AAPL	Stock	18.6782	18.8657	18.665	18.7804	92978676.0
2012-11-15 16:00:00	AAPL	Stock	18.7864	18.9207	18.7607	18.7721	13701632.0
2012-11-15 16:30:00	AAPL	Stock	18.7775	18.9033	18.683	18.7646	490056.0
2012-11-15 17:00:00	AAPL	Stock	18.7668	18.7707	18.6429	18.7679	402360.0
2012-11-15 17:30:00	AAPL	Stock	18.7611	18.7675	18.7536	18.7589	162764.0
2012-11-15 18:00:00	AAPL	Stock	18.7625	18.7625	18.7143	18.7196	439964.0
2012-11-15 18:30:00	AAPL	Stock	18.7193	18.7379	18.7143	18.725	191324.0
2012-11-15 19:00:00	AAPL	Stock	18.73	18.7357	18.7275	18.7286	108696.0
2012-11-15 19:30:00	AAPL	Stock	18.7257	18.7357	18.7196	18.735	361704.0
2012-11-15 07:00:00	MSFT	Stock	26.92	26.93	26.92	26.92	7900.0
2012-11-15 07:30:00	MSFT	Stock	26.92	26.93	26.86	26.93	3834.0
2012-11-15 08:00:00	MSFT	Stock	26.87	26.92	26.87	26.88	97075.0
2012-11-15 08:30:00	MSFT	Stock	26.9	26.9	26.83	26.87	71160.0
2012-11-15 09:00:00	MSFT	Stock	26.85	26.94	26.84	26.85	100178.0
2012-11-15 09:30:00	MSFT	Stock	26.88	26.97	26.69	26.805	6440744.0
2012-11-15 10:00:00	MSFT	Stock	26.8	26.9	26.76	26.825	4659800.0
2012-11-15 10:30:00	MSFT	Stock	26.83	26.86	26.75	26.78	3542544.0
2012-11-15 11:00:00	MSFT	Stock	26.78	26.8	26.71	26.77	4302356.0
2012-11-15 11:30:00	MSFT	Stock	26.77	26.8	26.7	26.79	2812632.0
2012-11-15 12:00:00	MSFT	Stock	26.79	26.81	26.75	26.79	2333117.0
2012-11-15 12:30:00	MSFT	Stock	26.79	26.8	26.73	26.76	2267909.0
2012-11-15 13:00:00	MSFT	Stock	26.75	26.775	26.7	26.76	2799150.0
2012-11-15 13:30:00	MSFT	Stock	26.76	26.81	26.73	26.76	2536328.0
2012-11-15 14:00:00	MSFT	Stock	26.76	26.83	26.73	26.82	2505844.0
2012-11-15 14:30:00	MSFT	Stock	26.82	26.82	26.76	26.76	1862511.0
2012-11-15 15:00:00	MSFT	Stock	26.76	26.765	26.69	26.72	3299229.0
2012-11-15 15:30:00	MSFT	Stock	26.71	26.765	26.63	26.67	7021640.0

> showing 50 of 77,390 rows — these rows as CSV

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