PREVIEW / stock_30min / 2011-09-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-07.parquet
  size:    1.4 MB
  rows:    75,663
  symbols: 3,513

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-09-07 04:00:00	AAPL	Stock	13.6496	13.6964	13.6429	13.6429	59080.0
2011-09-07 04:30:00	AAPL	Stock	13.6732	13.6732	13.6607	13.6607	8400.0
2011-09-07 05:00:00	AAPL	Stock	13.6679	13.6679	13.6607	13.6607	5600.0
2011-09-07 05:30:00	AAPL	Stock	13.6536	13.6536	13.6432	13.6436	33600.0
2011-09-07 06:00:00	AAPL	Stock	13.6429	13.6446	13.6429	13.6446	8400.0
2011-09-07 06:30:00	AAPL	Stock	13.6518	13.6614	13.6482	13.6607	43736.0
2011-09-07 07:00:00	AAPL	Stock	13.675	13.71	13.6739	13.6786	399560.0
2011-09-07 07:30:00	AAPL	Stock	13.6786	13.7043	13.6786	13.6825	524384.0
2011-09-07 08:00:00	AAPL	Stock	13.6868	13.7079	13.6696	13.7032	1673532.0
2011-09-07 08:30:00	AAPL	Stock	13.7046	13.7664	13.6996	13.7536	2381680.0
2011-09-07 09:00:00	AAPL	Stock	13.7507	13.7768	13.7507	13.77	3489220.0
2011-09-07 09:30:00	AAPL	Stock	13.7707	13.7714	13.6804	13.6989	65256408.0
2011-09-07 10:00:00	AAPL	Stock	13.7	13.71	13.6496	13.6546	42172648.0
2011-09-07 10:30:00	AAPL	Stock	13.6521	13.6893	13.6429	13.6696	27230000.0
2011-09-07 11:00:00	AAPL	Stock	13.6718	13.7186	13.6593	13.7118	22629040.0
2011-09-07 11:30:00	AAPL	Stock	13.7118	13.7139	13.6854	13.6975	13850172.0
2011-09-07 12:00:00	AAPL	Stock	13.6984	13.7004	13.6757	13.685	8107036.0
2011-09-07 12:30:00	AAPL	Stock	13.685	13.7096	13.6796	13.7032	12254620.0
2011-09-07 13:00:00	AAPL	Stock	13.7021	13.7393	13.6929	13.7193	18205292.0
2011-09-07 13:30:00	AAPL	Stock	13.7195	13.7221	13.6889	13.7157	12555480.0
2011-09-07 14:00:00	AAPL	Stock	13.7168	13.7443	13.7146	13.7424	17880016.0
2011-09-07 14:30:00	AAPL	Stock	13.7407	13.7486	13.7229	13.7243	19365724.0
2011-09-07 15:00:00	AAPL	Stock	13.7243	13.7393	13.7064	13.7247	19200860.0
2011-09-07 15:30:00	AAPL	Stock	13.7247	13.7321	13.6946	13.7114	36904784.0
2011-09-07 16:00:00	AAPL	Stock	13.7114	13.7265	13.705	13.7136	18032868.0
2011-09-07 16:30:00	AAPL	Stock	13.715	13.7731	13.7044	13.7104	785176.0
2011-09-07 17:00:00	AAPL	Stock	13.7107	13.7161	13.7089	13.7143	181720.0
2011-09-07 17:30:00	AAPL	Stock	13.7143	13.7175	13.7143	13.715	171388.0
2011-09-07 18:00:00	AAPL	Stock	13.715	13.7189	13.7146	13.7189	104356.0
2011-09-07 18:30:00	AAPL	Stock	13.7204	13.7282	13.7118	13.725	400372.0
2011-09-07 19:00:00	AAPL	Stock	13.7236	13.7286	13.7232	13.7286	175616.0
2011-09-07 19:30:00	AAPL	Stock	13.7268	13.7321	13.7232	13.7236	225652.0
2011-09-07 04:00:00	MSFT	Stock	25.64	25.64	25.64	25.64	100.0
2011-09-07 05:30:00	MSFT	Stock	25.64	25.64	25.64	25.64	100.0
2011-09-07 06:00:00	MSFT	Stock	25.65	25.65	25.65	25.65	900.0
2011-09-07 06:30:00	MSFT	Stock	25.76	25.8	25.76	25.8	2800.0
2011-09-07 07:00:00	MSFT	Stock	25.8	25.8	25.71	25.75	2900.0
2011-09-07 07:30:00	MSFT	Stock	25.7	25.7	25.68	25.68	2300.0
2011-09-07 08:00:00	MSFT	Stock	25.7	25.77	25.68	25.73	9850.0
2011-09-07 08:30:00	MSFT	Stock	25.71	25.77	25.7	25.76	5940.0
2011-09-07 09:00:00	MSFT	Stock	25.75	25.8	25.65	25.7	56424.0
2011-09-07 09:30:00	MSFT	Stock	25.69	25.86	25.57	25.86	3583327.0
2011-09-07 10:00:00	MSFT	Stock	25.86	25.87	25.69	25.727	3408862.0
2011-09-07 10:30:00	MSFT	Stock	25.73	25.81	25.702	25.784	2545810.0
2011-09-07 11:00:00	MSFT	Stock	25.785	25.88	25.76	25.855	2704331.0
2011-09-07 11:30:00	MSFT	Stock	25.86	25.93	25.84	25.912	1924156.0
2011-09-07 12:00:00	MSFT	Stock	25.918	25.92	25.78	25.86	2017443.0
2011-09-07 12:30:00	MSFT	Stock	25.86	25.93	25.845	25.88	1527772.0
2011-09-07 13:00:00	MSFT	Stock	25.88	25.95	25.86	25.94	1573858.0
2011-09-07 13:30:00	MSFT	Stock	25.94	25.95	25.87	25.91	1331934.0

> showing 50 of 75,663 rows — these rows as CSV

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