PREVIEW / stock_30min / 2020-07-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-16.parquet
  size:    1.9 MB
  rows:    96,161
  symbols: 2,439

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-07-16 04:00:00	AAPL	Stock	96.925	96.925	96.5	96.5	35660.0
2020-07-16 04:30:00	AAPL	Stock	96.2825	96.335	96.1225	96.21	9684.0
2020-07-16 05:00:00	AAPL	Stock	96.21	96.295	96.0575	96.175	23504.0
2020-07-16 05:30:00	AAPL	Stock	96.3025	96.35	96.245	96.25	19520.0
2020-07-16 06:00:00	AAPL	Stock	96.275	96.3375	96.25	96.3075	9992.0
2020-07-16 06:30:00	AAPL	Stock	96.25	96.3625	95.755	96.265	27248.0
2020-07-16 07:00:00	AAPL	Stock	96.3125	96.625	96.125	96.61	175252.0
2020-07-16 07:30:00	AAPL	Stock	96.605	96.875	96.58	96.675	133524.0
2020-07-16 08:00:00	AAPL	Stock	96.2625	96.875	96.2225	96.6625	234336.0
2020-07-16 08:30:00	AAPL	Stock	96.735	96.75	96.22	96.6	349912.0
2020-07-16 09:00:00	AAPL	Stock	96.5975	97.0	96.5	96.5325	328436.0
2020-07-16 09:30:00	AAPL	Stock	96.5625	97.405	96.52	96.7612	12378616.0
2020-07-16 10:00:00	AAPL	Stock	96.7802	96.85	96.165	96.575	9306588.0
2020-07-16 10:30:00	AAPL	Stock	96.5525	96.9195	96.33	96.41	6415556.0
2020-07-16 11:00:00	AAPL	Stock	96.4125	96.4778	95.95	96.2075	7328304.0
2020-07-16 11:30:00	AAPL	Stock	96.1975	96.3725	95.905	96.244	5235732.0
2020-07-16 12:00:00	AAPL	Stock	96.24	96.3175	95.9375	96.055	4310892.0
2020-07-16 12:30:00	AAPL	Stock	96.0638	96.22	95.95	95.975	3906720.0
2020-07-16 13:00:00	AAPL	Stock	95.9775	96.5275	95.945	96.48	4847724.0
2020-07-16 13:30:00	AAPL	Stock	96.4825	96.545	96.1275	96.1925	3986200.0
2020-07-16 14:00:00	AAPL	Stock	96.1875	96.7375	96.1775	96.6775	4480096.0
2020-07-16 14:30:00	AAPL	Stock	96.68	96.75	96.1325	96.2438	4831172.0
2020-07-16 15:00:00	AAPL	Stock	96.26	96.6525	96.1975	96.6275	4305268.0
2020-07-16 15:30:00	AAPL	Stock	96.6252	96.85	96.3425	96.5575	7353500.0
2020-07-16 16:00:00	AAPL	Stock	96.5575	96.5575	95.945	96.0925	5249576.0
2020-07-16 16:30:00	AAPL	Stock	96.0325	96.0725	96.0	96.02	80800.0
2020-07-16 17:00:00	AAPL	Stock	96.0225	96.5225	96.0	96.0625	108988.0
2020-07-16 17:30:00	AAPL	Stock	96.025	96.06	95.96	95.975	122784.0
2020-07-16 18:00:00	AAPL	Stock	95.975	96.15	95.975	96.09	79752.0
2020-07-16 18:30:00	AAPL	Stock	96.0875	96.2	96.0675	96.105	25072.0
2020-07-16 19:00:00	AAPL	Stock	96.1375	96.245	96.1375	96.2	17660.0
2020-07-16 19:30:00	AAPL	Stock	96.2375	96.2875	96.2	96.2875	51164.0
2020-07-16 04:00:00	MSFT	Stock	206.1	206.1	205.86	205.86	558.0
2020-07-16 04:30:00	MSFT	Stock	205.3	205.3	204.61	204.86	6236.0
2020-07-16 05:00:00	MSFT	Stock	204.87	204.88	204.33	204.57	1024.0
2020-07-16 05:30:00	MSFT	Stock	205.0	205.1	204.61	204.85	11175.0
2020-07-16 06:00:00	MSFT	Stock	205.11	205.15	204.99	204.99	4466.0
2020-07-16 06:30:00	MSFT	Stock	205.0	205.0	204.07	204.8	5961.0
2020-07-16 07:00:00	MSFT	Stock	204.8	205.45	204.75	205.45	22283.0
2020-07-16 07:30:00	MSFT	Stock	205.47	205.58	205.0	205.0	17223.0
2020-07-16 08:00:00	MSFT	Stock	205.1	208.56	204.746	205.11	37440.0
2020-07-16 08:30:00	MSFT	Stock	205.07	205.38	204.38	205.25	44246.0
2020-07-16 09:00:00	MSFT	Stock	205.19	205.95	205.12	205.32	43564.0
2020-07-16 09:30:00	MSFT	Stock	205.32	205.7	204.3	204.82	3284693.0
2020-07-16 10:00:00	MSFT	Stock	204.81	204.86	203.29	204.125	2310217.0
2020-07-16 10:30:00	MSFT	Stock	204.08	204.99	203.0	203.05	1829247.0
2020-07-16 11:00:00	MSFT	Stock	203.06	203.43	202.31	203.201	2035470.0
2020-07-16 11:30:00	MSFT	Stock	203.205	203.87	202.77	203.84	1170546.0
2020-07-16 12:00:00	MSFT	Stock	203.835	204.2	203.22	203.41	1017765.0
2020-07-16 12:30:00	MSFT	Stock	203.445	204.08	203.36	203.68	982144.0

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

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