PREVIEW / stock_30min / 2016-04-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-28.parquet
  size:    1.6 MB
  rows:    82,069
  symbols: 3,323

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-04-28 04:00:00	AAPL	Stock	24.5	24.5	24.275	24.3675	9548.0
2016-04-28 04:30:00	AAPL	Stock	24.32	24.32	24.32	24.32	7396.0
2016-04-28 05:00:00	AAPL	Stock	24.3	24.35	24.275	24.35	15756.0
2016-04-28 05:30:00	AAPL	Stock	24.35	24.35	24.35	24.35	1868.0
2016-04-28 06:00:00	AAPL	Stock	24.33	24.35	24.33	24.35	2408.0
2016-04-28 06:30:00	AAPL	Stock	24.325	24.3725	24.325	24.34	25128.0
2016-04-28 07:00:00	AAPL	Stock	24.3575	24.375	24.3475	24.3625	31348.0
2016-04-28 07:30:00	AAPL	Stock	24.3575	24.3575	24.3075	24.325	57236.0
2016-04-28 08:00:00	AAPL	Stock	24.35	24.525	24.3125	24.3775	204680.0
2016-04-28 08:30:00	AAPL	Stock	24.4025	24.4025	24.3575	24.3925	211956.0
2016-04-28 09:00:00	AAPL	Stock	24.3925	24.405	24.325	24.3825	189456.0
2016-04-28 09:30:00	AAPL	Stock	24.4025	24.45	24.1475	24.3102	34176996.0
2016-04-28 10:00:00	AAPL	Stock	24.31	24.3725	24.2275	24.3075	17207896.0
2016-04-28 10:30:00	AAPL	Stock	24.3082	24.47	24.265	24.4475	16210836.0
2016-04-28 11:00:00	AAPL	Stock	24.4475	24.46	24.3075	24.3668	11968020.0
2016-04-28 11:30:00	AAPL	Stock	24.365	24.395	24.3088	24.3108	7937200.0
2016-04-28 12:00:00	AAPL	Stock	24.311	24.3425	24.2275	24.245	8676248.0
2016-04-28 12:30:00	AAPL	Stock	24.245	24.265	24.2262	24.232	8270304.0
2016-04-28 13:00:00	AAPL	Stock	24.23	24.305	24.1875	24.29	12138860.0
2016-04-28 13:30:00	AAPL	Stock	24.29	24.3075	24.205	24.205	7373096.0
2016-04-28 14:00:00	AAPL	Stock	24.2055	24.2375	23.975	24.092	49881240.0
2016-04-28 14:30:00	AAPL	Stock	24.091	24.095	23.8625	23.8912	31198988.0
2016-04-28 15:00:00	AAPL	Stock	23.8925	23.9075	23.5625	23.605	45547120.0
2016-04-28 15:30:00	AAPL	Stock	23.605	23.7825	23.605	23.705	43841876.0
2016-04-28 16:00:00	AAPL	Stock	23.7075	24.2535	23.6875	23.7875	9556272.0
2016-04-28 16:30:00	AAPL	Stock	23.785	23.7975	23.7075	23.7825	364956.0
2016-04-28 17:00:00	AAPL	Stock	23.7875	23.8	23.77	23.7825	76684.0
2016-04-28 17:30:00	AAPL	Stock	23.775	23.785	23.76	23.785	104784.0
2016-04-28 18:00:00	AAPL	Stock	23.7775	23.7875	23.75	23.775	99756.0
2016-04-28 18:30:00	AAPL	Stock	23.7825	23.7825	23.7525	23.7675	79580.0
2016-04-28 19:00:00	AAPL	Stock	23.7575	23.78	23.755	23.78	47164.0
2016-04-28 19:30:00	AAPL	Stock	23.7825	23.79	23.76	23.77	87876.0
2016-04-28 04:00:00	MSFT	Stock	50.67	50.67	50.67	50.67	100.0
2016-04-28 06:00:00	MSFT	Stock	50.6	50.6	50.6	50.6	3000.0
2016-04-28 06:30:00	MSFT	Stock	50.56	50.58	50.55	50.58	1346.0
2016-04-28 07:00:00	MSFT	Stock	50.59	50.72	50.58	50.65	6485.0
2016-04-28 07:30:00	MSFT	Stock	50.65	50.65	50.61	50.61	1266.0
2016-04-28 08:00:00	MSFT	Stock	50.67	50.78	50.62	50.62	18217.0
2016-04-28 08:30:00	MSFT	Stock	50.64	50.78	50.6	50.78	14456.0
2016-04-28 09:00:00	MSFT	Stock	50.77	50.77	50.6	50.62	26115.0
2016-04-28 09:30:00	MSFT	Stock	50.62	50.77	50.36	50.58	3843520.0
2016-04-28 10:00:00	MSFT	Stock	50.575	50.61	50.3	50.44	2402650.0
2016-04-28 10:30:00	MSFT	Stock	50.45	50.56	50.4	50.5	1984290.0
2016-04-28 11:00:00	MSFT	Stock	50.5	50.65	50.49	50.61	1319362.0
2016-04-28 11:30:00	MSFT	Stock	50.61	50.66	50.53	50.57	1012959.0
2016-04-28 12:00:00	MSFT	Stock	50.56	50.62	50.32	50.332	1686980.0
2016-04-28 12:30:00	MSFT	Stock	50.33	50.35	50.26	50.285	1579914.0
2016-04-28 13:00:00	MSFT	Stock	50.29	50.31	50.09	50.207	2975481.0
2016-04-28 13:30:00	MSFT	Stock	50.203	50.28	50.115	50.15	1403023.0
2016-04-28 14:00:00	MSFT	Stock	50.155	50.26	50.12	50.23	1929873.0

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

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