PREVIEW / stock_30min / 2012-08-03

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-03.parquet
  size:    1.4 MB
  rows:    75,345
  symbols: 3,496

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-08-03 04:00:00	AAPL	Stock	21.7929	21.8129	21.7929	21.8125	28000.0
2012-08-03 04:30:00	AAPL	Stock	21.8321	21.8321	21.8321	21.8321	7000.0
2012-08-03 05:00:00	AAPL	Stock	21.8393	21.8393	21.8393	21.8393	33600.0
2012-08-03 05:30:00	AAPL	Stock	21.8393	21.8393	21.8357	21.8357	28000.0
2012-08-03 06:00:00	AAPL	Stock	21.8464	21.8464	21.8464	21.8464	7000.0
2012-08-03 06:30:00	AAPL	Stock	21.8564	21.8643	21.8564	21.8571	8400.0
2012-08-03 07:00:00	AAPL	Stock	21.8507	21.8714	21.8304	21.8475	354060.0
2012-08-03 07:30:00	AAPL	Stock	21.8214	21.8371	21.7946	21.7946	364672.0
2012-08-03 08:00:00	AAPL	Stock	21.7932	21.8461	21.7143	21.7804	1241044.0
2012-08-03 08:30:00	AAPL	Stock	21.7861	21.8893	21.7857	21.8707	3559528.0
2012-08-03 09:00:00	AAPL	Stock	21.8679	21.9421	21.8664	21.9186	2483096.0
2012-08-03 09:30:00	AAPL	Stock	21.9154	22.005	21.8414	21.9811	68985616.0
2012-08-03 10:00:00	AAPL	Stock	21.9821	21.9996	21.9175	21.9893	30586388.0
2012-08-03 10:30:00	AAPL	Stock	21.9896	22.0489	21.9569	22.035	30186716.0
2012-08-03 11:00:00	AAPL	Stock	22.0354	22.0707	22.0296	22.0493	26186356.0
2012-08-03 11:30:00	AAPL	Stock	22.0493	22.0671	21.9846	22.0175	23024568.0
2012-08-03 12:00:00	AAPL	Stock	22.0144	22.0339	21.9475	21.9962	17388560.0
2012-08-03 12:30:00	AAPL	Stock	21.9996	22.0021	21.9536	21.9564	10443216.0
2012-08-03 13:00:00	AAPL	Stock	21.9568	22.0311	21.9532	22.0296	14758044.0
2012-08-03 13:30:00	AAPL	Stock	22.0296	22.0332	22.0046	22.0157	10674412.0
2012-08-03 14:00:00	AAPL	Stock	22.0127	22.0446	22.0104	22.0361	15224524.0
2012-08-03 14:30:00	AAPL	Stock	22.0346	22.0407	22.005	22.0071	13274156.0
2012-08-03 15:00:00	AAPL	Stock	22.0089	22.0364	22.0068	22.0225	14843948.0
2012-08-03 15:30:00	AAPL	Stock	22.0196	22.0229	21.9614	21.9875	47437656.0
2012-08-03 16:00:00	AAPL	Stock	21.9875	22.0271	21.9575	21.9893	8927128.0
2012-08-03 16:30:00	AAPL	Stock	21.9907	22.0339	21.9839	21.9857	685020.0
2012-08-03 17:00:00	AAPL	Stock	21.9857	21.9904	21.9857	21.9886	187740.0
2012-08-03 17:30:00	AAPL	Stock	21.9893	21.9907	21.9875	21.9893	75488.0
2012-08-03 18:00:00	AAPL	Stock	21.9882	21.9907	21.9882	21.9907	128828.0
2012-08-03 18:30:00	AAPL	Stock	21.9907	21.9907	21.9861	21.9861	45052.0
2012-08-03 19:00:00	AAPL	Stock	21.9896	21.99	21.9857	21.99	25256.0
2012-08-03 19:30:00	AAPL	Stock	21.9893	22.0018	21.9893	22.0	280700.0
2012-08-03 07:30:00	MSFT	Stock	29.33	29.33	29.33	29.33	100.0
2012-08-03 08:00:00	MSFT	Stock	29.28	29.3	29.28	29.3	2260.0
2012-08-03 08:30:00	MSFT	Stock	29.33	29.43	29.33	29.39	51329.0
2012-08-03 09:00:00	MSFT	Stock	29.39	29.55	29.37	29.53	105751.0
2012-08-03 09:30:00	MSFT	Stock	29.54	29.76	29.48	29.74	4244653.0
2012-08-03 10:00:00	MSFT	Stock	29.735	29.89	29.71	29.85	3866249.0
2012-08-03 10:30:00	MSFT	Stock	29.845	29.87	29.79	29.81	2203426.0
2012-08-03 11:00:00	MSFT	Stock	29.805	29.86	29.785	29.84	1869761.0
2012-08-03 11:30:00	MSFT	Stock	29.84	29.89	29.84	29.88	1790713.0
2012-08-03 12:00:00	MSFT	Stock	29.885	29.9	29.84	29.88	1284242.0
2012-08-03 12:30:00	MSFT	Stock	29.89	29.92	29.83	29.83	1644320.0
2012-08-03 13:00:00	MSFT	Stock	29.835	29.86	29.8	29.81	1271778.0
2012-08-03 13:30:00	MSFT	Stock	29.815	29.87	29.76	29.868	1669966.0
2012-08-03 14:00:00	MSFT	Stock	29.865	29.9	29.85	29.855	1365059.0
2012-08-03 14:30:00	MSFT	Stock	29.86	29.9	29.83	29.89	1511990.0
2012-08-03 15:00:00	MSFT	Stock	29.89	29.94	29.815	29.84	2508456.0
2012-08-03 15:30:00	MSFT	Stock	29.84	29.9	29.73	29.75	7608865.0
2012-08-03 16:00:00	MSFT	Stock	29.74	29.822	29.74	29.822	1887895.0

> showing 50 of 75,345 rows — these rows as CSV

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