PREVIEW / stock_30min / 2021-09-24

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-24.parquet
  size:    2.2 MB
  rows:    106,995
  symbols: 2,673

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
2021-09-24 04:00:00	AAPL	Stock	146.4	146.4	145.65	145.86	16954.0
2021-09-24 04:30:00	AAPL	Stock	145.93	146.0	145.8	146.0	3923.0
2021-09-24 05:00:00	AAPL	Stock	146.01	146.01	145.94	145.98	2680.0
2021-09-24 05:30:00	AAPL	Stock	145.91	145.97	145.71	145.79	9111.0
2021-09-24 06:00:00	AAPL	Stock	145.73	146.0	145.66	145.88	4013.0
2021-09-24 06:30:00	AAPL	Stock	145.94	145.94	145.74	145.74	6864.0
2021-09-24 07:00:00	AAPL	Stock	145.79	146.03	145.75	145.95	76691.0
2021-09-24 07:30:00	AAPL	Stock	145.97	146.07	145.79	145.83	33889.0
2021-09-24 08:00:00	AAPL	Stock	145.8001	146.03	145.58	145.79	287326.0
2021-09-24 08:30:00	AAPL	Stock	145.79	145.82	145.49	145.7	222762.0
2021-09-24 09:00:00	AAPL	Stock	145.71	145.8	145.57	145.7	169446.0
2021-09-24 09:30:00	AAPL	Stock	145.66	146.28	145.56	146.17	7406105.0
2021-09-24 10:00:00	AAPL	Stock	146.17	146.39	145.76	146.12	4481020.0
2021-09-24 10:30:00	AAPL	Stock	146.125	146.32	145.73	145.9099	3264377.0
2021-09-24 11:00:00	AAPL	Stock	145.9023	146.1983	145.87	145.895	2524990.0
2021-09-24 11:30:00	AAPL	Stock	145.9	146.44	145.85	146.425	2537161.0
2021-09-24 12:00:00	AAPL	Stock	146.425	146.65	146.29	146.565	2697560.0
2021-09-24 12:30:00	AAPL	Stock	146.57	146.8	146.44	146.615	1968137.0
2021-09-24 13:00:00	AAPL	Stock	146.6169	146.79	146.5	146.7801	2025025.0
2021-09-24 13:30:00	AAPL	Stock	146.78	146.8999	146.6	146.705	1960359.0
2021-09-24 14:00:00	AAPL	Stock	146.705	146.88	146.69	146.8299	1491503.0
2021-09-24 14:30:00	AAPL	Stock	146.83	147.03	146.76	147.0025	2006915.0
2021-09-24 15:00:00	AAPL	Stock	147.0099	147.29	146.82	147.265	2819668.0
2021-09-24 15:30:00	AAPL	Stock	147.265	147.4701	146.82	146.91	6810254.0
2021-09-24 16:00:00	AAPL	Stock	146.92	147.0	146.92	146.97	4472937.0
2021-09-24 16:30:00	AAPL	Stock	146.97	147.0	146.94	146.99	35593.0
2021-09-24 17:00:00	AAPL	Stock	146.98	147.0	146.93	146.95	15625.0
2021-09-24 17:30:00	AAPL	Stock	146.98	147.0	146.95	146.95	16612.0
2021-09-24 18:00:00	AAPL	Stock	146.95	146.95	146.93	146.95	9769.0
2021-09-24 18:30:00	AAPL	Stock	146.95	146.96	146.92	146.93	6136.0
2021-09-24 19:00:00	AAPL	Stock	146.93	146.99	146.93	146.93	8027.0
2021-09-24 19:30:00	AAPL	Stock	146.9301	147.01	146.93	146.97	17452.0
2021-09-24 04:00:00	MSFT	Stock	298.02	298.02	298.0	298.0	778.0
2021-09-24 04:30:00	MSFT	Stock	298.1	298.3	298.1	298.3	340.0
2021-09-24 05:00:00	MSFT	Stock	298.3	298.33	298.2	298.2	708.0
2021-09-24 05:30:00	MSFT	Stock	298.22	298.22	298.22	298.22	100.0
2021-09-24 06:00:00	MSFT	Stock	298.0	298.6	298.0	298.6	910.0
2021-09-24 06:30:00	MSFT	Stock	298.58	298.58	298.25	298.25	4387.0
2021-09-24 07:00:00	MSFT	Stock	298.5	298.59	298.2	298.59	11991.0
2021-09-24 07:30:00	MSFT	Stock	298.55	298.55	298.09	298.17	4380.0
2021-09-24 08:00:00	MSFT	Stock	298.1001	298.58	298.0	298.0	25471.0
2021-09-24 08:30:00	MSFT	Stock	297.97	298.07	297.75	297.9401	19208.0
2021-09-24 09:00:00	MSFT	Stock	297.93	298.87	297.81	298.5	29882.0
2021-09-24 09:30:00	MSFT	Stock	298.35	299.466	297.61	298.52	1510502.0
2021-09-24 10:00:00	MSFT	Stock	298.51	298.97	297.23	297.76	1101375.0
2021-09-24 10:30:00	MSFT	Stock	297.74	297.97	297.13	297.44	638200.0
2021-09-24 11:00:00	MSFT	Stock	297.435	298.12	296.97	297.11	600945.0
2021-09-24 11:30:00	MSFT	Stock	297.16	297.76	296.93	297.64	481140.0
2021-09-24 12:00:00	MSFT	Stock	297.64	298.48	297.29	298.3	518065.0
2021-09-24 12:30:00	MSFT	Stock	298.32	298.62	298.12	298.4541	437415.0

> showing 50 of 106,995 rows — these rows as CSV

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