PREVIEW / stock_30min / 2011-08-30

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-30.parquet
  size:    1.4 MB
  rows:    72,782
  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-08-30 04:30:00	AAPL	Stock	13.8929	13.8929	13.8682	13.8682	5600.0
2011-08-30 05:00:00	AAPL	Stock	13.8789	13.8789	13.8789	13.8789	2800.0
2011-08-30 06:00:00	AAPL	Stock	13.8743	13.8743	13.8632	13.8661	14840.0
2011-08-30 06:30:00	AAPL	Stock	13.8661	13.8871	13.8661	13.8871	17136.0
2011-08-30 07:00:00	AAPL	Stock	13.8918	13.8929	13.8725	13.875	93856.0
2011-08-30 07:30:00	AAPL	Stock	13.8804	13.8889	13.8664	13.8761	86772.0
2011-08-30 08:00:00	AAPL	Stock	13.8875	13.8875	13.8482	13.8571	1168888.0
2011-08-30 08:30:00	AAPL	Stock	13.8568	13.8568	13.8164	13.8246	1222508.0
2011-08-30 09:00:00	AAPL	Stock	13.8282	13.8689	13.8236	13.8643	1548148.0
2011-08-30 09:30:00	AAPL	Stock	13.8661	13.9204	13.8239	13.8929	40444376.0
2011-08-30 10:00:00	AAPL	Stock	13.8886	13.9029	13.7932	13.8793	56175196.0
2011-08-30 10:30:00	AAPL	Stock	13.8768	13.8839	13.8432	13.8657	22381324.0
2011-08-30 11:00:00	AAPL	Stock	13.8664	13.9286	13.8625	13.9236	25487252.0
2011-08-30 11:30:00	AAPL	Stock	13.9211	13.9943	13.9032	13.9768	41892844.0
2011-08-30 12:00:00	AAPL	Stock	13.9784	13.9818	13.915	13.9236	22495032.0
2011-08-30 12:30:00	AAPL	Stock	13.9261	13.9318	13.8554	13.8818	21869148.0
2011-08-30 13:00:00	AAPL	Stock	13.8796	13.9107	13.8554	13.8925	21740012.0
2011-08-30 13:30:00	AAPL	Stock	13.8914	13.9039	13.8546	13.8932	17737244.0
2011-08-30 14:00:00	AAPL	Stock	13.8954	13.9396	13.8875	13.9386	32905068.0
2011-08-30 14:30:00	AAPL	Stock	13.9375	13.9496	13.875	13.9175	27867420.0
2011-08-30 15:00:00	AAPL	Stock	13.9198	13.9554	13.9025	13.9468	26350996.0
2011-08-30 15:30:00	AAPL	Stock	13.9482	13.9664	13.9254	13.9271	40895008.0
2011-08-30 16:00:00	AAPL	Stock	13.9279	13.9307	13.88	13.88	11201176.0
2011-08-30 16:30:00	AAPL	Stock	13.8839	13.9544	13.8621	13.8621	248024.0
2011-08-30 17:00:00	AAPL	Stock	13.8646	13.8782	13.8646	13.87	55272.0
2011-08-30 17:30:00	AAPL	Stock	13.87	13.8721	13.8579	13.8621	142212.0
2011-08-30 18:00:00	AAPL	Stock	13.8625	13.9282	13.8618	13.8643	109004.0
2011-08-30 18:30:00	AAPL	Stock	13.8675	13.8736	13.8618	13.8736	74200.0
2011-08-30 19:00:00	AAPL	Stock	13.8714	13.8768	13.8643	13.8768	132132.0
2011-08-30 19:30:00	AAPL	Stock	13.8761	13.8768	13.8593	13.8714	227864.0
2011-08-30 05:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	100.0
2011-08-30 06:30:00	MSFT	Stock	25.7	25.7	25.7	25.7	170.0
2011-08-30 07:30:00	MSFT	Stock	25.66	25.66	25.66	25.66	922.0
2011-08-30 08:00:00	MSFT	Stock	25.66	25.66	25.66	25.66	2000.0
2011-08-30 08:30:00	MSFT	Stock	25.66	25.85	25.66	25.69	49142.0
2011-08-30 09:00:00	MSFT	Stock	25.7	25.79	25.66	25.74	29177.0
2011-08-30 09:30:00	MSFT	Stock	25.73	26.12	25.7	25.97	7658032.0
2011-08-30 10:00:00	MSFT	Stock	25.97	26.06	25.81	26.032	7232727.0
2011-08-30 10:30:00	MSFT	Stock	26.035	26.175	26.02	26.123	4252750.0
2011-08-30 11:00:00	MSFT	Stock	26.13	26.23	26.1	26.17	3362256.0
2011-08-30 11:30:00	MSFT	Stock	26.175	26.265	26.15	26.25	3013886.0
2011-08-30 12:00:00	MSFT	Stock	26.25	26.28	26.15	26.22	2042222.0
2011-08-30 12:30:00	MSFT	Stock	26.21	26.252	26.1	26.19	2883499.0
2011-08-30 13:00:00	MSFT	Stock	26.185	26.34	26.163	26.29	2690833.0
2011-08-30 13:30:00	MSFT	Stock	26.291	26.3	26.15	26.16	2726653.0
2011-08-30 14:00:00	MSFT	Stock	26.16	26.29	26.11	26.29	4031706.0
2011-08-30 14:30:00	MSFT	Stock	26.295	26.37	26.23	26.367	3690597.0
2011-08-30 15:00:00	MSFT	Stock	26.365	26.42	26.31	26.37	2593447.0
2011-08-30 15:30:00	MSFT	Stock	26.365	26.43	26.22	26.24	7291474.0
2011-08-30 16:00:00	MSFT	Stock	26.24	26.399	25.773	26.11	2725130.0

> showing 50 of 72,782 rows — these rows as CSV

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