PREVIEW / stock_30min / 2016-12-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-29.parquet
  size:    1.6 MB
  rows:    80,986
  symbols: 3,152

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
2016-12-29 04:00:00	AAPL	Stock	29.1775	29.1775	29.1775	29.1775	1584.0
2016-12-29 05:00:00	AAPL	Stock	29.175	29.175	29.175	29.175	400.0
2016-12-29 06:30:00	AAPL	Stock	29.15	29.15	29.15	29.15	400.0
2016-12-29 07:00:00	AAPL	Stock	29.16	29.16	29.16	29.16	560.0
2016-12-29 07:30:00	AAPL	Stock	29.16	29.16	29.16	29.16	400.0
2016-12-29 08:00:00	AAPL	Stock	29.165	29.185	29.16	29.175	80036.0
2016-12-29 08:30:00	AAPL	Stock	29.1775	29.1775	29.15	29.1675	12428.0
2016-12-29 09:00:00	AAPL	Stock	29.1625	29.17	29.1025	29.1025	90228.0
2016-12-29 09:30:00	AAPL	Stock	29.135	29.2775	29.11	29.2075	9379052.0
2016-12-29 10:00:00	AAPL	Stock	29.2062	29.275	29.1625	29.2588	5044984.0
2016-12-29 10:30:00	AAPL	Stock	29.2588	29.26	29.15	29.1772	4808476.0
2016-12-29 11:00:00	AAPL	Stock	29.1775	29.1788	29.1325	29.1538	3267040.0
2016-12-29 11:30:00	AAPL	Stock	29.155	29.16	29.1	29.1262	3460520.0
2016-12-29 12:00:00	AAPL	Stock	29.1262	29.18	29.1225	29.1575	2656296.0
2016-12-29 12:30:00	AAPL	Stock	29.1585	29.1925	29.1375	29.1575	2257492.0
2016-12-29 13:00:00	AAPL	Stock	29.155	29.185	29.1525	29.1625	1674572.0
2016-12-29 13:30:00	AAPL	Stock	29.16	29.164	29.12	29.1512	2955172.0
2016-12-29 14:00:00	AAPL	Stock	29.1512	29.1738	29.145	29.1525	2119560.0
2016-12-29 14:30:00	AAPL	Stock	29.155	29.165	29.13	29.1475	2581360.0
2016-12-29 15:00:00	AAPL	Stock	29.15	29.1825	29.145	29.155	2457436.0
2016-12-29 15:30:00	AAPL	Stock	29.155	29.185	29.145	29.1825	6944740.0
2016-12-29 16:00:00	AAPL	Stock	29.1825	29.1825	29.1525	29.1725	4071340.0
2016-12-29 16:30:00	AAPL	Stock	29.18	29.18	29.175	29.18	20800.0
2016-12-29 17:00:00	AAPL	Stock	29.1775	29.195	29.175	29.175	43964.0
2016-12-29 17:30:00	AAPL	Stock	29.1825	29.1825	29.18	29.18	1016.0
2016-12-29 18:00:00	AAPL	Stock	29.18	29.1925	29.18	29.1925	8980.0
2016-12-29 18:30:00	AAPL	Stock	29.1925	29.1925	29.1925	29.1925	12800.0
2016-12-29 19:00:00	AAPL	Stock	29.1775	29.1875	29.1775	29.1775	1984.0
2016-12-29 19:30:00	AAPL	Stock	29.1925	29.205	29.1925	29.205	11900.0
2016-12-29 08:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	600.0
2016-12-29 08:30:00	MSFT	Stock	63.07	63.1	63.07	63.1	350.0
2016-12-29 09:00:00	MSFT	Stock	63.0	63.0	62.85	62.85	4075.0
2016-12-29 09:30:00	MSFT	Stock	62.86	63.2	62.75	62.835	1331159.0
2016-12-29 10:00:00	MSFT	Stock	62.836	62.975	62.83	62.955	736630.0
2016-12-29 10:30:00	MSFT	Stock	62.955	62.97	62.79	62.826	789551.0
2016-12-29 11:00:00	MSFT	Stock	62.82	62.875	62.76	62.805	566587.0
2016-12-29 11:30:00	MSFT	Stock	62.81	62.84	62.73	62.784	426153.0
2016-12-29 12:00:00	MSFT	Stock	62.79	62.95	62.775	62.92	443982.0
2016-12-29 12:30:00	MSFT	Stock	62.92	62.95	62.88	62.91	310507.0
2016-12-29 13:00:00	MSFT	Stock	62.91	62.925	62.86	62.88	261903.0
2016-12-29 13:30:00	MSFT	Stock	62.875	62.89	62.78	62.835	569654.0
2016-12-29 14:00:00	MSFT	Stock	62.84	62.905	62.83	62.855	489936.0
2016-12-29 14:30:00	MSFT	Stock	62.85	62.908	62.81	62.832	595219.0
2016-12-29 15:00:00	MSFT	Stock	62.83	62.92	62.815	62.884	553652.0
2016-12-29 15:30:00	MSFT	Stock	62.885	62.925	62.83	62.9	1369276.0
2016-12-29 16:00:00	MSFT	Stock	62.9	62.9	62.87	62.9	1052354.0
2016-12-29 16:30:00	MSFT	Stock	62.9	62.9	62.9	62.9	66718.0
2016-12-29 17:00:00	MSFT	Stock	62.9	62.9	62.9	62.9	100.0
2016-12-29 17:30:00	MSFT	Stock	62.9	62.9	62.9	62.9	150.0
2016-12-29 18:00:00	MSFT	Stock	62.9	62.9	62.9	62.9	1119.0

> showing 50 of 80,986 rows — these rows as CSV

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