PREVIEW / stock_30min / 2011-03-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-18.parquet
  size:    1.5 MB
  rows:    76,926
  symbols: 3,514

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-03-18 04:00:00	AAPL	Stock	11.9643	11.9643	11.9643	11.9643	2800.0
2011-03-18 04:30:00	AAPL	Stock	12.0893	12.0893	12.0893	12.0893	2800.0
2011-03-18 05:00:00	AAPL	Stock	12.0496	12.0496	12.0357	12.0357	14000.0
2011-03-18 05:30:00	AAPL	Stock	12.0357	12.0418	12.0232	12.0357	64400.0
2011-03-18 06:00:00	AAPL	Stock	12.0357	12.0357	12.0039	12.0111	22400.0
2011-03-18 06:30:00	AAPL	Stock	12.0054	12.0321	11.9468	11.9821	137200.0
2011-03-18 07:00:00	AAPL	Stock	11.9821	12.0514	11.9821	12.0354	544852.0
2011-03-18 07:30:00	AAPL	Stock	12.0343	12.0607	12.03	12.0464	520324.0
2011-03-18 08:00:00	AAPL	Stock	12.0464	12.0714	12.0225	12.0343	3011512.0
2011-03-18 08:30:00	AAPL	Stock	12.0293	12.0929	12.0293	12.0661	2828952.0
2011-03-18 09:00:00	AAPL	Stock	12.0696	12.1036	12.0432	12.0432	6337408.0
2011-03-18 09:30:00	AAPL	Stock	12.0468	12.0786	11.95	11.9543	178320884.0
2011-03-18 10:00:00	AAPL	Stock	11.9554	11.96	11.7857	11.8318	144245360.0
2011-03-18 10:30:00	AAPL	Stock	11.8314	11.9196	11.8107	11.8979	56548352.0
2011-03-18 11:00:00	AAPL	Stock	11.8979	11.9143	11.8418	11.8418	34706028.0
2011-03-18 11:30:00	AAPL	Stock	11.8418	11.8821	11.8221	11.83	36450456.0
2011-03-18 12:00:00	AAPL	Stock	11.8296	11.8832	11.8268	11.8729	22468068.0
2011-03-18 12:30:00	AAPL	Stock	11.8739	11.8782	11.8464	11.8614	15675100.0
2011-03-18 13:00:00	AAPL	Stock	11.8625	11.8989	11.8614	11.8846	23730280.0
2011-03-18 13:30:00	AAPL	Stock	11.885	11.8986	11.8707	11.8871	17739736.0
2011-03-18 14:00:00	AAPL	Stock	11.8871	11.8954	11.8446	11.8586	21305312.0
2011-03-18 14:30:00	AAPL	Stock	11.8571	11.8789	11.8286	11.8346	25537372.0
2011-03-18 15:00:00	AAPL	Stock	11.8346	11.8454	11.7964	11.7975	37546852.0
2011-03-18 15:30:00	AAPL	Stock	11.7975	11.8254	11.7857	11.8093	75974192.0
2011-03-18 16:00:00	AAPL	Stock	11.8093	11.8914	11.7897	11.7982	29444016.0
2011-03-18 16:30:00	AAPL	Stock	11.7993	11.8577	11.7875	11.7875	8203356.0
2011-03-18 17:00:00	AAPL	Stock	11.7893	12.0524	11.7836	11.7964	552020.0
2011-03-18 17:30:00	AAPL	Stock	11.7946	11.7946	11.7875	11.7893	63168.0
2011-03-18 18:00:00	AAPL	Stock	11.7893	11.7982	11.7864	11.7954	71988.0
2011-03-18 18:30:00	AAPL	Stock	11.7954	11.7957	11.7893	11.7946	62216.0
2011-03-18 19:00:00	AAPL	Stock	11.7893	11.7921	11.7875	11.7918	47740.0
2011-03-18 19:30:00	AAPL	Stock	11.7929	11.8096	11.7886	11.7918	347452.0
2011-03-18 04:00:00	MSFT	Stock	24.9	24.97	24.9	24.97	600.0
2011-03-18 04:30:00	MSFT	Stock	25.04	25.04	25.04	25.04	200.0
2011-03-18 06:30:00	MSFT	Stock	24.95	24.95	24.94	24.94	1100.0
2011-03-18 07:00:00	MSFT	Stock	24.98	24.98	24.95	24.97	2940.0
2011-03-18 07:30:00	MSFT	Stock	24.97	24.98	24.93	24.98	8255.0
2011-03-18 08:00:00	MSFT	Stock	24.93	24.97	24.88	24.95	52342.0
2011-03-18 08:30:00	MSFT	Stock	24.93	25.04	24.93	24.98	41324.0
2011-03-18 09:00:00	MSFT	Stock	24.98	25.17	24.784	25.04	264903.0
2011-03-18 09:30:00	MSFT	Stock	25.04	25.18	24.93	24.94	17328509.0
2011-03-18 10:00:00	MSFT	Stock	24.93	24.95	24.82	24.88	4572015.0
2011-03-18 10:30:00	MSFT	Stock	24.89	25.025	24.88	25.005	3113075.0
2011-03-18 11:00:00	MSFT	Stock	25.01	25.1	25.0	25.035	5070980.0
2011-03-18 11:30:00	MSFT	Stock	25.03	25.11	25.0	25.015	4472436.0
2011-03-18 12:00:00	MSFT	Stock	25.01	25.08	24.99	25.012	2519991.0
2011-03-18 12:30:00	MSFT	Stock	25.01	25.04	24.99	24.992	1479440.0
2011-03-18 13:00:00	MSFT	Stock	25.0	25.04	24.99	25.018	1813512.0
2011-03-18 13:30:00	MSFT	Stock	25.015	25.1	25.01	25.08	2013494.0
2011-03-18 14:00:00	MSFT	Stock	25.082	25.1	25.0	25.04	3154366.0

> showing 50 of 76,926 rows — these rows as CSV

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