PREVIEW / stock_30min / 2014-03-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-07.parquet
  size:    1.6 MB
  rows:    83,395
  symbols: 3,554

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
2014-03-07 04:00:00	AAPL	Stock	18.9557	18.9557	18.9554	18.9554	5600.0
2014-03-07 06:00:00	AAPL	Stock	18.9554	18.9554	18.9554	18.9554	5600.0
2014-03-07 06:30:00	AAPL	Stock	18.9796	18.9796	18.9796	18.9796	14000.0
2014-03-07 07:00:00	AAPL	Stock	18.9786	18.9786	18.9739	18.9764	16800.0
2014-03-07 07:30:00	AAPL	Stock	18.9646	18.9646	18.9646	18.9646	2800.0
2014-03-07 08:00:00	AAPL	Stock	18.9643	18.9643	18.8929	18.9086	163072.0
2014-03-07 08:30:00	AAPL	Stock	18.9179	18.9957	18.8986	18.9736	864836.0
2014-03-07 09:00:00	AAPL	Stock	18.9664	18.9843	18.9582	18.9761	680736.0
2014-03-07 09:30:00	AAPL	Stock	18.97	18.9993	18.8111	18.8642	37734564.0
2014-03-07 10:00:00	AAPL	Stock	18.8616	18.9032	18.8414	18.8557	14937916.0
2014-03-07 10:30:00	AAPL	Stock	18.8554	18.8889	18.8289	18.84	10669680.0
2014-03-07 11:00:00	AAPL	Stock	18.8389	18.8489	18.8004	18.841	12858076.0
2014-03-07 11:30:00	AAPL	Stock	18.8411	18.8689	18.8257	18.8464	7467796.0
2014-03-07 12:00:00	AAPL	Stock	18.8425	18.85	18.8061	18.8321	7957880.0
2014-03-07 12:30:00	AAPL	Stock	18.8336	18.8339	18.7946	18.7996	6784680.0
2014-03-07 13:00:00	AAPL	Stock	18.8	18.8614	18.7875	18.8611	9402960.0
2014-03-07 13:30:00	AAPL	Stock	18.8611	18.8611	18.8054	18.8182	5254788.0
2014-03-07 14:00:00	AAPL	Stock	18.8204	18.8517	18.8123	18.8396	6896708.0
2014-03-07 14:30:00	AAPL	Stock	18.8407	18.8911	18.8293	18.8821	8434132.0
2014-03-07 15:00:00	AAPL	Stock	18.8846	18.9107	18.8593	18.8961	10345552.0
2014-03-07 15:30:00	AAPL	Stock	18.8964	18.9443	18.865	18.9439	23637824.0
2014-03-07 16:00:00	AAPL	Stock	18.9439	18.9496	18.8583	18.9321	8974672.0
2014-03-07 16:30:00	AAPL	Stock	18.9339	18.9393	18.9268	18.9275	865620.0
2014-03-07 17:00:00	AAPL	Stock	18.9314	18.9443	18.9286	18.9357	266616.0
2014-03-07 17:30:00	AAPL	Stock	18.9346	18.9375	18.9286	18.9357	53480.0
2014-03-07 18:00:00	AAPL	Stock	18.9339	18.9443	18.9339	18.9368	730576.0
2014-03-07 19:00:00	AAPL	Stock	18.9371	18.9371	18.9339	18.9339	25200.0
2014-03-07 19:30:00	AAPL	Stock	18.9357	18.9446	18.9357	18.9443	132748.0
2014-03-07 08:30:00	MSFT	Stock	38.15	38.29	38.15	38.24	31200.0
2014-03-07 09:00:00	MSFT	Stock	38.26	38.35	38.24	38.33	10800.0
2014-03-07 09:30:00	MSFT	Stock	38.32	38.36	37.87	38.01	3023733.0
2014-03-07 10:00:00	MSFT	Stock	38.01	38.05	37.89	38.01	2799513.0
2014-03-07 10:30:00	MSFT	Stock	38.01	38.062	37.9	37.925	1233737.0
2014-03-07 11:00:00	MSFT	Stock	37.93	37.93	37.69	37.84	1589698.0
2014-03-07 11:30:00	MSFT	Stock	37.84	37.87	37.78	37.81	1211870.0
2014-03-07 12:00:00	MSFT	Stock	37.82	37.82	37.73	37.784	1057206.0
2014-03-07 12:30:00	MSFT	Stock	37.78	37.802	37.74	37.78	751857.0
2014-03-07 13:00:00	MSFT	Stock	37.785	37.8	37.7	37.77	1484099.0
2014-03-07 13:30:00	MSFT	Stock	37.775	37.812	37.72	37.805	872889.0
2014-03-07 14:00:00	MSFT	Stock	37.81	37.82	37.72	37.73	1219527.0
2014-03-07 14:30:00	MSFT	Stock	37.73	37.88	37.72	37.83	1707865.0
2014-03-07 15:00:00	MSFT	Stock	37.84	37.85	37.79	37.795	1246667.0
2014-03-07 15:30:00	MSFT	Stock	37.795	37.91	37.76	37.9	5128459.0
2014-03-07 16:00:00	MSFT	Stock	37.9	37.91	37.816	37.88	2448227.0
2014-03-07 16:30:00	MSFT	Stock	37.797	37.91	37.797	37.89	79323.0
2014-03-07 17:00:00	MSFT	Stock	37.9	37.9	37.9	37.9	40344.0
2014-03-07 17:30:00	MSFT	Stock	37.86	37.9	37.86	37.9	3600.0
2014-03-07 18:30:00	MSFT	Stock	37.9	37.9	37.9	37.9	400.0
2014-03-07 19:30:00	MSFT	Stock	37.83	37.83	37.81	37.81	2100.0
2014-03-07 08:00:00	NVDA	Stock	0.4595	0.4595	0.4595	0.4595	4000.0

> showing 50 of 83,395 rows — these rows as CSV

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