PREVIEW / stock_30min / 2011-03-29

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-29.parquet
  size:    1.4 MB
  rows:    74,612
  symbols: 3,523

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-03-29 04:00:00	AAPL	Stock	12.5711	12.5711	12.5446	12.5446	11200.0
2011-03-29 04:30:00	AAPL	Stock	12.5632	12.5632	12.5632	12.5632	23800.0
2011-03-29 05:00:00	AAPL	Stock	12.5468	12.5468	12.5443	12.5443	11200.0
2011-03-29 05:30:00	AAPL	Stock	12.5311	12.5311	12.4739	12.4739	33600.0
2011-03-29 06:00:00	AAPL	Stock	12.5011	12.5011	12.5011	12.5011	2800.0
2011-03-29 06:30:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-03-29 07:00:00	AAPL	Stock	12.5186	12.5186	12.4993	12.5	50400.0
2011-03-29 07:30:00	AAPL	Stock	12.5	12.51	12.4914	12.495	109200.0
2011-03-29 08:00:00	AAPL	Stock	12.5	12.5171	12.4911	12.4971	572656.0
2011-03-29 08:30:00	AAPL	Stock	12.4993	12.5	12.4254	12.4261	3147984.0
2011-03-29 09:00:00	AAPL	Stock	12.4268	12.4357	12.4018	12.4143	5500152.0
2011-03-29 09:30:00	AAPL	Stock	12.4143	12.4475	12.3593	12.4136	72917012.0
2011-03-29 10:00:00	AAPL	Stock	12.4136	12.4979	12.4	12.4704	47955068.0
2011-03-29 10:30:00	AAPL	Stock	12.4712	12.4961	12.4518	12.4921	23363788.0
2011-03-29 11:00:00	AAPL	Stock	12.4921	12.52	12.4787	12.5029	32309480.0
2011-03-29 11:30:00	AAPL	Stock	12.5025	12.5146	12.485	12.5086	14170408.0
2011-03-29 12:00:00	AAPL	Stock	12.5086	12.5229	12.4989	12.5011	13012692.0
2011-03-29 12:30:00	AAPL	Stock	12.5	12.5036	12.4693	12.4786	17919048.0
2011-03-29 13:00:00	AAPL	Stock	12.4782	12.4875	12.4343	12.4404	16416176.0
2011-03-29 13:30:00	AAPL	Stock	12.44	12.4564	12.4396	12.4521	11643352.0
2011-03-29 14:00:00	AAPL	Stock	12.4525	12.4768	12.4491	12.4657	14906696.0
2011-03-29 14:30:00	AAPL	Stock	12.4664	12.4957	12.4611	12.4839	13633984.0
2011-03-29 15:00:00	AAPL	Stock	12.4839	12.5071	12.4807	12.5043	17675728.0
2011-03-29 15:30:00	AAPL	Stock	12.5043	12.5343	12.4861	12.5339	32367972.0
2011-03-29 16:00:00	AAPL	Stock	12.5329	12.5358	12.4663	12.5304	8079876.0
2011-03-29 16:30:00	AAPL	Stock	12.5321	12.5471	12.426	12.5421	782992.0
2011-03-29 17:00:00	AAPL	Stock	12.5404	12.5411	12.5379	12.5393	56896.0
2011-03-29 17:30:00	AAPL	Stock	12.5393	12.5482	12.5379	12.5482	155316.0
2011-03-29 18:00:00	AAPL	Stock	12.5482	12.5482	12.5343	12.5393	188776.0
2011-03-29 18:30:00	AAPL	Stock	12.5414	12.5482	12.5357	12.5357	359828.0
2011-03-29 19:00:00	AAPL	Stock	12.5386	12.5411	12.5361	12.5411	43568.0
2011-03-29 19:30:00	AAPL	Stock	12.5411	12.5464	12.5357	12.5464	90636.0
2011-03-29 07:30:00	MSFT	Stock	25.49	25.49	25.49	25.49	100.0
2011-03-29 08:00:00	MSFT	Stock	25.47	25.47	25.44	25.44	500.0
2011-03-29 08:30:00	MSFT	Stock	25.48	25.49	25.43	25.45	700.0
2011-03-29 09:00:00	MSFT	Stock	25.44	25.48	25.3	25.36	113941.0
2011-03-29 09:30:00	MSFT	Stock	25.36	25.395	25.3	25.34	3875369.0
2011-03-29 10:00:00	MSFT	Stock	25.34	25.44	25.33	25.4	3325937.0
2011-03-29 10:30:00	MSFT	Stock	25.4	25.4	25.34	25.374	2150224.0
2011-03-29 11:00:00	MSFT	Stock	25.38	25.46	25.375	25.42	3538002.0
2011-03-29 11:30:00	MSFT	Stock	25.42	25.47	25.4	25.43	2322115.0
2011-03-29 12:00:00	MSFT	Stock	25.44	25.46	25.4	25.401	1171705.0
2011-03-29 12:30:00	MSFT	Stock	25.406	25.45	25.4	25.45	1358302.0
2011-03-29 13:00:00	MSFT	Stock	25.445	25.46	25.41	25.43	1432459.0
2011-03-29 13:30:00	MSFT	Stock	25.43	25.43	25.4	25.41	1879247.0
2011-03-29 14:00:00	MSFT	Stock	25.415	25.44	25.4	25.405	4761447.0
2011-03-29 14:30:00	MSFT	Stock	25.401	25.52	25.4	25.5	4142552.0
2011-03-29 15:00:00	MSFT	Stock	25.5	25.52	25.46	25.46	2388830.0
2011-03-29 15:30:00	MSFT	Stock	25.47	25.5	25.43	25.49	5169330.0
2011-03-29 16:00:00	MSFT	Stock	25.49	25.5	25.422	25.48	1604516.0

> showing 50 of 74,612 rows — these rows as CSV

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