PREVIEW / stock_30min / 2020-07-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-28.parquet
  size:    1.9 MB
  rows:    95,299
  symbols: 2,425

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-07-28 04:00:00	AAPL	Stock	95.1375	95.1375	95.0	95.01	2800.0
2020-07-28 04:30:00	AAPL	Stock	94.955	95.1525	94.955	95.15	28920.0
2020-07-28 05:00:00	AAPL	Stock	95.22	95.295	95.0	95.025	11136.0
2020-07-28 05:30:00	AAPL	Stock	95.0975	95.0975	94.6225	94.675	18632.0
2020-07-28 06:00:00	AAPL	Stock	94.675	94.75	94.5075	94.6725	21116.0
2020-07-28 06:30:00	AAPL	Stock	94.75	94.76	94.725	94.76	15976.0
2020-07-28 07:00:00	AAPL	Stock	94.8075	94.9725	94.5625	94.625	87620.0
2020-07-28 07:30:00	AAPL	Stock	94.595	94.595	94.36	94.5225	133272.0
2020-07-28 08:00:00	AAPL	Stock	94.9347	94.9875	94.3428	94.5725	167764.0
2020-07-28 08:30:00	AAPL	Stock	94.575	94.7248	94.5475	94.6975	46668.0
2020-07-28 09:00:00	AAPL	Stock	94.675	94.7	94.1	94.265	480952.0
2020-07-28 09:30:00	AAPL	Stock	94.3675	94.5498	93.4825	93.7475	12858344.0
2020-07-28 10:00:00	AAPL	Stock	93.7612	93.9525	93.4775	93.68	6566588.0
2020-07-28 10:30:00	AAPL	Stock	93.6775	94.0575	93.4825	94.0075	5816084.0
2020-07-28 11:00:00	AAPL	Stock	94.01	94.183	93.6875	93.95	4378316.0
2020-07-28 11:30:00	AAPL	Stock	93.956	94.125	93.6725	93.7258	3756576.0
2020-07-28 12:00:00	AAPL	Stock	93.7175	93.93	93.5488	93.8658	2896476.0
2020-07-28 12:30:00	AAPL	Stock	93.8695	93.94	93.7225	93.94	2288064.0
2020-07-28 13:00:00	AAPL	Stock	93.9325	94.0225	93.78	93.9625	2085776.0
2020-07-28 13:30:00	AAPL	Stock	93.9725	94.38	93.965	94.33	4123668.0
2020-07-28 14:00:00	AAPL	Stock	94.335	94.3375	93.9725	93.985	3510568.0
2020-07-28 14:30:00	AAPL	Stock	93.9862	94.2025	93.915	94.0395	3048988.0
2020-07-28 15:00:00	AAPL	Stock	94.0425	94.0678	93.5275	93.69	4685200.0
2020-07-28 15:30:00	AAPL	Stock	93.6762	93.8275	93.2475	93.26	8777804.0
2020-07-28 16:00:00	AAPL	Stock	93.27	93.4925	93.2525	93.4375	7143060.0
2020-07-28 16:30:00	AAPL	Stock	93.47	93.47	93.325	93.3875	46788.0
2020-07-28 17:00:00	AAPL	Stock	93.385	93.425	93.3525	93.3825	58228.0
2020-07-28 17:30:00	AAPL	Stock	93.3825	93.4775	93.38	93.4775	8060.0
2020-07-28 18:00:00	AAPL	Stock	93.4775	93.625	93.475	93.5625	53848.0
2020-07-28 18:30:00	AAPL	Stock	93.45	93.5375	93.45	93.5375	13172.0
2020-07-28 19:00:00	AAPL	Stock	93.5125	93.535	93.455	93.53	30088.0
2020-07-28 19:30:00	AAPL	Stock	93.5325	93.6875	93.445	93.6875	52992.0
2020-07-28 04:00:00	MSFT	Stock	204.3	204.3	203.85	203.85	200.0
2020-07-28 04:30:00	MSFT	Stock	204.2	204.41	204.2	204.4	1455.0
2020-07-28 05:00:00	MSFT	Stock	204.48	204.6	204.11	204.11	1854.0
2020-07-28 05:30:00	MSFT	Stock	204.11	204.11	203.4	203.4	1835.0
2020-07-28 06:00:00	MSFT	Stock	203.22	203.4	203.0	203.4	3564.0
2020-07-28 06:30:00	MSFT	Stock	203.44	203.5	203.05	203.05	1904.0
2020-07-28 07:00:00	MSFT	Stock	203.69	203.73	203.12	203.22	12691.0
2020-07-28 07:30:00	MSFT	Stock	203.15	203.17	202.74	203.0	7780.0
2020-07-28 08:00:00	MSFT	Stock	202.9	204.35	202.69	203.108	33592.0
2020-07-28 08:30:00	MSFT	Stock	203.12	203.46	203.09	203.26	9608.0
2020-07-28 09:00:00	MSFT	Stock	203.35	203.6	202.8	203.6	64960.0
2020-07-28 09:30:00	MSFT	Stock	203.47	204.0	202.34	202.84	2132773.0
2020-07-28 10:00:00	MSFT	Stock	202.88	203.07	202.28	202.86	1613340.0
2020-07-28 10:30:00	MSFT	Stock	202.86	203.41	202.25	203.34	1293419.0
2020-07-28 11:00:00	MSFT	Stock	203.34	203.45	202.659	203.11	970667.0
2020-07-28 11:30:00	MSFT	Stock	203.12	203.82	202.945	203.06	897978.0
2020-07-28 12:00:00	MSFT	Stock	203.06	203.57	202.61	203.44	900761.0
2020-07-28 12:30:00	MSFT	Stock	203.43	203.88	203.27	203.85	643302.0

> showing 50 of 95,299 rows — these rows as CSV

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