PREVIEW / stock_30min / 2013-10-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-22.parquet
  size:    1.6 MB
  rows:    83,988
  symbols: 3,552

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
2013-10-22 04:00:00	AAPL	Stock	18.75	18.75	18.7143	18.75	56000.0
2013-10-22 04:30:00	AAPL	Stock	18.72	18.72	18.72	18.72	2800.0
2013-10-22 05:00:00	AAPL	Stock	18.72	18.7232	18.72	18.7207	30800.0
2013-10-22 05:30:00	AAPL	Stock	18.7286	18.7404	18.7225	18.7404	45696.0
2013-10-22 06:00:00	AAPL	Stock	18.75	18.75	18.7061	18.7061	245672.0
2013-10-22 06:30:00	AAPL	Stock	18.7143	18.7643	18.7143	18.7643	131208.0
2013-10-22 07:00:00	AAPL	Stock	18.7843	18.8071	18.7607	18.7768	767480.0
2013-10-22 07:30:00	AAPL	Stock	18.7768	18.7857	18.7286	18.7496	701204.0
2013-10-22 08:00:00	AAPL	Stock	18.75	18.8589	18.7429	18.8518	2880388.0
2013-10-22 08:30:00	AAPL	Stock	18.8514	18.8871	18.8136	18.8214	2143624.0
2013-10-22 09:00:00	AAPL	Stock	18.8211	18.8796	18.7946	18.7996	2375884.0
2013-10-22 09:30:00	AAPL	Stock	18.8029	18.8732	18.6664	18.7174	73595452.0
2013-10-22 10:00:00	AAPL	Stock	18.7177	18.7711	18.7054	18.7376	27276312.0
2013-10-22 10:30:00	AAPL	Stock	18.7375	18.7893	18.1439	18.4836	74009908.0
2013-10-22 11:00:00	AAPL	Stock	18.4839	18.5614	18.3429	18.4404	47694808.0
2013-10-22 11:30:00	AAPL	Stock	18.4364	18.5932	18.3971	18.5732	23382548.0
2013-10-22 12:00:00	AAPL	Stock	18.5776	18.5821	18.485	18.5343	16388008.0
2013-10-22 12:30:00	AAPL	Stock	18.5339	18.5432	18.4114	18.4489	20182680.0
2013-10-22 13:00:00	AAPL	Stock	18.4468	18.5575	18.4432	18.4818	26854100.0
2013-10-22 13:30:00	AAPL	Stock	18.4821	18.5804	18.4682	18.5511	18178608.0
2013-10-22 14:00:00	AAPL	Stock	18.5529	18.6554	18.2464	18.3875	76717060.0
2013-10-22 14:30:00	AAPL	Stock	18.3911	18.5618	18.3743	18.4893	37035516.0
2013-10-22 15:00:00	AAPL	Stock	18.4882	18.6518	18.48	18.5746	27221824.0
2013-10-22 15:30:00	AAPL	Stock	18.5742	18.5943	18.5129	18.5668	31592988.0
2013-10-22 16:00:00	AAPL	Stock	18.5667	18.5982	18.5286	18.5893	18273220.0
2013-10-22 16:30:00	AAPL	Stock	18.5911	18.742	18.5188	18.742	454244.0
2013-10-22 17:00:00	AAPL	Stock	18.5939	18.7072	18.5585	18.5893	244692.0
2013-10-22 17:30:00	AAPL	Stock	18.5911	18.6393	18.59	18.6304	426636.0
2013-10-22 18:00:00	AAPL	Stock	18.6411	18.6421	18.6114	18.6114	196336.0
2013-10-22 18:30:00	AAPL	Stock	18.6129	18.6214	18.5654	18.6093	343112.0
2013-10-22 19:00:00	AAPL	Stock	18.6075	18.625	18.6	18.6	111384.0
2013-10-22 19:30:00	AAPL	Stock	18.6071	18.6075	18.5986	18.6071	130424.0
2013-10-22 08:00:00	MSFT	Stock	34.98	34.98	34.98	34.98	1795.0
2013-10-22 08:30:00	MSFT	Stock	35.18	35.19	35.13	35.14	11448.0
2013-10-22 09:00:00	MSFT	Stock	35.14	35.14	35.01	35.01	15892.0
2013-10-22 09:30:00	MSFT	Stock	35.01	35.1	34.715	34.93	4568247.0
2013-10-22 10:00:00	MSFT	Stock	34.93	34.99	34.9	34.95	2234285.0
2013-10-22 10:30:00	MSFT	Stock	34.945	34.96	34.69	34.885	4641131.0
2013-10-22 11:00:00	MSFT	Stock	34.89	34.95	34.73	34.74	2650458.0
2013-10-22 11:30:00	MSFT	Stock	34.73	34.85	34.69	34.83	2300489.0
2013-10-22 12:00:00	MSFT	Stock	34.83	34.85	34.755	34.791	1060573.0
2013-10-22 12:30:00	MSFT	Stock	34.79	34.81	34.75	34.784	1086144.0
2013-10-22 13:00:00	MSFT	Stock	34.78	34.83	34.57	34.63	2164577.0
2013-10-22 13:30:00	MSFT	Stock	34.64	34.74	34.59	34.666	1821274.0
2013-10-22 14:00:00	MSFT	Stock	34.67	34.71	34.65	34.68	1242769.0
2013-10-22 14:30:00	MSFT	Stock	34.689	34.69	34.58	34.6	3269431.0
2013-10-22 15:00:00	MSFT	Stock	34.6	34.65	34.58	34.625	2425286.0
2013-10-22 15:30:00	MSFT	Stock	34.62	34.635	34.52	34.57	5129972.0
2013-10-22 16:00:00	MSFT	Stock	34.58	34.791	34.55	34.587	3179835.0
2013-10-22 16:30:00	MSFT	Stock	34.59	34.854	34.58	34.59	59575.0

> showing 50 of 83,988 rows — these rows as CSV

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