PREVIEW / stock_30min / 2012-01-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-13.parquet
  size:    1.4 MB
  rows:    72,850
  symbols: 3,511

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
2012-01-13 04:30:00	AAPL	Stock	15.0829	15.0829	15.0786	15.0786	8400.0
2012-01-13 05:00:00	AAPL	Stock	15.0786	15.0821	15.0643	15.0643	39200.0
2012-01-13 05:30:00	AAPL	Stock	15.0679	15.0679	15.0643	15.0643	7504.0
2012-01-13 06:30:00	AAPL	Stock	15.0643	15.0643	15.0643	15.0643	5600.0
2012-01-13 07:00:00	AAPL	Stock	15.05	15.0518	15.05	15.0518	29652.0
2012-01-13 07:30:00	AAPL	Stock	15.0679	15.0679	15.0229	15.0296	198240.0
2012-01-13 08:00:00	AAPL	Stock	15.0296	15.07	15.0196	15.0636	699244.0
2012-01-13 08:30:00	AAPL	Stock	15.0536	15.0575	14.9821	14.9871	772268.0
2012-01-13 09:00:00	AAPL	Stock	14.9879	14.9946	14.9507	14.9889	1549324.0
2012-01-13 09:30:00	AAPL	Stock	14.9893	15.0161	14.9521	14.9829	38450048.0
2012-01-13 10:00:00	AAPL	Stock	14.9821	15.0046	14.9654	14.9825	24545360.0
2012-01-13 10:30:00	AAPL	Stock	14.9821	14.9875	14.9561	14.9739	21472612.0
2012-01-13 11:00:00	AAPL	Stock	14.9738	14.9957	14.9609	14.9914	11054148.0
2012-01-13 11:30:00	AAPL	Stock	14.9921	15.0089	14.9793	14.9943	10437392.0
2012-01-13 12:00:00	AAPL	Stock	14.995	14.9954	14.9664	14.9679	8665664.0
2012-01-13 12:30:00	AAPL	Stock	14.9679	14.9907	14.9661	14.9896	6664644.0
2012-01-13 13:00:00	AAPL	Stock	14.9904	14.9907	14.9664	14.9733	8758652.0
2012-01-13 13:30:00	AAPL	Stock	14.9742	14.9854	14.9643	14.9746	9265788.0
2012-01-13 14:00:00	AAPL	Stock	14.9757	14.9921	14.975	14.9861	7073332.0
2012-01-13 14:30:00	AAPL	Stock	14.9868	14.9936	14.9689	14.9829	8796928.0
2012-01-13 15:00:00	AAPL	Stock	14.9834	15.0079	14.9771	15.0018	16534196.0
2012-01-13 15:30:00	AAPL	Stock	15.0021	15.0079	14.9868	14.9984	32277504.0
2012-01-13 16:00:00	AAPL	Stock	14.9993	15.0021	14.9842	15.0	11159008.0
2012-01-13 16:30:00	AAPL	Stock	15.0011	15.0031	14.975	14.9989	1464708.0
2012-01-13 17:00:00	AAPL	Stock	14.9986	14.9996	14.9889	14.9936	264992.0
2012-01-13 17:30:00	AAPL	Stock	14.9918	14.9961	14.9911	14.9911	84420.0
2012-01-13 18:00:00	AAPL	Stock	14.9893	14.995	14.9893	14.9911	146328.0
2012-01-13 18:30:00	AAPL	Stock	14.9936	14.9993	14.9918	14.9918	25760.0
2012-01-13 19:00:00	AAPL	Stock	14.9929	14.9929	14.9911	14.9929	75516.0
2012-01-13 19:30:00	AAPL	Stock	14.9957	14.9964	14.9921	14.9961	38640.0
2012-01-13 08:00:00	MSFT	Stock	27.99	27.99	27.9	27.96	12476.0
2012-01-13 08:30:00	MSFT	Stock	27.94	27.96	27.92	27.92	14280.0
2012-01-13 09:00:00	MSFT	Stock	27.92	27.95	27.79	27.93	73601.0
2012-01-13 09:30:00	MSFT	Stock	27.93	28.0	27.81	27.96	5307199.0
2012-01-13 10:00:00	MSFT	Stock	27.96	27.96	27.79	27.83	6258820.0
2012-01-13 10:30:00	MSFT	Stock	27.835	27.9	27.8	27.896	6859165.0
2012-01-13 11:00:00	MSFT	Stock	27.893	27.96	27.86	27.95	3806688.0
2012-01-13 11:30:00	MSFT	Stock	27.95	28.0	27.94	27.99	3082302.0
2012-01-13 12:00:00	MSFT	Stock	27.995	28.0	27.98	27.985	1680256.0
2012-01-13 12:30:00	MSFT	Stock	27.985	28.0	27.95	28.0	1785703.0
2012-01-13 13:00:00	MSFT	Stock	28.0	28.0	27.9	27.945	1760370.0
2012-01-13 13:30:00	MSFT	Stock	27.945	28.03	27.94	28.02	2593123.0
2012-01-13 14:00:00	MSFT	Stock	28.02	28.07	27.98	28.03	2648251.0
2012-01-13 14:30:00	MSFT	Stock	28.04	28.09	28.03	28.069	2578729.0
2012-01-13 15:00:00	MSFT	Stock	28.065	28.2	28.06	28.19	4594927.0
2012-01-13 15:30:00	MSFT	Stock	28.19	28.25	28.15	28.25	10854437.0
2012-01-13 16:00:00	MSFT	Stock	28.25	28.33	27.991	28.023	3987144.0
2012-01-13 16:30:00	MSFT	Stock	28.3	28.3	27.91	28.25	109744.0
2012-01-13 17:00:00	MSFT	Stock	28.24	28.25	28.151	28.24	58319.0
2012-01-13 17:30:00	MSFT	Stock	28.25	28.25	28.24	28.25	20712.0

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

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