PREVIEW / stock_30min / 2016-02-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-12.parquet
  size:    1.6 MB
  rows:    82,085
  symbols: 3,341

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-02-12 04:00:00	AAPL	Stock	23.525	23.665	23.525	23.62	14972.0
2016-02-12 04:30:00	AAPL	Stock	23.5525	23.5525	23.5525	23.5525	400.0
2016-02-12 06:00:00	AAPL	Stock	23.55	23.55	23.55	23.55	932.0
2016-02-12 06:30:00	AAPL	Stock	23.555	23.6875	23.555	23.6875	52612.0
2016-02-12 07:00:00	AAPL	Stock	23.665	23.675	23.6025	23.6625	64276.0
2016-02-12 07:30:00	AAPL	Stock	23.65	23.6625	23.6025	23.6125	48112.0
2016-02-12 08:00:00	AAPL	Stock	23.6125	23.6425	23.5225	23.555	146784.0
2016-02-12 08:30:00	AAPL	Stock	23.5675	23.6125	23.545	23.5525	259988.0
2016-02-12 09:00:00	AAPL	Stock	23.545	23.6425	23.53	23.5475	247108.0
2016-02-12 09:30:00	AAPL	Stock	23.5475	23.625	23.305	23.3175	19481436.0
2016-02-12 10:00:00	AAPL	Stock	23.3175	23.385	23.2525	23.3438	15496516.0
2016-02-12 10:30:00	AAPL	Stock	23.3425	23.3575	23.2575	23.3075	10270112.0
2016-02-12 11:00:00	AAPL	Stock	23.31	23.565	23.31	23.5288	14418976.0
2016-02-12 11:30:00	AAPL	Stock	23.5298	23.545	23.449	23.49	9431756.0
2016-02-12 12:00:00	AAPL	Stock	23.4925	23.51	23.42	23.4475	6529388.0
2016-02-12 12:30:00	AAPL	Stock	23.45	23.4925	23.4275	23.4375	4706068.0
2016-02-12 13:00:00	AAPL	Stock	23.435	23.445	23.345	23.3775	6923676.0
2016-02-12 13:30:00	AAPL	Stock	23.375	23.4	23.345	23.3625	5868644.0
2016-02-12 14:00:00	AAPL	Stock	23.365	23.4825	23.3588	23.48	7202784.0
2016-02-12 14:30:00	AAPL	Stock	23.48	23.505	23.4585	23.4675	9161536.0
2016-02-12 15:00:00	AAPL	Stock	23.4675	23.5525	23.455	23.5	10690096.0
2016-02-12 15:30:00	AAPL	Stock	23.4992	23.5025	23.41	23.4975	17377892.0
2016-02-12 16:00:00	AAPL	Stock	23.4975	23.4975	23.4338	23.4525	9722808.0
2016-02-12 16:30:00	AAPL	Stock	23.46	23.4625	23.445	23.46	49728.0
2016-02-12 17:00:00	AAPL	Stock	23.45	23.4625	23.2785	23.45	82372.0
2016-02-12 17:30:00	AAPL	Stock	23.4525	23.455	23.45	23.455	16852.0
2016-02-12 18:00:00	AAPL	Stock	23.455	23.4625	23.4425	23.45	32064.0
2016-02-12 18:30:00	AAPL	Stock	23.4625	23.4625	23.4625	23.4625	2400.0
2016-02-12 19:00:00	AAPL	Stock	23.4625	23.4625	23.4375	23.4375	15108.0
2016-02-12 19:30:00	AAPL	Stock	23.4575	23.4625	23.44	23.4625	15400.0
2016-02-12 04:00:00	MSFT	Stock	50.1	50.1	50.1	50.1	2223.0
2016-02-12 05:30:00	MSFT	Stock	50.12	50.12	50.12	50.12	100.0
2016-02-12 06:30:00	MSFT	Stock	50.29	50.29	50.29	50.29	120.0
2016-02-12 07:00:00	MSFT	Stock	50.29	50.3	50.1	50.3	10300.0
2016-02-12 07:30:00	MSFT	Stock	50.22	50.25	50.22	50.25	1345.0
2016-02-12 08:00:00	MSFT	Stock	50.1	50.15	50.05	50.14	6665.0
2016-02-12 08:30:00	MSFT	Stock	50.14	50.3	50.14	50.24	33706.0
2016-02-12 09:00:00	MSFT	Stock	50.2	50.25	50.14	50.25	9018.0
2016-02-12 09:30:00	MSFT	Stock	50.25	50.35	49.81	49.87	3582001.0
2016-02-12 10:00:00	MSFT	Stock	49.87	50.09	49.75	50.05	2052416.0
2016-02-12 10:30:00	MSFT	Stock	50.05	50.17	49.98	50.09	1357568.0
2016-02-12 11:00:00	MSFT	Stock	50.095	50.54	50.01	50.52	1909588.0
2016-02-12 11:30:00	MSFT	Stock	50.52	50.68	50.32	50.34	1675075.0
2016-02-12 12:00:00	MSFT	Stock	50.35	50.43	50.3	50.325	1209901.0
2016-02-12 12:30:00	MSFT	Stock	50.325	50.36	50.19	50.208	1735614.0
2016-02-12 13:00:00	MSFT	Stock	50.2	50.24	49.94	50.047	1346072.0
2016-02-12 13:30:00	MSFT	Stock	50.05	50.09	49.91	49.98	1020309.0
2016-02-12 14:00:00	MSFT	Stock	49.975	50.31	49.96	50.27	1639618.0
2016-02-12 14:30:00	MSFT	Stock	50.265	50.52	50.25	50.51	1467071.0
2016-02-12 15:00:00	MSFT	Stock	50.51	50.51	50.31	50.4	2591051.0

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

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