PREVIEW / stock_30min / 2020-08-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-17.parquet
  size:    1.9 MB
  rows:    97,146
  symbols: 2,442

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-17 04:00:00	AAPL	Stock	115.6	115.6	115.45	115.5025	10536.0
2020-08-17 04:30:00	AAPL	Stock	115.4825	115.6225	115.45	115.6	5088.0
2020-08-17 05:00:00	AAPL	Stock	115.56	115.5875	115.5525	115.575	5776.0
2020-08-17 05:30:00	AAPL	Stock	115.5625	115.6	115.5625	115.5925	6000.0
2020-08-17 06:00:00	AAPL	Stock	115.6125	115.65	115.6125	115.65	5800.0
2020-08-17 06:30:00	AAPL	Stock	115.6125	115.6275	115.5775	115.5775	8984.0
2020-08-17 07:00:00	AAPL	Stock	115.6025	115.6625	115.495	115.5775	171276.0
2020-08-17 07:30:00	AAPL	Stock	115.5825	115.6	115.2575	115.4625	141072.0
2020-08-17 08:00:00	AAPL	Stock	115.5275	115.75	115.1925	115.6675	393168.0
2020-08-17 08:30:00	AAPL	Stock	115.6975	116.0	115.65	115.975	273528.0
2020-08-17 09:00:00	AAPL	Stock	115.9975	116.1225	115.89	116.0075	380072.0
2020-08-17 09:30:00	AAPL	Stock	116.04	116.09	115.1725	115.4625	15016580.0
2020-08-17 10:00:00	AAPL	Stock	115.46	115.5825	114.2925	114.415	11151476.0
2020-08-17 10:30:00	AAPL	Stock	114.4238	114.835	114.3525	114.5525	6032764.0
2020-08-17 11:00:00	AAPL	Stock	114.5535	114.72	114.315	114.501	5263028.0
2020-08-17 11:30:00	AAPL	Stock	114.49	114.5475	113.9625	114.335	6614028.0
2020-08-17 12:00:00	AAPL	Stock	114.3362	114.5925	114.27	114.4085	4482936.0
2020-08-17 12:30:00	AAPL	Stock	114.4135	114.6825	114.2775	114.6725	3164044.0
2020-08-17 13:00:00	AAPL	Stock	114.675	114.795	114.3625	114.465	3542312.0
2020-08-17 13:30:00	AAPL	Stock	114.4635	114.675	114.285	114.6662	2837184.0
2020-08-17 14:00:00	AAPL	Stock	114.66	115.125	114.6	115.035	5365444.0
2020-08-17 14:30:00	AAPL	Stock	115.0425	115.2275	114.825	115.0738	4304220.0
2020-08-17 15:00:00	AAPL	Stock	115.0675	115.0818	114.6425	114.918	3979456.0
2020-08-17 15:30:00	AAPL	Stock	114.9225	115.2025	114.5	114.5975	7758848.0
2020-08-17 16:00:00	AAPL	Stock	114.5975	114.6875	114.51	114.5875	8413880.0
2020-08-17 16:30:00	AAPL	Stock	114.565	114.655	114.565	114.655	48372.0
2020-08-17 17:00:00	AAPL	Stock	114.62	114.6525	114.6125	114.625	15992.0
2020-08-17 17:30:00	AAPL	Stock	114.6	114.625	114.58	114.58	19220.0
2020-08-17 18:00:00	AAPL	Stock	114.61	114.61	114.575	114.6	14584.0
2020-08-17 18:30:00	AAPL	Stock	114.6075	114.625	114.595	114.6025	26256.0
2020-08-17 19:00:00	AAPL	Stock	114.59	114.665	114.575	114.665	50464.0
2020-08-17 19:30:00	AAPL	Stock	114.665	114.7625	114.625	114.75	103820.0
2020-08-17 04:00:00	MSFT	Stock	209.75	209.88	209.0	209.6	2219.0
2020-08-17 04:30:00	MSFT	Stock	209.55	209.6	209.52	209.53	632.0
2020-08-17 05:30:00	MSFT	Stock	209.69	209.75	209.69	209.7	600.0
2020-08-17 06:00:00	MSFT	Stock	209.7	209.86	209.7	209.86	1191.0
2020-08-17 06:30:00	MSFT	Stock	209.87	209.87	209.85	209.87	300.0
2020-08-17 07:00:00	MSFT	Stock	209.79	209.94	209.26	209.65	17069.0
2020-08-17 07:30:00	MSFT	Stock	209.62	209.62	209.35	209.35	6208.0
2020-08-17 08:00:00	MSFT	Stock	209.61	209.7	209.2	209.25	34990.0
2020-08-17 08:30:00	MSFT	Stock	209.2	209.7	209.08	209.54	14544.0
2020-08-17 09:00:00	MSFT	Stock	209.536	209.7	208.9	209.21	32408.0
2020-08-17 09:30:00	MSFT	Stock	209.59	210.37	208.915	210.31	2314209.0
2020-08-17 10:00:00	MSFT	Stock	210.32	210.89	209.97	210.13	1311462.0
2020-08-17 10:30:00	MSFT	Stock	210.15	211.187	210.15	210.508	1274289.0
2020-08-17 11:00:00	MSFT	Stock	210.51	210.524	209.815	210.16	863696.0
2020-08-17 11:30:00	MSFT	Stock	210.17	210.21	209.595	209.86	545586.0
2020-08-17 12:00:00	MSFT	Stock	209.88	209.893	209.51	209.69	536013.0
2020-08-17 12:30:00	MSFT	Stock	209.68	210.269	209.56	210.01	562375.0
2020-08-17 13:00:00	MSFT	Stock	210.01	210.4	209.955	210.09	477246.0

> showing 50 of 97,146 rows — these rows as CSV

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