PREVIEW / stock_30min / 2019-09-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-03.parquet
  size:    1.7 MB
  rows:    84,529
  symbols: 2,560

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-03 04:00:00	AAPL	Stock	51.425	51.8475	51.365	51.68	13728.0
2019-09-03 04:30:00	AAPL	Stock	51.68	51.68	51.6275	51.6275	12096.0
2019-09-03 05:00:00	AAPL	Stock	51.7325	51.775	51.625	51.63	45252.0
2019-09-03 05:30:00	AAPL	Stock	51.55	51.55	51.45	51.45	8580.0
2019-09-03 06:00:00	AAPL	Stock	51.45	51.5875	51.425	51.5425	5252.0
2019-09-03 06:30:00	AAPL	Stock	51.575	51.675	51.565	51.625	7976.0
2019-09-03 07:00:00	AAPL	Stock	51.575	51.75	51.5625	51.6325	39128.0
2019-09-03 07:30:00	AAPL	Stock	51.6325	51.675	51.5625	51.5775	85584.0
2019-09-03 08:00:00	AAPL	Stock	51.625	51.675	51.5025	51.65	240140.0
2019-09-03 08:30:00	AAPL	Stock	51.645	51.77	51.55	51.585	130932.0
2019-09-03 09:00:00	AAPL	Stock	51.585	51.705	51.54	51.605	119036.0
2019-09-03 09:30:00	AAPL	Stock	51.605	51.745	51.4575	51.6725	10838556.0
2019-09-03 10:00:00	AAPL	Stock	51.6675	51.6675	51.055	51.205	10408804.0
2019-09-03 10:30:00	AAPL	Stock	51.2025	51.4075	51.1275	51.355	5359468.0
2019-09-03 11:00:00	AAPL	Stock	51.3575	51.3575	51.1325	51.26	4374132.0
2019-09-03 11:30:00	AAPL	Stock	51.2575	51.44	51.195	51.3225	4085460.0
2019-09-03 12:00:00	AAPL	Stock	51.315	51.35	51.2275	51.265	2727996.0
2019-09-03 12:30:00	AAPL	Stock	51.2625	51.3	51.1875	51.2212	2608980.0
2019-09-03 13:00:00	AAPL	Stock	51.2218	51.2638	51.1325	51.2	2791440.0
2019-09-03 13:30:00	AAPL	Stock	51.2002	51.225	51.115	51.1575	2963244.0
2019-09-03 14:00:00	AAPL	Stock	51.16	51.2825	51.15	51.2567	2642616.0
2019-09-03 14:30:00	AAPL	Stock	51.2575	51.395	51.2525	51.3475	2336756.0
2019-09-03 15:00:00	AAPL	Stock	51.35	51.4475	51.2925	51.4118	3189664.0
2019-09-03 15:30:00	AAPL	Stock	51.4125	51.5275	51.3875	51.4238	6825352.0
2019-09-03 16:00:00	AAPL	Stock	51.425	51.4625	51.4075	51.4625	4732992.0
2019-09-03 16:30:00	AAPL	Stock	51.4625	51.4725	51.425	51.445	76252.0
2019-09-03 17:00:00	AAPL	Stock	51.4725	51.4725	51.4375	51.44	7200.0
2019-09-03 17:30:00	AAPL	Stock	51.4475	51.4875	51.44	51.4625	28592.0
2019-09-03 18:00:00	AAPL	Stock	51.4625	51.475	51.4625	51.4625	13816.0
2019-09-03 18:30:00	AAPL	Stock	51.4725	51.55	51.4725	51.5225	54064.0
2019-09-03 19:00:00	AAPL	Stock	51.5	51.52	51.4925	51.4925	16504.0
2019-09-03 19:30:00	AAPL	Stock	51.495	51.525	51.45	51.495	61500.0
2019-09-03 04:00:00	MSFT	Stock	136.9	136.9	136.5	136.5	2308.0
2019-09-03 04:30:00	MSFT	Stock	136.81	136.81	136.52	136.78	2800.0
2019-09-03 05:00:00	MSFT	Stock	136.77	136.77	136.76	136.76	201.0
2019-09-03 05:30:00	MSFT	Stock	136.71	136.71	136.2	136.2	2738.0
2019-09-03 06:00:00	MSFT	Stock	136.6	136.62	136.5	136.62	3639.0
2019-09-03 06:30:00	MSFT	Stock	136.72	136.88	136.7	136.78	1398.0
2019-09-03 07:00:00	MSFT	Stock	136.9	137.0	136.68	136.8	2643.0
2019-09-03 07:30:00	MSFT	Stock	136.88	136.88	136.65	136.7	5882.0
2019-09-03 08:00:00	MSFT	Stock	136.8	136.95	136.61	136.94	16340.0
2019-09-03 08:30:00	MSFT	Stock	136.93	137.19	136.76	137.0	27130.0
2019-09-03 09:00:00	MSFT	Stock	137.0	137.0	136.49	136.63	19436.0
2019-09-03 09:30:00	MSFT	Stock	136.52	137.2	136.34	137.05	1917463.0
2019-09-03 10:00:00	MSFT	Stock	137.04	137.04	135.85	136.56	1720330.0
2019-09-03 10:30:00	MSFT	Stock	136.55	137.0	136.21	136.75	1059286.0
2019-09-03 11:00:00	MSFT	Stock	136.75	136.77	136.11	136.42	1062076.0
2019-09-03 11:30:00	MSFT	Stock	136.41	136.805	136.19	136.57	867506.0
2019-09-03 12:00:00	MSFT	Stock	136.57	136.68	136.29	136.37	526573.0
2019-09-03 12:30:00	MSFT	Stock	136.385	136.56	136.2	136.362	541364.0

> showing 50 of 84,529 rows — these rows as CSV

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