PREVIEW / stock_30min / 2018-12-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-07.parquet
  size:    1.7 MB
  rows:    84,649
  symbols: 2,720

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-12-07 04:00:00	AAPL	Stock	43.4375	43.4375	43.2375	43.3025	6584.0
2018-12-07 04:30:00	AAPL	Stock	43.3375	43.4675	43.3375	43.4025	9688.0
2018-12-07 05:00:00	AAPL	Stock	43.3825	43.4675	43.3825	43.42	6800.0
2018-12-07 05:30:00	AAPL	Stock	43.485	43.485	43.4275	43.475	2820.0
2018-12-07 06:00:00	AAPL	Stock	43.4275	43.4275	43.4	43.4	6628.0
2018-12-07 06:30:00	AAPL	Stock	43.375	43.375	43.3375	43.3375	2204.0
2018-12-07 07:00:00	AAPL	Stock	43.3375	43.41	43.315	43.4	75844.0
2018-12-07 07:30:00	AAPL	Stock	43.3875	43.4125	43.365	43.4075	31860.0
2018-12-07 08:00:00	AAPL	Stock	43.35	43.55	43.315	43.55	122000.0
2018-12-07 08:30:00	AAPL	Stock	43.55	43.8	43.5325	43.6	509648.0
2018-12-07 09:00:00	AAPL	Stock	43.5875	43.6625	43.2625	43.3775	366228.0
2018-12-07 09:30:00	AAPL	Stock	43.3775	43.6225	43.14	43.415	14424080.0
2018-12-07 10:00:00	AAPL	Stock	43.425	43.4875	42.8625	42.9885	10831284.0
2018-12-07 10:30:00	AAPL	Stock	42.99	42.99	42.7575	42.9025	8787952.0
2018-12-07 11:00:00	AAPL	Stock	42.9	42.955	42.5375	42.71	11470852.0
2018-12-07 11:30:00	AAPL	Stock	42.7075	42.87	42.5225	42.53	8177936.0
2018-12-07 12:00:00	AAPL	Stock	42.5275	42.8075	42.5	42.6425	7468884.0
2018-12-07 12:30:00	AAPL	Stock	42.6325	42.865	42.5275	42.815	6374108.0
2018-12-07 13:00:00	AAPL	Stock	42.815	42.8575	42.583	42.744	4802088.0
2018-12-07 13:30:00	AAPL	Stock	42.735	42.7525	42.4045	42.4268	8201312.0
2018-12-07 14:00:00	AAPL	Stock	42.425	42.64	42.3925	42.58	9162812.0
2018-12-07 14:30:00	AAPL	Stock	42.585	42.6325	42.205	42.26	10501408.0
2018-12-07 15:00:00	AAPL	Stock	42.27	42.315	42.0775	42.2012	11974080.0
2018-12-07 15:30:00	AAPL	Stock	42.1975	42.4125	42.075	42.0975	18837012.0
2018-12-07 16:00:00	AAPL	Stock	42.095	42.1875	42.095	42.1375	14845272.0
2018-12-07 16:30:00	AAPL	Stock	42.135	42.1525	42.1125	42.1125	904276.0
2018-12-07 17:00:00	AAPL	Stock	42.1372	42.1375	42.0875	42.107	42220.0
2018-12-07 17:30:00	AAPL	Stock	42.1225	42.1625	42.1	42.1	52408.0
2018-12-07 18:00:00	AAPL	Stock	42.1	42.1	42.0525	42.0525	31432.0
2018-12-07 18:30:00	AAPL	Stock	42.05	42.1225	42.025	42.045	2197252.0
2018-12-07 19:00:00	AAPL	Stock	42.0625	42.0625	42.025	42.05	19380.0
2018-12-07 19:30:00	AAPL	Stock	42.025	42.0775	42.0225	42.0225	72736.0
2018-12-07 04:00:00	MSFT	Stock	108.42	108.5	108.42	108.5	816.0
2018-12-07 04:30:00	MSFT	Stock	108.6	108.63	108.6	108.63	1516.0
2018-12-07 05:00:00	MSFT	Stock	108.71	108.73	108.6	108.6	984.0
2018-12-07 05:30:00	MSFT	Stock	108.54	108.54	108.54	108.54	516.0
2018-12-07 06:30:00	MSFT	Stock	108.31	108.31	108.31	108.31	100.0
2018-12-07 07:00:00	MSFT	Stock	108.2	108.5	108.17	108.23	5285.0
2018-12-07 07:30:00	MSFT	Stock	108.35	108.46	108.35	108.44	1780.0
2018-12-07 08:00:00	MSFT	Stock	108.35	108.64	108.19	108.56	6816.0
2018-12-07 08:30:00	MSFT	Stock	108.79	109.16	108.5	108.52	32151.0
2018-12-07 09:00:00	MSFT	Stock	108.54	108.75	108.17	108.38	29278.0
2018-12-07 09:30:00	MSFT	Stock	108.42	109.45	108.11	109.05	3210886.0
2018-12-07 10:00:00	MSFT	Stock	109.06	109.35	107.71	108.25	2654072.0
2018-12-07 10:30:00	MSFT	Stock	108.255	108.39	107.21	107.37	2515893.0
2018-12-07 11:00:00	MSFT	Stock	107.375	107.6	106.5	106.73	2866018.0
2018-12-07 11:30:00	MSFT	Stock	106.72	107.08	106.12	106.12	2400347.0
2018-12-07 12:00:00	MSFT	Stock	106.117	106.78	106.07	106.65	1705062.0
2018-12-07 12:30:00	MSFT	Stock	106.65	106.87	105.97	106.69	1714002.0
2018-12-07 13:00:00	MSFT	Stock	106.68	106.993	106.15	106.58	1575521.0

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

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