PREVIEW / stock_30min / 2019-12-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-11.parquet
  size:    1.7 MB
  rows:    85,258
  symbols: 2,481

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-12-11 04:00:00	AAPL	Stock	67.13	67.225	67.1025	67.2075	14580.0
2019-12-11 04:30:00	AAPL	Stock	67.15	67.15	67.15	67.15	688.0
2019-12-11 05:00:00	AAPL	Stock	67.1925	67.2675	67.1925	67.2675	2888.0
2019-12-11 05:30:00	AAPL	Stock	67.25	67.25	67.1925	67.1925	14936.0
2019-12-11 06:00:00	AAPL	Stock	67.2225	67.315	67.2225	67.3	6480.0
2019-12-11 06:30:00	AAPL	Stock	67.2875	67.4075	67.2875	67.375	9940.0
2019-12-11 07:00:00	AAPL	Stock	67.3625	67.4	67.2775	67.2775	28352.0
2019-12-11 07:30:00	AAPL	Stock	67.3125	67.4	67.3125	67.3425	85232.0
2019-12-11 08:00:00	AAPL	Stock	67.343	67.4125	67.2875	67.3375	91604.0
2019-12-11 08:30:00	AAPL	Stock	67.3375	67.4375	67.325	67.4	102920.0
2019-12-11 09:00:00	AAPL	Stock	67.3875	67.405	67.1925	67.2175	229348.0
2019-12-11 09:30:00	AAPL	Stock	67.2	67.685	67.125	67.66	12038988.0
2019-12-11 10:00:00	AAPL	Stock	67.66	67.7675	67.5575	67.606	7435868.0
2019-12-11 10:30:00	AAPL	Stock	67.6025	67.6125	67.335	67.365	5215848.0
2019-12-11 11:00:00	AAPL	Stock	67.365	67.575	67.2712	67.5375	4428472.0
2019-12-11 11:30:00	AAPL	Stock	67.54	67.6025	67.505	67.515	2901616.0
2019-12-11 12:00:00	AAPL	Stock	67.515	67.56	67.405	67.41	1981152.0
2019-12-11 12:30:00	AAPL	Stock	67.4088	67.5	67.4025	67.4925	2228508.0
2019-12-11 13:00:00	AAPL	Stock	67.495	67.5535	67.4675	67.5375	2031644.0
2019-12-11 13:30:00	AAPL	Stock	67.54	67.5575	67.45	67.4775	1517220.0
2019-12-11 14:00:00	AAPL	Stock	67.48	67.6625	67.445	67.568	4237780.0
2019-12-11 14:30:00	AAPL	Stock	67.5678	67.6675	67.5258	67.665	3218240.0
2019-12-11 15:00:00	AAPL	Stock	67.665	67.685	67.535	67.65	3428904.0
2019-12-11 15:30:00	AAPL	Stock	67.655	67.775	67.5875	67.685	7913628.0
2019-12-11 16:00:00	AAPL	Stock	67.6925	67.745	67.6625	67.6938	7858760.0
2019-12-11 16:30:00	AAPL	Stock	67.6775	67.7025	67.6775	67.7025	49156.0
2019-12-11 17:00:00	AAPL	Stock	67.7075	67.7175	67.6875	67.7	37000.0
2019-12-11 17:30:00	AAPL	Stock	67.7025	67.71	67.6875	67.6875	10356.0
2019-12-11 18:00:00	AAPL	Stock	67.6975	67.7	67.6825	67.7	10440.0
2019-12-11 18:30:00	AAPL	Stock	67.6975	67.75	67.6975	67.745	41004.0
2019-12-11 19:00:00	AAPL	Stock	67.75	67.75	67.725	67.725	39364.0
2019-12-11 19:30:00	AAPL	Stock	67.7125	67.7625	67.675	67.7625	23496.0
2019-12-11 05:00:00	MSFT	Stock	151.4	151.4	151.4	151.4	100.0
2019-12-11 05:30:00	MSFT	Stock	151.3	151.34	151.0	151.34	1352.0
2019-12-11 06:00:00	MSFT	Stock	151.34	151.34	151.18	151.18	1898.0
2019-12-11 06:30:00	MSFT	Stock	151.3	151.3	151.3	151.3	100.0
2019-12-11 07:00:00	MSFT	Stock	151.39	151.39	151.29	151.29	1303.0
2019-12-11 07:30:00	MSFT	Stock	151.28	151.4	151.28	151.4	1873.0
2019-12-11 08:00:00	MSFT	Stock	151.3	151.45	151.26	151.4	13293.0
2019-12-11 08:30:00	MSFT	Stock	151.44	151.6	151.4	151.42	7415.0
2019-12-11 09:00:00	MSFT	Stock	151.44	151.83	151.38	151.79	23879.0
2019-12-11 09:30:00	MSFT	Stock	151.61	151.83	150.33	150.9	2618839.0
2019-12-11 10:00:00	MSFT	Stock	150.9	151.07	150.85	150.95	1059463.0
2019-12-11 10:30:00	MSFT	Stock	150.96	151.19	150.87	151.04	872233.0
2019-12-11 11:00:00	MSFT	Stock	151.04	151.26	150.91	151.23	802607.0
2019-12-11 11:30:00	MSFT	Stock	151.24	151.45	151.035	151.1	1034819.0
2019-12-11 12:00:00	MSFT	Stock	151.09	151.24	151.03	151.105	506586.0
2019-12-11 12:30:00	MSFT	Stock	151.11	151.16	150.96	151.14	396164.0
2019-12-11 13:00:00	MSFT	Stock	151.145	151.18	150.994	151.117	367903.0
2019-12-11 13:30:00	MSFT	Stock	151.115	151.17	151.03	151.12	324827.0

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

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