PREVIEW / stock_30min / 2013-04-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-17.parquet
  size:    1.5 MB
  rows:    78,177
  symbols: 3,485

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-04-17 04:00:00	AAPL	Stock	15.0893	15.0893	15.0811	15.0811	11368.0
2013-04-17 04:30:00	AAPL	Stock	15.0636	15.0675	15.0571	15.0675	11200.0
2013-04-17 05:00:00	AAPL	Stock	15.0893	15.0893	15.0893	15.0893	4200.0
2013-04-17 05:30:00	AAPL	Stock	15.0821	15.0821	15.0821	15.0821	9912.0
2013-04-17 06:30:00	AAPL	Stock	15.1175	15.1175	15.0832	15.0832	24220.0
2013-04-17 07:00:00	AAPL	Stock	15.0796	15.0929	15.0268	15.0268	363692.0
2013-04-17 07:30:00	AAPL	Stock	15.0275	15.0604	15.0071	15.0604	706132.0
2013-04-17 08:00:00	AAPL	Stock	15.055	15.0929	15.0339	15.0929	1254568.0
2013-04-17 08:30:00	AAPL	Stock	15.0943	15.0982	15.0446	15.05	1004892.0
2013-04-17 09:00:00	AAPL	Stock	15.045	15.0496	14.9871	15.0139	2434264.0
2013-04-17 09:30:00	AAPL	Stock	15.0139	15.0214	14.7321	14.7482	125655740.0
2013-04-17 10:00:00	AAPL	Stock	14.7474	14.7725	14.4168	14.5396	149296840.0
2013-04-17 10:30:00	AAPL	Stock	14.5396	14.5532	14.4732	14.5207	74241104.0
2013-04-17 11:00:00	AAPL	Stock	14.5182	14.6029	14.4893	14.5632	65101260.0
2013-04-17 11:30:00	AAPL	Stock	14.5639	14.5639	14.4189	14.4197	48143088.0
2013-04-17 12:00:00	AAPL	Stock	14.4196	14.4455	14.3111	14.3325	70119728.0
2013-04-17 12:30:00	AAPL	Stock	14.3325	14.4275	14.2182	14.3907	92208536.0
2013-04-17 13:00:00	AAPL	Stock	14.3921	14.4589	14.3632	14.4318	46507552.0
2013-04-17 13:30:00	AAPL	Stock	14.4355	14.4918	14.4054	14.4379	38547012.0
2013-04-17 14:00:00	AAPL	Stock	14.4346	14.4589	14.3786	14.445	25274340.0
2013-04-17 14:30:00	AAPL	Stock	14.4403	14.4818	14.3054	14.3571	40901308.0
2013-04-17 15:00:00	AAPL	Stock	14.3566	14.4107	14.2854	14.324	54068700.0
2013-04-17 15:30:00	AAPL	Stock	14.3252	14.3996	14.3029	14.3857	72569196.0
2013-04-17 16:00:00	AAPL	Stock	14.3857	14.5027	14.3269	14.3932	20685028.0
2013-04-17 16:30:00	AAPL	Stock	14.3857	14.4827	14.327	14.3968	873096.0
2013-04-17 17:00:00	AAPL	Stock	14.3968	14.5027	14.3857	14.3996	527464.0
2013-04-17 17:30:00	AAPL	Stock	14.3971	14.4	14.3904	14.3929	50092.0
2013-04-17 18:00:00	AAPL	Stock	14.39	14.4071	14.3871	14.4071	91812.0
2013-04-17 18:30:00	AAPL	Stock	14.4071	14.4071	14.3857	14.3929	57400.0
2013-04-17 19:00:00	AAPL	Stock	14.3979	14.4036	14.3893	14.3932	134512.0
2013-04-17 19:30:00	AAPL	Stock	14.3929	14.4007	14.3857	14.3929	230776.0
2013-04-17 07:00:00	MSFT	Stock	28.81	28.81	28.8	28.8	1999.0
2013-04-17 07:30:00	MSFT	Stock	28.85	28.85	28.81	28.81	1200.0
2013-04-17 08:00:00	MSFT	Stock	28.82	28.93	28.82	28.82	7040.0
2013-04-17 08:30:00	MSFT	Stock	28.82	28.82	28.82	28.82	4198.0
2013-04-17 09:00:00	MSFT	Stock	28.82	28.87	28.82	28.86	58570.0
2013-04-17 09:30:00	MSFT	Stock	28.85	29.04	28.78	28.94	5932694.0
2013-04-17 10:00:00	MSFT	Stock	28.94	28.95	28.77	28.855	4423124.0
2013-04-17 10:30:00	MSFT	Stock	28.85	28.885	28.69	28.753	4210425.0
2013-04-17 11:00:00	MSFT	Stock	28.76	28.939	28.73	28.79	3469746.0
2013-04-17 11:30:00	MSFT	Stock	28.793	28.83	28.72	28.752	1838575.0
2013-04-17 12:00:00	MSFT	Stock	28.76	28.81	28.61	28.64	2649444.0
2013-04-17 12:30:00	MSFT	Stock	28.65	28.775	28.6	28.765	3133499.0
2013-04-17 13:00:00	MSFT	Stock	28.76	28.82	28.72	28.79	2693045.0
2013-04-17 13:30:00	MSFT	Stock	28.792	28.98	28.78	28.895	3718911.0
2013-04-17 14:00:00	MSFT	Stock	28.9	28.93	28.83	28.893	3441564.0
2013-04-17 14:30:00	MSFT	Stock	28.895	28.91	28.78	28.83	3052453.0
2013-04-17 15:00:00	MSFT	Stock	28.834	28.89	28.8	28.85	2741485.0
2013-04-17 15:30:00	MSFT	Stock	28.86	28.92	28.8	28.87	5816238.0
2013-04-17 16:00:00	MSFT	Stock	28.875	28.98	28.81	28.875	2650931.0

> showing 50 of 78,177 rows — these rows as CSV

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