PREVIEW / stock_30min / 2018-07-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-12.parquet
  size:    1.7 MB
  rows:    82,954
  symbols: 2,829

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-07-12 04:00:00	AAPL	Stock	47.1175	47.1525	47.1175	47.1525	3356.0
2018-07-12 04:30:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	3632.0
2018-07-12 05:00:00	AAPL	Stock	47.15	47.15	47.15	47.15	2800.0
2018-07-12 06:00:00	AAPL	Stock	47.0875	47.0875	47.0875	47.0875	400.0
2018-07-12 06:30:00	AAPL	Stock	47.23	47.2625	47.23	47.2625	4700.0
2018-07-12 07:00:00	AAPL	Stock	47.2625	47.2975	47.25	47.2625	50680.0
2018-07-12 07:30:00	AAPL	Stock	47.2675	47.3	47.2675	47.3	21484.0
2018-07-12 08:00:00	AAPL	Stock	47.2675	47.325	47.2525	47.3	147384.0
2018-07-12 08:30:00	AAPL	Stock	47.2875	47.3525	47.285	47.3375	148640.0
2018-07-12 09:00:00	AAPL	Stock	47.3375	47.385	47.2925	47.3675	196120.0
2018-07-12 09:30:00	AAPL	Stock	47.3825	47.5925	47.3275	47.505	9708840.0
2018-07-12 10:00:00	AAPL	Stock	47.5025	47.64	47.5	47.605	4820672.0
2018-07-12 10:30:00	AAPL	Stock	47.605	47.665	47.495	47.5075	4008560.0
2018-07-12 11:00:00	AAPL	Stock	47.5075	47.65	47.5	47.6225	3405044.0
2018-07-12 11:30:00	AAPL	Stock	47.63	47.75	47.5952	47.7425	4456176.0
2018-07-12 12:00:00	AAPL	Stock	47.7425	47.8275	47.71	47.7575	3424444.0
2018-07-12 12:30:00	AAPL	Stock	47.76	47.81	47.665	47.8	3601304.0
2018-07-12 13:00:00	AAPL	Stock	47.8015	47.8525	47.745	47.7825	3233460.0
2018-07-12 13:30:00	AAPL	Stock	47.785	47.7925	47.6775	47.69	2032860.0
2018-07-12 14:00:00	AAPL	Stock	47.69	47.7575	47.645	47.7425	1716916.0
2018-07-12 14:30:00	AAPL	Stock	47.745	47.775	47.69	47.7662	2178616.0
2018-07-12 15:00:00	AAPL	Stock	47.765	47.7875	47.6778	47.73	3331076.0
2018-07-12 15:30:00	AAPL	Stock	47.7325	47.79	47.645	47.76	7761176.0
2018-07-12 16:00:00	AAPL	Stock	47.7575	47.7775	47.73	47.73	9569800.0
2018-07-12 16:30:00	AAPL	Stock	47.73	47.7575	47.705	47.72	150796.0
2018-07-12 17:00:00	AAPL	Stock	47.72	47.7575	47.7125	47.72	163828.0
2018-07-12 17:30:00	AAPL	Stock	47.7125	47.72	47.7125	47.72	7508.0
2018-07-12 18:00:00	AAPL	Stock	47.705	47.72	47.705	47.72	3500.0
2018-07-12 18:30:00	AAPL	Stock	47.71	47.71	47.625	47.7	45952.0
2018-07-12 19:00:00	AAPL	Stock	47.7	47.75	47.7	47.75	51460.0
2018-07-12 19:30:00	AAPL	Stock	47.76	47.7775	47.755	47.7725	45940.0
2018-07-12 04:00:00	MSFT	Stock	102.4	102.4	102.4	102.4	100.0
2018-07-12 04:30:00	MSFT	Stock	102.15	102.15	102.15	102.15	100.0
2018-07-12 05:00:00	MSFT	Stock	102.5	102.5	102.5	102.5	200.0
2018-07-12 06:30:00	MSFT	Stock	102.49	102.63	102.49	102.62	2800.0
2018-07-12 07:00:00	MSFT	Stock	102.41	102.6	102.4	102.6	6619.0
2018-07-12 07:30:00	MSFT	Stock	102.55	102.65	102.55	102.65	9523.0
2018-07-12 08:00:00	MSFT	Stock	102.45	102.69	102.45	102.65	16866.0
2018-07-12 08:30:00	MSFT	Stock	102.65	102.72	102.6	102.71	25958.0
2018-07-12 09:00:00	MSFT	Stock	102.71	102.78	102.58	102.76	25729.0
2018-07-12 09:30:00	MSFT	Stock	102.76	103.32	102.73	103.164	3433820.0
2018-07-12 10:00:00	MSFT	Stock	103.16	103.44	103.1	103.435	1798754.0
2018-07-12 10:30:00	MSFT	Stock	103.44	103.53	103.39	103.405	1674891.0
2018-07-12 11:00:00	MSFT	Stock	103.41	103.9	103.405	103.785	1347131.0
2018-07-12 11:30:00	MSFT	Stock	103.79	104.15	103.64	104.145	1194832.0
2018-07-12 12:00:00	MSFT	Stock	104.135	104.41	104.07	104.14	1398375.0
2018-07-12 12:30:00	MSFT	Stock	104.138	104.195	103.94	104.07	1070586.0
2018-07-12 13:00:00	MSFT	Stock	104.074	104.26	104.07	104.26	776057.0
2018-07-12 13:30:00	MSFT	Stock	104.27	104.355	104.11	104.18	781603.0
2018-07-12 14:00:00	MSFT	Stock	104.18	104.38	104.07	104.346	964418.0

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

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