PREVIEW / stock_30min / 2016-12-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-16.parquet
  size:    1.7 MB
  rows:    85,267
  symbols: 3,177

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-16 04:00:00	AAPL	Stock	28.8825	28.8825	28.88	28.88	6880.0
2016-12-16 04:30:00	AAPL	Stock	28.8825	28.8825	28.8825	28.8825	400.0
2016-12-16 05:00:00	AAPL	Stock	28.8375	28.8825	28.8375	28.8825	5608.0
2016-12-16 05:30:00	AAPL	Stock	28.8825	28.925	28.8825	28.925	17848.0
2016-12-16 06:00:00	AAPL	Stock	28.9075	28.9075	28.9	28.9	1116.0
2016-12-16 06:30:00	AAPL	Stock	28.93	28.93	28.93	28.93	7372.0
2016-12-16 07:00:00	AAPL	Stock	28.965	29.045	28.965	29.01	30692.0
2016-12-16 07:30:00	AAPL	Stock	29.0125	29.075	29.0125	29.0625	27104.0
2016-12-16 08:00:00	AAPL	Stock	29.0625	29.1175	29.0125	29.0875	254028.0
2016-12-16 08:30:00	AAPL	Stock	29.0625	29.1075	29.0625	29.0875	117424.0
2016-12-16 09:00:00	AAPL	Stock	29.0875	29.1325	29.0625	29.0825	455240.0
2016-12-16 09:30:00	AAPL	Stock	29.0825	29.125	28.9725	29.07	42200116.0
2016-12-16 10:00:00	AAPL	Stock	29.0725	29.0825	28.9762	28.9925	6862352.0
2016-12-16 10:30:00	AAPL	Stock	28.995	29.0475	28.9538	29.0325	7382168.0
2016-12-16 11:00:00	AAPL	Stock	29.034	29.0425	28.925	28.9375	6606436.0
2016-12-16 11:30:00	AAPL	Stock	28.9388	29.075	28.9112	29.0288	7475316.0
2016-12-16 12:00:00	AAPL	Stock	29.03	29.0475	28.9962	29.0152	4442692.0
2016-12-16 12:30:00	AAPL	Stock	29.0162	29.0475	28.966	28.975	3779964.0
2016-12-16 13:00:00	AAPL	Stock	28.9775	28.9825	28.9425	28.9588	3882396.0
2016-12-16 13:30:00	AAPL	Stock	28.96	28.9875	28.9425	28.9475	3180304.0
2016-12-16 14:00:00	AAPL	Stock	28.9488	28.9985	28.9425	28.9575	3998576.0
2016-12-16 14:30:00	AAPL	Stock	28.9588	28.9888	28.95	28.9662	4051268.0
2016-12-16 15:00:00	AAPL	Stock	28.9662	28.9825	28.94	28.9475	6024488.0
2016-12-16 15:30:00	AAPL	Stock	28.9475	29.0	28.945	28.993	13264996.0
2016-12-16 16:00:00	AAPL	Stock	28.9925	29.0	28.9775	28.99	42910992.0
2016-12-16 16:30:00	AAPL	Stock	28.99	28.995	28.98	28.98	88712.0
2016-12-16 17:00:00	AAPL	Stock	28.99	28.99	28.965	28.965	17920.0
2016-12-16 17:30:00	AAPL	Stock	28.985	28.985	28.98	28.98	4560.0
2016-12-16 18:00:00	AAPL	Stock	28.9925	28.9925	28.9925	28.9925	4000.0
2016-12-16 18:30:00	AAPL	Stock	28.99	28.99	28.98	28.98	3060.0
2016-12-16 19:00:00	AAPL	Stock	28.98	28.9925	28.98	28.9875	239496.0
2016-12-16 19:30:00	AAPL	Stock	28.9875	28.9875	28.975	28.98	11576.0
2016-12-16 06:30:00	MSFT	Stock	62.58	62.58	62.58	62.58	100.0
2016-12-16 07:30:00	MSFT	Stock	62.8	62.8	62.8	62.8	100.0
2016-12-16 08:30:00	MSFT	Stock	62.74	62.92	62.72	62.92	625.0
2016-12-16 09:00:00	MSFT	Stock	62.82	63.02	62.82	62.91	354384.0
2016-12-16 09:30:00	MSFT	Stock	62.91	62.95	62.25	62.42	13722026.0
2016-12-16 10:00:00	MSFT	Stock	62.42	62.47	62.24	62.345	1417618.0
2016-12-16 10:30:00	MSFT	Stock	62.35	62.45	62.26	62.3	1239197.0
2016-12-16 11:00:00	MSFT	Stock	62.3	62.385	62.22	62.28	1977479.0
2016-12-16 11:30:00	MSFT	Stock	62.29	62.45	62.24	62.361	1088621.0
2016-12-16 12:00:00	MSFT	Stock	62.37	62.39	62.253	62.316	780508.0
2016-12-16 12:30:00	MSFT	Stock	62.31	62.425	62.22	62.245	1089408.0
2016-12-16 13:00:00	MSFT	Stock	62.24	62.266	62.115	62.18	938061.0
2016-12-16 13:30:00	MSFT	Stock	62.18	62.36	62.17	62.34	832072.0
2016-12-16 14:00:00	MSFT	Stock	62.335	62.48	62.28	62.396	1249566.0
2016-12-16 14:30:00	MSFT	Stock	62.39	62.465	62.34	62.375	1121188.0
2016-12-16 15:00:00	MSFT	Stock	62.38	62.42	62.21	62.325	1241873.0
2016-12-16 15:30:00	MSFT	Stock	62.33	62.4	62.26	62.3	4477316.0
2016-12-16 16:00:00	MSFT	Stock	62.3	62.44	62.27	62.4	7865510.0

> showing 50 of 85,267 rows — these rows as CSV

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