PREVIEW / stock_30min / 2019-05-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-21.parquet
  size:    1.7 MB
  rows:    83,560
  symbols: 2,594

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-05-21 04:30:00	AAPL	Stock	46.05	46.05	45.9525	45.9525	11764.0
2019-05-21 05:00:00	AAPL	Stock	45.995	46.165	45.94	46.0875	36240.0
2019-05-21 05:30:00	AAPL	Stock	46.1875	46.3	46.125	46.3	27724.0
2019-05-21 06:00:00	AAPL	Stock	46.35	46.425	46.3275	46.3925	25012.0
2019-05-21 06:30:00	AAPL	Stock	46.3825	46.465	46.375	46.3875	38436.0
2019-05-21 07:00:00	AAPL	Stock	46.405	46.41	46.0875	46.13	151528.0
2019-05-21 07:30:00	AAPL	Stock	46.0875	46.2	46.0875	46.2	68616.0
2019-05-21 08:00:00	AAPL	Stock	46.2125	46.425	46.085	46.22	331656.0
2019-05-21 08:30:00	AAPL	Stock	46.2425	46.3725	46.19	46.355	249120.0
2019-05-21 09:00:00	AAPL	Stock	46.34	46.3875	46.2525	46.3	484176.0
2019-05-21 09:30:00	AAPL	Stock	46.305	46.58	46.175	46.515	16494356.0
2019-05-21 10:00:00	AAPL	Stock	46.515	46.625	46.3875	46.6168	9419572.0
2019-05-21 10:30:00	AAPL	Stock	46.6175	46.93	46.6175	46.93	9637612.0
2019-05-21 11:00:00	AAPL	Stock	46.9325	46.9625	46.79	46.8945	5998116.0
2019-05-21 11:30:00	AAPL	Stock	46.895	46.9125	46.6675	46.7325	5427008.0
2019-05-21 12:00:00	AAPL	Stock	46.735	46.9425	46.7175	46.87	5177980.0
2019-05-21 12:30:00	AAPL	Stock	46.8725	46.875	46.7425	46.7975	3316568.0
2019-05-21 13:00:00	AAPL	Stock	46.7975	46.8448	46.78	46.824	2744124.0
2019-05-21 13:30:00	AAPL	Stock	46.8225	46.8895	46.7988	46.885	2467236.0
2019-05-21 14:00:00	AAPL	Stock	46.885	46.99	46.8278	46.975	3320896.0
2019-05-21 14:30:00	AAPL	Stock	46.9825	47.0	46.8175	46.85	3699668.0
2019-05-21 15:00:00	AAPL	Stock	46.85	46.87	46.7175	46.775	4534032.0
2019-05-21 15:30:00	AAPL	Stock	46.7725	46.8525	46.5875	46.6475	9935596.0
2019-05-21 16:00:00	AAPL	Stock	46.65	46.7745	46.5525	46.565	11537952.0
2019-05-21 16:30:00	AAPL	Stock	46.575	46.65	46.53	46.5625	187264.0
2019-05-21 17:00:00	AAPL	Stock	46.5575	46.6	46.5575	46.6	5688.0
2019-05-21 17:30:00	AAPL	Stock	46.595	46.6	46.5525	46.5525	15972.0
2019-05-21 18:00:00	AAPL	Stock	46.575	46.6625	46.575	46.6625	42508.0
2019-05-21 18:30:00	AAPL	Stock	46.675	46.745	46.675	46.74	98484.0
2019-05-21 19:00:00	AAPL	Stock	46.735	46.745	46.69	46.7	18276.0
2019-05-21 19:30:00	AAPL	Stock	46.6925	46.7375	46.69	46.7375	15136.0
2019-05-21 04:00:00	MSFT	Stock	127.0	128.0	127.0	128.0	1620.0
2019-05-21 04:30:00	MSFT	Stock	127.5	127.5	127.5	127.5	100.0
2019-05-21 05:00:00	MSFT	Stock	127.26	127.44	127.1	127.44	679.0
2019-05-21 06:00:00	MSFT	Stock	127.48	127.6	127.48	127.6	1297.0
2019-05-21 06:30:00	MSFT	Stock	127.79	127.79	127.68	127.72	578.0
2019-05-21 07:00:00	MSFT	Stock	127.65	127.7	127.1	127.25	5280.0
2019-05-21 07:30:00	MSFT	Stock	127.12	127.25	127.0	127.25	8455.0
2019-05-21 08:00:00	MSFT	Stock	127.675	127.76	127.1	127.11	25115.0
2019-05-21 08:30:00	MSFT	Stock	127.2	127.5	127.1	127.3	26742.0
2019-05-21 09:00:00	MSFT	Stock	127.4	127.67	127.2	127.44	21041.0
2019-05-21 09:30:00	MSFT	Stock	127.45	127.527	126.86	126.936	1932758.0
2019-05-21 10:00:00	MSFT	Stock	126.93	127.07	126.58	126.887	1091695.0
2019-05-21 10:30:00	MSFT	Stock	126.89	127.46	126.78	127.295	974977.0
2019-05-21 11:00:00	MSFT	Stock	127.3	127.385	126.95	127.23	745941.0
2019-05-21 11:30:00	MSFT	Stock	127.23	127.27	126.74	126.85	715295.0
2019-05-21 12:00:00	MSFT	Stock	126.87	127.13	126.87	126.95	504857.0
2019-05-21 12:30:00	MSFT	Stock	126.95	127.01	126.76	127.01	495628.0
2019-05-21 13:00:00	MSFT	Stock	127.02	127.045	126.87	126.903	388888.0
2019-05-21 13:30:00	MSFT	Stock	126.9	127.105	126.835	127.083	415503.0

> showing 50 of 83,560 rows — these rows as CSV

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