PREVIEW / stock_30min / 2011-06-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-13.parquet
  size:    1.4 MB
  rows:    78,591
  symbols: 3,567

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
2011-06-13 05:00:00	AAPL	Stock	11.6393	11.6393	11.6393	11.6393	2800.0
2011-06-13 05:30:00	AAPL	Stock	11.6389	11.6389	11.6389	11.6389	2800.0
2011-06-13 06:00:00	AAPL	Stock	11.6696	11.6696	11.6696	11.6696	4200.0
2011-06-13 06:30:00	AAPL	Stock	11.6782	11.6782	11.6782	11.6782	25760.0
2011-06-13 07:00:00	AAPL	Stock	11.6696	11.6929	11.6696	11.6893	131880.0
2011-06-13 07:30:00	AAPL	Stock	11.6946	11.6946	11.6786	11.6889	187320.0
2011-06-13 08:00:00	AAPL	Stock	11.68	11.7011	11.6786	11.7007	627032.0
2011-06-13 08:30:00	AAPL	Stock	11.6989	11.7036	11.6914	11.6964	308140.0
2011-06-13 09:00:00	AAPL	Stock	11.6986	11.6986	11.6746	11.6839	700168.0
2011-06-13 09:30:00	AAPL	Stock	11.6843	11.6954	11.6096	11.678	62229468.0
2011-06-13 10:00:00	AAPL	Stock	11.675	11.7125	11.6371	11.7032	34944140.0
2011-06-13 10:30:00	AAPL	Stock	11.7019	11.7064	11.6557	11.6696	21230832.0
2011-06-13 11:00:00	AAPL	Stock	11.6671	11.6893	11.6482	11.6793	11217808.0
2011-06-13 11:30:00	AAPL	Stock	11.6786	11.69	11.6371	11.6471	16485252.0
2011-06-13 12:00:00	AAPL	Stock	11.6493	11.675	11.6396	11.6454	13553456.0
2011-06-13 12:30:00	AAPL	Stock	11.6496	11.6679	11.6344	11.6461	12249384.0
2011-06-13 13:00:00	AAPL	Stock	11.6464	11.6729	11.6214	11.6614	21880824.0
2011-06-13 13:30:00	AAPL	Stock	11.6604	11.7032	11.6571	11.6986	19854100.0
2011-06-13 14:00:00	AAPL	Stock	11.6968	11.7193	11.6796	11.7086	22134084.0
2011-06-13 14:30:00	AAPL	Stock	11.7093	11.7254	11.6654	11.6971	27334132.0
2011-06-13 15:00:00	AAPL	Stock	11.6971	11.7082	11.67	11.6825	17818976.0
2011-06-13 15:30:00	AAPL	Stock	11.684	11.684	11.6386	11.6639	31154340.0
2011-06-13 16:00:00	AAPL	Stock	11.6646	11.67	11.6625	11.6632	7172256.0
2011-06-13 16:30:00	AAPL	Stock	11.6646	11.6833	11.6625	11.6671	109704.0
2011-06-13 17:00:00	AAPL	Stock	11.6643	11.6679	11.6607	11.6607	307664.0
2011-06-13 17:30:00	AAPL	Stock	11.6614	11.6625	11.6614	11.6625	25200.0
2011-06-13 18:00:00	AAPL	Stock	11.6607	11.6643	11.6582	11.6621	40320.0
2011-06-13 18:30:00	AAPL	Stock	11.6621	11.6714	11.6621	11.6714	44268.0
2011-06-13 19:00:00	AAPL	Stock	11.6768	11.6775	11.6704	11.6704	42084.0
2011-06-13 19:30:00	AAPL	Stock	11.675	11.6779	11.6714	11.6779	89516.0
2011-06-13 07:00:00	MSFT	Stock	23.8	23.83	23.8	23.83	900.0
2011-06-13 07:30:00	MSFT	Stock	23.75	23.75	23.74	23.75	1400.0
2011-06-13 08:00:00	MSFT	Stock	23.71	23.8	23.71	23.8	9200.0
2011-06-13 08:30:00	MSFT	Stock	23.78	23.8	23.78	23.8	6385.0
2011-06-13 09:00:00	MSFT	Stock	23.8	23.82	23.77	23.79	41637.0
2011-06-13 09:30:00	MSFT	Stock	23.79	23.83	23.7	23.82	3687856.0
2011-06-13 10:00:00	MSFT	Stock	23.82	24.0	23.815	23.941	3629570.0
2011-06-13 10:30:00	MSFT	Stock	23.948	23.96	23.88	23.891	2126103.0
2011-06-13 11:00:00	MSFT	Stock	23.9	23.99	23.88	23.951	2526441.0
2011-06-13 11:30:00	MSFT	Stock	23.955	24.0	23.91	23.94	2796542.0
2011-06-13 12:00:00	MSFT	Stock	23.94	23.97	23.91	23.92	2122674.0
2011-06-13 12:30:00	MSFT	Stock	23.91	23.96	23.88	23.94	1532570.0
2011-06-13 13:00:00	MSFT	Stock	23.95	23.99	23.89	23.97	2149620.0
2011-06-13 13:30:00	MSFT	Stock	23.972	24.05	23.96	24.04	2367972.0
2011-06-13 14:00:00	MSFT	Stock	24.04	24.15	24.04	24.14	4130017.0
2011-06-13 14:30:00	MSFT	Stock	24.13	24.19	24.1	24.12	4015968.0
2011-06-13 15:00:00	MSFT	Stock	24.12	24.16	24.02	24.155	4639174.0
2011-06-13 15:30:00	MSFT	Stock	24.15	24.158	23.99	24.03	7643827.0
2011-06-13 16:00:00	MSFT	Stock	24.03	24.063	23.98	24.04	3597458.0
2011-06-13 16:30:00	MSFT	Stock	24.06	24.152	24.06	24.06	14922.0

> showing 50 of 78,591 rows — these rows as CSV

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