PREVIEW / stock_30min / 2016-10-31

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-31.parquet
  size:    1.5 MB
  rows:    79,718
  symbols: 3,205

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-10-31 04:00:00	AAPL	Stock	28.4725	28.475	28.35	28.35	5128.0
2016-10-31 05:00:00	AAPL	Stock	28.44	28.4875	28.44	28.4875	1576.0
2016-10-31 06:00:00	AAPL	Stock	28.4375	28.47	28.4375	28.47	5780.0
2016-10-31 06:30:00	AAPL	Stock	28.4375	28.4375	28.4375	28.4375	800.0
2016-10-31 07:00:00	AAPL	Stock	28.44	28.45	28.43	28.435	27600.0
2016-10-31 07:30:00	AAPL	Stock	28.43	28.44	28.43	28.43	6800.0
2016-10-31 08:00:00	AAPL	Stock	28.445	28.445	28.405	28.41	91116.0
2016-10-31 08:30:00	AAPL	Stock	28.4175	28.45	28.405	28.45	63388.0
2016-10-31 09:00:00	AAPL	Stock	28.445	28.445	28.375	28.4125	196308.0
2016-10-31 09:30:00	AAPL	Stock	28.4125	28.485	28.3	28.3225	16327664.0
2016-10-31 10:00:00	AAPL	Stock	28.3225	28.4675	28.315	28.4562	9494488.0
2016-10-31 10:30:00	AAPL	Stock	28.4575	28.4662	28.38	28.42	7813368.0
2016-10-31 11:00:00	AAPL	Stock	28.4225	28.423	28.36	28.4125	4947732.0
2016-10-31 11:30:00	AAPL	Stock	28.4125	28.44	28.385	28.431	4506212.0
2016-10-31 12:00:00	AAPL	Stock	28.4312	28.4725	28.4225	28.4475	3150256.0
2016-10-31 12:30:00	AAPL	Stock	28.45	28.5	28.4325	28.4925	3589300.0
2016-10-31 13:00:00	AAPL	Stock	28.4945	28.535	28.48	28.51	4423284.0
2016-10-31 13:30:00	AAPL	Stock	28.5125	28.5575	28.5	28.5125	3611960.0
2016-10-31 14:00:00	AAPL	Stock	28.5125	28.52	28.4525	28.46	3132040.0
2016-10-31 14:30:00	AAPL	Stock	28.46	28.4925	28.425	28.435	3707292.0
2016-10-31 15:00:00	AAPL	Stock	28.4375	28.4825	28.4275	28.4462	4532028.0
2016-10-31 15:30:00	AAPL	Stock	28.4462	28.4525	28.385	28.39	11248464.0
2016-10-31 16:00:00	AAPL	Stock	28.385	28.4678	28.3825	28.39	14435452.0
2016-10-31 16:30:00	AAPL	Stock	28.3925	28.395	28.3875	28.395	13048.0
2016-10-31 17:00:00	AAPL	Stock	28.3925	28.395	28.38	28.38	7156.0
2016-10-31 17:30:00	AAPL	Stock	28.385	28.385	28.3825	28.3825	800.0
2016-10-31 18:00:00	AAPL	Stock	28.395	28.395	28.3875	28.3875	4532.0
2016-10-31 18:30:00	AAPL	Stock	28.3825	28.3825	28.3775	28.38	26656.0
2016-10-31 19:00:00	AAPL	Stock	28.3875	28.39	28.3775	28.385	24520.0
2016-10-31 19:30:00	AAPL	Stock	28.38	28.3875	28.3775	28.385	19940.0
2016-10-31 05:00:00	MSFT	Stock	60.12	60.12	60.12	60.12	500.0
2016-10-31 06:00:00	MSFT	Stock	60.11	60.12	60.11	60.12	4960.0
2016-10-31 06:30:00	MSFT	Stock	60.1	60.1	60.1	60.1	10000.0
2016-10-31 07:30:00	MSFT	Stock	60.07	60.07	60.07	60.07	8500.0
2016-10-31 08:00:00	MSFT	Stock	60.06	60.16	60.06	60.1	8240.0
2016-10-31 08:30:00	MSFT	Stock	60.15	60.15	60.1	60.15	27817.0
2016-10-31 09:00:00	MSFT	Stock	60.14	60.2	60.08	60.15	23126.0
2016-10-31 09:30:00	MSFT	Stock	60.16	60.38	60.12	60.225	2496950.0
2016-10-31 10:00:00	MSFT	Stock	60.23	60.35	60.15	60.29	1801902.0
2016-10-31 10:30:00	MSFT	Stock	60.29	60.35	60.2	60.295	1385236.0
2016-10-31 11:00:00	MSFT	Stock	60.295	60.32	60.21	60.31	1171721.0
2016-10-31 11:30:00	MSFT	Stock	60.32	60.42	60.31	60.38	1097358.0
2016-10-31 12:00:00	MSFT	Stock	60.39	60.41	60.32	60.36	806373.0
2016-10-31 12:30:00	MSFT	Stock	60.37	60.39	60.26	60.26	1136576.0
2016-10-31 13:00:00	MSFT	Stock	60.26	60.28	60.15	60.15	757741.0
2016-10-31 13:30:00	MSFT	Stock	60.15	60.2	60.11	60.148	746008.0
2016-10-31 14:00:00	MSFT	Stock	60.15	60.18	60.05	60.075	826615.0
2016-10-31 14:30:00	MSFT	Stock	60.075	60.15	60.07	60.08	855355.0
2016-10-31 15:00:00	MSFT	Stock	60.08	60.205	60.06	60.16	1373376.0
2016-10-31 15:30:00	MSFT	Stock	60.16	60.19	59.93	59.93	5031898.0

> showing 50 of 79,718 rows — these rows as CSV

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