PREVIEW / stock_30min / 2013-11-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-27.parquet
  size:    1.5 MB
  rows:    79,290
  symbols: 3,550

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-11-27 05:00:00	AAPL	Stock	19.0971	19.0971	19.0971	19.0971	2800.0
2013-11-27 06:00:00	AAPL	Stock	19.0996	19.1071	19.0936	19.1071	36400.0
2013-11-27 06:30:00	AAPL	Stock	19.1068	19.1239	19.1068	19.1071	122556.0
2013-11-27 07:00:00	AAPL	Stock	19.1157	19.1639	19.1071	19.1429	481936.0
2013-11-27 07:30:00	AAPL	Stock	19.1518	19.1789	19.1429	19.1589	706412.0
2013-11-27 08:00:00	AAPL	Stock	19.1607	19.1846	19.0679	19.1639	2023252.0
2013-11-27 08:30:00	AAPL	Stock	19.1621	19.1679	19.1507	19.1643	565068.0
2013-11-27 09:00:00	AAPL	Stock	19.1625	19.1739	19.1429	19.1507	1445192.0
2013-11-27 09:30:00	AAPL	Stock	19.1525	19.3964	19.1489	19.3711	101178672.0
2013-11-27 10:00:00	AAPL	Stock	19.3714	19.4211	19.3279	19.4118	45398080.0
2013-11-27 10:30:00	AAPL	Stock	19.4101	19.4268	19.3868	19.4064	23901052.0
2013-11-27 11:00:00	AAPL	Stock	19.4057	19.4521	19.3979	19.45	21393652.0
2013-11-27 11:30:00	AAPL	Stock	19.4486	19.4643	19.4382	19.4568	21585956.0
2013-11-27 12:00:00	AAPL	Stock	19.4573	19.4596	19.3839	19.4368	20231568.0
2013-11-27 12:30:00	AAPL	Stock	19.4352	19.4487	19.4064	19.4092	12069932.0
2013-11-27 13:00:00	AAPL	Stock	19.4089	19.4239	19.3789	19.4223	10884468.0
2013-11-27 13:30:00	AAPL	Stock	19.4214	19.4336	19.3932	19.4319	8683864.0
2013-11-27 14:00:00	AAPL	Stock	19.4296	19.4679	19.4279	19.4607	17641316.0
2013-11-27 14:30:00	AAPL	Stock	19.4609	19.4682	19.4232	19.4475	10960180.0
2013-11-27 15:00:00	AAPL	Stock	19.4475	19.45	19.4196	19.4346	10055500.0
2013-11-27 15:30:00	AAPL	Stock	19.4321	19.5	19.425	19.4992	34928824.0
2013-11-27 16:00:00	AAPL	Stock	19.4986	19.525	19.3704	19.5114	10010756.0
2013-11-27 16:30:00	AAPL	Stock	19.5132	19.5132	19.4392	19.5132	1389080.0
2013-11-27 17:00:00	AAPL	Stock	19.5104	19.5286	19.5104	19.5268	567448.0
2013-11-27 17:30:00	AAPL	Stock	19.5286	19.5389	19.5268	19.5329	169820.0
2013-11-27 18:00:00	AAPL	Stock	19.5329	19.5411	19.4986	19.5321	175672.0
2013-11-27 18:30:00	AAPL	Stock	19.5339	19.5443	19.5339	19.5361	123872.0
2013-11-27 19:00:00	AAPL	Stock	19.5361	19.5443	19.5357	19.5411	140532.0
2013-11-27 19:30:00	AAPL	Stock	19.5368	19.5446	19.5357	19.5357	253904.0
2013-11-27 07:00:00	MSFT	Stock	37.47	37.47	37.47	37.47	100.0
2013-11-27 08:00:00	MSFT	Stock	37.49	37.51	37.45	37.51	2500.0
2013-11-27 08:30:00	MSFT	Stock	37.49	37.55	37.47	37.5	41000.0
2013-11-27 09:00:00	MSFT	Stock	37.52	37.57	37.52	37.57	42720.0
2013-11-27 09:30:00	MSFT	Stock	37.57	37.76	37.49	37.73	3586373.0
2013-11-27 10:00:00	MSFT	Stock	37.73	37.73	37.63	37.689	1786830.0
2013-11-27 10:30:00	MSFT	Stock	37.69	37.73	37.64	37.695	1239739.0
2013-11-27 11:00:00	MSFT	Stock	37.69	37.715	37.6	37.63	1547838.0
2013-11-27 11:30:00	MSFT	Stock	37.624	37.67	37.58	37.63	1704543.0
2013-11-27 12:00:00	MSFT	Stock	37.63	37.64	37.595	37.625	1069006.0
2013-11-27 12:30:00	MSFT	Stock	37.63	37.69	37.6	37.63	1423371.0
2013-11-27 13:00:00	MSFT	Stock	37.62	37.67	37.61	37.664	942706.0
2013-11-27 13:30:00	MSFT	Stock	37.67	37.68	37.63	37.64	750219.0
2013-11-27 14:00:00	MSFT	Stock	37.65	37.71	37.63	37.71	663047.0
2013-11-27 14:30:00	MSFT	Stock	37.71	37.72	37.69	37.69	1453707.0
2013-11-27 15:00:00	MSFT	Stock	37.69	37.7	37.61	37.65	1108540.0
2013-11-27 15:30:00	MSFT	Stock	37.65	37.65	37.58	37.61	3289341.0
2013-11-27 16:00:00	MSFT	Stock	37.6	37.645	37.6	37.62	1703110.0
2013-11-27 16:30:00	MSFT	Stock	37.66	37.66	37.66	37.66	1071.0
2013-11-27 17:00:00	MSFT	Stock	37.56	37.56	37.56	37.56	1416.0
2013-11-27 17:30:00	MSFT	Stock	37.72	37.72	37.72	37.72	300.0

> showing 50 of 79,290 rows — these rows as CSV

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