PREVIEW / stock_30min / 2016-11-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-22.parquet
  size:    1.6 MB
  rows:    82,123
  symbols: 3,183

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-11-22 04:00:00	AAPL	Stock	28.0	28.0	27.975	27.995	15944.0
2016-11-22 04:30:00	AAPL	Stock	27.9925	28.01	27.9925	28.01	19916.0
2016-11-22 05:30:00	AAPL	Stock	28.02	28.0275	28.02	28.025	43296.0
2016-11-22 06:30:00	AAPL	Stock	28.0025	28.0025	27.975	27.975	8664.0
2016-11-22 07:00:00	AAPL	Stock	27.9975	28.0	27.975	27.975	38092.0
2016-11-22 07:30:00	AAPL	Stock	27.985	28.0175	27.985	28.01	42316.0
2016-11-22 08:00:00	AAPL	Stock	27.9975	28.0025	27.875	27.975	140344.0
2016-11-22 08:30:00	AAPL	Stock	27.9725	27.985	27.9425	27.9425	96240.0
2016-11-22 09:00:00	AAPL	Stock	27.9425	27.99	27.9425	27.9875	217948.0
2016-11-22 09:30:00	AAPL	Stock	27.99	28.105	27.915	28.02	14917260.0
2016-11-22 10:00:00	AAPL	Stock	28.02	28.0625	27.8775	27.8875	7683756.0
2016-11-22 10:30:00	AAPL	Stock	27.89	27.955	27.85	27.9025	7117220.0
2016-11-22 11:00:00	AAPL	Stock	27.9038	27.9725	27.8925	27.9275	5715604.0
2016-11-22 11:30:00	AAPL	Stock	27.9275	27.951	27.8985	27.9425	4554404.0
2016-11-22 12:00:00	AAPL	Stock	27.945	27.9925	27.9225	27.98	4186760.0
2016-11-22 12:30:00	AAPL	Stock	27.9812	27.9825	27.9475	27.9535	2961876.0
2016-11-22 13:00:00	AAPL	Stock	27.955	27.9925	27.9538	27.9825	3157156.0
2016-11-22 13:30:00	AAPL	Stock	27.9825	27.9975	27.9688	27.9812	3547516.0
2016-11-22 14:00:00	AAPL	Stock	27.9825	27.9825	27.9188	27.9325	4713212.0
2016-11-22 14:30:00	AAPL	Stock	27.9332	27.9638	27.9138	27.9405	4557612.0
2016-11-22 15:00:00	AAPL	Stock	27.941	27.96	27.9275	27.93	3490932.0
2016-11-22 15:30:00	AAPL	Stock	27.9312	27.9775	27.9312	27.9425	7711520.0
2016-11-22 16:00:00	AAPL	Stock	27.95	28.0075	27.935	27.95	18952788.0
2016-11-22 16:30:00	AAPL	Stock	27.95	27.96	27.94	27.9425	4784.0
2016-11-22 17:00:00	AAPL	Stock	27.96	27.96	27.9375	27.9375	24284.0
2016-11-22 17:30:00	AAPL	Stock	27.935	27.965	27.935	27.9625	58760.0
2016-11-22 18:00:00	AAPL	Stock	27.97	27.975	27.9525	27.9525	39300.0
2016-11-22 18:30:00	AAPL	Stock	27.95	27.95	27.95	27.95	800.0
2016-11-22 19:00:00	AAPL	Stock	27.9375	27.9475	27.935	27.9475	3600.0
2016-11-22 19:30:00	AAPL	Stock	27.95	27.9525	27.9425	27.9425	13796.0
2016-11-22 04:30:00	MSFT	Stock	61.08	61.08	61.08	61.08	121.0
2016-11-22 05:30:00	MSFT	Stock	61.04	61.05	61.04	61.05	200.0
2016-11-22 06:00:00	MSFT	Stock	61.03	61.03	61.03	61.03	100.0
2016-11-22 06:30:00	MSFT	Stock	61.02	61.02	61.02	61.02	100.0
2016-11-22 07:00:00	MSFT	Stock	61.0	61.0	61.0	61.0	100.0
2016-11-22 08:00:00	MSFT	Stock	60.91	61.03	60.91	60.99	4022.0
2016-11-22 08:30:00	MSFT	Stock	60.99	60.99	60.99	60.99	300.0
2016-11-22 09:00:00	MSFT	Stock	60.99	61.05	60.94	60.97	13384.0
2016-11-22 09:30:00	MSFT	Stock	60.98	61.11	60.805	60.81	1899397.0
2016-11-22 10:00:00	MSFT	Stock	60.81	61.17	60.805	61.14	2411632.0
2016-11-22 10:30:00	MSFT	Stock	61.135	61.14	60.91	61.051	1293737.0
2016-11-22 11:00:00	MSFT	Stock	61.055	61.14	60.995	61.08	1029948.0
2016-11-22 11:30:00	MSFT	Stock	61.075	61.17	61.0	61.17	932093.0
2016-11-22 12:00:00	MSFT	Stock	61.17	61.17	61.05	61.136	894039.0
2016-11-22 12:30:00	MSFT	Stock	61.14	61.26	61.107	61.216	1033561.0
2016-11-22 13:00:00	MSFT	Stock	61.22	61.26	61.12	61.191	1061481.0
2016-11-22 13:30:00	MSFT	Stock	61.195	61.2	61.09	61.105	717058.0
2016-11-22 14:00:00	MSFT	Stock	61.105	61.11	61.0	61.05	834469.0
2016-11-22 14:30:00	MSFT	Stock	61.05	61.17	61.04	61.075	879714.0
2016-11-22 15:00:00	MSFT	Stock	61.075	61.09	61.01	61.075	878098.0

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

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