PREVIEW / stock_30min / 2011-12-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-05.parquet
  size:    1.5 MB
  rows:    78,653
  symbols: 3,534

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
2011-12-05 04:30:00	AAPL	Stock	14.0179	14.0286	14.0179	14.0286	14644.0
2011-12-05 05:30:00	AAPL	Stock	14.0179	14.0179	14.0179	14.0179	12880.0
2011-12-05 06:00:00	AAPL	Stock	14.0	14.0	13.9821	13.9821	18116.0
2011-12-05 06:30:00	AAPL	Stock	13.9821	13.9821	13.9818	13.9821	19600.0
2011-12-05 07:00:00	AAPL	Stock	13.9818	14.0246	13.9818	14.0179	69720.0
2011-12-05 07:30:00	AAPL	Stock	14.0196	14.0357	14.0136	14.0171	180712.0
2011-12-05 08:00:00	AAPL	Stock	14.0161	14.025	13.9893	14.0018	1237348.0
2011-12-05 08:30:00	AAPL	Stock	14.0029	14.0036	13.9818	14.0032	584192.0
2011-12-05 09:00:00	AAPL	Stock	14.0029	14.0639	14.0	14.0532	2244704.0
2011-12-05 09:30:00	AAPL	Stock	14.0532	14.1221	14.0307	14.1079	53472608.0
2011-12-05 10:00:00	AAPL	Stock	14.1068	14.14	14.0857	14.1239	33362336.0
2011-12-05 10:30:00	AAPL	Stock	14.1246	14.1575	14.1196	14.1332	23901220.0
2011-12-05 11:00:00	AAPL	Stock	14.1325	14.1454	14.0954	14.1051	21989268.0
2011-12-05 11:30:00	AAPL	Stock	14.1061	14.1086	14.0675	14.0975	15794240.0
2011-12-05 12:00:00	AAPL	Stock	14.0986	14.1271	14.0968	14.1021	12951596.0
2011-12-05 12:30:00	AAPL	Stock	14.1046	14.1393	14.1021	14.1293	11972632.0
2011-12-05 13:00:00	AAPL	Stock	14.1293	14.1375	14.1054	14.1121	11990888.0
2011-12-05 13:30:00	AAPL	Stock	14.1118	14.1286	14.0686	14.0771	26543384.0
2011-12-05 14:00:00	AAPL	Stock	14.0768	14.0775	14.0121	14.0391	31258864.0
2011-12-05 14:30:00	AAPL	Stock	14.0411	14.0604	14.0293	14.0496	15489628.0
2011-12-05 15:00:00	AAPL	Stock	14.0471	14.0693	13.9546	13.97	37989084.0
2011-12-05 15:30:00	AAPL	Stock	13.97	14.0361	13.9424	14.036	38675392.0
2011-12-05 16:00:00	AAPL	Stock	14.0361	14.0721	14.0321	14.0321	4352544.0
2011-12-05 16:30:00	AAPL	Stock	14.0361	14.1215	13.9662	14.0236	575764.0
2011-12-05 17:00:00	AAPL	Stock	14.0254	14.0518	14.0218	14.0218	3119984.0
2011-12-05 17:30:00	AAPL	Stock	14.0271	14.0393	14.025	14.0357	147280.0
2011-12-05 18:00:00	AAPL	Stock	14.0386	14.0386	14.0232	14.0232	73668.0
2011-12-05 18:30:00	AAPL	Stock	14.0232	14.0243	14.0179	14.0179	48720.0
2011-12-05 19:00:00	AAPL	Stock	14.0275	14.0275	14.0014	14.0014	34160.0
2011-12-05 19:30:00	AAPL	Stock	14.0029	14.0164	14.0007	14.0093	41076.0
2011-12-05 05:00:00	MSFT	Stock	25.45	25.5	25.45	25.5	1800.0
2011-12-05 05:30:00	MSFT	Stock	25.55	25.55	25.55	25.55	100.0
2011-12-05 07:00:00	MSFT	Stock	25.49	25.51	25.45	25.49	13150.0
2011-12-05 07:30:00	MSFT	Stock	25.5	25.58	25.48	25.58	12329.0
2011-12-05 08:00:00	MSFT	Stock	25.53	25.6	25.5	25.6	47461.0
2011-12-05 08:30:00	MSFT	Stock	25.6	25.64	25.6	25.61	26740.0
2011-12-05 09:00:00	MSFT	Stock	25.62	25.78	25.62	25.77	169873.0
2011-12-05 09:30:00	MSFT	Stock	25.77	25.79	25.5	25.62	6560722.0
2011-12-05 10:00:00	MSFT	Stock	25.61	25.78	25.56	25.71	5277880.0
2011-12-05 10:30:00	MSFT	Stock	25.715	25.73	25.63	25.66	4657177.0
2011-12-05 11:00:00	MSFT	Stock	25.666	25.78	25.66	25.78	4937755.0
2011-12-05 11:30:00	MSFT	Stock	25.78	25.79	25.7	25.72	3296942.0
2011-12-05 12:00:00	MSFT	Stock	25.72	25.74	25.691	25.699	2283865.0
2011-12-05 12:30:00	MSFT	Stock	25.695	25.79	25.69	25.769	3325324.0
2011-12-05 13:00:00	MSFT	Stock	25.76	25.78	25.72	25.759	1753469.0
2011-12-05 13:30:00	MSFT	Stock	25.755	25.8	25.63	25.69	3766695.0
2011-12-05 14:00:00	MSFT	Stock	25.695	25.695	25.62	25.67	2362739.0
2011-12-05 14:30:00	MSFT	Stock	25.665	25.73	25.63	25.715	1841282.0
2011-12-05 15:00:00	MSFT	Stock	25.71	25.73	25.62	25.66	4433856.0
2011-12-05 15:30:00	MSFT	Stock	25.655	25.77	25.605	25.69	8626855.0

> showing 50 of 78,653 rows — these rows as CSV

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