PREVIEW / stock_30min / 2020-08-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-21.parquet
  size:    1.9 MB
  rows:    96,083
  symbols: 2,448

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
2020-08-21 04:00:00	AAPL	Stock	119.345	119.345	119.075	119.075	31800.0
2020-08-21 04:30:00	AAPL	Stock	119.05	119.0625	118.88	119.0625	36708.0
2020-08-21 05:00:00	AAPL	Stock	119.0625	119.3175	119.06	119.305	13992.0
2020-08-21 05:30:00	AAPL	Stock	119.25	119.3175	119.2	119.215	17952.0
2020-08-21 06:00:00	AAPL	Stock	119.23	119.2325	119.0075	119.0175	16348.0
2020-08-21 06:30:00	AAPL	Stock	119.0975	119.1175	118.755	118.8	81700.0
2020-08-21 07:00:00	AAPL	Stock	118.935	119.2025	118.8625	119.025	406532.0
2020-08-21 07:30:00	AAPL	Stock	119.025	119.1125	118.8	118.825	431676.0
2020-08-21 08:00:00	AAPL	Stock	119.0988	119.1875	118.5	118.9375	944912.0
2020-08-21 08:30:00	AAPL	Stock	118.9275	119.3125	118.875	119.2662	796832.0
2020-08-21 09:00:00	AAPL	Stock	119.27	119.8375	119.15	119.24	1939148.0
2020-08-21 09:30:00	AAPL	Stock	119.24	120.8475	119.24	120.755	31296496.0
2020-08-21 10:00:00	AAPL	Stock	120.7788	121.94	120.385	121.7375	21465104.0
2020-08-21 10:30:00	AAPL	Stock	121.7375	123.2375	121.63	123.119	29297520.0
2020-08-21 11:00:00	AAPL	Stock	123.11	123.3975	122.3025	123.2375	25064764.0
2020-08-21 11:30:00	AAPL	Stock	123.2525	123.3075	121.94	122.0625	17166396.0
2020-08-21 12:00:00	AAPL	Stock	122.055	122.7575	121.9775	122.535	12458036.0
2020-08-21 12:30:00	AAPL	Stock	122.5398	123.1698	122.5175	123.1058	11174420.0
2020-08-21 13:00:00	AAPL	Stock	123.1028	123.1525	122.16	122.4125	11668012.0
2020-08-21 13:30:00	AAPL	Stock	122.4075	122.86	122.305	122.6325	8906084.0
2020-08-21 14:00:00	AAPL	Stock	122.6282	123.345	122.595	123.337	9314928.0
2020-08-21 14:30:00	AAPL	Stock	123.325	124.0725	123.1025	124.025	18635548.0
2020-08-21 15:00:00	AAPL	Stock	124.0175	124.868	124.0125	124.285	27802712.0
2020-08-21 15:30:00	AAPL	Stock	124.2912	124.7975	123.625	124.35	28681252.0
2020-08-21 16:00:00	AAPL	Stock	124.35	124.675	121.55	124.525	8083728.0
2020-08-21 16:30:00	AAPL	Stock	124.52	124.7225	124.37	124.715	319084.0
2020-08-21 17:00:00	AAPL	Stock	124.7175	124.725	124.62	124.65	308144.0
2020-08-21 17:30:00	AAPL	Stock	124.65	124.7	124.6175	124.675	146248.0
2020-08-21 18:00:00	AAPL	Stock	124.675	124.7	124.6175	124.635	187128.0
2020-08-21 18:30:00	AAPL	Stock	124.645	124.71	124.635	124.6875	118344.0
2020-08-21 19:00:00	AAPL	Stock	124.6875	124.6975	124.6575	124.675	106420.0
2020-08-21 19:30:00	AAPL	Stock	124.6625	124.7475	124.625	124.7375	254168.0
2020-08-21 04:00:00	MSFT	Stock	214.07	214.19	214.0	214.0	1463.0
2020-08-21 04:30:00	MSFT	Stock	213.64	213.84	213.53	213.84	3391.0
2020-08-21 05:00:00	MSFT	Stock	214.09	214.19	213.87	213.99	1512.0
2020-08-21 05:30:00	MSFT	Stock	214.01	214.01	213.61	213.9	1569.0
2020-08-21 06:00:00	MSFT	Stock	213.57	213.73	213.21	213.31	1874.0
2020-08-21 06:30:00	MSFT	Stock	213.73	213.84	213.08	213.49	4926.0
2020-08-21 07:00:00	MSFT	Stock	213.5	213.73	213.0	213.22	13326.0
2020-08-21 07:30:00	MSFT	Stock	213.48	213.48	212.27	212.27	29011.0
2020-08-21 08:00:00	MSFT	Stock	213.3	213.75	212.082	212.86	55169.0
2020-08-21 08:30:00	MSFT	Stock	212.79	213.45	212.78	213.17	22054.0
2020-08-21 09:00:00	MSFT	Stock	213.13	214.75	213.0	213.5	170477.0
2020-08-21 09:30:00	MSFT	Stock	213.5	215.16	213.2	214.52	4691458.0
2020-08-21 10:00:00	MSFT	Stock	214.525	215.14	214.0	215.03	1866253.0
2020-08-21 10:30:00	MSFT	Stock	215.05	216.25	215.046	215.887	2444926.0
2020-08-21 11:00:00	MSFT	Stock	215.87	215.95	214.53	214.78	1395655.0
2020-08-21 11:30:00	MSFT	Stock	214.795	214.8	213.35	213.545	1690883.0
2020-08-21 12:00:00	MSFT	Stock	213.53	214.86	213.5	214.67	930860.0
2020-08-21 12:30:00	MSFT	Stock	214.66	214.683	213.765	214.085	831660.0

> showing 50 of 96,083 rows — these rows as CSV

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