PREVIEW / stock_30min / 2012-08-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-30.parquet
  size:    1.3 MB
  rows:    70,087
  symbols: 3,429

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-08-30 04:00:00	AAPL	Stock	24.0268	24.0268	24.0	24.0107	14000.0
2012-08-30 05:30:00	AAPL	Stock	23.9821	23.9893	23.9768	23.9893	42000.0
2012-08-30 06:00:00	AAPL	Stock	23.9768	23.9768	23.9318	23.9325	224812.0
2012-08-30 07:00:00	AAPL	Stock	23.9464	23.9825	23.9464	23.9825	71260.0
2012-08-30 07:30:00	AAPL	Stock	23.9893	24.0293	23.9761	23.9768	164080.0
2012-08-30 08:00:00	AAPL	Stock	23.9957	24.0464	23.9643	23.9996	424480.0
2012-08-30 08:30:00	AAPL	Stock	24.0039	24.0064	23.9664	23.9664	685048.0
2012-08-30 09:00:00	AAPL	Stock	23.9664	23.9821	23.9464	23.9482	1028944.0
2012-08-30 09:30:00	AAPL	Stock	23.9464	23.9841	23.8661	23.8971	52773504.0
2012-08-30 10:00:00	AAPL	Stock	23.8968	23.9196	23.7964	23.8259	34888504.0
2012-08-30 10:30:00	AAPL	Stock	23.8282	23.8704	23.7932	23.8357	26380060.0
2012-08-30 11:00:00	AAPL	Stock	23.8325	23.9093	23.8221	23.9064	15590064.0
2012-08-30 11:30:00	AAPL	Stock	23.9046	23.9064	23.8521	23.8529	10657724.0
2012-08-30 12:00:00	AAPL	Stock	23.8564	23.8786	23.8214	23.8289	8297632.0
2012-08-30 12:30:00	AAPL	Stock	23.8255	23.855	23.7889	23.7982	10539676.0
2012-08-30 13:00:00	AAPL	Stock	23.7954	23.7982	23.6875	23.7286	25202884.0
2012-08-30 13:30:00	AAPL	Stock	23.7282	23.7768	23.6986	23.765	14751212.0
2012-08-30 14:00:00	AAPL	Stock	23.7668	23.8071	23.7493	23.7582	11398016.0
2012-08-30 14:30:00	AAPL	Stock	23.7607	23.8071	23.7282	23.8011	11579232.0
2012-08-30 15:00:00	AAPL	Stock	23.8011	23.8346	23.7429	23.7578	17194044.0
2012-08-30 15:30:00	AAPL	Stock	23.7575	23.7996	23.6733	23.7111	31398304.0
2012-08-30 16:00:00	AAPL	Stock	23.7164	23.8245	23.6857	23.7061	20183408.0
2012-08-30 16:30:00	AAPL	Stock	23.7071	23.7207	23.7071	23.7096	266616.0
2012-08-30 17:00:00	AAPL	Stock	23.7179	23.7186	23.7111	23.7146	156156.0
2012-08-30 17:30:00	AAPL	Stock	23.7182	23.7214	23.6964	23.7	238168.0
2012-08-30 18:00:00	AAPL	Stock	23.7	23.7	23.6911	23.6918	105224.0
2012-08-30 18:30:00	AAPL	Stock	23.6925	23.7018	23.6914	23.6964	57848.0
2012-08-30 19:00:00	AAPL	Stock	23.6936	23.7107	23.6936	23.7086	92680.0
2012-08-30 19:30:00	AAPL	Stock	23.7107	23.7161	23.6832	23.6839	140224.0
2012-08-30 05:30:00	MSFT	Stock	30.65	30.65	30.65	30.65	100.0
2012-08-30 07:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	500.0
2012-08-30 08:00:00	MSFT	Stock	30.68	30.68	30.68	30.68	900.0
2012-08-30 08:30:00	MSFT	Stock	30.56	30.57	30.54	30.56	5000.0
2012-08-30 09:00:00	MSFT	Stock	30.56	30.67	30.46	30.49	71277.0
2012-08-30 09:30:00	MSFT	Stock	30.53	30.61	30.35	30.37	2961711.0
2012-08-30 10:00:00	MSFT	Stock	30.36	30.38	30.24	30.265	2690735.0
2012-08-30 10:30:00	MSFT	Stock	30.26	30.31	30.22	30.31	2490337.0
2012-08-30 11:00:00	MSFT	Stock	30.31	30.34	30.285	30.29	1718841.0
2012-08-30 11:30:00	MSFT	Stock	30.29	30.3	30.24	30.27	1256449.0
2012-08-30 12:00:00	MSFT	Stock	30.27	30.31	30.26	30.27	579605.0
2012-08-30 12:30:00	MSFT	Stock	30.27	30.31	30.27	30.285	1075190.0
2012-08-30 13:00:00	MSFT	Stock	30.28	30.32	30.26	30.298	1317333.0
2012-08-30 13:30:00	MSFT	Stock	30.29	30.34	30.29	30.325	918185.0
2012-08-30 14:00:00	MSFT	Stock	30.33	30.38	30.32	30.35	784302.0
2012-08-30 14:30:00	MSFT	Stock	30.35	30.38	30.32	30.365	690957.0
2012-08-30 15:00:00	MSFT	Stock	30.37	30.4	30.35	30.378	917866.0
2012-08-30 15:30:00	MSFT	Stock	30.38	30.43	30.31	30.34	3874607.0
2012-08-30 16:00:00	MSFT	Stock	30.34	30.67	30.28	30.32	2251060.0
2012-08-30 16:30:00	MSFT	Stock	30.32	30.32	30.3	30.32	37709.0
2012-08-30 17:00:00	MSFT	Stock	30.34	30.34	30.32	30.32	1100.0

> showing 50 of 70,087 rows — these rows as CSV

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