PREVIEW / stock_30min / 2013-06-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-12.parquet
  size:    1.5 MB
  rows:    78,906
  symbols: 3,494

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-06-12 05:30:00	AAPL	Stock	15.7043	15.7043	15.7043	15.7043	2800.0
2013-06-12 06:00:00	AAPL	Stock	15.7054	15.7054	15.6964	15.6964	11200.0
2013-06-12 06:30:00	AAPL	Stock	15.6964	15.7286	15.6964	15.7286	40572.0
2013-06-12 07:00:00	AAPL	Stock	15.7321	15.7446	15.7107	15.7225	135464.0
2013-06-12 07:30:00	AAPL	Stock	15.7143	15.7454	15.7	15.7232	111888.0
2013-06-12 08:00:00	AAPL	Stock	15.7271	15.7454	15.6429	15.7143	706468.0
2013-06-12 08:30:00	AAPL	Stock	15.7118	15.7221	15.6964	15.7221	436072.0
2013-06-12 09:00:00	AAPL	Stock	15.7221	15.7375	15.6911	15.6971	957936.0
2013-06-12 09:30:00	AAPL	Stock	15.6968	15.7589	15.6361	15.6479	40145952.0
2013-06-12 10:00:00	AAPL	Stock	15.6479	15.6511	15.5229	15.6015	38154060.0
2013-06-12 10:30:00	AAPL	Stock	15.6014	15.6071	15.5361	15.5379	15176448.0
2013-06-12 11:00:00	AAPL	Stock	15.5389	15.5811	15.5293	15.5607	13468504.0
2013-06-12 11:30:00	AAPL	Stock	15.5589	15.5854	15.4896	15.5029	17639244.0
2013-06-12 12:00:00	AAPL	Stock	15.5029	15.5357	15.4964	15.5139	12521852.0
2013-06-12 12:30:00	AAPL	Stock	15.5136	15.5614	15.5018	15.5511	10925544.0
2013-06-12 13:00:00	AAPL	Stock	15.555	15.5879	15.53	15.5729	9679712.0
2013-06-12 13:30:00	AAPL	Stock	15.5707	15.5754	15.535	15.5433	8334032.0
2013-06-12 14:00:00	AAPL	Stock	15.5432	15.5475	15.4904	15.5139	16019388.0
2013-06-12 14:30:00	AAPL	Stock	15.5086	15.5257	15.4896	15.5071	10301200.0
2013-06-12 15:00:00	AAPL	Stock	15.505	15.5071	15.4207	15.4309	23319044.0
2013-06-12 15:30:00	AAPL	Stock	15.435	15.4507	15.4107	15.4321	30946412.0
2013-06-12 16:00:00	AAPL	Stock	15.4343	15.5476	15.4143	15.4225	13435212.0
2013-06-12 16:30:00	AAPL	Stock	15.4236	15.6458	15.4193	15.6458	200508.0
2013-06-12 17:00:00	AAPL	Stock	15.425	15.4354	15.4193	15.4193	986496.0
2013-06-12 17:30:00	AAPL	Stock	15.4236	15.4236	15.4193	15.4193	92960.0
2013-06-12 18:00:00	AAPL	Stock	15.4193	15.425	15.4193	15.4225	57400.0
2013-06-12 18:30:00	AAPL	Stock	15.4196	15.4196	15.4179	15.4189	38780.0
2013-06-12 19:00:00	AAPL	Stock	15.4175	15.4196	15.4175	15.4196	6972.0
2013-06-12 19:30:00	AAPL	Stock	15.415	15.4214	15.4107	15.4161	139972.0
2013-06-12 08:00:00	MSFT	Stock	34.95	35.0	34.95	34.96	7384.0
2013-06-12 08:30:00	MSFT	Stock	34.99	34.99	34.99	34.99	700.0
2013-06-12 09:00:00	MSFT	Stock	34.99	35.13	34.91	35.13	41392.0
2013-06-12 09:30:00	MSFT	Stock	35.12	35.27	35.1	35.127	3431973.0
2013-06-12 10:00:00	MSFT	Stock	35.13	35.195	35.065	35.15	2930235.0
2013-06-12 10:30:00	MSFT	Stock	35.155	35.22	35.11	35.125	2476615.0
2013-06-12 11:00:00	MSFT	Stock	35.125	35.16	35.01	35.1	3311252.0
2013-06-12 11:30:00	MSFT	Stock	35.1	35.15	35.03	35.06	2794340.0
2013-06-12 12:00:00	MSFT	Stock	35.06	35.08	34.97	34.985	2363653.0
2013-06-12 12:30:00	MSFT	Stock	34.985	35.04	34.94	35.035	2041423.0
2013-06-12 13:00:00	MSFT	Stock	35.035	35.07	34.99	35.034	1644709.0
2013-06-12 13:30:00	MSFT	Stock	35.035	35.11	34.96	35.07	1530983.0
2013-06-12 14:00:00	MSFT	Stock	35.065	35.08	34.96	35.04	1544219.0
2013-06-12 14:30:00	MSFT	Stock	35.035	35.05	34.85	34.99	2332018.0
2013-06-12 15:00:00	MSFT	Stock	34.985	35.005	34.88	35.0	2601205.0
2013-06-12 15:30:00	MSFT	Stock	34.995	35.01	34.9	34.99	4476188.0
2013-06-12 16:00:00	MSFT	Stock	34.995	35.06	34.91	35.0	2228013.0
2013-06-12 16:30:00	MSFT	Stock	34.97	35.0	34.95	35.0	42498.0
2013-06-12 17:00:00	MSFT	Stock	34.95	35.0	34.93	35.0	7997.0
2013-06-12 17:30:00	MSFT	Stock	34.93	34.93	34.93	34.93	800.0
2013-06-12 18:00:00	MSFT	Stock	34.94	34.94	34.94	34.94	700.0

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

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