PREVIEW / stock_30min / 2019-04-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-25.parquet
  size:    1.7 MB
  rows:    83,806
  symbols: 2,608

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-04-25 04:00:00	AAPL	Stock	51.965	51.965	51.8625	51.8925	12212.0
2019-04-25 04:30:00	AAPL	Stock	51.885	51.885	51.885	51.885	400.0
2019-04-25 05:30:00	AAPL	Stock	51.9	51.9125	51.875	51.875	7044.0
2019-04-25 06:00:00	AAPL	Stock	51.8875	51.925	51.8775	51.9	4560.0
2019-04-25 06:30:00	AAPL	Stock	51.875	51.875	51.805	51.8625	13876.0
2019-04-25 07:00:00	AAPL	Stock	51.8475	51.9925	51.8475	51.8975	50404.0
2019-04-25 07:30:00	AAPL	Stock	51.95	51.95	51.8875	51.9375	32656.0
2019-04-25 08:00:00	AAPL	Stock	51.95	51.9725	51.8625	51.9625	122916.0
2019-04-25 08:30:00	AAPL	Stock	51.95	51.95	51.8575	51.8575	121036.0
2019-04-25 09:00:00	AAPL	Stock	51.885	51.895	51.6925	51.71	276356.0
2019-04-25 09:30:00	AAPL	Stock	51.71	51.94	51.6625	51.6925	11002916.0
2019-04-25 10:00:00	AAPL	Stock	51.6925	51.8075	51.28	51.42	9007836.0
2019-04-25 10:30:00	AAPL	Stock	51.4175	51.5575	51.33	51.5212	4378388.0
2019-04-25 11:00:00	AAPL	Stock	51.52	51.65	51.42	51.585	3396228.0
2019-04-25 11:30:00	AAPL	Stock	51.5925	51.6925	51.5625	51.5625	2579244.0
2019-04-25 12:00:00	AAPL	Stock	51.5675	51.61	51.4275	51.555	3153200.0
2019-04-25 12:30:00	AAPL	Stock	51.555	51.6025	51.495	51.5225	1764196.0
2019-04-25 13:00:00	AAPL	Stock	51.525	51.58	51.375	51.485	2722148.0
2019-04-25 13:30:00	AAPL	Stock	51.4852	51.5375	51.4612	51.5275	1733648.0
2019-04-25 14:00:00	AAPL	Stock	51.5275	51.61	51.525	51.54	2138516.0
2019-04-25 14:30:00	AAPL	Stock	51.54	51.5562	51.465	51.535	2182992.0
2019-04-25 15:00:00	AAPL	Stock	51.535	51.565	51.3775	51.3988	2823964.0
2019-04-25 15:30:00	AAPL	Stock	51.4	51.42	51.2825	51.31	9325340.0
2019-04-25 16:00:00	AAPL	Stock	51.32	51.3625	51.175	51.3175	5763816.0
2019-04-25 16:30:00	AAPL	Stock	51.3175	51.33	51.25	51.25	57900.0
2019-04-25 17:00:00	AAPL	Stock	51.295	51.295	51.1225	51.1225	125172.0
2019-04-25 17:30:00	AAPL	Stock	51.11	51.25	51.0375	51.2225	101024.0
2019-04-25 18:00:00	AAPL	Stock	51.175	51.225	51.15	51.1625	34464.0
2019-04-25 18:30:00	AAPL	Stock	51.22	51.22	51.1675	51.195	11212.0
2019-04-25 19:00:00	AAPL	Stock	51.195	51.2	51.155	51.1725	8748.0
2019-04-25 19:30:00	AAPL	Stock	51.1612	51.2925	51.15	51.2925	57888.0
2019-04-25 04:00:00	MSFT	Stock	129.35	130.23	129.35	130.23	18541.0
2019-04-25 04:30:00	MSFT	Stock	130.22	130.23	130.0	130.0	8088.0
2019-04-25 05:00:00	MSFT	Stock	130.05	130.14	129.99	130.14	6217.0
2019-04-25 05:30:00	MSFT	Stock	130.06	130.3	130.02	130.3	4127.0
2019-04-25 06:00:00	MSFT	Stock	130.46	131.0	130.35	130.9	7573.0
2019-04-25 06:30:00	MSFT	Stock	130.9	131.5	130.9	131.2	43209.0
2019-04-25 07:00:00	MSFT	Stock	131.29	131.5	130.89	131.0	77804.0
2019-04-25 07:30:00	MSFT	Stock	131.0	131.26	130.5	130.85	76858.0
2019-04-25 08:00:00	MSFT	Stock	131.14	131.85	130.56	131.75	254657.0
2019-04-25 08:30:00	MSFT	Stock	131.67	131.75	131.07	131.07	180640.0
2019-04-25 09:00:00	MSFT	Stock	131.08	131.08	129.99	130.06	493379.0
2019-04-25 09:30:00	MSFT	Stock	130.06	131.37	129.07	130.14	9280536.0
2019-04-25 10:00:00	MSFT	Stock	130.13	130.34	128.83	129.548	4888557.0
2019-04-25 10:30:00	MSFT	Stock	129.54	129.96	129.12	129.88	2194218.0
2019-04-25 11:00:00	MSFT	Stock	129.87	129.97	129.42	129.88	1891169.0
2019-04-25 11:30:00	MSFT	Stock	129.88	130.18	129.66	129.672	1606309.0
2019-04-25 12:00:00	MSFT	Stock	129.67	129.815	129.58	129.585	1178507.0
2019-04-25 12:30:00	MSFT	Stock	129.58	129.695	129.14	129.28	1075598.0
2019-04-25 13:00:00	MSFT	Stock	129.282	129.36	129.08	129.205	873818.0

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

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