PREVIEW / stock_30min / 2016-04-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-14.parquet
  size:    1.5 MB
  rows:    80,951
  symbols: 3,320

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-04-14 04:00:00	AAPL	Stock	27.91	27.935	27.91	27.935	2400.0
2016-04-14 04:30:00	AAPL	Stock	27.95	27.95	27.9375	27.9375	4180.0
2016-04-14 05:00:00	AAPL	Stock	27.95	27.95	27.91	27.91	1200.0
2016-04-14 05:30:00	AAPL	Stock	27.9375	27.9375	27.9375	27.9375	648.0
2016-04-14 07:00:00	AAPL	Stock	27.965	27.98	27.965	27.975	15796.0
2016-04-14 07:30:00	AAPL	Stock	27.955	27.955	27.9	27.9	89680.0
2016-04-14 08:00:00	AAPL	Stock	27.8975	27.98	27.7825	27.8325	509092.0
2016-04-14 08:30:00	AAPL	Stock	27.85	27.89	27.8375	27.855	259172.0
2016-04-14 09:00:00	AAPL	Stock	27.855	27.9175	27.8475	27.9175	507720.0
2016-04-14 09:30:00	AAPL	Stock	27.9175	28.0425	27.84	27.89	16626072.0
2016-04-14 10:00:00	AAPL	Stock	27.89	27.9375	27.8325	27.905	10380356.0
2016-04-14 10:30:00	AAPL	Stock	27.905	27.9325	27.8375	27.93	6428648.0
2016-04-14 11:00:00	AAPL	Stock	27.93	27.9925	27.92	27.9775	6033048.0
2016-04-14 11:30:00	AAPL	Stock	27.9778	28.0475	27.9778	28.0452	6610464.0
2016-04-14 12:00:00	AAPL	Stock	28.045	28.0975	28.0275	28.035	5152160.0
2016-04-14 12:30:00	AAPL	Stock	28.035	28.055	28.0025	28.0425	3633888.0
2016-04-14 13:00:00	AAPL	Stock	28.04	28.0675	27.98	28.01	4895452.0
2016-04-14 13:30:00	AAPL	Stock	28.0075	28.03	27.985	27.9912	3378732.0
2016-04-14 14:00:00	AAPL	Stock	27.99	28.0475	27.9775	28.0335	5409772.0
2016-04-14 14:30:00	AAPL	Stock	28.0348	28.045	27.975	28.0225	5566160.0
2016-04-14 15:00:00	AAPL	Stock	28.025	28.05	28.0	28.0175	2962040.0
2016-04-14 15:30:00	AAPL	Stock	28.0162	28.065	27.995	28.025	9323540.0
2016-04-14 16:00:00	AAPL	Stock	28.025	28.0625	28.0075	28.0375	6363076.0
2016-04-14 16:30:00	AAPL	Stock	28.03	28.05	28.03	28.05	11604.0
2016-04-14 17:00:00	AAPL	Stock	28.03	28.05	28.03	28.03	11844.0
2016-04-14 17:30:00	AAPL	Stock	28.025	28.045	28.025	28.025	95660.0
2016-04-14 18:00:00	AAPL	Stock	28.03	28.045	28.03	28.0425	11100.0
2016-04-14 18:30:00	AAPL	Stock	28.05	28.05	28.04	28.05	8788.0
2016-04-14 19:00:00	AAPL	Stock	28.05	28.0575	28.045	28.045	6800.0
2016-04-14 19:30:00	AAPL	Stock	28.05	28.0525	28.045	28.05	8508.0
2016-04-14 08:00:00	MSFT	Stock	55.45	55.45	55.3	55.3	3200.0
2016-04-14 08:30:00	MSFT	Stock	55.4	55.45	55.4	55.42	6616.0
2016-04-14 09:00:00	MSFT	Stock	55.45	55.45	55.21	55.23	17421.0
2016-04-14 09:30:00	MSFT	Stock	55.23	55.46	55.11	55.23	2574087.0
2016-04-14 10:00:00	MSFT	Stock	55.24	55.28	55.07	55.19	1160103.0
2016-04-14 10:30:00	MSFT	Stock	55.2	55.38	55.19	55.35	1068295.0
2016-04-14 11:00:00	MSFT	Stock	55.34	55.38	55.26	55.372	1106773.0
2016-04-14 11:30:00	MSFT	Stock	55.37	55.575	55.352	55.51	1306828.0
2016-04-14 12:00:00	MSFT	Stock	55.51	55.514	55.27	55.309	1002860.0
2016-04-14 12:30:00	MSFT	Stock	55.31	55.395	55.23	55.395	803842.0
2016-04-14 13:00:00	MSFT	Stock	55.385	55.44	55.28	55.36	780445.0
2016-04-14 13:30:00	MSFT	Stock	55.354	55.47	55.34	55.42	1013338.0
2016-04-14 14:00:00	MSFT	Stock	55.42	55.565	55.39	55.446	1172298.0
2016-04-14 14:30:00	MSFT	Stock	55.45	55.53	55.36	55.48	883975.0
2016-04-14 15:00:00	MSFT	Stock	55.485	55.55	55.405	55.45	945311.0
2016-04-14 15:30:00	MSFT	Stock	55.445	55.49	55.28	55.36	3210897.0
2016-04-14 16:00:00	MSFT	Stock	55.36	55.44	55.3	55.44	2569843.0
2016-04-14 16:30:00	MSFT	Stock	55.44	55.44	55.44	55.44	155.0
2016-04-14 18:00:00	MSFT	Stock	55.42	55.42	55.42	55.42	300.0
2016-04-14 19:00:00	MSFT	Stock	55.42	55.49	55.42	55.49	1133.0

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

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