PREVIEW / stock_30min / 2019-08-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-20.parquet
  size:    1.7 MB
  rows:    83,011
  symbols: 2,566

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-08-20 04:00:00	AAPL	Stock	52.65	52.785	52.65	52.785	10296.0
2019-08-20 04:30:00	AAPL	Stock	52.7725	52.7725	52.71	52.7525	4000.0
2019-08-20 05:00:00	AAPL	Stock	52.755	52.755	52.5925	52.635	6196.0
2019-08-20 05:30:00	AAPL	Stock	52.6275	52.65	52.6275	52.65	1384.0
2019-08-20 06:00:00	AAPL	Stock	52.6825	52.75	52.6775	52.6875	4084.0
2019-08-20 06:30:00	AAPL	Stock	52.7275	52.7275	52.65	52.65	10496.0
2019-08-20 07:00:00	AAPL	Stock	52.675	52.6975	52.5	52.575	53888.0
2019-08-20 07:30:00	AAPL	Stock	52.575	52.7625	52.55	52.7375	71884.0
2019-08-20 08:00:00	AAPL	Stock	52.6	52.85	52.5375	52.85	161736.0
2019-08-20 08:30:00	AAPL	Stock	52.86	52.9125	52.7275	52.775	161160.0
2019-08-20 09:00:00	AAPL	Stock	52.75	52.795	52.6625	52.7025	202656.0
2019-08-20 09:30:00	AAPL	Stock	52.7025	52.945	52.6275	52.7425	11727844.0
2019-08-20 10:00:00	AAPL	Stock	52.7425	52.9295	52.6925	52.905	5222148.0
2019-08-20 10:30:00	AAPL	Stock	52.9025	53.1025	52.805	53.095	6027420.0
2019-08-20 11:00:00	AAPL	Stock	53.095	53.3375	53.0625	53.1622	10039956.0
2019-08-20 11:30:00	AAPL	Stock	53.1575	53.17	52.98	53.06	4781676.0
2019-08-20 12:00:00	AAPL	Stock	53.061	53.2625	53.061	53.2275	5744000.0
2019-08-20 12:30:00	AAPL	Stock	53.2325	53.27	53.1375	53.245	2949280.0
2019-08-20 13:00:00	AAPL	Stock	53.245	53.26	53.015	53.0222	3133980.0
2019-08-20 13:30:00	AAPL	Stock	53.0212	53.0225	52.8175	52.9208	4524200.0
2019-08-20 14:00:00	AAPL	Stock	52.9175	52.9308	52.72	52.8525	4610964.0
2019-08-20 14:30:00	AAPL	Stock	52.8475	52.9025	52.7775	52.8625	3120424.0
2019-08-20 15:00:00	AAPL	Stock	52.86	52.8762	52.71	52.8762	4332484.0
2019-08-20 15:30:00	AAPL	Stock	52.8775	52.8925	52.58	52.5875	8282388.0
2019-08-20 16:00:00	AAPL	Stock	52.59	52.6525	52.5675	52.575	7092412.0
2019-08-20 16:30:00	AAPL	Stock	52.5925	52.6075	52.5175	52.5175	71024.0
2019-08-20 17:00:00	AAPL	Stock	52.5575	52.5575	52.5175	52.55	10600.0
2019-08-20 17:30:00	AAPL	Stock	52.5425	52.5625	52.525	52.55	26020.0
2019-08-20 18:00:00	AAPL	Stock	52.5375	52.625	52.505	52.62	34932.0
2019-08-20 18:30:00	AAPL	Stock	52.62	52.625	52.5525	52.5525	33332.0
2019-08-20 19:00:00	AAPL	Stock	52.61	52.6175	52.5775	52.6125	12240.0
2019-08-20 19:30:00	AAPL	Stock	52.6125	52.69	52.59	52.6725	83564.0
2019-08-20 04:00:00	MSFT	Stock	138.09	138.61	138.09	138.6	697.0
2019-08-20 04:30:00	MSFT	Stock	138.56	138.62	138.5	138.5	3434.0
2019-08-20 05:00:00	MSFT	Stock	138.4	138.62	138.4	138.61	4800.0
2019-08-20 06:00:00	MSFT	Stock	138.6	138.62	138.6	138.62	250.0
2019-08-20 06:30:00	MSFT	Stock	138.62	138.62	138.53	138.53	714.0
2019-08-20 07:00:00	MSFT	Stock	138.4	138.4	138.2	138.26	8128.0
2019-08-20 07:30:00	MSFT	Stock	138.45	138.65	138.45	138.59	6323.0
2019-08-20 08:00:00	MSFT	Stock	138.29	138.7	138.06	138.7	47479.0
2019-08-20 08:30:00	MSFT	Stock	138.67	138.8	138.21	138.41	29238.0
2019-08-20 09:00:00	MSFT	Stock	138.41	138.41	138.03	138.1	11429.0
2019-08-20 09:30:00	MSFT	Stock	138.21	138.37	137.39	137.9	1929649.0
2019-08-20 10:00:00	MSFT	Stock	137.89	138.23	137.54	138.14	989485.0
2019-08-20 10:30:00	MSFT	Stock	138.13	138.28	137.67	138.27	936011.0
2019-08-20 11:00:00	MSFT	Stock	138.27	138.71	138.21	138.4	1044707.0
2019-08-20 11:30:00	MSFT	Stock	138.4	138.545	138.29	138.39	588424.0
2019-08-20 12:00:00	MSFT	Stock	138.385	138.59	138.37	138.51	397093.0
2019-08-20 12:30:00	MSFT	Stock	138.51	138.585	138.275	138.445	540098.0
2019-08-20 13:00:00	MSFT	Stock	138.44	138.49	138.284	138.335	403417.0

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

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