PREVIEW / stock_30min / 2020-06-26

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-26.parquet
  size:    1.9 MB
  rows:    97,372
  symbols: 2,444

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-06-26 04:00:00	AAPL	Stock	90.965	91.0	90.75	90.8725	13732.0
2020-06-26 04:30:00	AAPL	Stock	90.7775	91.0	90.7775	91.0	8904.0
2020-06-26 05:00:00	AAPL	Stock	91.05	91.145	91.025	91.145	5780.0
2020-06-26 05:30:00	AAPL	Stock	91.125	91.15	91.125	91.15	3760.0
2020-06-26 06:00:00	AAPL	Stock	91.15	91.21	91.15	91.21	3800.0
2020-06-26 06:30:00	AAPL	Stock	91.255	91.2575	91.205	91.205	9848.0
2020-06-26 07:00:00	AAPL	Stock	91.295	91.48	91.25	91.25	90340.0
2020-06-26 07:30:00	AAPL	Stock	91.2725	91.355	91.2325	91.2325	39704.0
2020-06-26 08:00:00	AAPL	Stock	91.3758	91.465	91.0375	91.1875	187916.0
2020-06-26 08:30:00	AAPL	Stock	91.175	91.215	90.9825	91.0725	159988.0
2020-06-26 09:00:00	AAPL	Stock	91.02	91.21	90.9575	91.09	519236.0
2020-06-26 09:30:00	AAPL	Stock	91.1125	91.33	90.3825	90.5988	12478844.0
2020-06-26 10:00:00	AAPL	Stock	90.5925	90.5925	88.795	89.405	16871768.0
2020-06-26 10:30:00	AAPL	Stock	89.415	89.545	88.7625	89.355	11125776.0
2020-06-26 11:00:00	AAPL	Stock	89.355	89.96	89.303	89.7475	10054148.0
2020-06-26 11:30:00	AAPL	Stock	89.765	90.35	89.585	90.22	8041472.0
2020-06-26 12:00:00	AAPL	Stock	90.225	90.24	89.265	89.5625	7993224.0
2020-06-26 12:30:00	AAPL	Stock	89.5575	89.75	89.21	89.7425	7893036.0
2020-06-26 13:00:00	AAPL	Stock	89.7375	90.0475	89.675	89.95	8234164.0
2020-06-26 13:30:00	AAPL	Stock	89.9625	89.975	89.2525	89.255	7055916.0
2020-06-26 14:00:00	AAPL	Stock	89.2562	89.515	89.065	89.1525	6970212.0
2020-06-26 14:30:00	AAPL	Stock	89.15	89.205	88.8862	89.0722	7052888.0
2020-06-26 15:00:00	AAPL	Stock	89.0575	89.285	88.7675	89.0125	7225840.0
2020-06-26 15:30:00	AAPL	Stock	89.0	89.475	88.255	88.4225	21720868.0
2020-06-26 16:00:00	AAPL	Stock	88.4075	88.7375	88.4075	88.4575	27636960.0
2020-06-26 16:30:00	AAPL	Stock	88.465	88.5375	88.4175	88.435	111532.0
2020-06-26 17:00:00	AAPL	Stock	88.435	88.5	88.375	88.405	93520.0
2020-06-26 17:30:00	AAPL	Stock	88.4375	88.475	88.4075	88.4625	57780.0
2020-06-26 18:00:00	AAPL	Stock	88.47	88.5	88.425	88.425	37304.0
2020-06-26 18:30:00	AAPL	Stock	88.425	88.45	88.4075	88.42	36436.0
2020-06-26 19:00:00	AAPL	Stock	88.425	88.4375	88.4075	88.425	35304.0
2020-06-26 19:30:00	AAPL	Stock	88.4125	88.45	88.4075	88.41	41644.0
2020-06-26 04:00:00	MSFT	Stock	201.0	201.0	199.82	199.82	430.0
2020-06-26 04:30:00	MSFT	Stock	200.11	200.11	200.0	200.0	550.0
2020-06-26 05:00:00	MSFT	Stock	200.1	200.1	200.1	200.1	148.0
2020-06-26 05:30:00	MSFT	Stock	200.32	200.32	200.32	200.32	400.0
2020-06-26 06:00:00	MSFT	Stock	200.6	200.6	200.6	200.6	143.0
2020-06-26 06:30:00	MSFT	Stock	200.5	201.0	200.5	201.0	2813.0
2020-06-26 07:00:00	MSFT	Stock	201.0	201.24	200.47	200.47	7961.0
2020-06-26 07:30:00	MSFT	Stock	200.42	200.5	200.25	200.26	4117.0
2020-06-26 08:00:00	MSFT	Stock	201.0	201.35	199.6	199.95	28226.0
2020-06-26 08:30:00	MSFT	Stock	199.9	200.25	199.6	199.8	12569.0
2020-06-26 09:00:00	MSFT	Stock	199.804	200.34	199.338	199.6	34406.0
2020-06-26 09:30:00	MSFT	Stock	199.76	199.89	197.55	198.27	2793526.0
2020-06-26 10:00:00	MSFT	Stock	198.25	198.25	195.82	196.33	3261324.0
2020-06-26 10:30:00	MSFT	Stock	196.33	196.465	194.88	196.13	3450900.0
2020-06-26 11:00:00	MSFT	Stock	196.13	197.46	196.08	197.22	2226909.0
2020-06-26 11:30:00	MSFT	Stock	197.23	198.83	196.93	198.61	2362949.0
2020-06-26 12:00:00	MSFT	Stock	198.63	198.7	196.54	197.26	1778873.0
2020-06-26 12:30:00	MSFT	Stock	197.26	197.78	196.44	197.565	1531747.0

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

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