PREVIEW / stock_30min / 2011-08-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-08.parquet
  size:    1.6 MB
  rows:    87,777
  symbols: 3,592

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-08 04:00:00	AAPL	Stock	13.2932	13.2932	13.0357	13.0786	463484.0
2011-08-08 04:30:00	AAPL	Stock	13.0875	13.0875	13.045	13.045	140756.0
2011-08-08 05:00:00	AAPL	Stock	13.0368	13.0536	13.0	13.0179	143640.0
2011-08-08 05:30:00	AAPL	Stock	13.0179	13.0429	12.975	13.0007	218624.0
2011-08-08 06:00:00	AAPL	Stock	13.0086	13.0357	13.0043	13.0336	292180.0
2011-08-08 06:30:00	AAPL	Stock	13.0232	13.0429	13.0232	13.0357	42000.0
2011-08-08 07:00:00	AAPL	Stock	13.0289	13.1468	13.0289	13.0836	1129324.0
2011-08-08 07:30:00	AAPL	Stock	13.0839	13.1029	13.0054	13.0714	2257556.0
2011-08-08 08:00:00	AAPL	Stock	13.0539	13.0954	12.9286	13.0786	5903856.0
2011-08-08 08:30:00	AAPL	Stock	13.0804	13.0882	12.995	13.0068	3604524.0
2011-08-08 09:00:00	AAPL	Stock	13.005	13.0536	12.8914	12.9175	9120104.0
2011-08-08 09:30:00	AAPL	Stock	12.9179	13.1346	12.8643	13.0704	168578620.0
2011-08-08 10:00:00	AAPL	Stock	13.0671	13.085	12.8568	12.8821	110330248.0
2011-08-08 10:30:00	AAPL	Stock	12.8825	12.9932	12.8143	12.8873	100635248.0
2011-08-08 11:00:00	AAPL	Stock	12.8871	13.0736	12.8793	12.9757	79295748.0
2011-08-08 11:30:00	AAPL	Stock	12.9757	13.0357	12.9161	12.9986	50966748.0
2011-08-08 12:00:00	AAPL	Stock	12.9982	12.9986	12.9025	12.9342	43803928.0
2011-08-08 12:30:00	AAPL	Stock	12.9343	13.0179	12.92	12.9768	37046884.0
2011-08-08 13:00:00	AAPL	Stock	12.9778	13.0414	12.9286	12.9911	43163568.0
2011-08-08 13:30:00	AAPL	Stock	12.9921	12.9971	12.8904	12.8972	56653296.0
2011-08-08 14:00:00	AAPL	Stock	12.8939	12.9618	12.6982	12.8036	102798724.0
2011-08-08 14:30:00	AAPL	Stock	12.8036	12.8386	12.6864	12.7221	72437708.0
2011-08-08 15:00:00	AAPL	Stock	12.7218	12.9086	12.6679	12.7868	105759640.0
2011-08-08 15:30:00	AAPL	Stock	12.7871	12.8343	12.6079	12.6196	109202492.0
2011-08-08 16:00:00	AAPL	Stock	12.6257	12.9329	12.5468	12.5704	26887028.0
2011-08-08 16:30:00	AAPL	Stock	12.5693	12.9019	12.5	12.5536	4693892.0
2011-08-08 17:00:00	AAPL	Stock	12.5536	12.565	12.5321	12.5357	822444.0
2011-08-08 17:30:00	AAPL	Stock	12.5361	12.5386	12.5	12.535	760368.0
2011-08-08 18:00:00	AAPL	Stock	12.535	12.6146	12.4339	12.4893	1927240.0
2011-08-08 18:30:00	AAPL	Stock	12.49	12.5157	12.4554	12.4554	342496.0
2011-08-08 19:00:00	AAPL	Stock	12.4643	12.5329	12.4643	12.5321	391412.0
2011-08-08 19:30:00	AAPL	Stock	12.5182	12.5286	12.4929	12.5107	307160.0
2011-08-08 04:00:00	MSFT	Stock	25.2	25.2	25.05	25.05	500.0
2011-08-08 05:30:00	MSFT	Stock	24.93	24.93	24.78	24.78	1200.0
2011-08-08 06:00:00	MSFT	Stock	24.88	25.0	24.88	25.0	2300.0
2011-08-08 06:30:00	MSFT	Stock	24.9	24.99	24.9	24.99	2950.0
2011-08-08 07:00:00	MSFT	Stock	24.99	25.17	24.99	25.17	13709.0
2011-08-08 07:30:00	MSFT	Stock	25.16	25.17	25.0	25.1	46059.0
2011-08-08 08:00:00	MSFT	Stock	25.1	25.11	25.0	25.11	55100.0
2011-08-08 08:30:00	MSFT	Stock	25.1	25.16	25.1	25.1	69637.0
2011-08-08 09:00:00	MSFT	Stock	25.08	25.27	25.03	25.04	196230.0
2011-08-08 09:30:00	MSFT	Stock	25.04	25.6	24.97	25.32	12451862.0
2011-08-08 10:00:00	MSFT	Stock	25.32	25.35	24.795	24.812	10320416.0
2011-08-08 10:30:00	MSFT	Stock	24.815	25.235	24.78	24.97	11963304.0
2011-08-08 11:00:00	MSFT	Stock	24.96	25.3	24.872	25.12	8173029.0
2011-08-08 11:30:00	MSFT	Stock	25.12	25.16	24.99	25.05	6612771.0
2011-08-08 12:00:00	MSFT	Stock	25.04	25.069	24.9	24.97	4922680.0
2011-08-08 12:30:00	MSFT	Stock	24.975	25.09	24.96	25.001	4149001.0
2011-08-08 13:00:00	MSFT	Stock	25.0	25.09	24.9	25.01	4242985.0
2011-08-08 13:30:00	MSFT	Stock	25.015	25.03	24.69	24.715	8695339.0

> showing 50 of 87,777 rows — these rows as CSV

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