PREVIEW / stock_30min / 2013-04-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-15.parquet
  size:    1.5 MB
  rows:    79,468
  symbols: 3,500

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-04-15 05:00:00	AAPL	Stock	15.2889	15.2889	15.2889	15.2889	5600.0
2013-04-15 06:00:00	AAPL	Stock	15.25	15.25	15.2486	15.2486	11200.0
2013-04-15 06:30:00	AAPL	Stock	15.2493	15.2546	15.2493	15.2546	9408.0
2013-04-15 07:00:00	AAPL	Stock	15.2507	15.2639	15.2321	15.2386	93072.0
2013-04-15 07:30:00	AAPL	Stock	15.2371	15.25	15.2368	15.25	157976.0
2013-04-15 08:00:00	AAPL	Stock	15.2629	15.3214	15.2386	15.2518	371420.0
2013-04-15 08:30:00	AAPL	Stock	15.2729	15.275	15.2536	15.2589	209300.0
2013-04-15 09:00:00	AAPL	Stock	15.2536	15.2571	15.2257	15.2421	332304.0
2013-04-15 09:30:00	AAPL	Stock	15.2425	15.2818	15.1964	15.2375	40371688.0
2013-04-15 10:00:00	AAPL	Stock	15.2361	15.2407	15.1486	15.1641	28406840.0
2013-04-15 10:30:00	AAPL	Stock	15.1625	15.2446	15.1321	15.1839	23439724.0
2013-04-15 11:00:00	AAPL	Stock	15.1807	15.1807	15.1339	15.1564	19767160.0
2013-04-15 11:30:00	AAPL	Stock	15.1581	15.1839	15.1329	15.1389	12004496.0
2013-04-15 12:00:00	AAPL	Stock	15.1425	15.1479	15.1054	15.1221	13989528.0
2013-04-15 12:30:00	AAPL	Stock	15.1218	15.1232	15.0768	15.0896	16180052.0
2013-04-15 13:00:00	AAPL	Stock	15.0904	15.1096	15.0725	15.1018	8337056.0
2013-04-15 13:30:00	AAPL	Stock	15.1007	15.1125	15.0732	15.0818	6928096.0
2013-04-15 14:00:00	AAPL	Stock	15.0821	15.0821	15.0339	15.0598	17190180.0
2013-04-15 14:30:00	AAPL	Stock	15.0612	15.1032	15.0271	15.0386	20670944.0
2013-04-15 15:00:00	AAPL	Stock	15.0383	15.06	15.0029	15.0272	23205560.0
2013-04-15 15:30:00	AAPL	Stock	15.0314	15.0532	14.9839	14.995	47492284.0
2013-04-15 16:00:00	AAPL	Stock	14.9946	15.114	14.9796	14.9921	32622408.0
2013-04-15 16:30:00	AAPL	Stock	14.9893	15.159	14.9504	14.9643	1253476.0
2013-04-15 17:00:00	AAPL	Stock	14.9646	15.2337	14.9625	14.9946	233380.0
2013-04-15 17:30:00	AAPL	Stock	14.97	14.9782	14.9696	14.9732	181776.0
2013-04-15 18:00:00	AAPL	Stock	14.9732	14.9871	14.9725	14.9871	283948.0
2013-04-15 18:30:00	AAPL	Stock	14.9857	14.995	14.9857	14.9946	218876.0
2013-04-15 19:00:00	AAPL	Stock	14.995	14.9982	14.9896	14.9982	79604.0
2013-04-15 19:30:00	AAPL	Stock	15.0	15.0232	14.9996	15.0179	308112.0
2013-04-15 05:30:00	MSFT	Stock	28.55	28.55	28.55	28.55	200.0
2013-04-15 07:30:00	MSFT	Stock	28.61	28.61	28.6	28.6	2100.0
2013-04-15 08:00:00	MSFT	Stock	28.61	28.75	28.6	28.69	3663.0
2013-04-15 08:30:00	MSFT	Stock	28.65	28.7	28.65	28.67	8044.0
2013-04-15 09:00:00	MSFT	Stock	28.7	28.72	28.6	28.63	45250.0
2013-04-15 09:30:00	MSFT	Stock	28.63	28.79	28.51	28.78	7593579.0
2013-04-15 10:00:00	MSFT	Stock	28.78	28.97	28.68	28.865	4829831.0
2013-04-15 10:30:00	MSFT	Stock	28.865	28.96	28.84	28.87	3001354.0
2013-04-15 11:00:00	MSFT	Stock	28.865	28.95	28.83	28.934	2112030.0
2013-04-15 11:30:00	MSFT	Stock	28.935	28.98	28.83	28.86	2119117.0
2013-04-15 12:00:00	MSFT	Stock	28.855	28.89	28.79	28.85	2867944.0
2013-04-15 12:30:00	MSFT	Stock	28.85	28.88	28.78	28.85	3449461.0
2013-04-15 13:00:00	MSFT	Stock	28.85	28.9	28.83	28.897	2041655.0
2013-04-15 13:30:00	MSFT	Stock	28.9	28.9	28.84	28.855	1866627.0
2013-04-15 14:00:00	MSFT	Stock	28.85	28.86	28.78	28.816	3276241.0
2013-04-15 14:30:00	MSFT	Stock	28.813	28.91	28.7	28.725	3594852.0
2013-04-15 15:00:00	MSFT	Stock	28.725	28.79	28.62	28.705	6415679.0
2013-04-15 15:30:00	MSFT	Stock	28.705	28.76	28.63	28.68	9624514.0
2013-04-15 16:00:00	MSFT	Stock	28.68	28.86	28.63	28.86	2942274.0
2013-04-15 16:30:00	MSFT	Stock	28.63	28.7	28.56	28.6	179414.0
2013-04-15 17:00:00	MSFT	Stock	28.59	28.69	28.57	28.69	8172.0

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

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