PREVIEW / stock_30min / 2019-03-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-26.parquet
  size:    1.7 MB
  rows:    84,651
  symbols: 2,652

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-26 04:00:00	AAPL	Stock	47.445	47.4625	47.0	47.17	76728.0
2019-03-26 04:30:00	AAPL	Stock	47.1625	47.1625	47.1625	47.1625	600.0
2019-03-26 05:00:00	AAPL	Stock	47.25	47.25	47.2475	47.2475	10072.0
2019-03-26 05:30:00	AAPL	Stock	47.335	47.38	47.335	47.375	11948.0
2019-03-26 06:00:00	AAPL	Stock	47.485	47.4875	47.3975	47.4625	14280.0
2019-03-26 06:30:00	AAPL	Stock	47.4925	47.58	47.4925	47.575	44444.0
2019-03-26 07:00:00	AAPL	Stock	47.5475	47.805	47.515	47.725	363708.0
2019-03-26 07:30:00	AAPL	Stock	47.7025	47.75	47.6125	47.6925	205744.0
2019-03-26 08:00:00	AAPL	Stock	47.5625	47.8725	47.5425	47.85	632688.0
2019-03-26 08:30:00	AAPL	Stock	47.8475	48.0325	47.725	47.7725	665624.0
2019-03-26 09:00:00	AAPL	Stock	47.775	47.925	47.7525	47.875	668092.0
2019-03-26 09:30:00	AAPL	Stock	47.8725	48.125	47.54	48.1175	23751392.0
2019-03-26 10:00:00	AAPL	Stock	48.12	48.22	47.82	47.9845	15298772.0
2019-03-26 10:30:00	AAPL	Stock	47.985	48.075	47.7675	48.07	9838132.0
2019-03-26 11:00:00	AAPL	Stock	48.0675	48.11	47.8375	47.905	8308648.0
2019-03-26 11:30:00	AAPL	Stock	47.905	47.9875	47.6925	47.7875	7297084.0
2019-03-26 12:00:00	AAPL	Stock	47.79	47.88	47.6825	47.695	5510344.0
2019-03-26 12:30:00	AAPL	Stock	47.6925	47.7675	47.5425	47.655	6237244.0
2019-03-26 13:00:00	AAPL	Stock	47.6525	47.77	47.58	47.6265	4559976.0
2019-03-26 13:30:00	AAPL	Stock	47.6275	47.635	47.2	47.269	13116360.0
2019-03-26 14:00:00	AAPL	Stock	47.2675	47.345	47.035	47.04	8758812.0
2019-03-26 14:30:00	AAPL	Stock	47.04	47.0775	46.71	46.7375	11843752.0
2019-03-26 15:00:00	AAPL	Stock	46.7375	46.9022	46.3802	46.397	12461004.0
2019-03-26 15:30:00	AAPL	Stock	46.395	46.6975	46.145	46.6975	22662468.0
2019-03-26 16:00:00	AAPL	Stock	46.6975	46.745	46.62	46.63	17984148.0
2019-03-26 16:30:00	AAPL	Stock	46.65	47.2575	46.6275	46.89	514056.0
2019-03-26 17:00:00	AAPL	Stock	46.84	47.1375	46.84	47.0	137772.0
2019-03-26 17:30:00	AAPL	Stock	47.0025	47.035	46.95	47.0	57188.0
2019-03-26 18:00:00	AAPL	Stock	47.0175	47.1475	47.01	47.0375	113072.0
2019-03-26 18:30:00	AAPL	Stock	47.0375	47.0625	47.0	47.0	51276.0
2019-03-26 19:00:00	AAPL	Stock	46.97	47.045	46.88	47.0	67108.0
2019-03-26 19:30:00	AAPL	Stock	46.9925	47.0375	46.96	46.97	52436.0
2019-03-26 04:00:00	MSFT	Stock	118.1	118.13	117.96	117.96	1331.0
2019-03-26 05:00:00	MSFT	Stock	117.9	117.9	117.9	117.9	1000.0
2019-03-26 05:30:00	MSFT	Stock	118.39	118.39	118.35	118.35	300.0
2019-03-26 06:00:00	MSFT	Stock	118.39	118.45	118.24	118.34	5810.0
2019-03-26 06:30:00	MSFT	Stock	118.44	118.45	118.23	118.45	2372.0
2019-03-26 07:00:00	MSFT	Stock	118.26	118.35	118.2	118.27	10980.0
2019-03-26 07:30:00	MSFT	Stock	118.22	118.28	118.2	118.28	3184.0
2019-03-26 08:00:00	MSFT	Stock	118.28	118.5	118.15	118.25	39179.0
2019-03-26 08:30:00	MSFT	Stock	118.2	118.3	118.05	118.1	35644.0
2019-03-26 09:00:00	MSFT	Stock	118.13	118.31	118.1	118.27	27192.0
2019-03-26 09:30:00	MSFT	Stock	118.38	118.62	117.82	118.53	2799125.0
2019-03-26 10:00:00	MSFT	Stock	118.54	118.705	117.95	118.008	1974339.0
2019-03-26 10:30:00	MSFT	Stock	118.0	118.09	117.535	117.99	2510903.0
2019-03-26 11:00:00	MSFT	Stock	117.99	118.23	117.814	117.87	1575151.0
2019-03-26 11:30:00	MSFT	Stock	117.87	118.0	117.31	117.61	1295148.0
2019-03-26 12:00:00	MSFT	Stock	117.61	117.76	117.39	117.49	1039907.0
2019-03-26 12:30:00	MSFT	Stock	117.485	117.56	117.12	117.39	1093385.0
2019-03-26 13:00:00	MSFT	Stock	117.4	117.58	117.294	117.35	897080.0

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

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