PREVIEW / stock_30min / 2020-05-26

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-26.parquet
  size:    2.0 MB
  rows:    99,234
  symbols: 2,380

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
2020-05-26 04:00:00	AAPL	Stock	80.7875	81.3	80.7775	81.255	24976.0
2020-05-26 04:30:00	AAPL	Stock	81.33	81.3625	81.25	81.3625	7608.0
2020-05-26 05:00:00	AAPL	Stock	81.355	81.375	81.3425	81.35	8088.0
2020-05-26 05:30:00	AAPL	Stock	81.305	81.35	81.275	81.2875	6816.0
2020-05-26 06:00:00	AAPL	Stock	81.125	81.245	81.1225	81.175	18484.0
2020-05-26 06:30:00	AAPL	Stock	81.25	81.31	81.1075	81.1075	18120.0
2020-05-26 07:00:00	AAPL	Stock	81.1075	81.14	80.7675	80.9375	195060.0
2020-05-26 07:30:00	AAPL	Stock	80.9	81.0725	80.9	80.97	141952.0
2020-05-26 08:00:00	AAPL	Stock	80.925	81.0725	80.85	80.975	289036.0
2020-05-26 08:30:00	AAPL	Stock	80.9625	81.0475	80.8775	80.99	130916.0
2020-05-26 09:00:00	AAPL	Stock	80.995	81.4875	80.825	80.87	536444.0
2020-05-26 09:30:00	AAPL	Stock	80.8675	81.06	79.93	79.9838	16021492.0
2020-05-26 10:00:00	AAPL	Stock	79.9875	80.455	79.96	80.4375	7826084.0
2020-05-26 10:30:00	AAPL	Stock	80.4322	80.45	79.985	80.24	5953172.0
2020-05-26 11:00:00	AAPL	Stock	80.235	80.3615	79.845	79.965	4932596.0
2020-05-26 11:30:00	AAPL	Stock	79.9525	79.9775	79.175	79.7162	10290960.0
2020-05-26 12:00:00	AAPL	Stock	79.715	79.8912	79.6275	79.8425	5450600.0
2020-05-26 12:30:00	AAPL	Stock	79.8475	80.1325	79.8375	80.0108	4779344.0
2020-05-26 13:00:00	AAPL	Stock	80.015	80.3425	79.825	80.2325	7750848.0
2020-05-26 13:30:00	AAPL	Stock	80.24	80.245	79.9525	80.03	3789680.0
2020-05-26 14:00:00	AAPL	Stock	80.0275	80.0675	79.7775	79.7825	3700520.0
2020-05-26 14:30:00	AAPL	Stock	79.7825	79.8525	79.6275	79.8213	3718476.0
2020-05-26 15:00:00	AAPL	Stock	79.8175	79.86	79.355	79.355	6191376.0
2020-05-26 15:30:00	AAPL	Stock	79.3575	79.5625	79.125	79.21	11845176.0
2020-05-26 16:00:00	AAPL	Stock	79.1825	79.37	79.1625	79.35	11618568.0
2020-05-26 16:30:00	AAPL	Stock	79.3375	79.3875	79.28	79.3475	45472.0
2020-05-26 17:00:00	AAPL	Stock	79.3275	79.3625	79.3275	79.3325	8668.0
2020-05-26 17:30:00	AAPL	Stock	79.34	79.3675	79.3325	79.3325	9864.0
2020-05-26 18:00:00	AAPL	Stock	79.3125	79.4	79.2625	79.3375	13648.0
2020-05-26 18:30:00	AAPL	Stock	79.34	79.3425	79.2825	79.325	15000.0
2020-05-26 19:00:00	AAPL	Stock	79.3275	79.355	79.2525	79.2525	16124.0
2020-05-26 19:30:00	AAPL	Stock	79.2525	79.2525	79.1875	79.22	62732.0
2020-05-26 04:00:00	MSFT	Stock	186.7	187.0	186.6	186.99	9531.0
2020-05-26 04:30:00	MSFT	Stock	186.98	187.0	186.7	187.0	2578.0
2020-05-26 05:00:00	MSFT	Stock	187.2	187.6	187.2	187.39	2389.0
2020-05-26 05:30:00	MSFT	Stock	187.01	187.2	186.95	186.99	2106.0
2020-05-26 06:00:00	MSFT	Stock	186.89	187.2	186.71	187.0	2853.0
2020-05-26 06:30:00	MSFT	Stock	187.0	187.19	186.64	186.64	8093.0
2020-05-26 07:00:00	MSFT	Stock	186.62	186.92	185.91	186.37	33777.0
2020-05-26 07:30:00	MSFT	Stock	186.12	186.35	186.01	186.25	8420.0
2020-05-26 08:00:00	MSFT	Stock	186.23	186.55	185.54	185.6	59940.0
2020-05-26 08:30:00	MSFT	Stock	185.829	185.93	185.05	185.709	38905.0
2020-05-26 09:00:00	MSFT	Stock	185.65	186.55	185.65	186.43	116924.0
2020-05-26 09:30:00	MSFT	Stock	186.34	186.5	183.65	184.08	4577694.0
2020-05-26 10:00:00	MSFT	Stock	184.085	184.59	184.02	184.24	1983475.0
2020-05-26 10:30:00	MSFT	Stock	184.24	184.28	183.4	183.74	1946748.0
2020-05-26 11:00:00	MSFT	Stock	183.74	183.83	182.825	183.309	1958155.0
2020-05-26 11:30:00	MSFT	Stock	183.31	183.32	182.32	183.0	1580653.0
2020-05-26 12:00:00	MSFT	Stock	183.0	183.14	182.5	182.731	1229421.0
2020-05-26 12:30:00	MSFT	Stock	182.725	183.43	182.722	183.205	1105172.0

> showing 50 of 99,234 rows — these rows as CSV

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