PREVIEW / stock_30min / 2016-04-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-15.parquet
  size:    1.6 MB
  rows:    82,189
  symbols: 3,329

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-15 04:00:00	AAPL	Stock	27.95	27.95	27.95	27.95	4000.0
2016-04-15 04:30:00	AAPL	Stock	27.95	27.9575	27.95	27.9575	3952.0
2016-04-15 05:00:00	AAPL	Stock	27.95	27.97	27.95	27.97	5180.0
2016-04-15 06:30:00	AAPL	Stock	27.945	27.95	27.945	27.95	2800.0
2016-04-15 07:00:00	AAPL	Stock	27.9525	28.025	27.945	27.95	33704.0
2016-04-15 07:30:00	AAPL	Stock	27.965	27.965	27.9525	27.9525	5720.0
2016-04-15 08:00:00	AAPL	Stock	27.9575	28.045	27.955	28.01	88272.0
2016-04-15 08:30:00	AAPL	Stock	28.015	28.0225	27.9825	27.995	55984.0
2016-04-15 09:00:00	AAPL	Stock	27.9975	28.0625	27.9525	28.015	1297812.0
2016-04-15 09:30:00	AAPL	Stock	28.005	28.075	27.91	27.945	19119144.0
2016-04-15 10:00:00	AAPL	Stock	27.945	27.945	27.8775	27.9152	6742092.0
2016-04-15 10:30:00	AAPL	Stock	27.9152	27.99	27.9125	27.98	5357020.0
2016-04-15 11:00:00	AAPL	Stock	27.98	28.0175	27.96	28.005	4522108.0
2016-04-15 11:30:00	AAPL	Stock	28.0072	28.0125	27.975	27.9955	2868380.0
2016-04-15 12:00:00	AAPL	Stock	27.995	28.0	27.98	27.9825	2272968.0
2016-04-15 12:30:00	AAPL	Stock	27.9825	27.985	27.94	27.941	3161284.0
2016-04-15 13:00:00	AAPL	Stock	27.9415	27.95	27.4775	27.5175	36524052.0
2016-04-15 13:30:00	AAPL	Stock	27.5175	27.6275	27.445	27.5875	18689224.0
2016-04-15 14:00:00	AAPL	Stock	27.5875	27.6125	27.445	27.53	12211992.0
2016-04-15 14:30:00	AAPL	Stock	27.528	27.5725	27.4675	27.57	7765660.0
2016-04-15 15:00:00	AAPL	Stock	27.5675	27.57	27.4375	27.4875	10908284.0
2016-04-15 15:30:00	AAPL	Stock	27.486	27.5112	27.4325	27.4535	22412764.0
2016-04-15 16:00:00	AAPL	Stock	27.4625	27.9082	27.4375	27.465	11527912.0
2016-04-15 16:30:00	AAPL	Stock	27.4675	27.533	27.4425	27.4425	387196.0
2016-04-15 17:00:00	AAPL	Stock	27.45	27.4625	27.4175	27.425	1267180.0
2016-04-15 17:30:00	AAPL	Stock	27.425	27.425	27.3775	27.3975	45448.0
2016-04-15 18:00:00	AAPL	Stock	27.3875	27.4	27.3825	27.3825	36244.0
2016-04-15 18:30:00	AAPL	Stock	27.3875	27.405	27.3875	27.3975	24236.0
2016-04-15 19:00:00	AAPL	Stock	27.4	27.4	27.39	27.395	19044.0
2016-04-15 19:30:00	AAPL	Stock	27.395	27.4	27.39	27.4	49868.0
2016-04-15 07:00:00	MSFT	Stock	55.36	55.36	55.36	55.36	100.0
2016-04-15 08:00:00	MSFT	Stock	55.1	55.35	55.1	55.35	1500.0
2016-04-15 08:30:00	MSFT	Stock	55.37	55.37	55.27	55.27	5000.0
2016-04-15 09:00:00	MSFT	Stock	55.26	55.36	55.23	55.27	432111.0
2016-04-15 09:30:00	MSFT	Stock	55.27	55.79	55.11	55.77	6166553.0
2016-04-15 10:00:00	MSFT	Stock	55.769	55.92	55.725	55.845	2138561.0
2016-04-15 10:30:00	MSFT	Stock	55.845	55.865	55.73	55.795	1195731.0
2016-04-15 11:00:00	MSFT	Stock	55.79	55.805	55.69	55.77	1360438.0
2016-04-15 11:30:00	MSFT	Stock	55.77	55.79	55.68	55.73	950155.0
2016-04-15 12:00:00	MSFT	Stock	55.74	55.81	55.7	55.765	766235.0
2016-04-15 12:30:00	MSFT	Stock	55.76	55.785	55.695	55.75	676610.0
2016-04-15 13:00:00	MSFT	Stock	55.75	55.76	55.69	55.72	911757.0
2016-04-15 13:30:00	MSFT	Stock	55.71	55.72	55.49	55.52	804271.0
2016-04-15 14:00:00	MSFT	Stock	55.524	55.57	55.4	55.523	1172856.0
2016-04-15 14:30:00	MSFT	Stock	55.525	55.525	55.39	55.465	1105387.0
2016-04-15 15:00:00	MSFT	Stock	55.467	55.56	55.42	55.53	1076433.0
2016-04-15 15:30:00	MSFT	Stock	55.53	55.69	55.53	55.64	4036438.0
2016-04-15 16:00:00	MSFT	Stock	55.65	55.65	55.6	55.63	2962494.0
2016-04-15 16:30:00	MSFT	Stock	55.65	55.65	55.54	55.55	29832.0
2016-04-15 17:00:00	MSFT	Stock	55.55	55.55	55.55	55.55	400.0

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

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