PREVIEW / stock_30min / 2016-01-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-22.parquet
  size:    1.6 MB
  rows:    83,809
  symbols: 3,401

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-01-22 04:00:00	AAPL	Stock	24.44	24.595	24.44	24.5375	22140.0
2016-01-22 05:00:00	AAPL	Stock	24.4375	24.4375	24.425	24.425	3600.0
2016-01-22 05:30:00	AAPL	Stock	24.5	24.5125	24.4475	24.4825	3248.0
2016-01-22 06:00:00	AAPL	Stock	24.45	24.5	24.38	24.5	55792.0
2016-01-22 06:30:00	AAPL	Stock	24.5	24.5625	24.5	24.5125	36140.0
2016-01-22 07:00:00	AAPL	Stock	24.5325	24.54	24.4725	24.5125	209840.0
2016-01-22 07:30:00	AAPL	Stock	24.5375	24.6	24.525	24.595	132656.0
2016-01-22 08:00:00	AAPL	Stock	24.58	24.61	24.4875	24.575	480948.0
2016-01-22 08:30:00	AAPL	Stock	24.575	24.62	24.5125	24.5225	335612.0
2016-01-22 09:00:00	AAPL	Stock	24.5225	24.6575	24.4925	24.6225	595320.0
2016-01-22 09:30:00	AAPL	Stock	24.625	24.96	24.5925	24.9575	33240948.0
2016-01-22 10:00:00	AAPL	Stock	24.9575	24.9725	24.815	24.855	21297996.0
2016-01-22 10:30:00	AAPL	Stock	24.857	25.045	24.8525	24.8678	23782428.0
2016-01-22 11:00:00	AAPL	Stock	24.8675	24.905	24.725	24.877	19369932.0
2016-01-22 11:30:00	AAPL	Stock	24.8775	24.905	24.755	24.845	11963908.0
2016-01-22 12:00:00	AAPL	Stock	24.8425	25.0475	24.8307	25.012	13731716.0
2016-01-22 12:30:00	AAPL	Stock	25.0112	25.07	24.93	25.045	13314256.0
2016-01-22 13:00:00	AAPL	Stock	25.0475	25.08	25.0025	25.035	10334156.0
2016-01-22 13:30:00	AAPL	Stock	25.0375	25.0975	25.009	25.0885	8354512.0
2016-01-22 14:00:00	AAPL	Stock	25.09	25.17	25.065	25.14	13277344.0
2016-01-22 14:30:00	AAPL	Stock	25.1405	25.23	25.095	25.2242	16432900.0
2016-01-22 15:00:00	AAPL	Stock	25.225	25.2425	25.1425	25.2225	14454876.0
2016-01-22 15:30:00	AAPL	Stock	25.2225	25.365	25.185	25.355	30499164.0
2016-01-22 16:00:00	AAPL	Stock	25.355	25.375	25.31	25.375	9608808.0
2016-01-22 16:30:00	AAPL	Stock	25.375	25.375	25.3475	25.365	98780.0
2016-01-22 17:00:00	AAPL	Stock	25.37	25.4	25.365	25.4	128868.0
2016-01-22 17:30:00	AAPL	Stock	25.3875	25.4175	25.38	25.4125	64832.0
2016-01-22 18:00:00	AAPL	Stock	25.4	25.4375	25.3875	25.4375	79472.0
2016-01-22 18:30:00	AAPL	Stock	25.4375	25.4675	25.4225	25.4575	74444.0
2016-01-22 19:00:00	AAPL	Stock	25.4475	25.4625	25.4275	25.445	71024.0
2016-01-22 19:30:00	AAPL	Stock	25.4575	25.495	25.4475	25.495	188860.0
2016-01-22 04:00:00	MSFT	Stock	50.95	51.4	50.95	51.2	2547.0
2016-01-22 04:30:00	MSFT	Stock	51.24	51.24	51.24	51.24	100.0
2016-01-22 06:00:00	MSFT	Stock	51.39	51.4	51.39	51.4	3062.0
2016-01-22 07:00:00	MSFT	Stock	51.25	51.35	51.2	51.28	3480.0
2016-01-22 07:30:00	MSFT	Stock	51.25	51.46	51.21	51.21	5093.0
2016-01-22 08:00:00	MSFT	Stock	51.25	51.4	51.25	51.31	28652.0
2016-01-22 08:30:00	MSFT	Stock	51.35	51.35	51.25	51.25	44439.0
2016-01-22 09:00:00	MSFT	Stock	51.28	51.6	51.27	51.41	100830.0
2016-01-22 09:30:00	MSFT	Stock	51.42	51.9	51.26	51.689	4299906.0
2016-01-22 10:00:00	MSFT	Stock	51.685	52.18	51.68	52.04	3410684.0
2016-01-22 10:30:00	MSFT	Stock	52.05	52.33	51.89	51.93	3135168.0
2016-01-22 11:00:00	MSFT	Stock	51.93	52.16	51.765	52.085	2562656.0
2016-01-22 11:30:00	MSFT	Stock	52.065	52.13	51.9	52.046	1773707.0
2016-01-22 12:00:00	MSFT	Stock	52.04	52.28	52.03	52.115	1704911.0
2016-01-22 12:30:00	MSFT	Stock	52.12	52.18	51.995	52.111	1164658.0
2016-01-22 13:00:00	MSFT	Stock	52.118	52.245	51.995	52.13	1348904.0
2016-01-22 13:30:00	MSFT	Stock	52.14	52.22	52.05	52.2	1001749.0
2016-01-22 14:00:00	MSFT	Stock	52.191	52.3	52.09	52.12	1348133.0
2016-01-22 14:30:00	MSFT	Stock	52.12	52.28	52.06	52.23	2211417.0

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

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