PREVIEW / stock_30min / 2018-11-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-06.parquet
  size:    1.7 MB
  rows:    82,792
  symbols: 2,751

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
2018-11-06 04:00:00	AAPL	Stock	50.4725	50.4725	50.375	50.375	2064.0
2018-11-06 04:30:00	AAPL	Stock	50.1375	50.1375	50.11	50.11	1300.0
2018-11-06 05:00:00	AAPL	Stock	50.15	50.215	50.065	50.215	15588.0
2018-11-06 05:30:00	AAPL	Stock	50.1	50.25	50.1	50.2475	2000.0
2018-11-06 06:00:00	AAPL	Stock	50.16	50.2	50.0625	50.1	20660.0
2018-11-06 06:30:00	AAPL	Stock	50.205	50.21	50.14	50.14	7272.0
2018-11-06 07:00:00	AAPL	Stock	50.16	50.2025	50.0525	50.15	110428.0
2018-11-06 07:30:00	AAPL	Stock	50.1875	50.35	50.0625	50.35	142016.0
2018-11-06 08:00:00	AAPL	Stock	50.1775	50.35	50.0525	50.15	232104.0
2018-11-06 08:30:00	AAPL	Stock	50.1525	50.3375	50.15	50.325	245540.0
2018-11-06 09:00:00	AAPL	Stock	50.3325	50.4875	50.305	50.4875	285424.0
2018-11-06 09:30:00	AAPL	Stock	50.48	51.18	50.4375	51.0625	24975556.0
2018-11-06 10:00:00	AAPL	Stock	51.0625	51.1225	50.7925	50.91	11725348.0
2018-11-06 10:30:00	AAPL	Stock	50.9125	50.9375	50.6775	50.7325	8167216.0
2018-11-06 11:00:00	AAPL	Stock	50.7375	50.9625	50.605	50.8525	8243244.0
2018-11-06 11:30:00	AAPL	Stock	50.8575	50.955	50.7385	50.89	4960040.0
2018-11-06 12:00:00	AAPL	Stock	50.8875	50.9525	50.74	50.7548	3983644.0
2018-11-06 12:30:00	AAPL	Stock	50.7575	50.8725	50.6875	50.74	3458636.0
2018-11-06 13:00:00	AAPL	Stock	50.7425	50.84	50.705	50.7362	3417912.0
2018-11-06 13:30:00	AAPL	Stock	50.735	50.82	50.7125	50.73	2753864.0
2018-11-06 14:00:00	AAPL	Stock	50.7275	50.745	50.4675	50.53	5837096.0
2018-11-06 14:30:00	AAPL	Stock	50.52	50.6	50.4225	50.559	5542532.0
2018-11-06 15:00:00	AAPL	Stock	50.56	50.6825	50.4625	50.6592	5276844.0
2018-11-06 15:30:00	AAPL	Stock	50.6602	51.015	50.6475	50.945	10630104.0
2018-11-06 16:00:00	AAPL	Stock	50.945	51.0528	50.9425	50.985	9366540.0
2018-11-06 16:30:00	AAPL	Stock	51.0	51.0125	50.9875	51.01	87756.0
2018-11-06 17:00:00	AAPL	Stock	51.0025	51.0025	50.99	50.9925	32576.0
2018-11-06 17:30:00	AAPL	Stock	51.0	51.025	51.0	51.0225	61232.0
2018-11-06 18:00:00	AAPL	Stock	51.0075	51.02	50.9325	51.0025	71728.0
2018-11-06 18:30:00	AAPL	Stock	51.0	51.0125	50.9425	50.9875	83160.0
2018-11-06 19:00:00	AAPL	Stock	50.9625	51.03	50.9625	51.025	40560.0
2018-11-06 19:30:00	AAPL	Stock	51.0225	51.0625	50.8125	50.95	119772.0
2018-11-06 05:00:00	MSFT	Stock	107.0	107.01	107.0	107.0	2166.0
2018-11-06 05:30:00	MSFT	Stock	107.2	107.2	107.2	107.2	454.0
2018-11-06 06:30:00	MSFT	Stock	107.04	107.3	107.04	107.3	346.0
2018-11-06 07:00:00	MSFT	Stock	107.45	107.45	107.1	107.2	2064.0
2018-11-06 07:30:00	MSFT	Stock	107.25	107.32	107.22	107.28	1152.0
2018-11-06 08:00:00	MSFT	Stock	107.4	107.5	107.15	107.2	5600.0
2018-11-06 08:30:00	MSFT	Stock	107.33	107.51	107.15	107.15	44353.0
2018-11-06 09:00:00	MSFT	Stock	107.3	107.35	107.28	107.29	900.0
2018-11-06 09:30:00	MSFT	Stock	107.38	108.84	107.23	108.4	3055673.0
2018-11-06 10:00:00	MSFT	Stock	108.39	108.5	107.76	107.78	2000942.0
2018-11-06 10:30:00	MSFT	Stock	107.78	108.18	107.13	107.19	1973631.0
2018-11-06 11:00:00	MSFT	Stock	107.19	107.619	106.89	107.21	1512695.0
2018-11-06 11:30:00	MSFT	Stock	107.228	107.55	107.02	107.31	1003913.0
2018-11-06 12:00:00	MSFT	Stock	107.31	107.63	107.19	107.6	852814.0
2018-11-06 12:30:00	MSFT	Stock	107.606	107.875	107.565	107.755	1114475.0
2018-11-06 13:00:00	MSFT	Stock	107.74	107.78	107.35	107.35	621293.0
2018-11-06 13:30:00	MSFT	Stock	107.354	107.54	107.13	107.13	710522.0
2018-11-06 14:00:00	MSFT	Stock	107.13	107.17	106.28	106.426	1307846.0

> showing 50 of 82,792 rows — these rows as CSV

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