PREVIEW / stock_30min / 2019-08-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-28.parquet
  size:    1.7 MB
  rows:    84,651
  symbols: 2,554

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-28 04:00:00	AAPL	Stock	51.1625	51.23	51.12	51.23	6896.0
2019-08-28 04:30:00	AAPL	Stock	51.27	51.27	50.97	51.03	38188.0
2019-08-28 05:00:00	AAPL	Stock	51.1275	51.1525	51.1275	51.1525	6080.0
2019-08-28 05:30:00	AAPL	Stock	51.025	51.105	51.01	51.065	9120.0
2019-08-28 06:00:00	AAPL	Stock	51.16	51.2	51.04	51.04	6840.0
2019-08-28 06:30:00	AAPL	Stock	51.04	51.04	51.04	51.04	1800.0
2019-08-28 07:00:00	AAPL	Stock	51.075	51.1225	50.9275	50.9275	45424.0
2019-08-28 07:30:00	AAPL	Stock	50.9075	50.98	50.82	50.9	49208.0
2019-08-28 08:00:00	AAPL	Stock	50.925	51.025	50.7275	50.7775	147212.0
2019-08-28 08:30:00	AAPL	Stock	50.7925	51.275	50.7925	50.9575	127184.0
2019-08-28 09:00:00	AAPL	Stock	50.96	51.125	50.8775	51.0225	181716.0
2019-08-28 09:30:00	AAPL	Stock	51.025	51.31	50.83	51.215	10772240.0
2019-08-28 10:00:00	AAPL	Stock	51.2325	51.34	51.075	51.1425	4671132.0
2019-08-28 10:30:00	AAPL	Stock	51.1475	51.3625	51.1475	51.24	4109068.0
2019-08-28 11:00:00	AAPL	Stock	51.24	51.3625	51.1238	51.355	4149896.0
2019-08-28 11:30:00	AAPL	Stock	51.3525	51.4225	51.2775	51.33	2806708.0
2019-08-28 12:00:00	AAPL	Stock	51.3275	51.335	51.22	51.23	2120128.0
2019-08-28 12:30:00	AAPL	Stock	51.2325	51.285	51.19	51.256	1875740.0
2019-08-28 13:00:00	AAPL	Stock	51.2575	51.262	51.0875	51.1362	2056796.0
2019-08-28 13:30:00	AAPL	Stock	51.1362	51.2875	51.1025	51.2038	1993840.0
2019-08-28 14:00:00	AAPL	Stock	51.205	51.2525	51.1475	51.1675	1496052.0
2019-08-28 14:30:00	AAPL	Stock	51.1682	51.3525	51.15	51.3312	2929632.0
2019-08-28 15:00:00	AAPL	Stock	51.33	51.43	51.2975	51.305	3163268.0
2019-08-28 15:30:00	AAPL	Stock	51.3013	51.395	51.2225	51.38	4846524.0
2019-08-28 16:00:00	AAPL	Stock	51.3825	51.425	51.3195	51.3925	3461764.0
2019-08-28 16:30:00	AAPL	Stock	51.4125	51.4125	51.2775	51.28	45348.0
2019-08-28 17:00:00	AAPL	Stock	51.275	51.3825	51.275	51.3475	62952.0
2019-08-28 17:30:00	AAPL	Stock	51.375	51.375	51.3525	51.3525	3532.0
2019-08-28 18:00:00	AAPL	Stock	51.33	51.375	51.33	51.3725	37392.0
2019-08-28 18:30:00	AAPL	Stock	51.36	51.36	51.35	51.35	6800.0
2019-08-28 19:00:00	AAPL	Stock	51.3425	51.36	51.3225	51.36	4400.0
2019-08-28 19:30:00	AAPL	Stock	51.3275	51.3275	51.2775	51.3125	26740.0
2019-08-28 04:00:00	MSFT	Stock	135.83	136.08	135.82	136.08	671.0
2019-08-28 04:30:00	MSFT	Stock	136.01	136.01	136.0	136.0	200.0
2019-08-28 05:30:00	MSFT	Stock	135.84	135.84	135.84	135.84	100.0
2019-08-28 07:00:00	MSFT	Stock	135.6	135.62	135.5	135.5	2540.0
2019-08-28 07:30:00	MSFT	Stock	135.25	135.4	135.11	135.4	1199.0
2019-08-28 08:00:00	MSFT	Stock	135.62	135.74	134.55	135.0	8543.0
2019-08-28 08:30:00	MSFT	Stock	134.95	135.3	134.75	135.3	7509.0
2019-08-28 09:00:00	MSFT	Stock	135.39	135.6	134.86	134.95	15313.0
2019-08-28 09:30:00	MSFT	Stock	134.91	135.22	133.55	134.43	2480362.0
2019-08-28 10:00:00	MSFT	Stock	134.42	134.85	134.18	134.43	1154452.0
2019-08-28 10:30:00	MSFT	Stock	134.435	135.05	134.42	134.91	1135766.0
2019-08-28 11:00:00	MSFT	Stock	134.92	135.08	134.57	135.02	928306.0
2019-08-28 11:30:00	MSFT	Stock	135.01	135.298	134.93	135.103	799124.0
2019-08-28 12:00:00	MSFT	Stock	135.11	135.315	135.04	135.12	478690.0
2019-08-28 12:30:00	MSFT	Stock	135.12	135.2	134.87	135.173	670969.0
2019-08-28 13:00:00	MSFT	Stock	135.18	135.26	134.835	135.215	658654.0
2019-08-28 13:30:00	MSFT	Stock	135.22	135.39	135.11	135.2	486136.0
2019-08-28 14:00:00	MSFT	Stock	135.2	135.28	135.105	135.19	420996.0

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

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