PREVIEW / stock_30min / 2019-03-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-13.parquet
  size:    1.7 MB
  rows:    85,011
  symbols: 2,644

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
2019-03-13 04:00:00	AAPL	Stock	45.235	45.235	45.235	45.235	400.0
2019-03-13 04:30:00	AAPL	Stock	45.2625	45.2625	45.25	45.25	3604.0
2019-03-13 05:30:00	AAPL	Stock	45.2775	45.2775	45.2775	45.2775	1592.0
2019-03-13 06:00:00	AAPL	Stock	45.34	45.35	45.34	45.345	7160.0
2019-03-13 06:30:00	AAPL	Stock	45.325	45.325	45.325	45.325	1108.0
2019-03-13 07:00:00	AAPL	Stock	45.33	45.4	45.3275	45.39	36096.0
2019-03-13 07:30:00	AAPL	Stock	45.3825	45.475	45.3725	45.46	88136.0
2019-03-13 08:00:00	AAPL	Stock	45.375	45.5	45.34	45.42	219196.0
2019-03-13 08:30:00	AAPL	Stock	45.4225	45.4675	45.405	45.4325	144540.0
2019-03-13 09:00:00	AAPL	Stock	45.4125	45.62	45.4125	45.585	201732.0
2019-03-13 09:30:00	AAPL	Stock	45.5725	45.825	45.3888	45.4275	15814184.0
2019-03-13 10:00:00	AAPL	Stock	45.4325	45.4875	45.23	45.2875	8859952.0
2019-03-13 10:30:00	AAPL	Stock	45.2862	45.435	45.23	45.405	7655596.0
2019-03-13 11:00:00	AAPL	Stock	45.41	45.5725	45.4075	45.53	6836840.0
2019-03-13 11:30:00	AAPL	Stock	45.5325	45.565	45.4075	45.4325	5712772.0
2019-03-13 12:00:00	AAPL	Stock	45.4325	45.4975	45.4275	45.4475	3396040.0
2019-03-13 12:30:00	AAPL	Stock	45.4462	45.5625	45.4375	45.535	3598588.0
2019-03-13 13:00:00	AAPL	Stock	45.5375	45.5525	45.5025	45.545	2944516.0
2019-03-13 13:30:00	AAPL	Stock	45.545	45.65	45.515	45.65	4208812.0
2019-03-13 14:00:00	AAPL	Stock	45.65	45.7075	45.6375	45.6525	5693824.0
2019-03-13 14:30:00	AAPL	Stock	45.6525	45.6975	45.5575	45.6325	6851220.0
2019-03-13 15:00:00	AAPL	Stock	45.63	45.645	45.5175	45.5675	4838348.0
2019-03-13 15:30:00	AAPL	Stock	45.565	45.6325	45.4	45.43	9386032.0
2019-03-13 16:00:00	AAPL	Stock	45.375	45.47	45.375	45.44	25014784.0
2019-03-13 16:30:00	AAPL	Stock	45.455	45.51	45.4275	45.475	124416.0
2019-03-13 17:00:00	AAPL	Stock	45.4675	45.47	45.445	45.445	26688.0
2019-03-13 17:30:00	AAPL	Stock	45.4425	45.57	45.4425	45.565	76720.0
2019-03-13 18:00:00	AAPL	Stock	45.5725	45.62	45.4275	45.6	50928.0
2019-03-13 18:30:00	AAPL	Stock	45.585	45.6875	45.585	45.6375	133368.0
2019-03-13 19:00:00	AAPL	Stock	45.645	45.65	45.6	45.625	34028.0
2019-03-13 19:30:00	AAPL	Stock	45.625	45.6375	45.5625	45.615	44076.0
2019-03-13 04:00:00	MSFT	Stock	113.43	113.43	113.43	113.43	200.0
2019-03-13 04:30:00	MSFT	Stock	113.6	113.6	113.6	113.6	400.0
2019-03-13 06:00:00	MSFT	Stock	113.83	113.83	113.79	113.8	600.0
2019-03-13 07:00:00	MSFT	Stock	113.75	113.98	113.75	113.88	2707.0
2019-03-13 07:30:00	MSFT	Stock	113.9	114.0	113.89	114.0	9762.0
2019-03-13 08:00:00	MSFT	Stock	113.85	114.19	113.82	114.18	12635.0
2019-03-13 08:30:00	MSFT	Stock	114.03	114.12	113.92	113.95	14887.0
2019-03-13 09:00:00	MSFT	Stock	113.95	114.2	113.43	113.99	26834.0
2019-03-13 09:30:00	MSFT	Stock	114.13	114.58	113.78	114.38	2726796.0
2019-03-13 10:00:00	MSFT	Stock	114.39	114.45	114.07	114.2	1528034.0
2019-03-13 10:30:00	MSFT	Stock	114.21	114.6	114.15	114.5	1375628.0
2019-03-13 11:00:00	MSFT	Stock	114.5	114.905	114.48	114.9	1421386.0
2019-03-13 11:30:00	MSFT	Stock	114.9	114.95	114.75	114.78	907785.0
2019-03-13 12:00:00	MSFT	Stock	114.79	114.8	114.51	114.64	1174504.0
2019-03-13 12:30:00	MSFT	Stock	114.64	114.69	114.44	114.55	764847.0
2019-03-13 13:00:00	MSFT	Stock	114.55	114.68	114.49	114.61	667682.0
2019-03-13 13:30:00	MSFT	Stock	114.603	114.74	114.53	114.735	855655.0
2019-03-13 14:00:00	MSFT	Stock	114.735	115.0	114.68	114.865	1412542.0
2019-03-13 14:30:00	MSFT	Stock	114.85	114.87	114.45	114.63	1483093.0

> showing 50 of 85,011 rows — these rows as CSV

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