PREVIEW / stock_30min / 2019-09-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-20.parquet
  size:    1.7 MB
  rows:    85,660
  symbols: 2,551

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-09-20 04:00:00	AAPL	Stock	55.3225	55.3975	55.3225	55.3725	4800.0
2019-09-20 04:30:00	AAPL	Stock	55.41	55.41	55.3375	55.3375	1608.0
2019-09-20 05:00:00	AAPL	Stock	55.35	55.3625	55.35	55.3625	2400.0
2019-09-20 05:30:00	AAPL	Stock	55.3925	55.4025	55.3375	55.4025	10244.0
2019-09-20 06:00:00	AAPL	Stock	55.3875	55.3875	55.315	55.34	1600.0
2019-09-20 06:30:00	AAPL	Stock	55.34	55.34	55.335	55.335	6800.0
2019-09-20 07:00:00	AAPL	Stock	55.3625	55.425	55.2875	55.425	105996.0
2019-09-20 07:30:00	AAPL	Stock	55.4375	55.445	55.3375	55.4375	72020.0
2019-09-20 08:00:00	AAPL	Stock	55.3275	55.4575	55.325	55.385	229012.0
2019-09-20 08:30:00	AAPL	Stock	55.375	55.4875	55.375	55.4625	172916.0
2019-09-20 09:00:00	AAPL	Stock	55.4625	55.5075	55.345	55.3475	697744.0
2019-09-20 09:30:00	AAPL	Stock	55.3475	55.64	55.3425	55.4725	31483896.0
2019-09-20 10:00:00	AAPL	Stock	55.475	55.5175	55.3962	55.4525	4598624.0
2019-09-20 10:30:00	AAPL	Stock	55.4575	55.61	55.4475	55.4875	6840876.0
2019-09-20 11:00:00	AAPL	Stock	55.485	55.5338	55.4175	55.45	4106368.0
2019-09-20 11:30:00	AAPL	Stock	55.45	55.4525	55.215	55.28	4885828.0
2019-09-20 12:00:00	AAPL	Stock	55.2788	55.3075	55.1475	55.16	2874800.0
2019-09-20 12:30:00	AAPL	Stock	55.1648	55.17	55.025	55.0675	2949968.0
2019-09-20 13:00:00	AAPL	Stock	55.0652	55.1475	54.56	54.745	8190276.0
2019-09-20 13:30:00	AAPL	Stock	54.7475	54.765	54.3682	54.628	8291760.0
2019-09-20 14:00:00	AAPL	Stock	54.6325	54.875	54.5725	54.8692	6048876.0
2019-09-20 14:30:00	AAPL	Stock	54.8675	54.9925	54.8348	54.8575	3697720.0
2019-09-20 15:00:00	AAPL	Stock	54.86	54.9475	54.6775	54.69	4389768.0
2019-09-20 15:30:00	AAPL	Stock	54.6925	54.836	54.4025	54.4225	16530512.0
2019-09-20 16:00:00	AAPL	Stock	54.5475	54.7925	54.385	54.4525	69554036.0
2019-09-20 16:30:00	AAPL	Stock	54.475	54.5225	54.4325	54.4775	240984.0
2019-09-20 17:00:00	AAPL	Stock	54.5	54.525	54.4875	54.5	52516.0
2019-09-20 17:30:00	AAPL	Stock	54.4325	54.53	54.4325	54.4925	62284.0
2019-09-20 18:00:00	AAPL	Stock	54.5	54.5	54.445	54.495	43576.0
2019-09-20 18:30:00	AAPL	Stock	54.525	54.55	54.48	54.5	32048.0
2019-09-20 19:00:00	AAPL	Stock	54.5	54.5	54.44	54.45	17932.0
2019-09-20 19:30:00	AAPL	Stock	54.46	54.4625	54.42	54.4375	27340.0
2019-09-20 04:00:00	MSFT	Stock	141.3	141.35	141.3	141.35	508.0
2019-09-20 05:30:00	MSFT	Stock	141.4	141.47	141.4	141.47	791.0
2019-09-20 06:00:00	MSFT	Stock	141.41	141.5	141.41	141.5	1117.0
2019-09-20 06:30:00	MSFT	Stock	141.55	141.59	141.38	141.38	1144.0
2019-09-20 07:00:00	MSFT	Stock	141.44	141.5	141.41	141.46	8283.0
2019-09-20 07:30:00	MSFT	Stock	141.4	141.4	141.3	141.4	6995.0
2019-09-20 08:00:00	MSFT	Stock	141.49	141.5	141.28	141.3	30669.0
2019-09-20 08:30:00	MSFT	Stock	141.3	141.55	141.26	141.44	15759.0
2019-09-20 09:00:00	MSFT	Stock	141.46	141.73	141.0	141.0	214731.0
2019-09-20 09:30:00	MSFT	Stock	141.0	141.65	140.81	140.97	11996877.0
2019-09-20 10:00:00	MSFT	Stock	140.97	141.25	140.9	140.965	1377746.0
2019-09-20 10:30:00	MSFT	Stock	140.97	141.01	140.435	140.53	1384203.0
2019-09-20 11:00:00	MSFT	Stock	140.523	140.63	140.22	140.33	1238391.0
2019-09-20 11:30:00	MSFT	Stock	140.32	140.34	139.56	140.085	1397811.0
2019-09-20 12:00:00	MSFT	Stock	140.07	140.1	139.7	139.793	818611.0
2019-09-20 12:30:00	MSFT	Stock	139.8	139.81	139.16	139.455	1155908.0
2019-09-20 13:00:00	MSFT	Stock	139.46	139.56	138.25	138.97	2087314.0
2019-09-20 13:30:00	MSFT	Stock	139.0	139.03	138.48	138.94	1080800.0

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

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