PREVIEW / stock_30min / 2014-05-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-08.parquet
  size:    1.6 MB
  rows:    82,672
  symbols: 3,537

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
2014-05-08 04:00:00	AAPL	Stock	21.0714	21.1089	21.0714	21.1089	5600.0
2014-05-08 04:30:00	AAPL	Stock	21.1071	21.1107	21.1071	21.1107	14000.0
2014-05-08 05:00:00	AAPL	Stock	21.0893	21.0893	21.0893	21.0893	8400.0
2014-05-08 05:30:00	AAPL	Stock	21.0721	21.0721	21.0718	21.0718	5600.0
2014-05-08 06:00:00	AAPL	Stock	21.0714	21.0714	21.0643	21.0643	14000.0
2014-05-08 06:30:00	AAPL	Stock	21.0643	21.0643	21.0429	21.0429	68628.0
2014-05-08 07:00:00	AAPL	Stock	21.0711	21.0879	21.0711	21.0818	19600.0
2014-05-08 07:30:00	AAPL	Stock	21.0714	21.0714	21.0193	21.0446	458024.0
2014-05-08 08:00:00	AAPL	Stock	21.0536	21.0557	20.9954	21.0071	788312.0
2014-05-08 08:30:00	AAPL	Stock	20.9964	21.0443	20.9964	21.0282	688520.0
2014-05-08 09:00:00	AAPL	Stock	21.0304	21.0439	21.0107	21.03	602000.0
2014-05-08 09:30:00	AAPL	Stock	21.0311	21.1386	21.0089	21.1375	26957252.0
2014-05-08 10:00:00	AAPL	Stock	21.1375	21.1989	21.1236	21.1704	18527208.0
2014-05-08 10:30:00	AAPL	Stock	21.1711	21.1736	21.1084	21.1457	10824464.0
2014-05-08 11:00:00	AAPL	Stock	21.1429	21.1761	21.1375	21.1743	10393152.0
2014-05-08 11:30:00	AAPL	Stock	21.1743	21.2289	21.1311	21.1668	9006116.0
2014-05-08 12:00:00	AAPL	Stock	21.1664	21.1786	21.1536	21.1679	6175120.0
2014-05-08 12:30:00	AAPL	Stock	21.1704	21.1789	21.1129	21.12	7812280.0
2014-05-08 13:00:00	AAPL	Stock	21.12	21.1429	21.0936	21.1246	5753888.0
2014-05-08 13:30:00	AAPL	Stock	21.125	21.125	21.0718	21.0811	6979420.0
2014-05-08 14:00:00	AAPL	Stock	21.0814	21.0868	21.02	21.0646	10514280.0
2014-05-08 14:30:00	AAPL	Stock	21.0643	21.0689	20.9511	20.9863	12213460.0
2014-05-08 15:00:00	AAPL	Stock	20.9796	20.9946	20.9429	20.9871	14044464.0
2014-05-08 15:30:00	AAPL	Stock	20.9807	21.0081	20.955	21.0043	15516788.0
2014-05-08 16:00:00	AAPL	Stock	21.0043	21.1542	20.9875	20.9986	5904024.0
2014-05-08 16:30:00	AAPL	Stock	21.0036	21.0071	20.9982	20.9982	373044.0
2014-05-08 17:00:00	AAPL	Stock	21.0032	21.0057	20.9818	20.9818	102508.0
2014-05-08 17:30:00	AAPL	Stock	20.9875	20.9875	20.9286	20.9286	58100.0
2014-05-08 18:00:00	AAPL	Stock	20.9293	21.0043	20.825	20.9014	554400.0
2014-05-08 18:30:00	AAPL	Stock	20.8893	20.9286	20.8821	20.9286	133616.0
2014-05-08 19:00:00	AAPL	Stock	20.9279	20.9439	20.9196	20.93	173600.0
2014-05-08 19:30:00	AAPL	Stock	20.9286	20.945	20.9286	20.9425	56952.0
2014-05-08 07:30:00	MSFT	Stock	39.4	39.4	39.4	39.4	2000.0
2014-05-08 08:00:00	MSFT	Stock	39.35	39.35	39.22	39.22	1575.0
2014-05-08 08:30:00	MSFT	Stock	39.29	39.29	39.2	39.28	6579.0
2014-05-08 09:00:00	MSFT	Stock	39.29	39.33	39.23	39.33	3374.0
2014-05-08 09:30:00	MSFT	Stock	39.34	39.59	38.97	39.58	3147859.0
2014-05-08 10:00:00	MSFT	Stock	39.58	39.69	39.56	39.58	2589101.0
2014-05-08 10:30:00	MSFT	Stock	39.575	39.67	39.55	39.64	1989397.0
2014-05-08 11:00:00	MSFT	Stock	39.64	39.815	39.58	39.81	1502525.0
2014-05-08 11:30:00	MSFT	Stock	39.81	39.87	39.69	39.7	1606783.0
2014-05-08 12:00:00	MSFT	Stock	39.706	39.87	39.7	39.865	1246107.0
2014-05-08 12:30:00	MSFT	Stock	39.865	39.89	39.73	39.82	1634651.0
2014-05-08 13:00:00	MSFT	Stock	39.825	39.9	39.71	39.72	1268030.0
2014-05-08 13:30:00	MSFT	Stock	39.72	39.73	39.61	39.63	720039.0
2014-05-08 14:00:00	MSFT	Stock	39.625	39.63	39.52	39.62	1954087.0
2014-05-08 14:30:00	MSFT	Stock	39.615	39.631	39.45	39.52	2295329.0
2014-05-08 15:00:00	MSFT	Stock	39.52	39.615	39.48	39.55	2119540.0
2014-05-08 15:30:00	MSFT	Stock	39.56	39.64	39.51	39.64	3837719.0
2014-05-08 16:00:00	MSFT	Stock	39.64	39.768	39.57	39.659	985776.0

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

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