PREVIEW / stock_30min / 2013-10-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-02.parquet
  size:    1.6 MB
  rows:    83,625
  symbols: 3,524

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-10-02 04:00:00	AAPL	Stock	17.3357	17.3357	17.2929	17.2929	40320.0
2013-10-02 04:30:00	AAPL	Stock	17.3036	17.3036	17.3036	17.3036	8400.0
2013-10-02 05:00:00	AAPL	Stock	17.2964	17.2964	17.2954	17.2954	16800.0
2013-10-02 05:30:00	AAPL	Stock	17.3036	17.3071	17.2925	17.2925	37800.0
2013-10-02 06:00:00	AAPL	Stock	17.2932	17.3004	17.2932	17.295	14840.0
2013-10-02 06:30:00	AAPL	Stock	17.2946	17.3575	17.2857	17.3214	198716.0
2013-10-02 07:00:00	AAPL	Stock	17.3304	17.3961	17.3161	17.3929	595392.0
2013-10-02 07:30:00	AAPL	Stock	17.4004	17.4336	17.3746	17.3889	472220.0
2013-10-02 08:00:00	AAPL	Stock	17.3921	17.4282	17.31	17.375	1260672.0
2013-10-02 08:30:00	AAPL	Stock	17.3682	17.375	17.3468	17.3518	842744.0
2013-10-02 09:00:00	AAPL	Stock	17.3532	17.3571	17.3036	17.3321	1481704.0
2013-10-02 09:30:00	AAPL	Stock	17.3439	17.3886	17.2768	17.3311	49716436.0
2013-10-02 10:00:00	AAPL	Stock	17.3254	17.4254	17.2786	17.4114	35511364.0
2013-10-02 10:30:00	AAPL	Stock	17.4114	17.555	17.38	17.5043	42129584.0
2013-10-02 11:00:00	AAPL	Stock	17.5046	17.5381	17.4839	17.5275	17452708.0
2013-10-02 11:30:00	AAPL	Stock	17.5286	17.5507	17.5061	17.5261	13406232.0
2013-10-02 12:00:00	AAPL	Stock	17.5246	17.5643	17.5161	17.5268	11746364.0
2013-10-02 12:30:00	AAPL	Stock	17.5279	17.5587	17.4707	17.4889	11237884.0
2013-10-02 13:00:00	AAPL	Stock	17.4884	17.4943	17.4321	17.4878	14747600.0
2013-10-02 13:30:00	AAPL	Stock	17.4821	17.5268	17.4643	17.5032	9574376.0
2013-10-02 14:00:00	AAPL	Stock	17.5039	17.5114	17.4689	17.511	8174124.0
2013-10-02 14:30:00	AAPL	Stock	17.5075	17.5096	17.4475	17.4704	11852316.0
2013-10-02 15:00:00	AAPL	Stock	17.4704	17.4971	17.4571	17.4807	8584884.0
2013-10-02 15:30:00	AAPL	Stock	17.4811	17.5018	17.4579	17.4843	19674172.0
2013-10-02 16:00:00	AAPL	Stock	17.4857	17.4928	17.4436	17.4857	17424428.0
2013-10-02 16:30:00	AAPL	Stock	17.4886	17.4889	17.4271	17.4793	386988.0
2013-10-02 17:00:00	AAPL	Stock	17.4836	17.4857	17.4786	17.4857	667968.0
2013-10-02 17:30:00	AAPL	Stock	17.4714	17.4821	17.4714	17.4732	109116.0
2013-10-02 18:00:00	AAPL	Stock	17.4786	17.4821	17.4661	17.4661	300132.0
2013-10-02 18:30:00	AAPL	Stock	17.4671	17.4843	17.4661	17.475	920752.0
2013-10-02 19:00:00	AAPL	Stock	17.4739	17.4739	17.4389	17.4389	182952.0
2013-10-02 19:30:00	AAPL	Stock	17.4336	17.445	17.3929	17.4318	381052.0
2013-10-02 07:30:00	MSFT	Stock	33.48	33.48	33.35	33.48	2914.0
2013-10-02 08:00:00	MSFT	Stock	33.43	33.47	33.35	33.4	7385.0
2013-10-02 08:30:00	MSFT	Stock	33.4	33.43	33.39	33.4	4294.0
2013-10-02 09:00:00	MSFT	Stock	33.4	33.45	33.31	33.35	37178.0
2013-10-02 09:30:00	MSFT	Stock	33.37	33.57	33.29	33.48	3490574.0
2013-10-02 10:00:00	MSFT	Stock	33.48	33.57	33.42	33.54	4125288.0
2013-10-02 10:30:00	MSFT	Stock	33.53	33.62	33.48	33.545	5070298.0
2013-10-02 11:00:00	MSFT	Stock	33.547	33.67	33.54	33.58	2790782.0
2013-10-02 11:30:00	MSFT	Stock	33.58	33.79	33.58	33.78	2261517.0
2013-10-02 12:00:00	MSFT	Stock	33.775	33.9	33.76	33.813	2562689.0
2013-10-02 12:30:00	MSFT	Stock	33.82	33.9	33.81	33.9	1513839.0
2013-10-02 13:00:00	MSFT	Stock	33.9	33.92	33.82	33.92	1658048.0
2013-10-02 13:30:00	MSFT	Stock	33.91	34.0	33.88	33.969	2794768.0
2013-10-02 14:00:00	MSFT	Stock	33.966	34.02	33.91	33.986	2660717.0
2013-10-02 14:30:00	MSFT	Stock	33.98	34.01	33.91	33.95	1841327.0
2013-10-02 15:00:00	MSFT	Stock	33.955	34.03	33.93	33.94	2059336.0
2013-10-02 15:30:00	MSFT	Stock	33.94	34.015	33.89	33.9	5741522.0
2013-10-02 16:00:00	MSFT	Stock	33.91	33.929	33.533	33.91	2466108.0

> showing 50 of 83,625 rows — these rows as CSV

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