PREVIEW / stock_30min / 2020-08-26

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-26.parquet
  size:    1.9 MB
  rows:    97,009
  symbols: 2,455

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-08-26 04:00:00	AAPL	Stock	125.005	125.005	124.75	124.925	18176.0
2020-08-26 04:30:00	AAPL	Stock	125.2125	125.2875	125.1875	125.2625	9960.0
2020-08-26 05:00:00	AAPL	Stock	125.305	125.5175	125.275	125.485	10748.0
2020-08-26 05:30:00	AAPL	Stock	125.5	125.5	125.3075	125.325	10136.0
2020-08-26 06:00:00	AAPL	Stock	125.375	125.945	125.315	125.945	60212.0
2020-08-26 06:30:00	AAPL	Stock	125.9375	126.23	125.9375	126.1275	73592.0
2020-08-26 07:00:00	AAPL	Stock	126.2225	126.2225	125.6675	125.97	269800.0
2020-08-26 07:30:00	AAPL	Stock	125.96	126.0925	125.8175	125.875	153860.0
2020-08-26 08:00:00	AAPL	Stock	125.83	126.0975	125.135	125.775	472152.0
2020-08-26 08:30:00	AAPL	Stock	125.7775	125.9175	125.5	125.8715	273340.0
2020-08-26 09:00:00	AAPL	Stock	125.875	126.4	125.5175	126.195	498260.0
2020-08-26 09:30:00	AAPL	Stock	126.195	126.9925	125.8475	125.98	21557496.0
2020-08-26 10:00:00	AAPL	Stock	125.985	126.0632	125.0825	125.45	12924164.0
2020-08-26 10:30:00	AAPL	Stock	125.46	125.9725	125.38	125.5625	7888912.0
2020-08-26 11:00:00	AAPL	Stock	125.5675	125.8698	125.33	125.745	6534124.0
2020-08-26 11:30:00	AAPL	Stock	125.735	126.2708	125.57	126.2075	7376108.0
2020-08-26 12:00:00	AAPL	Stock	126.205	126.825	125.785	126.6712	10409748.0
2020-08-26 12:30:00	AAPL	Stock	126.6712	126.8012	126.1	126.1742	8325908.0
2020-08-26 13:00:00	AAPL	Stock	126.1762	126.295	125.8425	126.0775	5063432.0
2020-08-26 13:30:00	AAPL	Stock	126.099	126.415	126.05	126.305	4201008.0
2020-08-26 14:00:00	AAPL	Stock	126.31	126.4675	126.08	126.155	3957988.0
2020-08-26 14:30:00	AAPL	Stock	126.16	126.1975	125.4	125.631	8075376.0
2020-08-26 15:00:00	AAPL	Stock	125.6275	126.07	125.46	126.0125	6019864.0
2020-08-26 15:30:00	AAPL	Stock	126.0175	126.58	125.85	126.5475	10748108.0
2020-08-26 16:00:00	AAPL	Stock	126.5225	126.5975	126.0925	126.445	6827524.0
2020-08-26 16:30:00	AAPL	Stock	126.445	126.805	126.445	126.6875	213792.0
2020-08-26 17:00:00	AAPL	Stock	126.6875	126.75	126.625	126.65	65104.0
2020-08-26 17:30:00	AAPL	Stock	126.63	126.675	126.565	126.6625	113116.0
2020-08-26 18:00:00	AAPL	Stock	126.575	126.66	126.5225	126.5225	72576.0
2020-08-26 18:30:00	AAPL	Stock	126.54	126.5625	126.475	126.475	48612.0
2020-08-26 19:00:00	AAPL	Stock	126.475	126.5225	126.33	126.33	99316.0
2020-08-26 19:30:00	AAPL	Stock	126.325	126.3425	126.2	126.325	210372.0
2020-08-26 04:00:00	MSFT	Stock	217.47	217.47	217.0	217.0	3406.0
2020-08-26 04:30:00	MSFT	Stock	217.06	217.15	217.04	217.15	630.0
2020-08-26 05:00:00	MSFT	Stock	217.15	217.19	217.15	217.15	2417.0
2020-08-26 05:30:00	MSFT	Stock	217.31	217.31	217.13	217.15	2465.0
2020-08-26 06:00:00	MSFT	Stock	217.15	217.4	217.15	217.36	2162.0
2020-08-26 06:30:00	MSFT	Stock	217.27	217.42	217.21	217.21	1448.0
2020-08-26 07:00:00	MSFT	Stock	217.47	218.43	217.4	218.25	26815.0
2020-08-26 07:30:00	MSFT	Stock	218.25	218.39	217.5	217.66	18402.0
2020-08-26 08:00:00	MSFT	Stock	217.5	218.405	217.0	217.69	67364.0
2020-08-26 08:30:00	MSFT	Stock	217.58	217.89	217.07	217.71	35771.0
2020-08-26 09:00:00	MSFT	Stock	217.72	218.21	217.72	217.91	41275.0
2020-08-26 09:30:00	MSFT	Stock	217.91	218.985	217.36	218.405	3633399.0
2020-08-26 10:00:00	MSFT	Stock	218.435	219.65	217.88	219.39	2153844.0
2020-08-26 10:30:00	MSFT	Stock	219.39	220.53	219.3	219.864	2318282.0
2020-08-26 11:00:00	MSFT	Stock	219.865	221.15	219.865	221.07	1684888.0
2020-08-26 11:30:00	MSFT	Stock	221.06	221.69	220.99	221.36	1733368.0
2020-08-26 12:00:00	MSFT	Stock	221.4	222.09	221.31	221.62	1468729.0
2020-08-26 12:30:00	MSFT	Stock	221.65	221.72	219.55	220.07	2172099.0

> showing 50 of 97,009 rows — these rows as CSV

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