PREVIEW / stock_30min / 2019-11-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-22.parquet
  size:    1.7 MB
  rows:    83,880
  symbols: 2,477

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-11-22 04:00:00	AAPL	Stock	65.7625	65.7625	65.7475	65.75	4120.0
2019-11-22 04:30:00	AAPL	Stock	65.66	65.755	65.65	65.755	4688.0
2019-11-22 06:00:00	AAPL	Stock	65.7425	65.745	65.665	65.665	5564.0
2019-11-22 06:30:00	AAPL	Stock	65.6925	65.7025	65.6925	65.7025	4964.0
2019-11-22 07:00:00	AAPL	Stock	65.7025	65.775	65.7	65.775	35772.0
2019-11-22 07:30:00	AAPL	Stock	65.775	65.775	65.725	65.75	29948.0
2019-11-22 08:00:00	AAPL	Stock	65.7375	65.8	65.67	65.7075	206104.0
2019-11-22 08:30:00	AAPL	Stock	65.7	65.8	65.5025	65.75	356904.0
2019-11-22 09:00:00	AAPL	Stock	65.75	65.7625	65.5875	65.6375	211948.0
2019-11-22 09:30:00	AAPL	Stock	65.6375	65.795	65.385	65.635	9368656.0
2019-11-22 10:00:00	AAPL	Stock	65.635	65.725	65.5775	65.6082	4040744.0
2019-11-22 10:30:00	AAPL	Stock	65.6135	65.62	65.4425	65.475	3781952.0
2019-11-22 11:00:00	AAPL	Stock	65.475	65.5	65.2175	65.4625	5511128.0
2019-11-22 11:30:00	AAPL	Stock	65.4675	65.62	65.4375	65.5825	2801940.0
2019-11-22 12:00:00	AAPL	Stock	65.5775	65.6	65.435	65.535	2617916.0
2019-11-22 12:30:00	AAPL	Stock	65.535	65.6075	65.5325	65.5425	1708524.0
2019-11-22 13:00:00	AAPL	Stock	65.545	65.605	65.5075	65.5975	1421892.0
2019-11-22 13:30:00	AAPL	Stock	65.5975	65.6	65.3525	65.435	2562244.0
2019-11-22 14:00:00	AAPL	Stock	65.435	65.4425	65.2525	65.2975	2435396.0
2019-11-22 14:30:00	AAPL	Stock	65.2958	65.3538	65.2775	65.3153	2597208.0
2019-11-22 15:00:00	AAPL	Stock	65.32	65.4625	65.29	65.4525	2036820.0
2019-11-22 15:30:00	AAPL	Stock	65.4525	65.555	65.21	65.46	7785192.0
2019-11-22 16:00:00	AAPL	Stock	65.445	65.4875	65.4125	65.445	7157356.0
2019-11-22 16:30:00	AAPL	Stock	65.45	65.455	65.44	65.45	18256.0
2019-11-22 17:00:00	AAPL	Stock	65.4575	65.4625	65.44	65.44	5932.0
2019-11-22 17:30:00	AAPL	Stock	65.445	65.48	65.445	65.4625	28108.0
2019-11-22 18:00:00	AAPL	Stock	65.47	65.47	65.47	65.47	3600.0
2019-11-22 18:30:00	AAPL	Stock	65.47	65.48	65.4625	65.4675	14132.0
2019-11-22 19:00:00	AAPL	Stock	65.4675	65.4675	65.4625	65.4625	1560.0
2019-11-22 19:30:00	AAPL	Stock	65.475	65.4775	65.4525	65.4525	12632.0
2019-11-22 04:00:00	MSFT	Stock	149.98	150.1	149.93	150.02	3367.0
2019-11-22 04:30:00	MSFT	Stock	149.98	150.0	149.98	150.0	410.0
2019-11-22 05:00:00	MSFT	Stock	150.0	150.05	149.94	150.05	760.0
2019-11-22 06:00:00	MSFT	Stock	149.9	150.08	149.9	150.0	1252.0
2019-11-22 06:30:00	MSFT	Stock	150.06	150.17	149.98	150.16	2152.0
2019-11-22 07:00:00	MSFT	Stock	150.08	150.2	150.0	150.1	5413.0
2019-11-22 07:30:00	MSFT	Stock	150.1	150.1	150.05	150.06	1761.0
2019-11-22 08:00:00	MSFT	Stock	150.1	150.18	149.83	149.9	21123.0
2019-11-22 08:30:00	MSFT	Stock	149.9	150.12	149.48	149.48	71752.0
2019-11-22 09:00:00	MSFT	Stock	150.03	150.15	149.91	150.09	14714.0
2019-11-22 09:30:00	MSFT	Stock	150.07	150.3	149.619	149.75	1851392.0
2019-11-22 10:00:00	MSFT	Stock	149.745	149.875	149.41	149.425	1159917.0
2019-11-22 10:30:00	MSFT	Stock	149.42	149.45	148.88	149.06	1133612.0
2019-11-22 11:00:00	MSFT	Stock	149.05	149.19	148.82	149.15	882964.0
2019-11-22 11:30:00	MSFT	Stock	149.16	149.41	149.12	149.186	566529.0
2019-11-22 12:00:00	MSFT	Stock	149.19	149.3	149.03	149.155	528488.0
2019-11-22 12:30:00	MSFT	Stock	149.16	149.39	149.15	149.345	337335.0
2019-11-22 13:00:00	MSFT	Stock	149.35	149.48	149.31	149.42	366832.0
2019-11-22 13:30:00	MSFT	Stock	149.42	149.45	149.21	149.337	408028.0
2019-11-22 14:00:00	MSFT	Stock	149.335	149.34	149.12	149.13	419883.0

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

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