PREVIEW / stock_30min / 2020-07-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-08.parquet
  size:    1.9 MB
  rows:    96,447
  symbols: 2,421

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-08 04:00:00	AAPL	Stock	93.715	93.85	93.715	93.85	2012.0
2020-07-08 04:30:00	AAPL	Stock	93.85	94.05	93.67	93.975	5588.0
2020-07-08 05:00:00	AAPL	Stock	93.95	93.9525	93.45	93.45	8520.0
2020-07-08 05:30:00	AAPL	Stock	93.4125	93.44	93.3875	93.44	4000.0
2020-07-08 06:00:00	AAPL	Stock	93.375	93.625	93.375	93.605	5400.0
2020-07-08 06:30:00	AAPL	Stock	93.72	93.8425	93.715	93.75	7568.0
2020-07-08 07:00:00	AAPL	Stock	93.82	94.03	93.82	93.9525	112848.0
2020-07-08 07:30:00	AAPL	Stock	93.95	94.075	93.95	94.0	108972.0
2020-07-08 08:00:00	AAPL	Stock	93.75	94.0625	93.405	93.925	238080.0
2020-07-08 08:30:00	AAPL	Stock	93.925	94.1875	93.8	94.1	158104.0
2020-07-08 09:00:00	AAPL	Stock	94.09	94.2475	93.1725	94.19	243192.0
2020-07-08 09:30:00	AAPL	Stock	94.1875	95.22	94.09	95.03	18320692.0
2020-07-08 10:00:00	AAPL	Stock	95.0342	95.11	94.5162	94.5675	7409788.0
2020-07-08 10:30:00	AAPL	Stock	94.5625	95.1618	94.5375	95.1025	6534268.0
2020-07-08 11:00:00	AAPL	Stock	95.1125	95.1425	94.1675	94.5938	9394688.0
2020-07-08 11:30:00	AAPL	Stock	94.605	94.9725	94.54	94.9375	5113792.0
2020-07-08 12:00:00	AAPL	Stock	94.9475	95.0925	94.8315	94.9325	4370028.0
2020-07-08 12:30:00	AAPL	Stock	94.9325	95.075	94.675	95.0725	3602332.0
2020-07-08 13:00:00	AAPL	Stock	95.075	95.0925	94.635	94.785	3448172.0
2020-07-08 13:30:00	AAPL	Stock	94.7825	94.865	94.4775	94.6552	3244332.0
2020-07-08 14:00:00	AAPL	Stock	94.665	94.9625	94.525	94.92	3744484.0
2020-07-08 14:30:00	AAPL	Stock	94.932	95.0325	94.715	95.0075	3792292.0
2020-07-08 15:00:00	AAPL	Stock	95.0112	95.145	94.8775	95.0775	4556712.0
2020-07-08 15:30:00	AAPL	Stock	95.0775	95.375	94.8775	95.36	9146476.0
2020-07-08 16:00:00	AAPL	Stock	95.333	95.375	95.2625	95.36	10760512.0
2020-07-08 16:30:00	AAPL	Stock	95.3625	95.4525	95.3425	95.4525	61212.0
2020-07-08 17:00:00	AAPL	Stock	95.465	95.625	95.465	95.575	82468.0
2020-07-08 17:30:00	AAPL	Stock	95.5375	95.75	95.5375	95.6625	92716.0
2020-07-08 18:00:00	AAPL	Stock	95.7	95.7725	95.515	95.5475	129576.0
2020-07-08 18:30:00	AAPL	Stock	95.525	95.665	95.425	95.5	104620.0
2020-07-08 19:00:00	AAPL	Stock	95.5	95.55	95.415	95.525	77252.0
2020-07-08 19:30:00	AAPL	Stock	95.5125	95.725	95.4975	95.55	63540.0
2020-07-08 04:00:00	MSFT	Stock	209.53	210.0	209.5	210.0	1568.0
2020-07-08 04:30:00	MSFT	Stock	209.87	209.87	209.29	209.75	3928.0
2020-07-08 05:00:00	MSFT	Stock	209.5	209.55	208.78	209.35	4150.0
2020-07-08 05:30:00	MSFT	Stock	209.3	209.3	209.05	209.14	1387.0
2020-07-08 06:00:00	MSFT	Stock	209.05	209.7	209.05	209.7	3262.0
2020-07-08 06:30:00	MSFT	Stock	209.75	209.75	209.62	209.62	2237.0
2020-07-08 07:00:00	MSFT	Stock	209.9	210.02	209.55	209.69	18251.0
2020-07-08 07:30:00	MSFT	Stock	209.69	210.28	209.69	210.27	8890.0
2020-07-08 08:00:00	MSFT	Stock	209.83	210.33	209.55	209.75	39844.0
2020-07-08 08:30:00	MSFT	Stock	209.85	210.07	209.35	210.07	18508.0
2020-07-08 09:00:00	MSFT	Stock	209.9	210.26	209.3	210.26	39077.0
2020-07-08 09:30:00	MSFT	Stock	210.07	212.67	209.56	212.46	4202458.0
2020-07-08 10:00:00	MSFT	Stock	212.45	212.52	210.44	210.53	1812406.0
2020-07-08 10:30:00	MSFT	Stock	210.52	211.32	210.21	211.1	1360324.0
2020-07-08 11:00:00	MSFT	Stock	211.125	211.155	208.69	209.39	2087308.0
2020-07-08 11:30:00	MSFT	Stock	209.4	211.025	209.39	210.905	1548284.0
2020-07-08 12:00:00	MSFT	Stock	210.97	211.57	210.65	211.102	1515781.0
2020-07-08 12:30:00	MSFT	Stock	211.09	211.7	210.73	211.655	1147895.0

> showing 50 of 96,447 rows — these rows as CSV

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