PREVIEW / stock_30min / 2014-02-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-04.parquet
  size:    1.6 MB
  rows:    83,490
  symbols: 3,536

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
2014-02-04 04:00:00	AAPL	Stock	17.9629	17.9629	17.9464	17.9464	8400.0
2014-02-04 05:30:00	AAPL	Stock	17.9286	17.9286	17.9286	17.9286	2800.0
2014-02-04 06:00:00	AAPL	Stock	17.9289	17.9454	17.9232	17.9375	50400.0
2014-02-04 06:30:00	AAPL	Stock	17.9439	17.9532	17.9439	17.9439	70140.0
2014-02-04 07:00:00	AAPL	Stock	17.9714	18.0193	17.9632	18.0	164472.0
2014-02-04 07:30:00	AAPL	Stock	17.9964	18.0086	17.9761	18.0032	296184.0
2014-02-04 08:00:00	AAPL	Stock	18.0054	18.0579	17.9379	18.0571	1164212.0
2014-02-04 08:30:00	AAPL	Stock	18.0464	18.1286	18.0304	18.1189	1440488.0
2014-02-04 09:00:00	AAPL	Stock	18.1082	18.1196	18.0536	18.0679	921396.0
2014-02-04 09:30:00	AAPL	Stock	18.0686	18.1207	17.9557	18.1089	59134936.0
2014-02-04 10:00:00	AAPL	Stock	18.1132	18.1311	18.0086	18.0407	29025388.0
2014-02-04 10:30:00	AAPL	Stock	18.0407	18.0707	18.0146	18.0396	19011580.0
2014-02-04 11:00:00	AAPL	Stock	18.045	18.1539	18.0314	18.1346	30564184.0
2014-02-04 11:30:00	AAPL	Stock	18.1346	18.1864	18.1125	18.1861	18643212.0
2014-02-04 12:00:00	AAPL	Stock	18.1857	18.195	18.1507	18.1804	13743688.0
2014-02-04 12:30:00	AAPL	Stock	18.1786	18.1904	18.1654	18.1764	8301048.0
2014-02-04 13:00:00	AAPL	Stock	18.1771	18.1929	18.1439	18.1564	10849804.0
2014-02-04 13:30:00	AAPL	Stock	18.1546	18.1811	18.1159	18.125	11543168.0
2014-02-04 14:00:00	AAPL	Stock	18.1266	18.1696	18.1093	18.1564	9734816.0
2014-02-04 14:30:00	AAPL	Stock	18.1561	18.1764	18.1404	18.1746	8491616.0
2014-02-04 15:00:00	AAPL	Stock	18.1729	18.1814	18.112	18.1216	13110356.0
2014-02-04 15:30:00	AAPL	Stock	18.1199	18.1764	18.1114	18.1711	25572092.0
2014-02-04 16:00:00	AAPL	Stock	18.1711	18.1714	18.1129	18.1429	16066624.0
2014-02-04 16:30:00	AAPL	Stock	18.1747	18.1747	18.047	18.1504	272216.0
2014-02-04 17:00:00	AAPL	Stock	18.1554	18.1589	18.1429	18.1439	58240.0
2014-02-04 17:30:00	AAPL	Stock	18.1432	18.1457	18.1432	18.1446	41328.0
2014-02-04 18:00:00	AAPL	Stock	18.1514	18.1514	18.1439	18.1439	39200.0
2014-02-04 18:30:00	AAPL	Stock	18.1446	18.145	18.1446	18.145	22400.0
2014-02-04 19:00:00	AAPL	Stock	18.1514	18.1514	18.1429	18.1429	105532.0
2014-02-04 19:30:00	AAPL	Stock	18.145	18.1554	18.1375	18.15	83384.0
2014-02-04 05:30:00	MSFT	Stock	36.42	36.42	36.42	36.42	100.0
2014-02-04 07:30:00	MSFT	Stock	36.46	36.46	36.46	36.46	300.0
2014-02-04 08:00:00	MSFT	Stock	36.5	36.74	36.5	36.74	13839.0
2014-02-04 08:30:00	MSFT	Stock	36.73	36.74	36.64	36.7	5400.0
2014-02-04 09:00:00	MSFT	Stock	36.74	37.44	36.51	36.99	632481.0
2014-02-04 09:30:00	MSFT	Stock	36.99	37.189	36.67	36.8	9920103.0
2014-02-04 10:00:00	MSFT	Stock	36.8	36.85	36.441	36.441	5021525.0
2014-02-04 10:30:00	MSFT	Stock	36.44	36.53	36.25	36.29	4346789.0
2014-02-04 11:00:00	MSFT	Stock	36.29	36.57	36.26	36.545	5006356.0
2014-02-04 11:30:00	MSFT	Stock	36.55	36.67	36.52	36.62	2754184.0
2014-02-04 12:00:00	MSFT	Stock	36.62	36.64	36.56	36.6	1589624.0
2014-02-04 12:30:00	MSFT	Stock	36.6	36.62	36.54	36.602	2200295.0
2014-02-04 13:00:00	MSFT	Stock	36.61	36.64	36.57	36.63	1969128.0
2014-02-04 13:30:00	MSFT	Stock	36.622	36.63	36.48	36.51	2220038.0
2014-02-04 14:00:00	MSFT	Stock	36.502	36.55	36.43	36.54	2185855.0
2014-02-04 14:30:00	MSFT	Stock	36.536	36.61	36.5	36.56	1824524.0
2014-02-04 15:00:00	MSFT	Stock	36.56	36.59	36.42	36.45	3761999.0
2014-02-04 15:30:00	MSFT	Stock	36.445	36.48	36.34	36.34	6927470.0
2014-02-04 16:00:00	MSFT	Stock	36.35	36.606	36.31	36.37	3194615.0
2014-02-04 16:30:00	MSFT	Stock	36.357	36.504	36.34	36.475	71388.0

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

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