PREVIEW / stock_30min / 2019-11-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-06.parquet
  size:    1.7 MB
  rows:    85,106
  symbols: 2,517

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-11-06 04:00:00	AAPL	Stock	64.2375	64.275	64.2225	64.25	6060.0
2019-11-06 04:30:00	AAPL	Stock	64.195	64.195	64.1575	64.175	18840.0
2019-11-06 05:00:00	AAPL	Stock	64.1925	64.195	64.1275	64.155	8032.0
2019-11-06 05:30:00	AAPL	Stock	64.1625	64.1625	64.1625	64.1625	3204.0
2019-11-06 06:00:00	AAPL	Stock	64.175	64.175	64.0025	64.1225	25448.0
2019-11-06 06:30:00	AAPL	Stock	64.115	64.145	64.1075	64.135	14416.0
2019-11-06 07:00:00	AAPL	Stock	64.15	64.235	64.125	64.2	78944.0
2019-11-06 07:30:00	AAPL	Stock	64.1775	64.27	64.17	64.265	51784.0
2019-11-06 08:00:00	AAPL	Stock	64.1875	64.275	64.1225	64.2475	145140.0
2019-11-06 08:30:00	AAPL	Stock	64.2475	64.3125	64.22	64.27	95844.0
2019-11-06 09:00:00	AAPL	Stock	64.2375	64.24	64.175	64.195	97080.0
2019-11-06 09:30:00	AAPL	Stock	64.2175	64.3725	64.0925	64.2775	8699588.0
2019-11-06 10:00:00	AAPL	Stock	64.2725	64.3025	64.1675	64.1858	3984684.0
2019-11-06 10:30:00	AAPL	Stock	64.1875	64.195	64.0075	64.025	3958212.0
2019-11-06 11:00:00	AAPL	Stock	64.025	64.1625	63.9175	64.07	4467724.0
2019-11-06 11:30:00	AAPL	Stock	64.0675	64.3375	63.8412	64.0325	6826616.0
2019-11-06 12:00:00	AAPL	Stock	64.0375	64.1038	63.9275	63.945	3110508.0
2019-11-06 12:30:00	AAPL	Stock	63.9475	64.0175	63.8875	63.9605	2264784.0
2019-11-06 13:00:00	AAPL	Stock	63.965	64.0625	63.905	64.03	2365104.0
2019-11-06 13:30:00	AAPL	Stock	64.0312	64.145	64.0168	64.095	2046680.0
2019-11-06 14:00:00	AAPL	Stock	64.0975	64.1825	64.085	64.1258	2055124.0
2019-11-06 14:30:00	AAPL	Stock	64.1288	64.1675	64.1125	64.1625	1735308.0
2019-11-06 15:00:00	AAPL	Stock	64.1625	64.185	64.125	64.1275	2048392.0
2019-11-06 15:30:00	AAPL	Stock	64.13	64.3325	64.1075	64.31	7095484.0
2019-11-06 16:00:00	AAPL	Stock	64.31	64.35	64.28	64.3275	10886868.0
2019-11-06 16:30:00	AAPL	Stock	64.35	64.375	64.31	64.3275	260404.0
2019-11-06 17:00:00	AAPL	Stock	64.33	64.3875	64.31	64.37	113588.0
2019-11-06 17:30:00	AAPL	Stock	64.3825	64.3875	64.33	64.375	16656.0
2019-11-06 18:00:00	AAPL	Stock	64.375	64.3925	64.355	64.355	13756.0
2019-11-06 18:30:00	AAPL	Stock	64.3625	64.3625	64.3325	64.355	21092.0
2019-11-06 19:00:00	AAPL	Stock	64.34	64.3625	64.34	64.34	14560.0
2019-11-06 19:30:00	AAPL	Stock	64.3725	64.425	64.3725	64.3975	18900.0
2019-11-06 04:00:00	MSFT	Stock	144.3	144.6	144.3	144.53	1738.0
2019-11-06 04:30:00	MSFT	Stock	144.35	144.35	144.27	144.27	688.0
2019-11-06 05:00:00	MSFT	Stock	144.36	144.36	144.32	144.32	690.0
2019-11-06 05:30:00	MSFT	Stock	144.55	144.58	144.55	144.58	400.0
2019-11-06 06:00:00	MSFT	Stock	144.51	144.6	144.46	144.6	600.0
2019-11-06 06:30:00	MSFT	Stock	144.45	144.57	144.45	144.57	1467.0
2019-11-06 07:00:00	MSFT	Stock	144.45	144.58	144.45	144.58	747.0
2019-11-06 07:30:00	MSFT	Stock	144.53	144.53	144.53	144.53	1398.0
2019-11-06 08:00:00	MSFT	Stock	144.351	144.58	144.351	144.46	5156.0
2019-11-06 08:30:00	MSFT	Stock	144.41	144.58	144.364	144.54	20135.0
2019-11-06 09:00:00	MSFT	Stock	144.58	144.58	144.0	144.33	14291.0
2019-11-06 09:30:00	MSFT	Stock	144.34	144.52	143.76	144.04	1829038.0
2019-11-06 10:00:00	MSFT	Stock	144.04	144.136	143.79	143.83	1022611.0
2019-11-06 10:30:00	MSFT	Stock	143.825	144.01	143.79	143.88	752755.0
2019-11-06 11:00:00	MSFT	Stock	143.88	143.95	143.71	143.88	690058.0
2019-11-06 11:30:00	MSFT	Stock	143.875	144.2	143.2	143.45	1686734.0
2019-11-06 12:00:00	MSFT	Stock	143.47	143.755	143.44	143.58	653880.0
2019-11-06 12:30:00	MSFT	Stock	143.58	143.79	143.55	143.76	416057.0

> showing 50 of 85,106 rows — these rows as CSV

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