PREVIEW / stock_30min / 2019-05-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-29.parquet
  size:    1.7 MB
  rows:    84,643
  symbols: 2,612

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-05-29 04:00:00	AAPL	Stock	44.125	44.3375	44.125	44.2075	18204.0
2019-05-29 04:30:00	AAPL	Stock	44.21	44.25	44.125	44.1375	20008.0
2019-05-29 05:00:00	AAPL	Stock	44.1375	44.1375	44.0	44.03	34040.0
2019-05-29 05:30:00	AAPL	Stock	44.0275	44.04	43.875	43.9875	61736.0
2019-05-29 06:00:00	AAPL	Stock	44.0	44.07	44.0	44.0525	12424.0
2019-05-29 06:30:00	AAPL	Stock	44.0325	44.215	44.0	44.215	18884.0
2019-05-29 07:00:00	AAPL	Stock	44.2	44.225	44.035	44.0625	119124.0
2019-05-29 07:30:00	AAPL	Stock	44.0525	44.15	44.0225	44.075	67996.0
2019-05-29 08:00:00	AAPL	Stock	44.1125	44.2075	43.9775	43.9875	214732.0
2019-05-29 08:30:00	AAPL	Stock	43.98	44.1	43.9078	44.0875	229332.0
2019-05-29 09:00:00	AAPL	Stock	44.1	44.22	44.0875	44.1225	347648.0
2019-05-29 09:30:00	AAPL	Stock	44.105	44.555	44.0	44.4908	16030820.0
2019-05-29 10:00:00	AAPL	Stock	44.5	44.8225	44.42	44.81	9721756.0
2019-05-29 10:30:00	AAPL	Stock	44.815	44.8375	44.4325	44.439	6573688.0
2019-05-29 11:00:00	AAPL	Stock	44.4375	44.505	44.22	44.265	9007084.0
2019-05-29 11:30:00	AAPL	Stock	44.26	44.305	44.0925	44.2225	7188744.0
2019-05-29 12:00:00	AAPL	Stock	44.22	44.4575	44.165	44.3675	5727496.0
2019-05-29 12:30:00	AAPL	Stock	44.3675	44.5125	44.3375	44.4015	4331484.0
2019-05-29 13:00:00	AAPL	Stock	44.4075	44.585	44.3675	44.535	4065444.0
2019-05-29 13:30:00	AAPL	Stock	44.53	44.63	44.4375	44.4525	4603872.0
2019-05-29 14:00:00	AAPL	Stock	44.45	44.5325	44.3575	44.4758	3364132.0
2019-05-29 14:30:00	AAPL	Stock	44.4725	44.4725	44.2325	44.295	4596472.0
2019-05-29 15:00:00	AAPL	Stock	44.2925	44.395	44.195	44.375	5304340.0
2019-05-29 15:30:00	AAPL	Stock	44.3725	44.4875	44.265	44.3375	11150144.0
2019-05-29 16:00:00	AAPL	Stock	44.345	44.4	44.3175	44.35	5632696.0
2019-05-29 16:30:00	AAPL	Stock	44.3375	44.365	44.325	44.3475	24680.0
2019-05-29 17:00:00	AAPL	Stock	44.345	44.35	44.3225	44.3275	16052.0
2019-05-29 17:30:00	AAPL	Stock	44.3275	44.3275	44.3	44.305	20908.0
2019-05-29 18:00:00	AAPL	Stock	44.3225	44.4	44.32	44.4	55236.0
2019-05-29 18:30:00	AAPL	Stock	44.4025	44.4075	44.345	44.4075	19336.0
2019-05-29 19:00:00	AAPL	Stock	44.4	44.425	44.38	44.38	8896.0
2019-05-29 19:30:00	AAPL	Stock	44.3975	44.4	44.3375	44.3875	21204.0
2019-05-29 04:00:00	MSFT	Stock	125.5	125.78	125.3	125.3	625.0
2019-05-29 04:30:00	MSFT	Stock	125.35	125.35	125.35	125.35	100.0
2019-05-29 06:00:00	MSFT	Stock	125.22	125.22	125.22	125.22	500.0
2019-05-29 06:30:00	MSFT	Stock	125.38	125.49	125.38	125.49	2798.0
2019-05-29 07:00:00	MSFT	Stock	125.75	125.76	125.4	125.4	4334.0
2019-05-29 07:30:00	MSFT	Stock	125.42	125.44	125.32	125.41	1139.0
2019-05-29 08:00:00	MSFT	Stock	125.605	125.65	125.29	125.31	12506.0
2019-05-29 08:30:00	MSFT	Stock	125.32	125.43	125.23	125.43	4700.0
2019-05-29 09:00:00	MSFT	Stock	125.45	125.55	125.24	125.38	31969.0
2019-05-29 09:30:00	MSFT	Stock	125.38	125.38	124.56	124.67	2421961.0
2019-05-29 10:00:00	MSFT	Stock	124.67	125.39	124.42	125.347	1596248.0
2019-05-29 10:30:00	MSFT	Stock	125.33	125.39	124.88	124.91	965533.0
2019-05-29 11:00:00	MSFT	Stock	124.9	125.33	124.755	124.8	1098548.0
2019-05-29 11:30:00	MSFT	Stock	124.78	125.0	124.04	124.32	1398117.0
2019-05-29 12:00:00	MSFT	Stock	124.305	124.59	124.15	124.48	1059861.0
2019-05-29 12:30:00	MSFT	Stock	124.47	124.66	124.35	124.56	901753.0
2019-05-29 13:00:00	MSFT	Stock	124.56	125.12	124.42	124.95	1031958.0
2019-05-29 13:30:00	MSFT	Stock	124.945	125.38	124.86	125.17	736556.0

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

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