PREVIEW / stock_30min / 2012-04-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-26.parquet
  size:    1.4 MB
  rows:    75,293
  symbols: 3,533

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-04-26 04:00:00	AAPL	Stock	21.8932	21.9554	21.8857	21.9554	80444.0
2012-04-26 04:30:00	AAPL	Stock	21.8664	21.8857	21.8593	21.8629	25200.0
2012-04-26 05:00:00	AAPL	Stock	21.8661	21.8982	21.8629	21.8982	21000.0
2012-04-26 05:30:00	AAPL	Stock	21.8675	21.8675	21.8393	21.8571	95200.0
2012-04-26 06:00:00	AAPL	Stock	21.8411	21.8568	21.835	21.8568	18200.0
2012-04-26 06:30:00	AAPL	Stock	21.8257	21.8257	21.7857	21.8054	42812.0
2012-04-26 07:00:00	AAPL	Stock	21.8071	21.8579	21.7857	21.8482	236992.0
2012-04-26 07:30:00	AAPL	Stock	21.8425	21.8568	21.8329	21.8482	109368.0
2012-04-26 08:00:00	AAPL	Stock	21.8518	21.9082	21.7982	21.8696	2296000.0
2012-04-26 08:30:00	AAPL	Stock	21.8696	21.9082	21.8436	21.9036	3158512.0
2012-04-26 09:00:00	AAPL	Stock	21.8989	21.9557	21.8736	21.9507	3527188.0
2012-04-26 09:30:00	AAPL	Stock	21.9382	21.9532	21.6968	21.7125	85130304.0
2012-04-26 10:00:00	AAPL	Stock	21.7139	21.7925	21.7114	21.7114	41116572.0
2012-04-26 10:30:00	AAPL	Stock	21.7139	21.7414	21.5575	21.5982	55502776.0
2012-04-26 11:00:00	AAPL	Stock	21.6007	21.66	21.5046	21.6536	56906556.0
2012-04-26 11:30:00	AAPL	Stock	21.6579	21.6586	21.5629	21.5875	22150296.0
2012-04-26 12:00:00	AAPL	Stock	21.59	21.6175	21.5596	21.5936	14876148.0
2012-04-26 12:30:00	AAPL	Stock	21.5936	21.6068	21.5504	21.5671	14629384.0
2012-04-26 13:00:00	AAPL	Stock	21.5632	21.6511	21.5539	21.6407	24023860.0
2012-04-26 13:30:00	AAPL	Stock	21.6407	21.7071	21.6385	21.6861	29719312.0
2012-04-26 14:00:00	AAPL	Stock	21.685	21.7107	21.6461	21.7077	21717080.0
2012-04-26 14:30:00	AAPL	Stock	21.7096	21.7836	21.7025	21.7768	41558916.0
2012-04-26 15:00:00	AAPL	Stock	21.7783	21.8	21.75	21.7586	37004576.0
2012-04-26 15:30:00	AAPL	Stock	21.7589	21.7636	21.6589	21.7043	50052688.0
2012-04-26 16:00:00	AAPL	Stock	21.6939	21.7079	21.6697	21.7036	16142028.0
2012-04-26 16:30:00	AAPL	Stock	21.6929	21.755	21.6929	21.7146	1996512.0
2012-04-26 17:00:00	AAPL	Stock	21.7143	21.7221	21.6232	21.6429	1078084.0
2012-04-26 17:30:00	AAPL	Stock	21.6354	21.6568	21.6354	21.6429	251076.0
2012-04-26 18:00:00	AAPL	Stock	21.6375	21.6429	21.6143	21.6179	619444.0
2012-04-26 18:30:00	AAPL	Stock	21.6143	21.6314	21.6	21.6286	106372.0
2012-04-26 19:00:00	AAPL	Stock	21.635	21.6411	21.6179	21.6196	145068.0
2012-04-26 19:30:00	AAPL	Stock	21.6179	21.6214	21.5893	21.5893	312872.0
2012-04-26 08:00:00	MSFT	Stock	32.21	32.21	32.17	32.17	2200.0
2012-04-26 08:30:00	MSFT	Stock	32.18	32.23	32.11	32.13	3269.0
2012-04-26 09:00:00	MSFT	Stock	32.12	32.12	32.06	32.1	3600.0
2012-04-26 09:30:00	MSFT	Stock	32.08	32.17	32.03	32.09	3898784.0
2012-04-26 10:00:00	MSFT	Stock	32.1	32.15	32.04	32.07	2789220.0
2012-04-26 10:30:00	MSFT	Stock	32.065	32.07	31.92	31.945	2951635.0
2012-04-26 11:00:00	MSFT	Stock	31.95	32.115	31.935	31.99	2296632.0
2012-04-26 11:30:00	MSFT	Stock	31.99	32.01	31.96	32.0	1982817.0
2012-04-26 12:00:00	MSFT	Stock	32.0	32.03	31.96	31.99	1687471.0
2012-04-26 12:30:00	MSFT	Stock	31.99	32.01	31.97	31.99	1586912.0
2012-04-26 13:00:00	MSFT	Stock	31.99	32.04	31.97	32.03	1894176.0
2012-04-26 13:30:00	MSFT	Stock	32.021	32.11	32.0	32.098	2690385.0
2012-04-26 14:00:00	MSFT	Stock	32.1	32.19	32.08	32.19	2748040.0
2012-04-26 14:30:00	MSFT	Stock	32.19	32.23	32.15	32.2	3470673.0
2012-04-26 15:00:00	MSFT	Stock	32.2	32.23	32.14	32.15	3425196.0
2012-04-26 15:30:00	MSFT	Stock	32.15	32.19	32.04	32.12	6295698.0
2012-04-26 16:00:00	MSFT	Stock	32.11	32.13	32.075	32.11	1872136.0
2012-04-26 16:30:00	MSFT	Stock	32.11	32.23	32.09	32.09	62482.0

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

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