PREVIEW / stock_30min / 2019-06-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-07.parquet
  size:    1.7 MB
  rows:    83,121
  symbols: 2,607

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-06-07 04:00:00	AAPL	Stock	46.4275	46.575	46.4275	46.55	9612.0
2019-06-07 04:30:00	AAPL	Stock	46.575	46.625	46.575	46.625	12080.0
2019-06-07 05:00:00	AAPL	Stock	46.63	46.645	46.63	46.645	3956.0
2019-06-07 05:30:00	AAPL	Stock	46.6575	46.6575	46.6575	46.6575	400.0
2019-06-07 06:00:00	AAPL	Stock	46.65	46.655	46.595	46.595	5304.0
2019-06-07 06:30:00	AAPL	Stock	46.6375	46.6375	46.585	46.6	25816.0
2019-06-07 07:00:00	AAPL	Stock	46.5925	46.615	46.5375	46.55	36400.0
2019-06-07 07:30:00	AAPL	Stock	46.525	46.55	46.4675	46.4675	31636.0
2019-06-07 08:00:00	AAPL	Stock	46.6118	46.625	46.3825	46.5	259004.0
2019-06-07 08:30:00	AAPL	Stock	46.47	46.9	46.305	46.595	639840.0
2019-06-07 09:00:00	AAPL	Stock	46.5525	46.7	46.48	46.6425	249264.0
2019-06-07 09:30:00	AAPL	Stock	46.65	47.165	46.4425	47.1438	15459756.0
2019-06-07 10:00:00	AAPL	Stock	47.1425	47.53	47.1312	47.4728	11665168.0
2019-06-07 10:30:00	AAPL	Stock	47.47	47.9125	47.47	47.9125	12867940.0
2019-06-07 11:00:00	AAPL	Stock	47.9125	47.98	47.6075	47.6312	10339180.0
2019-06-07 11:30:00	AAPL	Stock	47.6325	47.75	47.5775	47.6225	6293912.0
2019-06-07 12:00:00	AAPL	Stock	47.615	47.6338	47.515	47.6175	4456412.0
2019-06-07 12:30:00	AAPL	Stock	47.6175	47.64	47.4925	47.565	4202844.0
2019-06-07 13:00:00	AAPL	Stock	47.5675	47.6375	47.4925	47.5425	3922404.0
2019-06-07 13:30:00	AAPL	Stock	47.5435	47.6275	47.54	47.6225	3556852.0
2019-06-07 14:00:00	AAPL	Stock	47.6175	47.6262	47.53	47.55	3283336.0
2019-06-07 14:30:00	AAPL	Stock	47.5475	47.61	47.4525	47.4878	4069832.0
2019-06-07 15:00:00	AAPL	Stock	47.4875	47.5513	47.4475	47.5412	4704944.0
2019-06-07 15:30:00	AAPL	Stock	47.54	47.56	47.465	47.535	12712520.0
2019-06-07 16:00:00	AAPL	Stock	47.5375	47.55	47.4925	47.5025	7739060.0
2019-06-07 16:30:00	AAPL	Stock	47.505	47.5375	47.495	47.525	602352.0
2019-06-07 17:00:00	AAPL	Stock	47.5372	47.5375	47.5	47.5125	25440.0
2019-06-07 17:30:00	AAPL	Stock	47.525	47.525	47.5	47.5	3300.0
2019-06-07 18:00:00	AAPL	Stock	47.5025	47.5025	47.4625	47.4875	20388.0
2019-06-07 18:30:00	AAPL	Stock	47.4975	47.5225	47.495	47.5175	28704.0
2019-06-07 19:00:00	AAPL	Stock	47.5175	47.5375	47.5175	47.535	8516.0
2019-06-07 19:30:00	AAPL	Stock	47.5475	47.5625	47.5375	47.5625	40304.0
2019-06-07 04:00:00	MSFT	Stock	128.0	128.07	128.0	128.07	1050.0
2019-06-07 04:30:00	MSFT	Stock	128.36	128.36	128.22	128.22	412.0
2019-06-07 05:00:00	MSFT	Stock	128.5	128.5	128.5	128.5	905.0
2019-06-07 05:30:00	MSFT	Stock	128.44	128.44	128.44	128.44	100.0
2019-06-07 06:00:00	MSFT	Stock	128.49	128.56	128.49	128.56	3027.0
2019-06-07 07:00:00	MSFT	Stock	128.57	128.68	128.45	128.45	1249.0
2019-06-07 07:30:00	MSFT	Stock	128.48	128.48	128.29	128.29	4415.0
2019-06-07 08:00:00	MSFT	Stock	128.48	128.6	128.1	128.4	48848.0
2019-06-07 08:30:00	MSFT	Stock	128.12	128.85	127.7	128.32	52148.0
2019-06-07 09:00:00	MSFT	Stock	128.3	129.27	128.15	128.87	32494.0
2019-06-07 09:30:00	MSFT	Stock	129.2	130.85	128.26	130.67	4955034.0
2019-06-07 10:00:00	MSFT	Stock	130.69	131.382	130.58	131.29	2867700.0
2019-06-07 10:30:00	MSFT	Stock	131.3	132.14	131.18	131.945	3776503.0
2019-06-07 11:00:00	MSFT	Stock	131.945	132.25	131.49	131.58	2269925.0
2019-06-07 11:30:00	MSFT	Stock	131.57	131.78	131.41	131.61	1496839.0
2019-06-07 12:00:00	MSFT	Stock	131.59	131.668	131.4	131.65	1349042.0
2019-06-07 12:30:00	MSFT	Stock	131.65	131.91	131.44	131.905	1166586.0
2019-06-07 13:00:00	MSFT	Stock	131.91	131.94	131.51	131.56	1125151.0

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

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