PREVIEW / stock_30min / 2015-07-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-01.parquet
  size:    1.6 MB
  rows:    84,004
  symbols: 3,487

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-07-01 04:00:00	AAPL	Stock	31.4975	31.5475	31.4725	31.54	4680.0
2015-07-01 04:30:00	AAPL	Stock	31.54	31.57	31.5275	31.57	12480.0
2015-07-01 05:00:00	AAPL	Stock	31.5675	31.7	31.5675	31.675	19800.0
2015-07-01 05:30:00	AAPL	Stock	31.6925	31.6925	31.685	31.685	2160.0
2015-07-01 06:00:00	AAPL	Stock	31.675	31.6875	31.605	31.605	35792.0
2015-07-01 06:30:00	AAPL	Stock	31.6075	31.675	31.6075	31.675	41032.0
2015-07-01 07:00:00	AAPL	Stock	31.675	31.7375	31.65	31.6825	253020.0
2015-07-01 07:30:00	AAPL	Stock	31.6875	31.74	31.6625	31.685	190444.0
2015-07-01 08:00:00	AAPL	Stock	31.3562	31.7375	31.3562	31.69	387488.0
2015-07-01 08:30:00	AAPL	Stock	31.6975	31.725	31.68	31.7075	276076.0
2015-07-01 09:00:00	AAPL	Stock	31.72	31.735	31.7075	31.71	364012.0
2015-07-01 09:30:00	AAPL	Stock	31.7275	31.735	31.5825	31.6875	21742684.0
2015-07-01 10:00:00	AAPL	Stock	31.6888	31.7225	31.6462	31.685	12079404.0
2015-07-01 10:30:00	AAPL	Stock	31.6825	31.6875	31.5775	31.6262	9961292.0
2015-07-01 11:00:00	AAPL	Stock	31.6275	31.6375	31.58	31.605	6168108.0
2015-07-01 11:30:00	AAPL	Stock	31.6075	31.6375	31.55	31.5625	5970020.0
2015-07-01 12:00:00	AAPL	Stock	31.5625	31.6025	31.5325	31.569	4925956.0
2015-07-01 12:30:00	AAPL	Stock	31.5675	31.5875	31.5175	31.545	5119320.0
2015-07-01 13:00:00	AAPL	Stock	31.5448	31.5875	31.5025	31.575	5166372.0
2015-07-01 13:30:00	AAPL	Stock	31.5738	31.6175	31.5305	31.5375	5057000.0
2015-07-01 14:00:00	AAPL	Stock	31.54	31.5725	31.505	31.53	4916268.0
2015-07-01 14:30:00	AAPL	Stock	31.53	31.5502	31.4975	31.53	4986260.0
2015-07-01 15:00:00	AAPL	Stock	31.53	31.5972	31.5285	31.5925	4516396.0
2015-07-01 15:30:00	AAPL	Stock	31.5925	31.65	31.5628	31.645	12384852.0
2015-07-01 16:00:00	AAPL	Stock	31.65	31.68	31.6125	31.6125	5687592.0
2015-07-01 16:30:00	AAPL	Stock	31.6125	31.6375	31.6025	31.625	69604.0
2015-07-01 17:00:00	AAPL	Stock	31.62	31.6475	31.62	31.625	61340.0
2015-07-01 17:30:00	AAPL	Stock	31.6475	31.65	31.6375	31.6375	16900.0
2015-07-01 18:00:00	AAPL	Stock	31.645	31.645	31.6125	31.6125	23844.0
2015-07-01 18:30:00	AAPL	Stock	31.6125	31.6225	31.61	31.615	10648.0
2015-07-01 19:00:00	AAPL	Stock	31.625	31.6275	31.6125	31.6125	12464.0
2015-07-01 19:30:00	AAPL	Stock	31.6075	31.6125	31.6025	31.6125	29704.0
2015-07-01 05:00:00	MSFT	Stock	44.49	44.49	44.49	44.49	100.0
2015-07-01 05:30:00	MSFT	Stock	44.62	44.62	44.62	44.62	200.0
2015-07-01 06:00:00	MSFT	Stock	44.56	44.56	44.56	44.56	1900.0
2015-07-01 06:30:00	MSFT	Stock	44.49	44.55	44.49	44.55	500.0
2015-07-01 07:00:00	MSFT	Stock	44.49	44.49	44.49	44.49	8757.0
2015-07-01 07:30:00	MSFT	Stock	44.49	44.49	44.45	44.45	1100.0
2015-07-01 08:00:00	MSFT	Stock	44.15	44.49	44.15	44.45	25488.0
2015-07-01 08:30:00	MSFT	Stock	44.45	44.47	44.15	44.47	8644.0
2015-07-01 09:00:00	MSFT	Stock	44.15	44.58	44.15	44.45	36059.0
2015-07-01 09:30:00	MSFT	Stock	44.46	45.23	44.38	45.08	5196528.0
2015-07-01 10:00:00	MSFT	Stock	45.08	45.12	44.87	44.9	2535625.0
2015-07-01 10:30:00	MSFT	Stock	44.895	44.92	44.48	44.655	3359319.0
2015-07-01 11:00:00	MSFT	Stock	44.66	44.7	44.57	44.62	1548091.0
2015-07-01 11:30:00	MSFT	Stock	44.61	44.64	44.48	44.6	1179575.0
2015-07-01 12:00:00	MSFT	Stock	44.6	44.63	44.43	44.435	1234962.0
2015-07-01 12:30:00	MSFT	Stock	44.435	44.51	44.22	44.26	1444607.0
2015-07-01 13:00:00	MSFT	Stock	44.25	44.36	44.21	44.3	1208243.0
2015-07-01 13:30:00	MSFT	Stock	44.3	44.35	44.2	44.22	1095841.0

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

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