PREVIEW / stock_30min / 2023-09-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-06.parquet
  size:    2.0 MB
  rows:    97,297
  symbols: 1,428

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-09-06 04:00:00	AAPL	Stock	188.8	188.8	188.27	188.4	22506.0
2023-09-06 04:30:00	AAPL	Stock	188.43	188.46	188.02	188.2	19977.0
2023-09-06 05:00:00	AAPL	Stock	188.16	188.35	188.13	188.27	16295.0
2023-09-06 05:30:00	AAPL	Stock	188.27	188.46	188.27	188.44	2658.0
2023-09-06 06:00:00	AAPL	Stock	188.4	188.42	188.27	188.41	10674.0
2023-09-06 06:30:00	AAPL	Stock	188.41	188.48	188.21	188.38	14160.0
2023-09-06 07:00:00	AAPL	Stock	188.48	188.78	188.39	188.7	37944.0
2023-09-06 07:30:00	AAPL	Stock	188.71	188.82	188.38	188.5	40434.0
2023-09-06 08:00:00	AAPL	Stock	188.46	189.5	188.15	188.4	126911.0
2023-09-06 08:30:00	AAPL	Stock	188.47	188.47	188.21	188.4	113134.0
2023-09-06 09:00:00	AAPL	Stock	188.37	188.429	188.08	188.41	131710.0
2023-09-06 09:30:00	AAPL	Stock	188.4	188.85	186.5	186.54	7843538.0
2023-09-06 10:00:00	AAPL	Stock	186.53	186.53	183.93	184.17	9900127.0
2023-09-06 10:30:00	AAPL	Stock	184.15	184.65	183.96	184.0188	4243648.0
2023-09-06 11:00:00	AAPL	Stock	184.02	184.09	183.53	184.03	4060796.0
2023-09-06 11:30:00	AAPL	Stock	184.0239	184.31	183.945	184.15	2514487.0
2023-09-06 12:00:00	AAPL	Stock	184.145	184.32	183.16	183.2104	3166065.0
2023-09-06 12:30:00	AAPL	Stock	183.21	183.31	182.8	183.115	2839847.0
2023-09-06 13:00:00	AAPL	Stock	183.115	183.42	182.77	182.9154	2768187.0
2023-09-06 13:30:00	AAPL	Stock	182.91	183.17	182.67	182.9699	2526469.0
2023-09-06 14:00:00	AAPL	Stock	182.9656	183.01	182.13	182.6343	3355325.0
2023-09-06 14:30:00	AAPL	Stock	182.635	182.9	182.16	182.2	3110064.0
2023-09-06 15:00:00	AAPL	Stock	182.19	182.29	181.47	181.52	4800009.0
2023-09-06 15:30:00	AAPL	Stock	181.53	183.02	181.49	182.9	10039330.0
2023-09-06 16:00:00	AAPL	Stock	182.88	183.0	182.75	182.8807	7405199.0
2023-09-06 16:30:00	AAPL	Stock	182.92	182.95	182.73	182.75	184962.0
2023-09-06 17:00:00	AAPL	Stock	182.7501	182.82	182.32	182.68	103360.0
2023-09-06 17:30:00	AAPL	Stock	182.6081	182.83	182.53	182.65	38863.0
2023-09-06 18:00:00	AAPL	Stock	182.7	182.84	182.68	182.77	20188.0
2023-09-06 18:30:00	AAPL	Stock	182.77	182.77	182.65	182.6601	19161.0
2023-09-06 19:00:00	AAPL	Stock	182.68	182.8	182.66	182.69	28279.0
2023-09-06 19:30:00	AAPL	Stock	182.72	182.76	182.56	182.56	22111.0
2023-09-06 04:00:00	MSFT	Stock	332.6	332.71	332.35	332.35	730.0
2023-09-06 04:30:00	MSFT	Stock	332.35	332.47	332.24	332.47	1211.0
2023-09-06 05:00:00	MSFT	Stock	332.68	332.68	332.68	332.68	200.0
2023-09-06 05:30:00	MSFT	Stock	332.5	332.5	332.5	332.5	200.0
2023-09-06 06:00:00	MSFT	Stock	332.55	332.73	332.55	332.73	1072.0
2023-09-06 06:30:00	MSFT	Stock	332.39	332.39	332.39	332.39	103.0
2023-09-06 07:00:00	MSFT	Stock	332.45	332.47	331.88	332.3	5364.0
2023-09-06 07:30:00	MSFT	Stock	332.29	332.29	331.9	331.95	2763.0
2023-09-06 08:00:00	MSFT	Stock	332.2	334.5	331.7289	332.28	9809.0
2023-09-06 08:30:00	MSFT	Stock	332.12	332.6349	331.896	332.6182	8091.0
2023-09-06 09:00:00	MSFT	Stock	332.4296	333.54	332.4296	333.24	17466.0
2023-09-06 09:30:00	MSFT	Stock	333.39	334.46	331.9	333.74	1512539.0
2023-09-06 10:00:00	MSFT	Stock	333.68	333.7	331.251	331.5905	1268957.0
2023-09-06 10:30:00	MSFT	Stock	331.56	332.64	331.34	331.35	680834.0
2023-09-06 11:00:00	MSFT	Stock	331.375	332.2	331.02	332.185	661162.0
2023-09-06 11:30:00	MSFT	Stock	332.18	332.41	331.6858	331.86	402639.0
2023-09-06 12:00:00	MSFT	Stock	331.85	332.15	330.83	330.8889	458534.0
2023-09-06 12:30:00	MSFT	Stock	330.88	331.05	330.18	330.76	548788.0

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

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