PREVIEW / stock_30min / 2012-11-05

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-05.parquet
  size:    1.4 MB
  rows:    73,198
  symbols: 3,467

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-05 04:00:00	AAPL	Stock	20.6	20.6	20.52	20.52	19600.0
2012-11-05 04:30:00	AAPL	Stock	20.5	20.5	20.4943	20.4943	10836.0
2012-11-05 05:30:00	AAPL	Stock	20.4679	20.5179	20.4679	20.5179	37660.0
2012-11-05 06:00:00	AAPL	Stock	20.5179	20.5393	20.5125	20.5393	18200.0
2012-11-05 06:30:00	AAPL	Stock	20.5575	20.5604	20.5304	20.5304	48104.0
2012-11-05 07:00:00	AAPL	Stock	20.5179	20.5357	20.4643	20.4679	346668.0
2012-11-05 07:30:00	AAPL	Stock	20.4643	20.4732	20.3818	20.4343	981932.0
2012-11-05 08:00:00	AAPL	Stock	20.4446	20.5639	20.4286	20.5196	1448664.0
2012-11-05 08:30:00	AAPL	Stock	20.5179	20.8929	20.5179	20.8771	12146540.0
2012-11-05 09:00:00	AAPL	Stock	20.8846	20.9211	20.8311	20.8393	5728044.0
2012-11-05 09:30:00	AAPL	Stock	20.8475	20.9918	20.7393	20.8771	98308308.0
2012-11-05 10:00:00	AAPL	Stock	20.8764	20.9132	20.7586	20.7964	37082136.0
2012-11-05 10:30:00	AAPL	Stock	20.7968	20.9675	20.7968	20.9554	32823924.0
2012-11-05 11:00:00	AAPL	Stock	20.9511	20.9786	20.8661	20.9289	27174224.0
2012-11-05 11:30:00	AAPL	Stock	20.9365	20.9568	20.8404	20.8798	20176716.0
2012-11-05 12:00:00	AAPL	Stock	20.8814	20.8907	20.7243	20.7314	23957052.0
2012-11-05 12:30:00	AAPL	Stock	20.7311	20.741	20.6361	20.7111	37062704.0
2012-11-05 13:00:00	AAPL	Stock	20.7121	20.8375	20.7089	20.8057	24143308.0
2012-11-05 13:30:00	AAPL	Stock	20.8057	20.825	20.6286	20.6911	28018956.0
2012-11-05 14:00:00	AAPL	Stock	20.6896	20.8143	20.6679	20.8055	25052944.0
2012-11-05 14:30:00	AAPL	Stock	20.8107	20.8929	20.8004	20.8359	29259664.0
2012-11-05 15:00:00	AAPL	Stock	20.8375	20.8879	20.7739	20.8243	24312428.0
2012-11-05 15:30:00	AAPL	Stock	20.8228	20.9532	20.7754	20.8793	50425760.0
2012-11-05 16:00:00	AAPL	Stock	20.8857	20.9061	20.8039	20.9018	20492136.0
2012-11-05 16:30:00	AAPL	Stock	20.9036	20.9196	20.818	20.8964	676760.0
2012-11-05 17:00:00	AAPL	Stock	20.8964	20.9096	20.8925	20.8929	229600.0
2012-11-05 17:30:00	AAPL	Stock	20.8961	20.8964	20.8571	20.8764	184408.0
2012-11-05 18:00:00	AAPL	Stock	20.8607	20.8714	20.8571	20.8714	34720.0
2012-11-05 18:30:00	AAPL	Stock	20.86	20.8754	20.86	20.8754	70784.0
2012-11-05 19:00:00	AAPL	Stock	20.8764	20.8782	20.8764	20.8782	25592.0
2012-11-05 19:30:00	AAPL	Stock	20.8611	20.8746	20.8554	20.8571	62328.0
2012-11-05 05:30:00	MSFT	Stock	29.5	29.5	29.5	29.5	200.0
2012-11-05 06:00:00	MSFT	Stock	29.55	29.55	29.5	29.5	300.0
2012-11-05 08:00:00	MSFT	Stock	29.59	29.59	29.5	29.5	3060.0
2012-11-05 08:30:00	MSFT	Stock	29.55	29.6	29.5	29.57	8150.0
2012-11-05 09:00:00	MSFT	Stock	29.56	29.62	29.55	29.62	38545.0
2012-11-05 09:30:00	MSFT	Stock	29.62	29.74	29.35	29.44	4090517.0
2012-11-05 10:00:00	MSFT	Stock	29.43	29.49	29.33	29.49	2812767.0
2012-11-05 10:30:00	MSFT	Stock	29.485	29.56	29.45	29.49	2731015.0
2012-11-05 11:00:00	MSFT	Stock	29.49	29.5	29.4	29.43	2102917.0
2012-11-05 11:30:00	MSFT	Stock	29.425	29.45	29.37	29.42	2605604.0
2012-11-05 12:00:00	MSFT	Stock	29.42	29.5	29.4	29.47	2517750.0
2012-11-05 12:30:00	MSFT	Stock	29.48	29.51	29.45	29.47	2452536.0
2012-11-05 13:00:00	MSFT	Stock	29.47	29.5	29.445	29.455	2126080.0
2012-11-05 13:30:00	MSFT	Stock	29.455	29.48	29.42	29.435	1800778.0
2012-11-05 14:00:00	MSFT	Stock	29.435	29.48	29.4	29.45	1885832.0
2012-11-05 14:30:00	MSFT	Stock	29.45	29.59	29.45	29.585	2109325.0
2012-11-05 15:00:00	MSFT	Stock	29.585	29.65	29.57	29.65	1989662.0
2012-11-05 15:30:00	MSFT	Stock	29.65	29.73	29.6	29.63	6009258.0
2012-11-05 16:00:00	MSFT	Stock	29.63	29.669	29.462	29.56	2144827.0

> showing 50 of 73,198 rows — these rows as CSV

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