PREVIEW / stock_30min / 2012-10-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-25.parquet
  size:    1.4 MB
  rows:    73,074
  symbols: 3,485

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-10-25 04:00:00	AAPL	Stock	22.0271	22.125	22.0271	22.125	105896.0
2012-10-25 04:30:00	AAPL	Stock	22.1246	22.1246	22.0929	22.0929	20216.0
2012-10-25 05:30:00	AAPL	Stock	22.1032	22.1161	22.0964	22.0964	109116.0
2012-10-25 06:30:00	AAPL	Stock	22.0929	22.1061	22.0929	22.1061	5768.0
2012-10-25 07:00:00	AAPL	Stock	22.0932	22.1161	22.0893	22.1161	358624.0
2012-10-25 07:30:00	AAPL	Stock	22.1329	22.175	22.1329	22.1546	404460.0
2012-10-25 08:00:00	AAPL	Stock	22.1429	22.1604	22.0929	22.1143	1115940.0
2012-10-25 08:30:00	AAPL	Stock	22.1179	22.1207	22.0764	22.1193	669704.0
2012-10-25 09:00:00	AAPL	Stock	22.1196	22.1607	22.1071	22.1396	1212624.0
2012-10-25 09:30:00	AAPL	Stock	22.1429	22.2143	21.9139	21.9382	68059124.0
2012-10-25 10:00:00	AAPL	Stock	21.9382	22.0639	21.8986	21.9918	38284708.0
2012-10-25 10:30:00	AAPL	Stock	21.995	22.0304	21.9107	21.9161	23816324.0
2012-10-25 11:00:00	AAPL	Stock	21.9107	22.0011	21.8775	21.9031	21410452.0
2012-10-25 11:30:00	AAPL	Stock	21.9029	21.9214	21.8054	21.8643	33403160.0
2012-10-25 12:00:00	AAPL	Stock	21.87	21.8871	21.7879	21.8257	27610100.0
2012-10-25 12:30:00	AAPL	Stock	21.8243	21.8393	21.6904	21.7971	47727988.0
2012-10-25 13:00:00	AAPL	Stock	21.7964	21.8732	21.7421	21.8729	29696884.0
2012-10-25 13:30:00	AAPL	Stock	21.8725	21.8846	21.8097	21.865	28331324.0
2012-10-25 14:00:00	AAPL	Stock	21.8675	21.91	21.7607	21.8718	37257332.0
2012-10-25 14:30:00	AAPL	Stock	21.8754	21.9018	21.7843	21.7964	32093964.0
2012-10-25 15:00:00	AAPL	Stock	21.7921	21.8271	21.6986	21.7045	47279960.0
2012-10-25 15:30:00	AAPL	Stock	21.7011	21.7804	21.6268	21.7732	92535268.0
2012-10-25 16:00:00	AAPL	Stock	21.7786	21.9912	21.7321	21.9029	21177380.0
2012-10-25 16:30:00	AAPL	Stock	21.9029	21.9029	20.8964	21.75	41971160.0
2012-10-25 17:00:00	AAPL	Stock	21.7486	21.8339	21.4282	21.6786	34019720.0
2012-10-25 17:30:00	AAPL	Stock	21.6786	21.7857	21.5714	21.7739	7559048.0
2012-10-25 18:00:00	AAPL	Stock	21.7857	21.8036	21.6614	21.7779	2753044.0
2012-10-25 18:30:00	AAPL	Stock	21.7679	21.7761	21.7414	21.7711	523236.0
2012-10-25 19:00:00	AAPL	Stock	21.7768	21.7843	21.7504	21.7596	833672.0
2012-10-25 19:30:00	AAPL	Stock	21.7507	21.7818	21.7504	21.7743	887180.0
2012-10-25 04:00:00	MSFT	Stock	27.9	27.9	27.9	27.9	500.0
2012-10-25 06:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	200.0
2012-10-25 07:00:00	MSFT	Stock	28.19	28.19	28.05	28.05	1000.0
2012-10-25 07:30:00	MSFT	Stock	28.08	28.1	28.08	28.09	2472.0
2012-10-25 08:00:00	MSFT	Stock	28.09	28.15	28.05	28.15	32356.0
2012-10-25 08:30:00	MSFT	Stock	28.15	28.18	28.1	28.15	37165.0
2012-10-25 09:00:00	MSFT	Stock	28.15	28.21	28.15	28.18	54272.0
2012-10-25 09:30:00	MSFT	Stock	28.19	28.2	27.955	27.98	5954141.0
2012-10-25 10:00:00	MSFT	Stock	27.98	28.07	27.935	28.01	3534440.0
2012-10-25 10:30:00	MSFT	Stock	28.01	28.01	27.89	27.9	3732964.0
2012-10-25 11:00:00	MSFT	Stock	27.905	27.96	27.86	27.907	2836947.0
2012-10-25 11:30:00	MSFT	Stock	27.91	27.96	27.875	27.915	3068705.0
2012-10-25 12:00:00	MSFT	Stock	27.915	27.94	27.86	27.89	2463800.0
2012-10-25 12:30:00	MSFT	Stock	27.895	27.98	27.86	27.972	2900569.0
2012-10-25 13:00:00	MSFT	Stock	27.98	28.01	27.93	27.985	2756996.0
2012-10-25 13:30:00	MSFT	Stock	27.985	28.0	27.91	27.94	1979359.0
2012-10-25 14:00:00	MSFT	Stock	27.94	27.95	27.88	27.925	2541396.0
2012-10-25 14:30:00	MSFT	Stock	27.93	28.02	27.92	27.99	2419673.0
2012-10-25 15:00:00	MSFT	Stock	28.0	28.03	27.88	27.92	5689460.0
2012-10-25 15:30:00	MSFT	Stock	27.93	27.95	27.86	27.89	8337510.0

> showing 50 of 73,074 rows — these rows as CSV

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