PREVIEW / stock_30min / 2019-11-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-05.parquet
  size:    1.7 MB
  rows:    85,944
  symbols: 2,526

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-05 04:00:00	AAPL	Stock	64.55	64.605	64.5	64.5625	16544.0
2019-11-05 04:30:00	AAPL	Stock	64.5625	64.605	64.5625	64.575	4476.0
2019-11-05 05:00:00	AAPL	Stock	64.5625	64.5625	64.5625	64.5625	400.0
2019-11-05 06:30:00	AAPL	Stock	64.4775	64.4775	64.4675	64.4675	7076.0
2019-11-05 07:00:00	AAPL	Stock	64.4625	64.5375	64.45	64.5	110392.0
2019-11-05 07:30:00	AAPL	Stock	64.49	64.5	64.45	64.4525	37740.0
2019-11-05 08:00:00	AAPL	Stock	64.525	64.5375	64.4375	64.4725	180108.0
2019-11-05 08:30:00	AAPL	Stock	64.4725	64.5125	64.45	64.48	110120.0
2019-11-05 09:00:00	AAPL	Stock	64.475	64.48	64.25	64.2625	372420.0
2019-11-05 09:30:00	AAPL	Stock	64.2625	64.4125	64.08	64.33	10793068.0
2019-11-05 10:00:00	AAPL	Stock	64.33	64.4875	64.1775	64.3	7969508.0
2019-11-05 10:30:00	AAPL	Stock	64.3025	64.5475	64.3025	64.3775	5877668.0
2019-11-05 11:00:00	AAPL	Stock	64.38	64.4425	64.275	64.2818	3504028.0
2019-11-05 11:30:00	AAPL	Stock	64.28	64.3875	64.2675	64.38	2773192.0
2019-11-05 12:00:00	AAPL	Stock	64.3775	64.4775	64.2875	64.36	3093144.0
2019-11-05 12:30:00	AAPL	Stock	64.36	64.435	64.2975	64.395	2001640.0
2019-11-05 13:00:00	AAPL	Stock	64.395	64.5025	64.3925	64.4575	2810028.0
2019-11-05 13:30:00	AAPL	Stock	64.4575	64.4975	64.415	64.4525	2191416.0
2019-11-05 14:00:00	AAPL	Stock	64.4512	64.4512	64.39	64.4088	2555700.0
2019-11-05 14:30:00	AAPL	Stock	64.41	64.5475	64.4025	64.48	3124568.0
2019-11-05 15:00:00	AAPL	Stock	64.4812	64.5128	64.42	64.43	3407492.0
2019-11-05 15:30:00	AAPL	Stock	64.4325	64.465	64.235	64.2875	6395224.0
2019-11-05 16:00:00	AAPL	Stock	64.2825	64.3025	64.2425	64.2625	6064416.0
2019-11-05 16:30:00	AAPL	Stock	64.2675	64.27	64.1825	64.2375	33496.0
2019-11-05 17:00:00	AAPL	Stock	64.2375	64.2825	64.225	64.2825	99168.0
2019-11-05 17:30:00	AAPL	Stock	64.2375	64.2375	64.1875	64.1875	17128.0
2019-11-05 18:00:00	AAPL	Stock	64.1875	64.2125	64.1825	64.2125	21316.0
2019-11-05 18:30:00	AAPL	Stock	64.2125	64.2375	64.1925	64.215	33460.0
2019-11-05 19:00:00	AAPL	Stock	64.21	64.225	64.1825	64.2225	15276.0
2019-11-05 19:30:00	AAPL	Stock	64.1875	64.2	64.15	64.155	51916.0
2019-11-05 04:00:00	MSFT	Stock	145.0	145.15	145.0	145.15	1887.0
2019-11-05 04:30:00	MSFT	Stock	145.01	145.11	145.01	145.1	3665.0
2019-11-05 05:00:00	MSFT	Stock	145.13	145.21	145.12	145.17	3255.0
2019-11-05 05:30:00	MSFT	Stock	145.14	145.14	145.14	145.14	500.0
2019-11-05 06:00:00	MSFT	Stock	145.09	145.09	144.68	145.04	5465.0
2019-11-05 06:30:00	MSFT	Stock	144.99	144.99	144.91	144.91	1798.0
2019-11-05 07:00:00	MSFT	Stock	144.95	145.03	144.9	145.0	13071.0
2019-11-05 07:30:00	MSFT	Stock	144.99	145.05	144.92	144.92	10600.0
2019-11-05 08:00:00	MSFT	Stock	144.98	145.31	144.85	145.1	51281.0
2019-11-05 08:30:00	MSFT	Stock	145.1	145.12	145.01	145.1	21707.0
2019-11-05 09:00:00	MSFT	Stock	145.14	145.15	144.9	144.99	40380.0
2019-11-05 09:30:00	MSFT	Stock	144.99	145.02	144.23	144.42	2302770.0
2019-11-05 10:00:00	MSFT	Stock	144.42	144.68	143.905	144.17	1425363.0
2019-11-05 10:30:00	MSFT	Stock	144.16	144.46	144.07	144.13	771720.0
2019-11-05 11:00:00	MSFT	Stock	144.15	144.565	144.11	144.55	755282.0
2019-11-05 11:30:00	MSFT	Stock	144.545	144.64	144.28	144.539	659598.0
2019-11-05 12:00:00	MSFT	Stock	144.53	144.65	144.365	144.495	581279.0
2019-11-05 12:30:00	MSFT	Stock	144.49	144.73	144.43	144.7	552778.0
2019-11-05 13:00:00	MSFT	Stock	144.7	144.759	144.6	144.641	670519.0
2019-11-05 13:30:00	MSFT	Stock	144.65	144.65	144.46	144.58	535459.0

> showing 50 of 85,944 rows — these rows as CSV

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