PREVIEW / stock_30min / 2013-08-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-07.parquet
  size:    1.5 MB
  rows:    78,228
  symbols: 3,503

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-08-07 07:00:00	AAPL	Stock	16.5571	16.5936	16.5464	16.5464	36400.0
2013-08-07 07:30:00	AAPL	Stock	16.5643	16.5643	16.5511	16.5589	121912.0
2013-08-07 08:00:00	AAPL	Stock	16.5536	16.5786	16.5482	16.5729	437668.0
2013-08-07 08:30:00	AAPL	Stock	16.5746	16.5904	16.5582	16.575	558768.0
2013-08-07 09:00:00	AAPL	Stock	16.5746	16.575	16.5571	16.5575	494480.0
2013-08-07 09:30:00	AAPL	Stock	16.5643	16.6786	16.5368	16.6206	45118976.0
2013-08-07 10:00:00	AAPL	Stock	16.6204	16.6293	16.4918	16.5339	31620092.0
2013-08-07 10:30:00	AAPL	Stock	16.5339	16.58	16.5157	16.5561	24700060.0
2013-08-07 11:00:00	AAPL	Stock	16.558	16.5642	16.5225	16.5392	10661448.0
2013-08-07 11:30:00	AAPL	Stock	16.5361	16.5461	16.51	16.5292	11091416.0
2013-08-07 12:00:00	AAPL	Stock	16.5275	16.5429	16.5071	16.5171	6858768.0
2013-08-07 12:30:00	AAPL	Stock	16.5139	16.5843	16.5089	16.5693	12501692.0
2013-08-07 13:00:00	AAPL	Stock	16.57	16.5943	16.5575	16.5936	8613220.0
2013-08-07 13:30:00	AAPL	Stock	16.5918	16.6214	16.585	16.6029	9673356.0
2013-08-07 14:00:00	AAPL	Stock	16.6074	16.6454	16.5754	16.5879	19976180.0
2013-08-07 14:30:00	AAPL	Stock	16.5893	16.6089	16.5693	16.5886	11821908.0
2013-08-07 15:00:00	AAPL	Stock	16.5921	16.615	16.5718	16.599	11322220.0
2013-08-07 15:30:00	AAPL	Stock	16.6018	16.6218	16.5882	16.605	29053528.0
2013-08-07 16:00:00	AAPL	Stock	16.6064	16.6111	16.5785	16.5825	41434988.0
2013-08-07 16:30:00	AAPL	Stock	16.5879	16.6064	16.5818	16.5818	250264.0
2013-08-07 17:00:00	AAPL	Stock	16.5889	16.5889	16.5789	16.5789	222684.0
2013-08-07 17:30:00	AAPL	Stock	16.575	16.6064	16.5746	16.5746	143864.0
2013-08-07 18:00:00	AAPL	Stock	16.5779	16.5804	16.5714	16.5786	65940.0
2013-08-07 18:30:00	AAPL	Stock	16.58	16.5886	16.58	16.5804	52108.0
2013-08-07 19:00:00	AAPL	Stock	16.5804	16.5889	16.5804	16.5889	39256.0
2013-08-07 19:30:00	AAPL	Stock	16.5839	16.5893	16.5839	16.5893	42084.0
2013-08-07 08:00:00	MSFT	Stock	31.45	31.45	31.45	31.45	587.0
2013-08-07 08:30:00	MSFT	Stock	31.45	31.5	31.42	31.49	2756.0
2013-08-07 09:00:00	MSFT	Stock	31.49	31.5	31.49	31.5	2140.0
2013-08-07 09:30:00	MSFT	Stock	31.54	31.56	31.43	31.47	2351082.0
2013-08-07 10:00:00	MSFT	Stock	31.46	31.487	31.25	31.29	3196797.0
2013-08-07 10:30:00	MSFT	Stock	31.285	31.405	31.255	31.39	2121874.0
2013-08-07 11:00:00	MSFT	Stock	31.4	31.44	31.3	31.31	1566953.0
2013-08-07 11:30:00	MSFT	Stock	31.315	31.32	31.25	31.31	1858027.0
2013-08-07 12:00:00	MSFT	Stock	31.307	31.39	31.29	31.373	1216364.0
2013-08-07 12:30:00	MSFT	Stock	31.37	31.48	31.36	31.48	1401359.0
2013-08-07 13:00:00	MSFT	Stock	31.475	31.64	31.46	31.54	2036836.0
2013-08-07 13:30:00	MSFT	Stock	31.54	31.56	31.47	31.511	1092519.0
2013-08-07 14:00:00	MSFT	Stock	31.52	31.61	31.5	31.6	1858323.0
2013-08-07 14:30:00	MSFT	Stock	31.61	31.9	31.575	31.89	3336053.0
2013-08-07 15:00:00	MSFT	Stock	31.89	31.98	31.89	31.95	4242477.0
2013-08-07 15:30:00	MSFT	Stock	31.96	32.1	31.92	32.065	9211529.0
2013-08-07 16:00:00	MSFT	Stock	32.06	32.11	31.334	32.06	1752747.0
2013-08-07 16:30:00	MSFT	Stock	32.05	32.06	31.961	32.05	24859.0
2013-08-07 17:00:00	MSFT	Stock	32.03	32.05	32.03	32.05	1232.0
2013-08-07 17:30:00	MSFT	Stock	32.03	32.063	32.03	32.05	17585.0
2013-08-07 18:00:00	MSFT	Stock	32.03	32.05	32.03	32.03	2088.0
2013-08-07 18:30:00	MSFT	Stock	31.97	32.04	31.97	32.04	4850.0
2013-08-07 19:00:00	MSFT	Stock	32.04	32.04	32.04	32.04	3913.0
2013-08-07 19:30:00	MSFT	Stock	32.04	32.04	32.01	32.01	4300.0

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

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