PREVIEW / stock_30min / 2019-01-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-25.parquet
  size:    1.7 MB
  rows:    83,225
  symbols: 2,679

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-25 04:00:00	AAPL	Stock	38.3875	38.5525	38.3875	38.5	20072.0
2019-01-25 04:30:00	AAPL	Stock	38.5	38.5	38.4375	38.4375	13360.0
2019-01-25 05:00:00	AAPL	Stock	38.475	38.475	38.415	38.415	2396.0
2019-01-25 05:30:00	AAPL	Stock	38.5	38.5	38.5	38.5	4704.0
2019-01-25 06:00:00	AAPL	Stock	38.465	38.4975	38.45	38.45	9036.0
2019-01-25 06:30:00	AAPL	Stock	38.4375	38.4875	38.425	38.445	19328.0
2019-01-25 07:00:00	AAPL	Stock	38.47	38.47	38.3425	38.4325	126756.0
2019-01-25 07:30:00	AAPL	Stock	38.4275	38.4625	38.375	38.4575	54204.0
2019-01-25 08:00:00	AAPL	Stock	38.41	38.575	38.275	38.54	286268.0
2019-01-25 08:30:00	AAPL	Stock	38.5575	38.845	38.5575	38.7775	583908.0
2019-01-25 09:00:00	AAPL	Stock	38.7825	38.875	38.745	38.8575	580212.0
2019-01-25 09:30:00	AAPL	Stock	38.82	39.09	38.58	39.0802	22375452.0
2019-01-25 10:00:00	AAPL	Stock	39.0775	39.2675	39.07	39.185	14475196.0
2019-01-25 10:30:00	AAPL	Stock	39.1825	39.3125	39.1275	39.29	7969628.0
2019-01-25 11:00:00	AAPL	Stock	39.29	39.3125	39.0575	39.09	6857304.0
2019-01-25 11:30:00	AAPL	Stock	39.095	39.275	39.09	39.2525	6379328.0
2019-01-25 12:00:00	AAPL	Stock	39.2525	39.2625	39.1475	39.235	4106836.0
2019-01-25 12:30:00	AAPL	Stock	39.2325	39.305	39.14	39.215	5159772.0
2019-01-25 13:00:00	AAPL	Stock	39.215	39.3075	39.155	39.2875	3993776.0
2019-01-25 13:30:00	AAPL	Stock	39.2875	39.41	39.285	39.4068	5353056.0
2019-01-25 14:00:00	AAPL	Stock	39.41	39.5325	39.3182	39.3625	8407680.0
2019-01-25 14:30:00	AAPL	Stock	39.3625	39.4775	39.34	39.4045	5297432.0
2019-01-25 15:00:00	AAPL	Stock	39.4025	39.47	39.3275	39.3875	5382916.0
2019-01-25 15:30:00	AAPL	Stock	39.3875	39.505	39.305	39.43	14529864.0
2019-01-25 16:00:00	AAPL	Stock	39.44	39.46	39.203	39.4375	7236084.0
2019-01-25 16:30:00	AAPL	Stock	39.4425	39.4775	39.4425	39.4775	39832.0
2019-01-25 17:00:00	AAPL	Stock	39.4625	39.475	39.43	39.43	26908.0
2019-01-25 17:30:00	AAPL	Stock	39.4375	39.45	39.43	39.445	25996.0
2019-01-25 18:00:00	AAPL	Stock	39.45	39.45	39.425	39.4425	20036.0
2019-01-25 18:30:00	AAPL	Stock	39.4425	39.4725	39.4375	39.4725	15924.0
2019-01-25 19:00:00	AAPL	Stock	39.47	39.4925	39.455	39.4925	32916.0
2019-01-25 19:30:00	AAPL	Stock	39.465	39.4875	39.455	39.455	37616.0
2019-01-25 04:00:00	MSFT	Stock	106.54	106.6	106.49	106.6	800.0
2019-01-25 04:30:00	MSFT	Stock	106.6	106.6	106.6	106.6	1000.0
2019-01-25 05:00:00	MSFT	Stock	106.6	106.6	106.6	106.6	100.0
2019-01-25 05:30:00	MSFT	Stock	106.63	106.68	106.6	106.6	1458.0
2019-01-25 06:00:00	MSFT	Stock	106.78	106.78	106.61	106.63	694.0
2019-01-25 06:30:00	MSFT	Stock	106.6	106.85	106.5	106.83	3324.0
2019-01-25 07:00:00	MSFT	Stock	106.7	106.88	106.66	106.75	11237.0
2019-01-25 07:30:00	MSFT	Stock	106.74	106.76	106.54	106.76	19590.0
2019-01-25 08:00:00	MSFT	Stock	106.89	106.978	106.45	106.86	28739.0
2019-01-25 08:30:00	MSFT	Stock	106.91	107.5	106.85	107.3	47057.0
2019-01-25 09:00:00	MSFT	Stock	107.25	107.35	107.04	107.24	35073.0
2019-01-25 09:30:00	MSFT	Stock	107.24	107.25	106.59	107.095	3659161.0
2019-01-25 10:00:00	MSFT	Stock	107.09	107.5	106.98	107.37	2624614.0
2019-01-25 10:30:00	MSFT	Stock	107.38	107.58	107.16	107.565	1653299.0
2019-01-25 11:00:00	MSFT	Stock	107.57	107.74	107.4	107.455	1622098.0
2019-01-25 11:30:00	MSFT	Stock	107.45	107.82	107.305	107.81	1740075.0
2019-01-25 12:00:00	MSFT	Stock	107.81	107.88	107.574	107.74	1098571.0
2019-01-25 12:30:00	MSFT	Stock	107.74	107.85	107.24	107.34	1186665.0

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

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