PREVIEW / stock_30min / 2013-06-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-10.parquet
  size:    1.5 MB
  rows:    77,631
  symbols: 3,520

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-06-10 04:00:00	AAPL	Stock	15.8689	15.8689	15.8679	15.8679	19600.0
2013-06-10 04:30:00	AAPL	Stock	15.8757	15.8757	15.8757	15.8757	2800.0
2013-06-10 05:00:00	AAPL	Stock	15.8925	15.8925	15.8757	15.8757	11200.0
2013-06-10 06:00:00	AAPL	Stock	15.8671	15.8875	15.8671	15.8875	5600.0
2013-06-10 06:30:00	AAPL	Stock	15.875	15.8929	15.8686	15.8686	32200.0
2013-06-10 07:00:00	AAPL	Stock	15.8793	15.8975	15.8643	15.8746	318220.0
2013-06-10 07:30:00	AAPL	Stock	15.8746	15.8746	15.8586	15.8743	140756.0
2013-06-10 08:00:00	AAPL	Stock	15.8739	15.8918	15.7321	15.8371	1229480.0
2013-06-10 08:30:00	AAPL	Stock	15.8339	15.8457	15.7843	15.8304	4171216.0
2013-06-10 09:00:00	AAPL	Stock	15.8354	15.8839	15.8329	15.8836	1252636.0
2013-06-10 09:30:00	AAPL	Stock	15.8764	16.0154	15.825	15.9807	59864448.0
2013-06-10 10:00:00	AAPL	Stock	15.9811	15.9954	15.9079	15.9229	31235176.0
2013-06-10 10:30:00	AAPL	Stock	15.9229	15.9604	15.8789	15.9596	22305752.0
2013-06-10 11:00:00	AAPL	Stock	15.9571	15.9841	15.9254	15.9529	17196676.0
2013-06-10 11:30:00	AAPL	Stock	15.9486	16.0093	15.9321	15.9977	15616664.0
2013-06-10 12:00:00	AAPL	Stock	15.9971	16.0143	15.9575	15.9842	11625824.0
2013-06-10 12:30:00	AAPL	Stock	15.9843	15.9843	15.9507	15.9607	9643844.0
2013-06-10 13:00:00	AAPL	Stock	15.9625	16.0385	15.9202	15.9354	30111060.0
2013-06-10 13:30:00	AAPL	Stock	15.9354	15.9821	15.875	15.9321	24052896.0
2013-06-10 14:00:00	AAPL	Stock	15.9321	15.9346	15.7786	15.7925	38222296.0
2013-06-10 14:30:00	AAPL	Stock	15.7925	15.9464	15.775	15.8329	37022244.0
2013-06-10 15:00:00	AAPL	Stock	15.8286	15.8346	15.6	15.685	73037748.0
2013-06-10 15:30:00	AAPL	Stock	15.685	15.7318	15.625	15.6686	47328484.0
2013-06-10 16:00:00	AAPL	Stock	15.6682	15.857	15.6675	15.6739	20825364.0
2013-06-10 16:30:00	AAPL	Stock	15.6714	15.7805	15.6429	15.6604	2104816.0
2013-06-10 17:00:00	AAPL	Stock	15.6571	15.6614	15.6475	15.6614	163240.0
2013-06-10 17:30:00	AAPL	Stock	15.6586	15.6643	15.6475	15.6475	125440.0
2013-06-10 18:00:00	AAPL	Stock	15.6496	15.65	15.6439	15.65	63812.0
2013-06-10 18:30:00	AAPL	Stock	15.6489	15.6564	15.6468	15.6468	56980.0
2013-06-10 19:00:00	AAPL	Stock	15.6468	15.6482	15.6457	15.6471	53788.0
2013-06-10 19:30:00	AAPL	Stock	15.6518	15.6586	15.6475	15.6586	92876.0
2013-06-10 04:30:00	MSFT	Stock	35.75	35.75	35.75	35.75	100.0
2013-06-10 05:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	200.0
2013-06-10 05:30:00	MSFT	Stock	35.7	35.7	35.7	35.7	100.0
2013-06-10 06:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	100.0
2013-06-10 06:30:00	MSFT	Stock	35.7	35.7	35.7	35.7	1000.0
2013-06-10 07:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	200.0
2013-06-10 08:00:00	MSFT	Stock	35.73	35.74	35.55	35.55	11486.0
2013-06-10 08:30:00	MSFT	Stock	35.55	35.67	35.54	35.6	682905.0
2013-06-10 09:00:00	MSFT	Stock	35.61	35.64	35.46	35.48	31482.0
2013-06-10 09:30:00	MSFT	Stock	35.51	35.64	35.36	35.55	4379330.0
2013-06-10 10:00:00	MSFT	Stock	35.545	35.65	35.401	35.44	3758315.0
2013-06-10 10:30:00	MSFT	Stock	35.445	35.56	35.44	35.5	1878122.0
2013-06-10 11:00:00	MSFT	Stock	35.49	35.56	35.47	35.525	1779730.0
2013-06-10 11:30:00	MSFT	Stock	35.528	35.54	35.432	35.448	1799663.0
2013-06-10 12:00:00	MSFT	Stock	35.45	35.47	35.42	35.44	2260440.0
2013-06-10 12:30:00	MSFT	Stock	35.44	35.445	35.33	35.34	2068728.0
2013-06-10 13:00:00	MSFT	Stock	35.34	35.36	35.228	35.23	3169357.0
2013-06-10 13:30:00	MSFT	Stock	35.23	35.27	35.14	35.27	1991439.0
2013-06-10 14:00:00	MSFT	Stock	35.26	35.32	35.19	35.32	1490641.0

> showing 50 of 77,631 rows — these rows as CSV

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