PREVIEW / stock_30min / 2019-01-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-15.parquet
  size:    1.7 MB
  rows:    83,083
  symbols: 2,697

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-01-15 04:00:00	AAPL	Stock	37.765	37.765	37.7	37.7	18020.0
2019-01-15 04:30:00	AAPL	Stock	37.6	37.6	37.6	37.6	1444.0
2019-01-15 05:00:00	AAPL	Stock	37.7075	37.7075	37.7	37.7	1200.0
2019-01-15 05:30:00	AAPL	Stock	37.6275	37.6975	37.625	37.6975	4216.0
2019-01-15 06:00:00	AAPL	Stock	37.69	37.7	37.69	37.69	11408.0
2019-01-15 06:30:00	AAPL	Stock	37.69	37.7	37.6	37.6	12184.0
2019-01-15 07:00:00	AAPL	Stock	37.6	37.645	37.5775	37.6225	33836.0
2019-01-15 07:30:00	AAPL	Stock	37.6125	37.6375	37.5875	37.6375	75476.0
2019-01-15 08:00:00	AAPL	Stock	37.65	37.6775	37.5625	37.5625	197540.0
2019-01-15 08:30:00	AAPL	Stock	37.5775	37.6	37.5275	37.53	129216.0
2019-01-15 09:00:00	AAPL	Stock	37.547	37.5875	37.5025	37.5575	265100.0
2019-01-15 09:30:00	AAPL	Stock	37.5675	37.975	37.5125	37.89	13553144.0
2019-01-15 10:00:00	AAPL	Stock	37.89	38.1575	37.8325	37.8975	10527972.0
2019-01-15 10:30:00	AAPL	Stock	37.9025	38.0225	37.83	37.9725	6041360.0
2019-01-15 11:00:00	AAPL	Stock	37.9725	37.9725	37.8325	37.92	4537156.0
2019-01-15 11:30:00	AAPL	Stock	37.925	38.155	37.9125	38.135	5350424.0
2019-01-15 12:00:00	AAPL	Stock	38.133	38.2225	38.0925	38.1225	5088304.0
2019-01-15 12:30:00	AAPL	Stock	38.1225	38.2	38.09	38.175	3839436.0
2019-01-15 13:00:00	AAPL	Stock	38.1775	38.2525	38.16	38.195	4213612.0
2019-01-15 13:30:00	AAPL	Stock	38.195	38.2975	38.1925	38.2678	4437232.0
2019-01-15 14:00:00	AAPL	Stock	38.2675	38.3475	38.0825	38.09	6560084.0
2019-01-15 14:30:00	AAPL	Stock	38.09	38.1725	37.96	38.165	4905524.0
2019-01-15 15:00:00	AAPL	Stock	38.165	38.3	38.1475	38.2422	4974616.0
2019-01-15 15:30:00	AAPL	Stock	38.245	38.3425	38.18	38.2625	9808776.0
2019-01-15 16:00:00	AAPL	Stock	38.2675	38.3	38.1775	38.245	7248864.0
2019-01-15 16:30:00	AAPL	Stock	38.2125	38.2718	38.2125	38.2275	47456.0
2019-01-15 17:00:00	AAPL	Stock	38.225	38.25	38.225	38.225	24668.0
2019-01-15 17:30:00	AAPL	Stock	38.2525	38.275	38.2475	38.25	13748.0
2019-01-15 18:00:00	AAPL	Stock	38.2375	38.3475	38.2375	38.315	98736.0
2019-01-15 18:30:00	AAPL	Stock	38.325	38.3525	38.325	38.335	23808.0
2019-01-15 19:00:00	AAPL	Stock	38.35	38.35	38.25	38.2625	28168.0
2019-01-15 19:30:00	AAPL	Stock	38.265	38.3375	38.265	38.275	29680.0
2019-01-15 04:00:00	MSFT	Stock	102.97	102.97	102.66	102.66	600.0
2019-01-15 04:30:00	MSFT	Stock	102.59	102.59	102.59	102.59	200.0
2019-01-15 05:00:00	MSFT	Stock	102.7	102.7	102.68	102.68	595.0
2019-01-15 05:30:00	MSFT	Stock	102.5	102.5	102.31	102.5	2993.0
2019-01-15 06:00:00	MSFT	Stock	102.5	102.5	102.46	102.46	200.0
2019-01-15 06:30:00	MSFT	Stock	102.36	102.36	102.31	102.31	447.0
2019-01-15 07:00:00	MSFT	Stock	102.3	102.42	102.25	102.27	6265.0
2019-01-15 07:30:00	MSFT	Stock	102.35	102.66	102.35	102.6	13790.0
2019-01-15 08:00:00	MSFT	Stock	102.4	102.8	102.33	102.35	12817.0
2019-01-15 08:30:00	MSFT	Stock	102.55	102.76	102.26	102.62	39632.0
2019-01-15 09:00:00	MSFT	Stock	102.65	102.75	102.4	102.5	72591.0
2019-01-15 09:30:00	MSFT	Stock	102.59	104.52	101.88	104.46	4414644.0
2019-01-15 10:00:00	MSFT	Stock	104.47	104.79	104.191	104.51	2913070.0
2019-01-15 10:30:00	MSFT	Stock	104.52	104.75	104.28	104.39	1982567.0
2019-01-15 11:00:00	MSFT	Stock	104.4	104.64	104.16	104.288	1333508.0
2019-01-15 11:30:00	MSFT	Stock	104.29	104.75	104.18	104.7	1853857.0
2019-01-15 12:00:00	MSFT	Stock	104.71	104.86	104.63	104.69	1290756.0
2019-01-15 12:30:00	MSFT	Stock	104.69	104.81	104.57	104.76	920367.0

> showing 50 of 83,083 rows — these rows as CSV

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