PREVIEW / stock_30min / 2015-08-26

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-26.parquet
  size:    1.6 MB
  rows:    84,813
  symbols: 3,479

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
2015-08-26 04:00:00	AAPL	Stock	26.2625	26.55	26.25	26.465	69280.0
2015-08-26 04:30:00	AAPL	Stock	26.5475	26.55	26.4375	26.5125	9488.0
2015-08-26 05:00:00	AAPL	Stock	26.5	26.52	26.4375	26.5	45000.0
2015-08-26 05:30:00	AAPL	Stock	26.5	26.5	26.4375	26.4375	4000.0
2015-08-26 06:00:00	AAPL	Stock	26.41	26.4625	26.325	26.4125	53712.0
2015-08-26 06:30:00	AAPL	Stock	26.425	26.6075	26.425	26.5975	105236.0
2015-08-26 07:00:00	AAPL	Stock	26.54	26.76	26.51	26.675	343164.0
2015-08-26 07:30:00	AAPL	Stock	26.6775	26.695	26.5275	26.6575	240476.0
2015-08-26 08:00:00	AAPL	Stock	26.65	26.75	26.375	26.535	1363336.0
2015-08-26 08:30:00	AAPL	Stock	26.525	26.77	26.525	26.6	1172800.0
2015-08-26 09:00:00	AAPL	Stock	26.61	26.7925	26.465	26.7625	3094064.0
2015-08-26 09:30:00	AAPL	Stock	26.7625	27.0825	26.575	26.7645	53462040.0
2015-08-26 10:00:00	AAPL	Stock	26.765	26.92	26.5	26.67	31981516.0
2015-08-26 10:30:00	AAPL	Stock	26.67	26.8475	26.592	26.68	22601952.0
2015-08-26 11:00:00	AAPL	Stock	26.6775	26.7225	26.5275	26.575	17826592.0
2015-08-26 11:30:00	AAPL	Stock	26.5725	26.6275	26.285	26.495	20911240.0
2015-08-26 12:00:00	AAPL	Stock	26.495	26.6175	26.375	26.3925	14883620.0
2015-08-26 12:30:00	AAPL	Stock	26.3925	26.49	26.2625	26.4875	16562332.0
2015-08-26 13:00:00	AAPL	Stock	26.49	26.7475	26.465	26.745	18066184.0
2015-08-26 13:30:00	AAPL	Stock	26.745	26.96	26.7	26.8625	21621768.0
2015-08-26 14:00:00	AAPL	Stock	26.865	26.885	26.5625	26.6755	19207692.0
2015-08-26 14:30:00	AAPL	Stock	26.68	27.075	26.67	26.86	25229792.0
2015-08-26 15:00:00	AAPL	Stock	26.8575	27.175	26.81	27.0888	29647436.0
2015-08-26 15:30:00	AAPL	Stock	27.09	27.4725	27.085	27.425	41934176.0
2015-08-26 16:00:00	AAPL	Stock	27.425	27.4725	26.8388	27.45	23992544.0
2015-08-26 16:30:00	AAPL	Stock	27.44	27.4725	27.4225	27.47	313348.0
2015-08-26 17:00:00	AAPL	Stock	27.455	27.4725	27.455	27.4625	105396.0
2015-08-26 17:30:00	AAPL	Stock	27.4625	27.4725	27.455	27.455	100852.0
2015-08-26 18:00:00	AAPL	Stock	27.4625	27.4725	27.45	27.4675	105540.0
2015-08-26 18:30:00	AAPL	Stock	27.4725	27.485	27.455	27.475	107536.0
2015-08-26 19:00:00	AAPL	Stock	27.4875	27.5	27.4725	27.49	90588.0
2015-08-26 19:30:00	AAPL	Stock	27.5	27.6	27.4975	27.6	130872.0
2015-08-26 05:00:00	MSFT	Stock	41.25	41.25	40.73	40.83	2826.0
2015-08-26 05:30:00	MSFT	Stock	41.0	41.0	41.0	41.0	400.0
2015-08-26 06:00:00	MSFT	Stock	41.01	41.01	41.0	41.0	1000.0
2015-08-26 06:30:00	MSFT	Stock	41.18	41.4	41.1	41.35	25299.0
2015-08-26 07:00:00	MSFT	Stock	41.34	41.6	41.25	41.6	8452.0
2015-08-26 07:30:00	MSFT	Stock	41.42	41.57	41.4	41.4	38803.0
2015-08-26 08:00:00	MSFT	Stock	41.4	41.6	41.16	41.5	24559.0
2015-08-26 08:30:00	MSFT	Stock	41.5	41.86	41.5	41.75	63475.0
2015-08-26 09:00:00	MSFT	Stock	41.75	42.02	41.62	41.96	53736.0
2015-08-26 09:30:00	MSFT	Stock	42.01	42.02	41.33	41.65	6740700.0
2015-08-26 10:00:00	MSFT	Stock	41.65	41.74	41.17	41.59	5425879.0
2015-08-26 10:30:00	MSFT	Stock	41.59	41.82	41.34	41.43	4168332.0
2015-08-26 11:00:00	MSFT	Stock	41.43	41.51	41.24	41.44	2707453.0
2015-08-26 11:30:00	MSFT	Stock	41.42	41.49	41.06	41.31	3071293.0
2015-08-26 12:00:00	MSFT	Stock	41.31	41.45	41.18	41.246	1917057.0
2015-08-26 12:30:00	MSFT	Stock	41.24	41.38	41.1	41.35	2693385.0
2015-08-26 13:00:00	MSFT	Stock	41.34	41.44	41.12	41.34	3956180.0
2015-08-26 13:30:00	MSFT	Stock	41.35	41.54	41.26	41.42	4077794.0

> showing 50 of 84,813 rows — these rows as CSV

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