PREVIEW / stock_30min / 2023-05-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-01.parquet
  size:    2.1 MB
  rows:    101,840
  symbols: 1,659

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-05-01 04:00:00	AAPL	Stock	168.4	169.8	168.35	168.53	17642.0
2023-05-01 04:30:00	AAPL	Stock	168.51	169.05	168.26	169.0	4127.0
2023-05-01 05:00:00	AAPL	Stock	169.1	169.37	169.1	169.22	8726.0
2023-05-01 05:30:00	AAPL	Stock	169.24	169.24	168.97	168.97	3735.0
2023-05-01 06:00:00	AAPL	Stock	168.9	169.09	168.9	169.0	1627.0
2023-05-01 06:30:00	AAPL	Stock	169.0	169.0	168.77	168.85	1867.0
2023-05-01 07:00:00	AAPL	Stock	168.95	169.3	168.95	169.19	20681.0
2023-05-01 07:30:00	AAPL	Stock	169.14	169.21	168.93	168.94	36339.0
2023-05-01 08:00:00	AAPL	Stock	169.15	169.3789	168.88	169.09	82792.0
2023-05-01 08:30:00	AAPL	Stock	169.08	169.49	169.04	169.49	65668.0
2023-05-01 09:00:00	AAPL	Stock	169.46	169.58	169.0	169.29	109977.0
2023-05-01 09:30:00	AAPL	Stock	169.28	170.29	169.03	169.48	7587392.0
2023-05-01 10:00:00	AAPL	Stock	169.47	169.67	169.02	169.045	2891042.0
2023-05-01 10:30:00	AAPL	Stock	169.045	169.56	168.64	169.5199	3077260.0
2023-05-01 11:00:00	AAPL	Stock	169.515	169.83	168.93	169.13	2791492.0
2023-05-01 11:30:00	AAPL	Stock	169.14	169.69	169.051	169.65	1729317.0
2023-05-01 12:00:00	AAPL	Stock	169.6304	170.19	169.5801	169.975	2412753.0
2023-05-01 12:30:00	AAPL	Stock	169.985	170.42	169.985	170.35	2218368.0
2023-05-01 13:00:00	AAPL	Stock	170.3577	170.45	170.1	170.14	2137994.0
2023-05-01 13:30:00	AAPL	Stock	170.13	170.41	170.0701	170.1499	1647594.0
2023-05-01 14:00:00	AAPL	Stock	170.145	170.178	169.82	169.9199	1687498.0
2023-05-01 14:30:00	AAPL	Stock	169.9	169.96	169.2	169.5343	2520537.0
2023-05-01 15:00:00	AAPL	Stock	169.53	169.76	169.36	169.691	1867783.0
2023-05-01 15:30:00	AAPL	Stock	169.7	169.9	169.25	169.56	4394606.0
2023-05-01 16:00:00	AAPL	Stock	169.55	169.74	169.53	169.68	4102977.0
2023-05-01 16:30:00	AAPL	Stock	169.67	169.67	169.5	169.52	62533.0
2023-05-01 17:00:00	AAPL	Stock	169.52	169.57	169.5	169.5127	8880.0
2023-05-01 17:30:00	AAPL	Stock	169.53	169.54	169.39	169.39	18205.0
2023-05-01 18:00:00	AAPL	Stock	169.39	169.45	169.34	169.43	5506.0
2023-05-01 18:30:00	AAPL	Stock	169.45	169.57	169.39	169.4	8765.0
2023-05-01 19:00:00	AAPL	Stock	169.45	169.53	169.41	169.47	8186.0
2023-05-01 19:30:00	AAPL	Stock	169.46	169.53	169.39	169.4	12688.0
2023-05-01 04:00:00	MSFT	Stock	307.5	307.5	307.1	307.1	1499.0
2023-05-01 04:30:00	MSFT	Stock	306.99	307.08	306.99	307.08	933.0
2023-05-01 05:00:00	MSFT	Stock	307.01	307.49	306.91	307.12	1668.0
2023-05-01 05:30:00	MSFT	Stock	307.16	307.26	307.13	307.26	931.0
2023-05-01 06:00:00	MSFT	Stock	307.2	307.35	307.01	307.01	810.0
2023-05-01 06:30:00	MSFT	Stock	307.0	307.0	307.0	307.0	141.0
2023-05-01 07:00:00	MSFT	Stock	307.0	307.11	306.96	306.96	2645.0
2023-05-01 07:30:00	MSFT	Stock	306.94	306.94	306.47	306.5	840.0
2023-05-01 08:00:00	MSFT	Stock	306.9	307.8	306.05	306.1	27339.0
2023-05-01 08:30:00	MSFT	Stock	306.3628	306.48	306.16	306.19	6537.0
2023-05-01 09:00:00	MSFT	Stock	306.23	307.0	305.9	306.96	85148.0
2023-05-01 09:30:00	MSFT	Stock	306.8	308.6	306.5	307.6929	2258526.0
2023-05-01 10:00:00	MSFT	Stock	307.64	307.64	306.17	306.315	1360983.0
2023-05-01 10:30:00	MSFT	Stock	306.3	307.33	305.77	307.13	1260647.0
2023-05-01 11:00:00	MSFT	Stock	307.13	307.5527	306.07	306.3	1469683.0
2023-05-01 11:30:00	MSFT	Stock	306.33	307.145	306.1	307.05	673519.0
2023-05-01 12:00:00	MSFT	Stock	307.03	307.46	306.85	307.1	748010.0
2023-05-01 12:30:00	MSFT	Stock	307.1	308.01	307.1	307.88	932004.0

> showing 50 of 101,840 rows — these rows as CSV

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