PREVIEW / stock_30min / 2018-05-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-16.parquet
  size:    1.7 MB
  rows:    84,031
  symbols: 2,851

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-05-16 04:00:00	AAPL	Stock	46.54	46.54	46.54	46.54	3704.0
2018-05-16 04:30:00	AAPL	Stock	46.605	46.605	46.605	46.605	400.0
2018-05-16 06:30:00	AAPL	Stock	46.4875	46.4875	46.4875	46.4875	800.0
2018-05-16 07:00:00	AAPL	Stock	46.56	46.625	46.56	46.625	49976.0
2018-05-16 07:30:00	AAPL	Stock	46.6	46.6	46.5275	46.57	15852.0
2018-05-16 08:00:00	AAPL	Stock	46.639	46.64	46.525	46.575	86612.0
2018-05-16 08:30:00	AAPL	Stock	46.575	46.575	46.375	46.435	233424.0
2018-05-16 09:00:00	AAPL	Stock	46.4225	46.5625	46.4025	46.525	154788.0
2018-05-16 09:30:00	AAPL	Stock	46.525	46.7675	46.5	46.7522	9522776.0
2018-05-16 10:00:00	AAPL	Stock	46.75	46.9325	46.714	46.91	7742804.0
2018-05-16 10:30:00	AAPL	Stock	46.915	47.0938	46.915	46.965	7804696.0
2018-05-16 11:00:00	AAPL	Stock	46.965	46.9725	46.77	46.8212	5622552.0
2018-05-16 11:30:00	AAPL	Stock	46.8225	46.9675	46.8225	46.9672	3140080.0
2018-05-16 12:00:00	AAPL	Stock	46.9675	47.06	46.9525	47.005	3880468.0
2018-05-16 12:30:00	AAPL	Stock	47.006	47.065	46.975	47.0225	2675756.0
2018-05-16 13:00:00	AAPL	Stock	47.025	47.0525	46.955	46.9825	2295108.0
2018-05-16 13:30:00	AAPL	Stock	46.9828	47.0525	46.96	47.0298	2554272.0
2018-05-16 14:00:00	AAPL	Stock	47.025	47.075	46.99	47.035	2431960.0
2018-05-16 14:30:00	AAPL	Stock	47.035	47.115	47.025	47.0975	2550532.0
2018-05-16 15:00:00	AAPL	Stock	47.095	47.0975	47.0	47.03	3534916.0
2018-05-16 15:30:00	AAPL	Stock	47.0325	47.0475	46.8975	47.0475	7090416.0
2018-05-16 16:00:00	AAPL	Stock	47.045	47.045	47.0125	47.0325	7123916.0
2018-05-16 16:30:00	AAPL	Stock	47.0325	47.045	47.0125	47.035	59968.0
2018-05-16 17:00:00	AAPL	Stock	47.0338	47.035	47.0	47.0125	20916.0
2018-05-16 17:30:00	AAPL	Stock	47.0	47.0175	47.0	47.0	9516.0
2018-05-16 18:00:00	AAPL	Stock	47.0075	47.0075	47.0	47.0075	7028.0
2018-05-16 18:30:00	AAPL	Stock	47.0075	47.0175	47.0075	47.0175	3844.0
2018-05-16 19:00:00	AAPL	Stock	47.015	47.0425	47.015	47.0375	23204.0
2018-05-16 19:30:00	AAPL	Stock	47.04	47.0425	47.0375	47.0375	4020.0
2018-05-16 05:30:00	MSFT	Stock	96.85	96.85	96.8	96.81	1599.0
2018-05-16 06:00:00	MSFT	Stock	97.15	97.3	97.15	97.26	4935.0
2018-05-16 06:30:00	MSFT	Stock	97.05	97.11	97.05	97.1	1660.0
2018-05-16 07:00:00	MSFT	Stock	97.18	97.18	97.1	97.1	3791.0
2018-05-16 07:30:00	MSFT	Stock	97.02	97.02	96.98	96.98	8154.0
2018-05-16 08:00:00	MSFT	Stock	97.1	97.18	96.91	97.09	5141.0
2018-05-16 08:30:00	MSFT	Stock	97.05	97.05	96.9	97.05	6686.0
2018-05-16 09:00:00	MSFT	Stock	96.95	97.34	96.91	97.34	12893.0
2018-05-16 09:30:00	MSFT	Stock	97.35	97.38	96.615	97.14	1954953.0
2018-05-16 10:00:00	MSFT	Stock	97.15	97.32	97.01	97.11	1118655.0
2018-05-16 10:30:00	MSFT	Stock	97.11	97.34	96.87	97.005	1419119.0
2018-05-16 11:00:00	MSFT	Stock	97.005	97.02	96.66	96.715	1005155.0
2018-05-16 11:30:00	MSFT	Stock	96.72	97.0	96.71	96.95	593739.0
2018-05-16 12:00:00	MSFT	Stock	96.96	97.29	96.95	97.171	836072.0
2018-05-16 12:30:00	MSFT	Stock	97.18	97.4	97.14	97.25	743751.0
2018-05-16 13:00:00	MSFT	Stock	97.243	97.27	97.054	97.17	455096.0
2018-05-16 13:30:00	MSFT	Stock	97.16	97.25	96.8	96.935	729621.0
2018-05-16 14:00:00	MSFT	Stock	96.935	97.03	96.77	96.84	711366.0
2018-05-16 14:30:00	MSFT	Stock	96.85	97.074	96.81	97.05	493133.0
2018-05-16 15:00:00	MSFT	Stock	97.04	97.04	96.81	96.96	746754.0
2018-05-16 15:30:00	MSFT	Stock	96.96	97.15	96.67	97.15	2265273.0

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

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