PREVIEW / stock_30min / 2019-05-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-15.parquet
  size:    1.7 MB
  rows:    84,189
  symbols: 2,626

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-15 04:00:00	AAPL	Stock	47.175	47.2575	47.065	47.16	25028.0
2019-05-15 04:30:00	AAPL	Stock	47.2125	47.2225	47.2125	47.2125	9488.0
2019-05-15 05:00:00	AAPL	Stock	47.2225	47.375	47.2225	47.3675	3660.0
2019-05-15 05:30:00	AAPL	Stock	47.35	47.35	47.125	47.125	26024.0
2019-05-15 06:00:00	AAPL	Stock	47.1	47.1525	47.04	47.04	14104.0
2019-05-15 06:30:00	AAPL	Stock	47.0375	47.0375	46.9575	46.9925	18900.0
2019-05-15 07:00:00	AAPL	Stock	47.025	47.185	47.0	47.1375	53080.0
2019-05-15 07:30:00	AAPL	Stock	47.0875	47.11	46.93	46.95	98596.0
2019-05-15 08:00:00	AAPL	Stock	47.05	47.2825	46.8375	46.8525	421080.0
2019-05-15 08:30:00	AAPL	Stock	46.8325	46.845	46.7075	46.75	266608.0
2019-05-15 09:00:00	AAPL	Stock	46.7575	46.78	46.5625	46.575	283472.0
2019-05-15 09:30:00	AAPL	Stock	46.575	47.005	46.505	46.855	13292992.0
2019-05-15 10:00:00	AAPL	Stock	46.845	47.325	46.775	47.2875	10274148.0
2019-05-15 10:30:00	AAPL	Stock	47.28	47.45	47.225	47.3825	8856204.0
2019-05-15 11:00:00	AAPL	Stock	47.385	47.595	47.255	47.5635	6981936.0
2019-05-15 11:30:00	AAPL	Stock	47.5625	47.62	47.4825	47.57	4725600.0
2019-05-15 12:00:00	AAPL	Stock	47.5725	47.69	47.54	47.584	4294364.0
2019-05-15 12:30:00	AAPL	Stock	47.5905	47.61	47.48	47.5375	3332488.0
2019-05-15 13:00:00	AAPL	Stock	47.535	47.65	47.51	47.637	3414684.0
2019-05-15 13:30:00	AAPL	Stock	47.64	47.8	47.64	47.77	3715108.0
2019-05-15 14:00:00	AAPL	Stock	47.7745	47.8875	47.7632	47.85	3856888.0
2019-05-15 14:30:00	AAPL	Stock	47.8512	47.8725	47.745	47.7818	3861668.0
2019-05-15 15:00:00	AAPL	Stock	47.78	47.91	47.7338	47.89	4777056.0
2019-05-15 15:30:00	AAPL	Stock	47.89	47.9375	47.695	47.73	10754544.0
2019-05-15 16:00:00	AAPL	Stock	47.765	47.825	46.8768	47.73	7209320.0
2019-05-15 16:30:00	AAPL	Stock	47.8175	47.8175	47.5275	47.625	139472.0
2019-05-15 17:00:00	AAPL	Stock	47.6275	47.6475	47.5775	47.6025	16824.0
2019-05-15 17:30:00	AAPL	Stock	47.6025	47.65	47.5975	47.65	32276.0
2019-05-15 18:00:00	AAPL	Stock	47.625	47.65	47.6175	47.6475	11276.0
2019-05-15 18:30:00	AAPL	Stock	47.65	47.65	47.6325	47.6325	12664.0
2019-05-15 19:00:00	AAPL	Stock	47.65	47.7	47.6475	47.655	25336.0
2019-05-15 19:30:00	AAPL	Stock	47.715	47.715	47.6525	47.685	18452.0
2019-05-15 04:00:00	MSFT	Stock	124.41	124.51	124.22	124.51	1178.0
2019-05-15 04:30:00	MSFT	Stock	124.7	124.7	124.7	124.7	289.0
2019-05-15 05:00:00	MSFT	Stock	124.68	124.68	124.68	124.68	100.0
2019-05-15 05:30:00	MSFT	Stock	124.54	124.54	124.33	124.33	2423.0
2019-05-15 06:00:00	MSFT	Stock	124.23	124.23	124.23	124.23	100.0
2019-05-15 07:00:00	MSFT	Stock	124.33	124.49	124.33	124.49	2675.0
2019-05-15 07:30:00	MSFT	Stock	124.4	124.43	124.19	124.19	4499.0
2019-05-15 08:00:00	MSFT	Stock	124.33	124.41	123.8	124.0	14633.0
2019-05-15 08:30:00	MSFT	Stock	123.85	123.85	123.54	123.7	14442.0
2019-05-15 09:00:00	MSFT	Stock	123.77	124.21	123.5	123.95	32643.0
2019-05-15 09:30:00	MSFT	Stock	123.95	124.65	123.7	124.51	2223788.0
2019-05-15 10:00:00	MSFT	Stock	124.51	125.695	124.49	125.58	2474024.0
2019-05-15 10:30:00	MSFT	Stock	125.585	125.94	125.5	125.65	1564567.0
2019-05-15 11:00:00	MSFT	Stock	125.65	126.13	125.39	126.125	1525154.0
2019-05-15 11:30:00	MSFT	Stock	126.13	126.2	125.75	126.0	1230455.0
2019-05-15 12:00:00	MSFT	Stock	126.0	126.19	125.6	125.69	836565.0
2019-05-15 12:30:00	MSFT	Stock	125.69	125.95	125.59	125.69	1006241.0
2019-05-15 13:00:00	MSFT	Stock	125.685	126.045	125.64	126.03	877543.0

> showing 50 of 84,189 rows — these rows as CSV

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