PREVIEW / stock_30min / 2011-04-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-28.parquet
  size:    1.4 MB
  rows:    76,052
  symbols: 3,566

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-04-28 04:00:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-04-28 05:00:00	AAPL	Stock	12.4993	12.4993	12.4993	12.4993	12600.0
2011-04-28 05:30:00	AAPL	Stock	12.4943	12.4943	12.4911	12.4911	9800.0
2011-04-28 06:00:00	AAPL	Stock	12.4918	12.4918	12.4918	12.4918	2800.0
2011-04-28 06:30:00	AAPL	Stock	12.4918	12.4918	12.4679	12.4679	11648.0
2011-04-28 07:00:00	AAPL	Stock	12.48	12.48	12.4643	12.4643	69328.0
2011-04-28 07:30:00	AAPL	Stock	12.4561	12.4921	12.4468	12.4529	167468.0
2011-04-28 08:00:00	AAPL	Stock	12.4468	12.4743	12.4446	12.4464	1358560.0
2011-04-28 08:30:00	AAPL	Stock	12.44	12.4464	12.4107	12.4107	1462524.0
2011-04-28 09:00:00	AAPL	Stock	12.4118	12.4179	12.3475	12.3632	5755736.0
2011-04-28 09:30:00	AAPL	Stock	12.3621	12.4911	12.3611	12.4582	70330652.0
2011-04-28 10:00:00	AAPL	Stock	12.4575	12.4732	12.4218	12.44	26324760.0
2011-04-28 10:30:00	AAPL	Stock	12.4404	12.4599	12.4132	12.4345	19147436.0
2011-04-28 11:00:00	AAPL	Stock	12.4371	12.4571	12.4221	12.4271	15312976.0
2011-04-28 11:30:00	AAPL	Stock	12.4268	12.4375	12.3821	12.3882	29605492.0
2011-04-28 12:00:00	AAPL	Stock	12.3893	12.4179	12.3796	12.4104	15998864.0
2011-04-28 12:30:00	AAPL	Stock	12.4121	12.4129	12.375	12.3854	11043452.0
2011-04-28 13:00:00	AAPL	Stock	12.3843	12.3943	12.34	12.3732	26603332.0
2011-04-28 13:30:00	AAPL	Stock	12.3732	12.3929	12.3591	12.3893	14279468.0
2011-04-28 14:00:00	AAPL	Stock	12.39	12.392	12.3618	12.3679	10379040.0
2011-04-28 14:30:00	AAPL	Stock	12.3696	12.3914	12.3643	12.3686	14330736.0
2011-04-28 15:00:00	AAPL	Stock	12.3693	12.3893	12.3589	12.3679	21540988.0
2011-04-28 15:30:00	AAPL	Stock	12.3689	12.3979	12.3589	12.3968	46137028.0
2011-04-28 16:00:00	AAPL	Stock	12.3986	12.4232	12.3543	12.3857	19189744.0
2011-04-28 16:30:00	AAPL	Stock	12.385	12.3968	12.3721	12.3846	1633716.0
2011-04-28 17:00:00	AAPL	Stock	12.3868	12.4018	12.3864	12.3964	1828260.0
2011-04-28 17:30:00	AAPL	Stock	12.4025	12.4107	12.3964	12.4107	204428.0
2011-04-28 18:00:00	AAPL	Stock	12.4104	12.4107	12.3839	12.3932	227528.0
2011-04-28 18:30:00	AAPL	Stock	12.3929	12.4071	12.3929	12.3929	55636.0
2011-04-28 19:00:00	AAPL	Stock	12.3929	12.4104	12.3929	12.4	20300.0
2011-04-28 19:30:00	AAPL	Stock	12.3964	12.3964	12.3929	12.3932	100044.0
2011-04-28 04:00:00	MSFT	Stock	26.49	26.49	26.49	26.49	100.0
2011-04-28 05:00:00	MSFT	Stock	26.48	26.5	26.47	26.49	1700.0
2011-04-28 05:30:00	MSFT	Stock	26.5	26.5	26.48	26.48	700.0
2011-04-28 06:00:00	MSFT	Stock	26.48	26.48	26.46	26.47	2700.0
2011-04-28 06:30:00	MSFT	Stock	26.43	26.43	26.43	26.43	1400.0
2011-04-28 07:00:00	MSFT	Stock	26.46	26.48	26.44	26.45	29632.0
2011-04-28 07:30:00	MSFT	Stock	26.47	26.48	26.46	26.47	8668.0
2011-04-28 08:00:00	MSFT	Stock	26.46	26.48	26.43	26.44	30301.0
2011-04-28 08:30:00	MSFT	Stock	26.43	26.5	26.37	26.43	72247.0
2011-04-28 09:00:00	MSFT	Stock	26.45	26.53	26.42	26.5	78143.0
2011-04-28 09:30:00	MSFT	Stock	26.46	26.55	26.42	26.545	6561337.0
2011-04-28 10:00:00	MSFT	Stock	26.54	26.55	26.41	26.475	5289432.0
2011-04-28 10:30:00	MSFT	Stock	26.48	26.49	26.4	26.48	2972494.0
2011-04-28 11:00:00	MSFT	Stock	26.488	26.55	26.48	26.54	2773658.0
2011-04-28 11:30:00	MSFT	Stock	26.53	26.55	26.5	26.52	3292325.0
2011-04-28 12:00:00	MSFT	Stock	26.51	26.59	26.51	26.585	4260804.0
2011-04-28 12:30:00	MSFT	Stock	26.58	26.68	26.58	26.665	3128382.0
2011-04-28 13:00:00	MSFT	Stock	26.66	26.71	26.57	26.65	3317803.0
2011-04-28 13:30:00	MSFT	Stock	26.651	26.7	26.63	26.656	3337658.0

> showing 50 of 76,052 rows — these rows as CSV

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