PREVIEW / stock_30min / 2016-12-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-19.parquet
  size:    1.6 MB
  rows:    82,825
  symbols: 3,165

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-19 04:00:00	AAPL	Stock	28.955	28.955	28.955	28.955	664.0
2016-12-19 05:30:00	AAPL	Stock	28.9275	28.95	28.9275	28.95	4112.0
2016-12-19 06:00:00	AAPL	Stock	28.925	28.925	28.925	28.925	3752.0
2016-12-19 06:30:00	AAPL	Stock	28.9125	28.925	28.9	28.925	5172.0
2016-12-19 07:00:00	AAPL	Stock	28.9275	28.9425	28.9125	28.93	23164.0
2016-12-19 07:30:00	AAPL	Stock	28.94	29.0	28.94	28.98	14064.0
2016-12-19 08:00:00	AAPL	Stock	28.9475	28.9975	28.9175	28.9625	77348.0
2016-12-19 08:30:00	AAPL	Stock	28.9625	28.9925	28.9625	28.9725	66640.0
2016-12-19 09:00:00	AAPL	Stock	28.9725	28.9925	28.9425	28.9525	106568.0
2016-12-19 09:30:00	AAPL	Stock	28.95	29.205	28.9375	29.1525	15446476.0
2016-12-19 10:00:00	AAPL	Stock	29.1525	29.195	29.1425	29.1675	6779356.0
2016-12-19 10:30:00	AAPL	Stock	29.1675	29.305	29.1612	29.2872	10916656.0
2016-12-19 11:00:00	AAPL	Stock	29.285	29.345	29.275	29.2875	8363212.0
2016-12-19 11:30:00	AAPL	Stock	29.2878	29.31	29.2025	29.2075	5063592.0
2016-12-19 12:00:00	AAPL	Stock	29.2062	29.28	29.205	29.2575	4022880.0
2016-12-19 12:30:00	AAPL	Stock	29.26	29.3	29.2462	29.265	3752676.0
2016-12-19 13:00:00	AAPL	Stock	29.2668	29.285	29.1875	29.2098	3697644.0
2016-12-19 13:30:00	AAPL	Stock	29.21	29.2475	29.1975	29.2375	3084608.0
2016-12-19 14:00:00	AAPL	Stock	29.2375	29.25	29.1975	29.2025	2706864.0
2016-12-19 14:30:00	AAPL	Stock	29.2025	29.22	29.1625	29.1725	2777404.0
2016-12-19 15:00:00	AAPL	Stock	29.1725	29.19	29.1375	29.1525	4057972.0
2016-12-19 15:30:00	AAPL	Stock	29.1525	29.165	29.095	29.1575	8937968.0
2016-12-19 16:00:00	AAPL	Stock	29.16	29.19	29.1125	29.16	10841576.0
2016-12-19 16:30:00	AAPL	Stock	29.16	29.1625	29.15	29.15	94724.0
2016-12-19 17:00:00	AAPL	Stock	29.15	29.16	29.1425	29.155	33356.0
2016-12-19 17:30:00	AAPL	Stock	29.1575	29.1625	29.1425	29.1425	18740.0
2016-12-19 18:00:00	AAPL	Stock	29.16	29.16	29.16	29.16	2400.0
2016-12-19 18:30:00	AAPL	Stock	29.1625	29.1625	29.15	29.16	6616.0
2016-12-19 19:00:00	AAPL	Stock	29.15	29.1625	29.15	29.16	26508.0
2016-12-19 19:30:00	AAPL	Stock	29.16	29.17	29.1575	29.16	31576.0
2016-12-19 07:30:00	MSFT	Stock	62.5	62.5	62.5	62.5	400.0
2016-12-19 08:00:00	MSFT	Stock	62.47	62.48	62.41	62.41	2585.0
2016-12-19 08:30:00	MSFT	Stock	62.5	62.5	62.3	62.3	7434.0
2016-12-19 09:00:00	MSFT	Stock	62.5	62.64	62.5	62.61	21634.0
2016-12-19 09:30:00	MSFT	Stock	62.55	63.04	62.42	63.01	3298396.0
2016-12-19 10:00:00	MSFT	Stock	63.01	63.18	62.91	63.16	2033780.0
2016-12-19 10:30:00	MSFT	Stock	63.164	63.52	63.14	63.505	2657849.0
2016-12-19 11:00:00	MSFT	Stock	63.5	63.72	63.5	63.58	2813983.0
2016-12-19 11:30:00	MSFT	Stock	63.57	63.67	63.52	63.524	1701136.0
2016-12-19 12:00:00	MSFT	Stock	63.52	63.605	63.5	63.555	1545932.0
2016-12-19 12:30:00	MSFT	Stock	63.56	63.65	63.535	63.59	834229.0
2016-12-19 13:00:00	MSFT	Stock	63.59	63.65	63.55	63.595	998196.0
2016-12-19 13:30:00	MSFT	Stock	63.6	63.72	63.545	63.7	1045759.0
2016-12-19 14:00:00	MSFT	Stock	63.71	63.75	63.68	63.71	1183684.0
2016-12-19 14:30:00	MSFT	Stock	63.705	63.77	63.67	63.695	1144423.0
2016-12-19 15:00:00	MSFT	Stock	63.69	63.71	63.55	63.59	1625264.0
2016-12-19 15:30:00	MSFT	Stock	63.59	63.65	63.405	63.62	3775055.0
2016-12-19 16:00:00	MSFT	Stock	63.62	63.64	62.75	63.62	6881160.0
2016-12-19 16:30:00	MSFT	Stock	63.62	63.72	63.6	63.72	229052.0
2016-12-19 17:00:00	MSFT	Stock	63.62	63.75	63.62	63.65	834334.0

> showing 50 of 82,825 rows — these rows as CSV

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