PREVIEW / stock_30min / 2012-06-08

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-08.parquet
  size:    1.4 MB
  rows:    73,397
  symbols: 3,498

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
2012-06-08 04:00:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	28000.0
2012-06-08 04:30:00	AAPL	Stock	20.3368	20.3368	20.3368	20.3368	2800.0
2012-06-08 05:00:00	AAPL	Stock	20.2611	20.3214	20.2607	20.3214	18200.0
2012-06-08 05:30:00	AAPL	Stock	20.3214	20.3682	20.3214	20.3682	28000.0
2012-06-08 06:00:00	AAPL	Stock	20.3689	20.3711	20.3679	20.3679	27748.0
2012-06-08 06:30:00	AAPL	Stock	20.3686	20.3686	20.3464	20.3575	24920.0
2012-06-08 07:00:00	AAPL	Stock	20.3393	20.3907	20.3214	20.3875	148036.0
2012-06-08 07:30:00	AAPL	Stock	20.3871	20.3907	20.3621	20.3707	91000.0
2012-06-08 08:00:00	AAPL	Stock	20.3621	20.3921	20.3429	20.3643	584360.0
2012-06-08 08:30:00	AAPL	Stock	20.3646	20.4107	20.3596	20.3946	1080604.0
2012-06-08 09:00:00	AAPL	Stock	20.3996	20.4571	20.3929	20.3996	1272264.0
2012-06-08 09:30:00	AAPL	Stock	20.4143	20.4232	20.3214	20.4152	42880600.0
2012-06-08 10:00:00	AAPL	Stock	20.4189	20.4729	20.4014	20.4364	30363396.0
2012-06-08 10:30:00	AAPL	Stock	20.4382	20.5018	20.4286	20.4996	23055984.0
2012-06-08 11:00:00	AAPL	Stock	20.5014	20.5039	20.4518	20.4754	17001124.0
2012-06-08 11:30:00	AAPL	Stock	20.475	20.4882	20.4182	20.4275	11823924.0
2012-06-08 12:00:00	AAPL	Stock	20.4263	20.4679	20.4254	20.4643	10092544.0
2012-06-08 12:30:00	AAPL	Stock	20.4636	20.4993	20.4636	20.4904	11923408.0
2012-06-08 13:00:00	AAPL	Stock	20.4864	20.5942	20.4857	20.5921	33040280.0
2012-06-08 13:30:00	AAPL	Stock	20.5936	20.5961	20.5475	20.5636	15684872.0
2012-06-08 14:00:00	AAPL	Stock	20.5671	20.5868	20.545	20.5807	10839332.0
2012-06-08 14:30:00	AAPL	Stock	20.5807	20.6321	20.5729	20.6032	22086568.0
2012-06-08 15:00:00	AAPL	Stock	20.6021	20.6607	20.5982	20.6579	27388060.0
2012-06-08 15:30:00	AAPL	Stock	20.6571	20.7351	20.6468	20.7239	65207184.0
2012-06-08 16:00:00	AAPL	Stock	20.7246	20.735	20.4186	20.735	12474364.0
2012-06-08 16:30:00	AAPL	Stock	20.7346	20.7857	20.6663	20.7379	1828680.0
2012-06-08 17:00:00	AAPL	Stock	20.7379	20.7461	20.7343	20.7375	183680.0
2012-06-08 17:30:00	AAPL	Stock	20.7407	20.7875	20.7407	20.7871	580748.0
2012-06-08 18:00:00	AAPL	Stock	20.7768	20.7875	20.7768	20.7875	88536.0
2012-06-08 18:30:00	AAPL	Stock	20.7857	20.7857	20.775	20.775	106344.0
2012-06-08 19:00:00	AAPL	Stock	20.7686	20.7786	20.7579	20.7679	141064.0
2012-06-08 19:30:00	AAPL	Stock	20.7625	20.7839	20.7611	20.7821	209468.0
2012-06-08 08:00:00	MSFT	Stock	29.18	29.24	29.18	29.19	5598.0
2012-06-08 08:30:00	MSFT	Stock	29.19	29.22	29.19	29.2	1353.0
2012-06-08 09:00:00	MSFT	Stock	29.17	29.24	29.15	29.24	26219.0
2012-06-08 09:30:00	MSFT	Stock	29.23	29.29	29.05	29.235	3664983.0
2012-06-08 10:00:00	MSFT	Stock	29.23	29.42	29.19	29.3	3839242.0
2012-06-08 10:30:00	MSFT	Stock	29.3	29.45	29.28	29.435	2479274.0
2012-06-08 11:00:00	MSFT	Stock	29.43	29.45	29.33	29.35	3979342.0
2012-06-08 11:30:00	MSFT	Stock	29.36	29.4	29.33	29.34	1882581.0
2012-06-08 12:00:00	MSFT	Stock	29.34	29.38	29.28	29.38	2019758.0
2012-06-08 12:30:00	MSFT	Stock	29.376	29.44	29.34	29.35	2337031.0
2012-06-08 13:00:00	MSFT	Stock	29.355	29.42	29.34	29.4	1939256.0
2012-06-08 13:30:00	MSFT	Stock	29.4	29.46	29.37	29.37	2391222.0
2012-06-08 14:00:00	MSFT	Stock	29.375	29.5	29.36	29.49	2274647.0
2012-06-08 14:30:00	MSFT	Stock	29.49	29.56	29.46	29.506	2357240.0
2012-06-08 15:00:00	MSFT	Stock	29.5	29.62	29.5	29.585	3199970.0
2012-06-08 15:30:00	MSFT	Stock	29.58	29.68	29.53	29.64	5706681.0
2012-06-08 16:00:00	MSFT	Stock	29.65	29.7	29.4	29.65	3755054.0
2012-06-08 16:30:00	MSFT	Stock	29.65	29.65	29.292	29.65	56100.0

> showing 50 of 73,397 rows — these rows as CSV

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