PREVIEW / stock_30min / 2023-01-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-27.parquet
  size:    2.1 MB
  rows:    102,743
  symbols: 1,885

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
2023-01-27 04:00:00	AAPL	Stock	143.48	143.56	143.1	143.36	9208.0
2023-01-27 04:30:00	AAPL	Stock	143.3	143.57	143.3	143.4	8813.0
2023-01-27 05:00:00	AAPL	Stock	143.48	143.49	143.29	143.49	1577.0
2023-01-27 05:30:00	AAPL	Stock	143.42	143.43	143.38	143.39	1238.0
2023-01-27 06:00:00	AAPL	Stock	143.48	143.5	143.27	143.36	5920.0
2023-01-27 06:30:00	AAPL	Stock	143.39	143.5	143.35	143.45	4895.0
2023-01-27 07:00:00	AAPL	Stock	143.45	143.69	143.3	143.38	25657.0
2023-01-27 07:30:00	AAPL	Stock	143.46	143.6	143.38	143.57	25703.0
2023-01-27 08:00:00	AAPL	Stock	143.65	143.9	143.0	143.9	105367.0
2023-01-27 08:30:00	AAPL	Stock	143.95	143.99	143.42	143.64	103944.0
2023-01-27 09:00:00	AAPL	Stock	143.64	143.64	143.0	143.11	163738.0
2023-01-27 09:30:00	AAPL	Stock	143.18	145.21	143.08	144.6999	7139852.0
2023-01-27 10:00:00	AAPL	Stock	144.71	145.5	144.39	145.43	4892869.0
2023-01-27 10:30:00	AAPL	Stock	145.43	145.525	144.38	144.68	3818666.0
2023-01-27 11:00:00	AAPL	Stock	144.7	145.35	144.61	145.25	3197586.0
2023-01-27 11:30:00	AAPL	Stock	145.26	146.19	145.17	146.05	3948021.0
2023-01-27 12:00:00	AAPL	Stock	146.05	146.89	145.92	146.3622	3903701.0
2023-01-27 12:30:00	AAPL	Stock	146.3778	146.825	146.17	146.37	2671613.0
2023-01-27 13:00:00	AAPL	Stock	146.3601	146.464	145.99	146.185	1963221.0
2023-01-27 13:30:00	AAPL	Stock	146.2	146.56	146.16	146.35	2367424.0
2023-01-27 14:00:00	AAPL	Stock	146.35	146.95	146.25	146.7715	2707544.0
2023-01-27 14:30:00	AAPL	Stock	146.78	147.02	146.51	146.9	3205889.0
2023-01-27 15:00:00	AAPL	Stock	146.895	147.16	146.62	146.96	3631128.0
2023-01-27 15:30:00	AAPL	Stock	146.95	147.23	145.8	145.97	7288204.0
2023-01-27 16:00:00	AAPL	Stock	145.93	146.04	145.855	145.95	8381864.0
2023-01-27 16:30:00	AAPL	Stock	145.95	146.0	145.93	145.98	58409.0
2023-01-27 17:00:00	AAPL	Stock	145.96	145.96	145.83	145.93	51658.0
2023-01-27 17:30:00	AAPL	Stock	145.9	145.95	145.81	145.86	17818.0
2023-01-27 18:00:00	AAPL	Stock	145.85	145.89	145.83	145.86	5943.0
2023-01-27 18:30:00	AAPL	Stock	145.9	145.9	145.85	145.89	8630.0
2023-01-27 19:00:00	AAPL	Stock	145.88	145.9	145.84	145.87	8974.0
2023-01-27 19:30:00	AAPL	Stock	145.87	145.98	145.85	145.9	17853.0
2023-01-27 04:00:00	MSFT	Stock	246.87	247.0	246.28	246.72	3666.0
2023-01-27 04:30:00	MSFT	Stock	246.86	247.01	246.86	247.01	200.0
2023-01-27 05:30:00	MSFT	Stock	247.35	247.5	247.28	247.28	2150.0
2023-01-27 06:00:00	MSFT	Stock	247.31	247.31	247.19	247.2	717.0
2023-01-27 06:30:00	MSFT	Stock	247.16	247.3	247.15	247.2	1713.0
2023-01-27 07:00:00	MSFT	Stock	247.15	247.68	247.14	247.35	10703.0
2023-01-27 07:30:00	MSFT	Stock	247.42	247.5	247.2	247.2	6351.0
2023-01-27 08:00:00	MSFT	Stock	247.61	247.8	247.0	247.8	24146.0
2023-01-27 08:30:00	MSFT	Stock	247.49	248.23	247.35	247.63	45867.0
2023-01-27 09:00:00	MSFT	Stock	247.79	249.07	247.52	249.07	63552.0
2023-01-27 09:30:00	MSFT	Stock	249.07	249.36	247.33	247.8701	3204889.0
2023-01-27 10:00:00	MSFT	Stock	247.9	248.99	247.3701	248.919	1498869.0
2023-01-27 10:30:00	MSFT	Stock	248.92	249.0	246.83	247.51	1234499.0
2023-01-27 11:00:00	MSFT	Stock	247.52	248.42	247.151	248.07	937112.0
2023-01-27 11:30:00	MSFT	Stock	248.07	248.88	247.93	248.32	833615.0
2023-01-27 12:00:00	MSFT	Stock	248.33	248.77	247.9605	248.21	909465.0
2023-01-27 12:30:00	MSFT	Stock	248.2	248.84	248.07	248.57	673508.0
2023-01-27 13:00:00	MSFT	Stock	248.58	248.7	247.78	247.99	599607.0

> showing 50 of 102,743 rows — these rows as CSV

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