PREVIEW / stock_30min / 2016-09-06

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-06.parquet
  size:    1.6 MB
  rows:    83,678
  symbols: 3,271

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-09-06 04:00:00	AAPL	Stock	26.985	26.985	26.97	26.97	33096.0
2016-09-06 04:30:00	AAPL	Stock	26.97	27.0	26.97	26.9925	2980.0
2016-09-06 05:00:00	AAPL	Stock	26.97	26.97	26.97	26.97	2000.0
2016-09-06 05:30:00	AAPL	Stock	26.99	27.0	26.99	27.0	8480.0
2016-09-06 06:00:00	AAPL	Stock	27.035	27.045	27.0	27.025	4800.0
2016-09-06 06:30:00	AAPL	Stock	27.025	27.025	26.99	26.99	1228.0
2016-09-06 07:00:00	AAPL	Stock	27.0175	27.0425	27.0	27.0275	84228.0
2016-09-06 07:30:00	AAPL	Stock	27.04	27.04	27.0125	27.0125	90308.0
2016-09-06 08:00:00	AAPL	Stock	27.0	27.04	26.985	27.01	229108.0
2016-09-06 08:30:00	AAPL	Stock	27.01	27.0175	27.0	27.0125	68572.0
2016-09-06 09:00:00	AAPL	Stock	27.0125	27.03	26.9575	26.9575	280524.0
2016-09-06 09:30:00	AAPL	Stock	26.9575	27.075	26.9375	27.0275	17375896.0
2016-09-06 10:00:00	AAPL	Stock	27.025	27.05	26.91	26.9625	9136012.0
2016-09-06 10:30:00	AAPL	Stock	26.9638	26.9888	26.9162	26.965	6186464.0
2016-09-06 11:00:00	AAPL	Stock	26.9625	26.9975	26.9565	26.9612	4675776.0
2016-09-06 11:30:00	AAPL	Stock	26.96	26.9825	26.945	26.97	3652024.0
2016-09-06 12:00:00	AAPL	Stock	26.9685	26.9775	26.95	26.9535	2917440.0
2016-09-06 12:30:00	AAPL	Stock	26.955	26.9875	26.9525	26.98	3557976.0
2016-09-06 13:00:00	AAPL	Stock	26.9812	26.985	26.9	26.9	4563384.0
2016-09-06 13:30:00	AAPL	Stock	26.9	26.925	26.885	26.9115	4555736.0
2016-09-06 14:00:00	AAPL	Stock	26.9112	26.92	26.885	26.8925	3583176.0
2016-09-06 14:30:00	AAPL	Stock	26.895	26.9075	26.8775	26.9	3488536.0
2016-09-06 15:00:00	AAPL	Stock	26.9025	26.9225	26.895	26.9112	3547980.0
2016-09-06 15:30:00	AAPL	Stock	26.91	26.9338	26.9	26.925	8916288.0
2016-09-06 16:00:00	AAPL	Stock	26.925	26.929	26.9025	26.925	22553452.0
2016-09-06 16:30:00	AAPL	Stock	26.9175	26.925	26.9175	26.925	36608.0
2016-09-06 17:00:00	AAPL	Stock	26.925	26.925	26.9175	26.9225	40568.0
2016-09-06 17:30:00	AAPL	Stock	26.9225	26.935	26.905	26.925	79396.0
2016-09-06 18:00:00	AAPL	Stock	26.91	26.935	26.91	26.9325	34628.0
2016-09-06 18:30:00	AAPL	Stock	26.9325	26.945	26.9325	26.94	52684.0
2016-09-06 19:00:00	AAPL	Stock	26.9425	26.9625	26.9425	26.9525	19344.0
2016-09-06 19:30:00	AAPL	Stock	26.96	26.9675	26.9525	26.965	73400.0
2016-09-06 06:00:00	MSFT	Stock	57.79	57.79	57.79	57.79	240.0
2016-09-06 07:00:00	MSFT	Stock	57.67	57.67	57.65	57.65	840.0
2016-09-06 08:30:00	MSFT	Stock	57.73	57.78	57.7	57.78	2770.0
2016-09-06 09:00:00	MSFT	Stock	57.78	57.78	57.6	57.6	32500.0
2016-09-06 09:30:00	MSFT	Stock	57.58	57.8	57.4	57.475	2007643.0
2016-09-06 10:00:00	MSFT	Stock	57.47	57.53	57.21	57.31	1561914.0
2016-09-06 10:30:00	MSFT	Stock	57.315	57.455	57.28	57.44	921237.0
2016-09-06 11:00:00	MSFT	Stock	57.445	57.52	57.39	57.455	875366.0
2016-09-06 11:30:00	MSFT	Stock	57.45	57.53	57.4	57.49	706489.0
2016-09-06 12:00:00	MSFT	Stock	57.485	57.51	57.46	57.49	499319.0
2016-09-06 12:30:00	MSFT	Stock	57.49	57.61	57.48	57.555	780570.0
2016-09-06 13:00:00	MSFT	Stock	57.55	57.59	57.53	57.565	462876.0
2016-09-06 13:30:00	MSFT	Stock	57.56	57.59	57.54	57.55	590542.0
2016-09-06 14:00:00	MSFT	Stock	57.56	57.58	57.51	57.53	597726.0
2016-09-06 14:30:00	MSFT	Stock	57.535	57.6	57.53	57.6	600949.0
2016-09-06 15:00:00	MSFT	Stock	57.6	57.6	57.54	57.59	675583.0
2016-09-06 15:30:00	MSFT	Stock	57.585	57.6	57.54	57.6	1778147.0
2016-09-06 16:00:00	MSFT	Stock	57.6	57.61	57.59	57.61	2890022.0

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

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