PREVIEW / stock_30min / 2019-09-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-27.parquet
  size:    1.7 MB
  rows:    83,380
  symbols: 2,540

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-09-27 04:00:00	AAPL	Stock	54.975	55.025	54.975	55.025	2800.0
2019-09-27 05:30:00	AAPL	Stock	55.0975	55.1	55.0725	55.0725	6400.0
2019-09-27 06:00:00	AAPL	Stock	55.0725	55.16	55.0725	55.16	10952.0
2019-09-27 07:00:00	AAPL	Stock	55.1025	55.15	55.075	55.1125	20772.0
2019-09-27 07:30:00	AAPL	Stock	55.11	55.145	55.09	55.145	16796.0
2019-09-27 08:00:00	AAPL	Stock	55.15	55.195	55.0725	55.105	80084.0
2019-09-27 08:30:00	AAPL	Stock	55.12	55.145	55.025	55.1122	83220.0
2019-09-27 09:00:00	AAPL	Stock	55.1	55.145	55.035	55.11	114308.0
2019-09-27 09:30:00	AAPL	Stock	55.1075	55.24	54.99	55.06	6687268.0
2019-09-27 10:00:00	AAPL	Stock	55.045	55.1025	54.9475	55.0175	6235204.0
2019-09-27 10:30:00	AAPL	Stock	55.015	55.12	54.8675	55.0975	4575392.0
2019-09-27 11:00:00	AAPL	Stock	55.0975	55.13	55.0375	55.0925	2755088.0
2019-09-27 11:30:00	AAPL	Stock	55.09	55.1175	54.445	54.9325	8834704.0
2019-09-27 12:00:00	AAPL	Stock	54.9325	54.9925	54.75	54.7975	4610824.0
2019-09-27 12:30:00	AAPL	Stock	54.795	54.91	54.5575	54.5575	6327264.0
2019-09-27 13:00:00	AAPL	Stock	54.5575	54.7475	54.5225	54.585	4885460.0
2019-09-27 13:30:00	AAPL	Stock	54.587	54.705	54.4925	54.645	3917880.0
2019-09-27 14:00:00	AAPL	Stock	54.6475	54.66	54.455	54.5425	4279244.0
2019-09-27 14:30:00	AAPL	Stock	54.5375	54.605	54.3202	54.375	6033940.0
2019-09-27 15:00:00	AAPL	Stock	54.375	54.6475	54.375	54.5725	7016860.0
2019-09-27 15:30:00	AAPL	Stock	54.5675	54.7825	54.545	54.7125	7696948.0
2019-09-27 16:00:00	AAPL	Stock	54.7425	54.815	54.675	54.745	5106664.0
2019-09-27 16:30:00	AAPL	Stock	54.705	54.745	54.705	54.745	88616.0
2019-09-27 17:00:00	AAPL	Stock	54.745	54.745	54.7075	54.7375	24628.0
2019-09-27 17:30:00	AAPL	Stock	54.725	54.725	54.705	54.725	6644.0
2019-09-27 18:30:00	AAPL	Stock	54.6925	54.7	54.685	54.685	4636.0
2019-09-27 19:00:00	AAPL	Stock	54.7125	54.7125	54.7125	54.7125	804.0
2019-09-27 19:30:00	AAPL	Stock	54.6875	54.7125	54.6425	54.6875	22580.0
2019-09-27 04:00:00	MSFT	Stock	139.64	139.79	139.64	139.79	1628.0
2019-09-27 06:00:00	MSFT	Stock	139.9	140.03	139.9	140.03	1200.0
2019-09-27 07:00:00	MSFT	Stock	140.16	140.18	139.86	139.98	2930.0
2019-09-27 08:00:00	MSFT	Stock	139.9	139.98	139.67	139.77	7246.0
2019-09-27 08:30:00	MSFT	Stock	139.88	139.9	139.67	139.8	2535.0
2019-09-27 09:00:00	MSFT	Stock	139.88	140.48	139.671	140.25	22840.0
2019-09-27 09:30:00	MSFT	Stock	140.11	140.42	139.1	139.268	1500002.0
2019-09-27 10:00:00	MSFT	Stock	139.28	139.46	138.89	139.13	999679.0
2019-09-27 10:30:00	MSFT	Stock	139.14	139.523	138.94	139.45	728736.0
2019-09-27 11:00:00	MSFT	Stock	139.46	139.78	139.36	139.615	667361.0
2019-09-27 11:30:00	MSFT	Stock	139.61	139.62	138.04	139.06	1561981.0
2019-09-27 12:00:00	MSFT	Stock	139.06	139.135	138.65	138.76	680097.0
2019-09-27 12:30:00	MSFT	Stock	138.75	138.784	137.69	137.7	953949.0
2019-09-27 13:00:00	MSFT	Stock	137.69	138.0	137.49	137.76	1177635.0
2019-09-27 13:30:00	MSFT	Stock	137.77	137.88	137.32	137.72	1068550.0
2019-09-27 14:00:00	MSFT	Stock	137.73	137.73	137.02	137.15	1061931.0
2019-09-27 14:30:00	MSFT	Stock	137.13	137.25	136.645	137.013	1018970.0
2019-09-27 15:00:00	MSFT	Stock	137.01	137.395	136.87	137.09	1195349.0
2019-09-27 15:30:00	MSFT	Stock	137.08	137.85	137.06	137.75	2649564.0
2019-09-27 16:00:00	MSFT	Stock	137.8	137.92	137.54	137.9	2913921.0
2019-09-27 16:30:00	MSFT	Stock	137.81	138.09	137.73	138.09	56980.0
2019-09-27 17:00:00	MSFT	Stock	138.07	138.07	137.945	137.945	1208.0

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

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