PREVIEW / stock_30min / 2014-04-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-08.parquet
  size:    1.6 MB
  rows:    81,848
  symbols: 3,555

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-04-08 04:30:00	AAPL	Stock	18.7725	18.7839	18.7725	18.7839	19600.0
2014-04-08 05:00:00	AAPL	Stock	18.7557	18.7557	18.75	18.75	9716.0
2014-04-08 05:30:00	AAPL	Stock	18.7479	18.7479	18.7161	18.7161	19600.0
2014-04-08 06:00:00	AAPL	Stock	18.71	18.71	18.71	18.71	2800.0
2014-04-08 06:30:00	AAPL	Stock	18.6964	18.6964	18.6964	18.6964	2800.0
2014-04-08 07:30:00	AAPL	Stock	18.6986	18.7036	18.6857	18.7036	26292.0
2014-04-08 08:00:00	AAPL	Stock	18.6986	18.8079	18.6986	18.7857	291536.0
2014-04-08 08:30:00	AAPL	Stock	18.7957	18.815	18.7868	18.8007	571788.0
2014-04-08 09:00:00	AAPL	Stock	18.7982	18.8029	18.7432	18.7432	558628.0
2014-04-08 09:30:00	AAPL	Stock	18.7546	18.79	18.525	18.5646	41128528.0
2014-04-08 10:00:00	AAPL	Stock	18.5711	18.68	18.565	18.5936	21470428.0
2014-04-08 10:30:00	AAPL	Stock	18.5936	18.7807	18.5936	18.7454	26543916.0
2014-04-08 11:00:00	AAPL	Stock	18.7461	18.7739	18.6989	18.7104	12276600.0
2014-04-08 11:30:00	AAPL	Stock	18.7139	18.7229	18.6554	18.6894	11769268.0
2014-04-08 12:00:00	AAPL	Stock	18.6921	18.7257	18.6689	18.6936	5783372.0
2014-04-08 12:30:00	AAPL	Stock	18.6961	18.7014	18.644	18.6521	6096412.0
2014-04-08 13:00:00	AAPL	Stock	18.6532	18.6943	18.6164	18.6836	9389912.0
2014-04-08 13:30:00	AAPL	Stock	18.6868	18.6911	18.6282	18.6614	6604640.0
2014-04-08 14:00:00	AAPL	Stock	18.6614	18.675	18.6107	18.6218	6044304.0
2014-04-08 14:30:00	AAPL	Stock	18.6218	18.69	18.6157	18.6896	6442296.0
2014-04-08 15:00:00	AAPL	Stock	18.6904	18.7296	18.6554	18.7161	7759024.0
2014-04-08 15:30:00	AAPL	Stock	18.7157	18.7421	18.6936	18.6939	19671204.0
2014-04-08 16:00:00	AAPL	Stock	18.7	18.725	18.5427	18.6943	17433976.0
2014-04-08 16:30:00	AAPL	Stock	18.6939	18.698	18.6829	18.698	98560.0
2014-04-08 17:00:00	AAPL	Stock	18.6943	18.6964	18.6918	18.6964	210420.0
2014-04-08 17:30:00	AAPL	Stock	18.6957	18.6957	18.6839	18.6839	11200.0
2014-04-08 18:00:00	AAPL	Stock	18.6914	18.6914	18.6875	18.6875	19600.0
2014-04-08 18:30:00	AAPL	Stock	18.6943	18.7004	18.6857	18.7	215404.0
2014-04-08 19:00:00	AAPL	Stock	18.705	18.705	18.7018	18.7018	33600.0
2014-04-08 19:30:00	AAPL	Stock	18.6982	18.7032	18.6964	18.6964	39312.0
2014-04-08 06:30:00	MSFT	Stock	39.63	39.63	39.58	39.58	444.0
2014-04-08 07:30:00	MSFT	Stock	39.66	39.7	39.65	39.65	825.0
2014-04-08 08:00:00	MSFT	Stock	39.7	39.8	39.7	39.8	2104.0
2014-04-08 08:30:00	MSFT	Stock	39.81	39.92	39.81	39.85	1535.0
2014-04-08 09:00:00	MSFT	Stock	39.86	39.87	39.66	39.72	23966.0
2014-04-08 09:30:00	MSFT	Stock	39.75	39.93	39.43	39.49	5203774.0
2014-04-08 10:00:00	MSFT	Stock	39.49	39.57	39.2	39.278	4824580.0
2014-04-08 10:30:00	MSFT	Stock	39.27	39.77	39.27	39.736	3602582.0
2014-04-08 11:00:00	MSFT	Stock	39.74	39.86	39.67	39.78	2866472.0
2014-04-08 11:30:00	MSFT	Stock	39.78	39.8	39.654	39.675	1763739.0
2014-04-08 12:00:00	MSFT	Stock	39.67	39.84	39.665	39.834	1767836.0
2014-04-08 12:30:00	MSFT	Stock	39.84	39.88	39.77	39.8	1452133.0
2014-04-08 13:00:00	MSFT	Stock	39.799	39.91	39.79	39.9	1550988.0
2014-04-08 13:30:00	MSFT	Stock	39.89	39.9	39.79	39.84	1057471.0
2014-04-08 14:00:00	MSFT	Stock	39.84	39.85	39.69	39.745	1133790.0
2014-04-08 14:30:00	MSFT	Stock	39.74	39.79	39.65	39.758	1546376.0
2014-04-08 15:00:00	MSFT	Stock	39.75	39.9	39.71	39.85	2009199.0
2014-04-08 15:30:00	MSFT	Stock	39.85	39.9	39.795	39.82	3281795.0
2014-04-08 16:00:00	MSFT	Stock	39.82	39.82	39.457	39.82	2216420.0
2014-04-08 16:30:00	MSFT	Stock	39.82	39.83	39.82	39.828	24183.0

> showing 50 of 81,848 rows — these rows as CSV

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