PREVIEW / stock_30min / 2010-03-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-22.parquet
  size:    1.4 MB
  rows:    75,006
  symbols: 3,490

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
2010-03-22 04:00:00	AAPL	Stock	7.9	7.9	7.9	7.9	5600.0
2010-03-22 04:30:00	AAPL	Stock	7.8961	7.8961	7.8961	7.8961	7000.0
2010-03-22 05:30:00	AAPL	Stock	7.8982	7.9064	7.8982	7.9064	26600.0
2010-03-22 06:00:00	AAPL	Stock	7.8982	7.9036	7.8982	7.9036	12712.0
2010-03-22 06:30:00	AAPL	Stock	7.9107	7.9107	7.9107	7.9107	2828.0
2010-03-22 07:00:00	AAPL	Stock	7.8982	7.9089	7.8982	7.9089	24640.0
2010-03-22 07:30:00	AAPL	Stock	7.9064	7.9064	7.8775	7.8832	139272.0
2010-03-22 08:00:00	AAPL	Stock	7.8775	7.8929	7.8643	7.8732	1292956.0
2010-03-22 08:30:00	AAPL	Stock	7.8729	7.8946	7.8729	7.8864	1009456.0
2010-03-22 09:00:00	AAPL	Stock	7.8857	7.8925	7.8571	7.8739	1305500.0
2010-03-22 09:30:00	AAPL	Stock	7.8739	8.0	7.8625	7.9814	86972704.0
2010-03-22 10:00:00	AAPL	Stock	7.9814	8.0643	7.9614	7.9857	51977156.0
2010-03-22 10:30:00	AAPL	Stock	7.9857	8.02	7.9821	8.0129	38180744.0
2010-03-22 11:00:00	AAPL	Stock	8.0125	8.0354	8.0111	8.025	30692452.0
2010-03-22 11:30:00	AAPL	Stock	8.0257	8.0257	8.0057	8.0243	19367264.0
2010-03-22 12:00:00	AAPL	Stock	8.0243	8.0254	8.0118	8.0221	15013796.0
2010-03-22 12:30:00	AAPL	Stock	8.0214	8.0493	8.02	8.0482	29286320.0
2010-03-22 13:00:00	AAPL	Stock	8.0479	8.0607	8.0439	8.0457	22188824.0
2010-03-22 13:30:00	AAPL	Stock	8.0454	8.0529	8.0418	8.0425	12007044.0
2010-03-22 14:00:00	AAPL	Stock	8.0432	8.0561	8.0339	8.0536	19391008.0
2010-03-22 14:30:00	AAPL	Stock	8.0529	8.0696	8.0496	8.0561	26693408.0
2010-03-22 15:00:00	AAPL	Stock	8.0559	8.0714	8.05	8.0554	24229268.0
2010-03-22 15:30:00	AAPL	Stock	8.0561	8.0586	8.0189	8.0314	47368132.0
2010-03-22 16:00:00	AAPL	Stock	8.0286	8.0521	7.9393	8.0271	23765252.0
2010-03-22 16:30:00	AAPL	Stock	8.0271	8.057	8.0179	8.0254	311668.0
2010-03-22 17:00:00	AAPL	Stock	8.025	8.0304	8.0236	8.0304	49672.0
2010-03-22 17:30:00	AAPL	Stock	8.0286	8.0286	8.0271	8.0286	43596.0
2010-03-22 18:00:00	AAPL	Stock	8.0286	8.0475	8.0261	8.0475	518560.0
2010-03-22 18:30:00	AAPL	Stock	8.0464	8.0493	8.0446	8.0482	147952.0
2010-03-22 19:00:00	AAPL	Stock	8.0439	8.0482	8.0432	8.0461	81088.0
2010-03-22 19:30:00	AAPL	Stock	8.0446	8.0461	8.0371	8.0429	67004.0
2010-03-22 20:00:00	AAPL	Stock	8.0014	8.0257	8.0014	8.0257	221648.0
2010-03-22 06:00:00	MSFT	Stock	29.31	29.31	29.31	29.31	141.0
2010-03-22 06:30:00	MSFT	Stock	29.3	29.3	29.3	29.3	100.0
2010-03-22 07:00:00	MSFT	Stock	29.3	29.3	29.3	29.3	200.0
2010-03-22 07:30:00	MSFT	Stock	29.35	29.35	29.35	29.35	100.0
2010-03-22 08:00:00	MSFT	Stock	29.36	29.52	29.35	29.48	18798.0
2010-03-22 08:30:00	MSFT	Stock	29.45	29.5	29.39	29.42	13158.0
2010-03-22 09:00:00	MSFT	Stock	29.41	29.51	29.35	29.5	23994.0
2010-03-22 09:30:00	MSFT	Stock	29.51	29.58	29.39	29.48	3977531.0
2010-03-22 10:00:00	MSFT	Stock	29.48	29.63	29.4	29.58	3219264.0
2010-03-22 10:30:00	MSFT	Stock	29.58	29.63	29.525	29.56	2496251.0
2010-03-22 11:00:00	MSFT	Stock	29.558	29.64	29.55	29.56	2371834.0
2010-03-22 11:30:00	MSFT	Stock	29.559	29.63	29.54	29.59	1184821.0
2010-03-22 12:00:00	MSFT	Stock	29.59	29.6	29.52	29.58	1646284.0
2010-03-22 12:30:00	MSFT	Stock	29.58	29.6	29.55	29.57	1020389.0
2010-03-22 13:00:00	MSFT	Stock	29.58	29.67	29.57	29.61	1784997.0
2010-03-22 13:30:00	MSFT	Stock	29.613	29.64	29.57	29.57	2264344.0
2010-03-22 14:00:00	MSFT	Stock	29.57	29.63	29.55	29.61	1495091.0
2010-03-22 14:30:00	MSFT	Stock	29.615	29.7	29.61	29.643	1677447.0

> showing 50 of 75,006 rows — these rows as CSV

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