PREVIEW / stock_30min / 2014-04-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-17.parquet
  size:    1.5 MB
  rows:    80,700
  symbols: 3,540

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-17 04:30:00	AAPL	Stock	18.4575	18.4575	18.4575	18.4575	5600.0
2014-04-17 07:00:00	AAPL	Stock	18.4571	18.4571	18.4571	18.4571	3024.0
2014-04-17 07:30:00	AAPL	Stock	18.4861	18.5218	18.4861	18.5218	75600.0
2014-04-17 08:00:00	AAPL	Stock	18.4571	18.6089	18.4571	18.6071	525336.0
2014-04-17 08:30:00	AAPL	Stock	18.6071	18.6429	18.5979	18.6271	527296.0
2014-04-17 09:00:00	AAPL	Stock	18.6286	18.6418	18.5468	18.5893	1159788.0
2014-04-17 09:30:00	AAPL	Stock	18.5714	18.6129	18.5429	18.5768	39730348.0
2014-04-17 10:00:00	AAPL	Stock	18.5764	18.6279	18.57	18.6054	17366020.0
2014-04-17 10:30:00	AAPL	Stock	18.6032	18.6475	18.5907	18.6475	16769200.0
2014-04-17 11:00:00	AAPL	Stock	18.6471	18.6946	18.6418	18.6921	16133628.0
2014-04-17 11:30:00	AAPL	Stock	18.6949	18.7071	18.6607	18.7029	13637596.0
2014-04-17 12:00:00	AAPL	Stock	18.7	18.7303	18.6946	18.7182	13482224.0
2014-04-17 12:30:00	AAPL	Stock	18.7164	18.7489	18.7143	18.7364	9892708.0
2014-04-17 13:00:00	AAPL	Stock	18.7361	18.7796	18.7229	18.775	12281864.0
2014-04-17 13:30:00	AAPL	Stock	18.775	18.8314	18.7675	18.8118	16365244.0
2014-04-17 14:00:00	AAPL	Stock	18.8107	18.8486	18.7875	18.8421	13935516.0
2014-04-17 14:30:00	AAPL	Stock	18.8429	18.845	18.8071	18.8082	9510956.0
2014-04-17 15:00:00	AAPL	Stock	18.8079	18.8082	18.7696	18.7739	12877088.0
2014-04-17 15:30:00	AAPL	Stock	18.7718	18.7746	18.735	18.7496	30353932.0
2014-04-17 16:00:00	AAPL	Stock	18.7479	18.7632	18.6965	18.7518	10266172.0
2014-04-17 16:30:00	AAPL	Stock	18.7536	18.7536	18.5361	18.7536	1161272.0
2014-04-17 17:00:00	AAPL	Stock	18.75	18.7554	18.7464	18.755	320404.0
2014-04-17 17:30:00	AAPL	Stock	18.7486	18.7486	18.7307	18.7346	65240.0
2014-04-17 18:00:00	AAPL	Stock	18.7418	18.7496	18.7418	18.7496	270592.0
2014-04-17 18:30:00	AAPL	Stock	18.7493	18.7493	18.7379	18.7379	22120.0
2014-04-17 19:00:00	AAPL	Stock	18.7464	18.7464	18.7464	18.7464	8400.0
2014-04-17 19:30:00	AAPL	Stock	18.7482	18.7525	18.7482	18.75	20692.0
2014-04-17 07:30:00	MSFT	Stock	40.22	40.22	40.22	40.22	1200.0
2014-04-17 08:00:00	MSFT	Stock	40.24	40.24	40.2	40.2	1954.0
2014-04-17 08:30:00	MSFT	Stock	40.22	40.23	40.11	40.11	10074.0
2014-04-17 09:00:00	MSFT	Stock	40.19	40.19	39.98	40.03	149684.0
2014-04-17 09:30:00	MSFT	Stock	40.01	40.1	39.63	39.7	7578756.0
2014-04-17 10:00:00	MSFT	Stock	39.7	39.85	39.51	39.78	3323497.0
2014-04-17 10:30:00	MSFT	Stock	39.78	39.86	39.61	39.77	1921668.0
2014-04-17 11:00:00	MSFT	Stock	39.76	39.81	39.729	39.79	1247926.0
2014-04-17 11:30:00	MSFT	Stock	39.795	39.85	39.76	39.832	940509.0
2014-04-17 12:00:00	MSFT	Stock	39.835	39.91	39.81	39.91	1389845.0
2014-04-17 12:30:00	MSFT	Stock	39.909	40.0	39.87	39.999	1411082.0
2014-04-17 13:00:00	MSFT	Stock	40.0	40.08	39.984	40.08	1181557.0
2014-04-17 13:30:00	MSFT	Stock	40.08	40.12	40.05	40.1	1511010.0
2014-04-17 14:00:00	MSFT	Stock	40.1	40.11	40.02	40.09	1012690.0
2014-04-17 14:30:00	MSFT	Stock	40.08	40.12	40.04	40.08	937408.0
2014-04-17 15:00:00	MSFT	Stock	40.08	40.195	40.07	40.185	1633039.0
2014-04-17 15:30:00	MSFT	Stock	40.18	40.185	40.01	40.01	6248505.0
2014-04-17 16:00:00	MSFT	Stock	40.01	40.105	39.937	40.105	2864829.0
2014-04-17 16:30:00	MSFT	Stock	40.05	40.4	40.005	40.4	67278.0
2014-04-17 17:00:00	MSFT	Stock	40.01	40.03	40.01	40.03	79399.0
2014-04-17 18:00:00	MSFT	Stock	40.03	40.03	40.03	40.03	400.0
2014-04-17 19:00:00	MSFT	Stock	40.16	40.16	40.16	40.16	500.0
2014-04-17 19:30:00	MSFT	Stock	40.03	40.04	40.03	40.04	500.0

> showing 50 of 80,700 rows — these rows as CSV

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