PREVIEW / stock_30min / 2013-11-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-08.parquet
  size:    1.6 MB
  rows:    82,865
  symbols: 3,547

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
2013-11-08 04:00:00	AAPL	Stock	18.3496	18.3496	18.3496	18.3496	2800.0
2013-11-08 05:30:00	AAPL	Stock	18.3393	18.3393	18.3393	18.3393	2800.0
2013-11-08 06:00:00	AAPL	Stock	18.35	18.3618	18.35	18.3618	5600.0
2013-11-08 06:30:00	AAPL	Stock	18.3596	18.375	18.3571	18.3571	40824.0
2013-11-08 07:00:00	AAPL	Stock	18.3571	18.3807	18.3536	18.3568	102256.0
2013-11-08 07:30:00	AAPL	Stock	18.3561	18.3561	18.3221	18.3336	100296.0
2013-11-08 08:00:00	AAPL	Stock	18.3325	18.3711	18.3033	18.3489	619500.0
2013-11-08 08:30:00	AAPL	Stock	18.3443	18.3732	18.27	18.3732	5094544.0
2013-11-08 09:00:00	AAPL	Stock	18.3679	18.4229	18.3571	18.3807	1856176.0
2013-11-08 09:30:00	AAPL	Stock	18.3779	18.4154	18.3068	18.3357	35878640.0
2013-11-08 10:00:00	AAPL	Stock	18.3336	18.4939	18.3304	18.4796	30259936.0
2013-11-08 10:30:00	AAPL	Stock	18.4804	18.5125	18.4654	18.5002	23637040.0
2013-11-08 11:00:00	AAPL	Stock	18.5016	18.555	18.4754	18.5511	17036768.0
2013-11-08 11:30:00	AAPL	Stock	18.5521	18.5661	18.5282	18.545	13206620.0
2013-11-08 12:00:00	AAPL	Stock	18.5468	18.5618	18.5296	18.5532	8388492.0
2013-11-08 12:30:00	AAPL	Stock	18.5568	18.5618	18.5389	18.5496	9189068.0
2013-11-08 13:00:00	AAPL	Stock	18.5496	18.5814	18.5286	18.5807	12274920.0
2013-11-08 13:30:00	AAPL	Stock	18.58	18.5971	18.565	18.5889	9923564.0
2013-11-08 14:00:00	AAPL	Stock	18.5904	18.5921	18.5714	18.5875	6906424.0
2013-11-08 14:30:00	AAPL	Stock	18.591	18.6118	18.5773	18.605	10731840.0
2013-11-08 15:00:00	AAPL	Stock	18.605	18.6064	18.5761	18.5832	10725540.0
2013-11-08 15:30:00	AAPL	Stock	18.5832	18.5982	18.5589	18.5925	35656292.0
2013-11-08 16:00:00	AAPL	Stock	18.5929	18.6171	18.4962	18.6157	33124392.0
2013-11-08 16:30:00	AAPL	Stock	18.5929	18.6157	18.5929	18.6075	880096.0
2013-11-08 17:00:00	AAPL	Stock	18.5982	18.6068	18.5982	18.6036	107268.0
2013-11-08 17:30:00	AAPL	Stock	18.6036	18.6118	18.6036	18.61	145712.0
2013-11-08 18:00:00	AAPL	Stock	18.5929	18.6143	18.5914	18.6071	503468.0
2013-11-08 18:30:00	AAPL	Stock	18.6104	18.6104	18.6029	18.6068	28000.0
2013-11-08 19:00:00	AAPL	Stock	18.6	18.6018	18.6	18.6018	11508.0
2013-11-08 19:30:00	AAPL	Stock	18.6	18.6071	18.595	18.6071	155008.0
2013-11-08 07:30:00	MSFT	Stock	37.54	37.54	37.52	37.52	1000.0
2013-11-08 08:00:00	MSFT	Stock	37.53	37.72	37.52	37.54	3445.0
2013-11-08 08:30:00	MSFT	Stock	37.56	37.61	37.38	37.49	104458.0
2013-11-08 09:00:00	MSFT	Stock	37.47	37.77	37.45	37.65	63216.0
2013-11-08 09:30:00	MSFT	Stock	37.67	37.75	37.35	37.4	5803727.0
2013-11-08 10:00:00	MSFT	Stock	37.39	37.64	37.34	37.59	3498847.0
2013-11-08 10:30:00	MSFT	Stock	37.58	37.69	37.51	37.6	2736771.0
2013-11-08 11:00:00	MSFT	Stock	37.61	37.64	37.53	37.55	1742242.0
2013-11-08 11:30:00	MSFT	Stock	37.545	37.6	37.46	37.56	1951561.0
2013-11-08 12:00:00	MSFT	Stock	37.56	37.61	37.53	37.57	2449091.0
2013-11-08 12:30:00	MSFT	Stock	37.57	37.61	37.55	37.56	1040053.0
2013-11-08 13:00:00	MSFT	Stock	37.565	37.6	37.54	37.6	1062178.0
2013-11-08 13:30:00	MSFT	Stock	37.595	37.6	37.53	37.55	1401911.0
2013-11-08 14:00:00	MSFT	Stock	37.556	37.62	37.55	37.59	1193417.0
2013-11-08 14:30:00	MSFT	Stock	37.58	37.63	37.56	37.599	1193353.0
2013-11-08 15:00:00	MSFT	Stock	37.6	37.61	37.492	37.585	1427916.0
2013-11-08 15:30:00	MSFT	Stock	37.585	37.78	37.55	37.78	7826724.0
2013-11-08 16:00:00	MSFT	Stock	37.78	37.784	37.578	37.74	2583203.0
2013-11-08 16:30:00	MSFT	Stock	37.78	37.788	37.6	37.71	184718.0
2013-11-08 17:00:00	MSFT	Stock	37.71	37.71	37.562	37.68	28240.0

> showing 50 of 82,865 rows — these rows as CSV

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