PREVIEW / stock_30min / 2012-05-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-15.parquet
  size:    1.4 MB
  rows:    75,633
  symbols: 3,537

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-05-15 04:00:00	AAPL	Stock	20.0521	20.0714	20.0471	20.0636	37128.0
2012-05-15 04:30:00	AAPL	Stock	20.105	20.105	20.0536	20.0714	58800.0
2012-05-15 05:00:00	AAPL	Stock	20.0714	20.0714	20.0714	20.0714	2800.0
2012-05-15 05:30:00	AAPL	Stock	20.0714	20.0714	20.0643	20.0714	25816.0
2012-05-15 06:00:00	AAPL	Stock	20.0696	20.1143	20.0696	20.1071	62468.0
2012-05-15 06:30:00	AAPL	Stock	20.0839	20.0893	20.0839	20.0893	5600.0
2012-05-15 07:00:00	AAPL	Stock	20.0807	20.0807	20.0282	20.0457	203868.0
2012-05-15 07:30:00	AAPL	Stock	20.0707	20.125	20.0707	20.125	409192.0
2012-05-15 08:00:00	AAPL	Stock	20.1204	20.1357	20.0536	20.0936	1252328.0
2012-05-15 08:30:00	AAPL	Stock	20.0982	20.1346	20.0454	20.0454	1935500.0
2012-05-15 09:00:00	AAPL	Stock	20.0457	20.0593	19.9843	20.0529	4641084.0
2012-05-15 09:30:00	AAPL	Stock	20.0518	20.0643	19.8839	19.9568	68892264.0
2012-05-15 10:00:00	AAPL	Stock	19.9561	20.1025	19.8936	20.1025	56895524.0
2012-05-15 10:30:00	AAPL	Stock	20.0982	20.1021	19.9868	20.0005	35085540.0
2012-05-15 11:00:00	AAPL	Stock	20.0018	20.01	19.9475	19.9921	20661648.0
2012-05-15 11:30:00	AAPL	Stock	19.9925	20.1021	19.9925	20.0507	25468184.0
2012-05-15 12:00:00	AAPL	Stock	20.0489	20.115	20.0429	20.1007	22638504.0
2012-05-15 12:30:00	AAPL	Stock	20.0971	20.1139	20.0171	20.0403	14849688.0
2012-05-15 13:00:00	AAPL	Stock	20.0389	20.0857	20.0368	20.0707	9360512.0
2012-05-15 13:30:00	AAPL	Stock	20.0711	20.0711	19.9643	19.9946	17161172.0
2012-05-15 14:00:00	AAPL	Stock	19.9993	20.045	19.9697	20.0282	14759388.0
2012-05-15 14:30:00	AAPL	Stock	20.0293	20.0336	19.9382	19.9461	14460656.0
2012-05-15 15:00:00	AAPL	Stock	19.9379	19.9411	19.7657	19.7879	58516360.0
2012-05-15 15:30:00	AAPL	Stock	19.7914	19.8139	19.7054	19.7532	64981028.0
2012-05-15 16:00:00	AAPL	Stock	19.7539	20.0689	19.7389	19.7482	33373844.0
2012-05-15 16:30:00	AAPL	Stock	19.745	19.8012	19.7446	19.7568	421176.0
2012-05-15 17:00:00	AAPL	Stock	19.7521	19.7554	19.7464	19.755	139748.0
2012-05-15 17:30:00	AAPL	Stock	19.7511	19.755	19.7429	19.7496	119896.0
2012-05-15 18:00:00	AAPL	Stock	19.7464	19.7829	19.7457	19.7771	216216.0
2012-05-15 18:30:00	AAPL	Stock	19.7768	19.7911	19.7768	19.7911	192220.0
2012-05-15 19:00:00	AAPL	Stock	19.7857	19.7914	19.7857	19.7857	53480.0
2012-05-15 19:30:00	AAPL	Stock	19.7786	19.7979	19.75	19.7979	258916.0
2012-05-15 06:00:00	MSFT	Stock	30.92	30.92	30.92	30.92	100.0
2012-05-15 06:30:00	MSFT	Stock	30.89	30.89	30.88	30.88	200.0
2012-05-15 07:00:00	MSFT	Stock	30.8	30.8	30.79	30.79	2268.0
2012-05-15 07:30:00	MSFT	Stock	30.79	30.8	30.77	30.78	8832.0
2012-05-15 08:00:00	MSFT	Stock	30.73	30.78	30.72	30.75	10765.0
2012-05-15 08:30:00	MSFT	Stock	30.79	30.82	30.7	30.7	7546.0
2012-05-15 09:00:00	MSFT	Stock	30.69	30.73	30.56	30.68	32179.0
2012-05-15 09:30:00	MSFT	Stock	30.62	30.77	30.58	30.72	3523906.0
2012-05-15 10:00:00	MSFT	Stock	30.72	30.77	30.54	30.61	4562536.0
2012-05-15 10:30:00	MSFT	Stock	30.61	30.71	30.54	30.685	3296754.0
2012-05-15 11:00:00	MSFT	Stock	30.69	30.69	30.45	30.467	2551943.0
2012-05-15 11:30:00	MSFT	Stock	30.46	30.795	30.45	30.77	2611046.0
2012-05-15 12:00:00	MSFT	Stock	30.775	30.78	30.68	30.746	2792141.0
2012-05-15 12:30:00	MSFT	Stock	30.75	30.77	30.63	30.642	1444257.0
2012-05-15 13:00:00	MSFT	Stock	30.65	30.665	30.58	30.633	1460545.0
2012-05-15 13:30:00	MSFT	Stock	30.63	30.635	30.465	30.52	2621161.0
2012-05-15 14:00:00	MSFT	Stock	30.52	30.66	30.51	30.62	1742341.0
2012-05-15 14:30:00	MSFT	Stock	30.615	30.7	30.47	30.48	2523073.0

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

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