PREVIEW / stock_30min / 2023-11-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-09.parquet
  size:    2.0 MB
  rows:    97,166
  symbols: 1,279

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-11-09 04:00:00	AAPL	Stock	182.69	182.69	181.51	182.22	20198.0
2023-11-09 04:30:00	AAPL	Stock	182.26	182.26	182.0	182.15	6394.0
2023-11-09 05:00:00	AAPL	Stock	182.11	182.3	182.1	182.27	2582.0
2023-11-09 05:30:00	AAPL	Stock	182.3	182.48	182.3	182.4	5638.0
2023-11-09 06:00:00	AAPL	Stock	182.34	182.34	182.12	182.12	4371.0
2023-11-09 06:30:00	AAPL	Stock	182.14	182.2	182.11	182.11	1826.0
2023-11-09 07:00:00	AAPL	Stock	182.22	182.6	182.2	182.38	32131.0
2023-11-09 07:30:00	AAPL	Stock	182.33	182.41	182.29	182.39	13034.0
2023-11-09 08:00:00	AAPL	Stock	182.6	182.8	182.16	182.4	52285.0
2023-11-09 08:30:00	AAPL	Stock	182.49	182.6486	182.23	182.6486	38259.0
2023-11-09 09:00:00	AAPL	Stock	182.6	183.1	182.4029	182.98	90596.0
2023-11-09 09:30:00	AAPL	Stock	182.96	183.55	182.72	183.299	4984677.0
2023-11-09 10:00:00	AAPL	Stock	183.29	183.415	182.6	182.63	3050353.0
2023-11-09 10:30:00	AAPL	Stock	182.635	183.38	182.48	183.36	2642756.0
2023-11-09 11:00:00	AAPL	Stock	183.35	183.9797	183.325	183.535	3265456.0
2023-11-09 11:30:00	AAPL	Stock	183.54	184.12	183.48	183.97	2639587.0
2023-11-09 12:00:00	AAPL	Stock	183.97	183.99	183.51	183.57	1723080.0
2023-11-09 12:30:00	AAPL	Stock	183.58	184.015	183.52	183.93	1737787.0
2023-11-09 13:00:00	AAPL	Stock	183.93	183.97	182.69	183.7	3393946.0
2023-11-09 13:30:00	AAPL	Stock	183.7	183.73	182.99	183.1188	1820002.0
2023-11-09 14:00:00	AAPL	Stock	183.11	183.11	182.34	182.82	2695414.0
2023-11-09 14:30:00	AAPL	Stock	182.82	182.83	182.16	182.375	1823345.0
2023-11-09 15:00:00	AAPL	Stock	182.37	182.38	181.81	181.86	2940474.0
2023-11-09 15:30:00	AAPL	Stock	181.85	182.48	181.83	182.44	4416109.0
2023-11-09 16:00:00	AAPL	Stock	182.44	182.64	182.21	182.55	5681479.0
2023-11-09 16:30:00	AAPL	Stock	182.53	182.6	182.41	182.49	237657.0
2023-11-09 17:00:00	AAPL	Stock	182.47	182.6	182.45	182.55	28141.0
2023-11-09 17:30:00	AAPL	Stock	182.52	182.52	182.28	182.29	24153.0
2023-11-09 18:00:00	AAPL	Stock	182.28	182.42	182.21	182.39	48759.0
2023-11-09 18:30:00	AAPL	Stock	182.39	182.43	182.32	182.35	23051.0
2023-11-09 19:00:00	AAPL	Stock	182.39	182.39	182.23	182.26	7426.0
2023-11-09 19:30:00	AAPL	Stock	182.26	182.49	182.12	182.38	6498.0
2023-11-09 04:00:00	MSFT	Stock	362.9	363.2	362.85	362.98	2536.0
2023-11-09 04:30:00	MSFT	Stock	363.0	363.1	363.0	363.05	2072.0
2023-11-09 05:00:00	MSFT	Stock	363.27	363.27	363.04	363.04	397.0
2023-11-09 05:30:00	MSFT	Stock	363.08	363.1	363.08	363.1	250.0
2023-11-09 06:00:00	MSFT	Stock	363.5	363.5	362.73	362.73	1717.0
2023-11-09 06:30:00	MSFT	Stock	362.69	362.7	362.69	362.7	244.0
2023-11-09 07:00:00	MSFT	Stock	362.7	363.3	362.7	363.05	12299.0
2023-11-09 07:30:00	MSFT	Stock	362.99	363.7	362.99	363.55	10292.0
2023-11-09 08:00:00	MSFT	Stock	362.7	364.1726	362.45	363.5	48591.0
2023-11-09 08:30:00	MSFT	Stock	363.4	363.64	363.0	363.5493	16277.0
2023-11-09 09:00:00	MSFT	Stock	363.5	363.75	361.89	362.18	44343.0
2023-11-09 09:30:00	MSFT	Stock	362.19	363.61	361.63	363.35	2077920.0
2023-11-09 10:00:00	MSFT	Stock	363.37	363.55	361.41	361.445	1125318.0
2023-11-09 10:30:00	MSFT	Stock	361.41	362.71	361.33	362.57	736546.0
2023-11-09 11:00:00	MSFT	Stock	362.575	363.69	362.52	363.2799	704509.0
2023-11-09 11:30:00	MSFT	Stock	363.26	364.79	363.0527	364.2	1009638.0
2023-11-09 12:00:00	MSFT	Stock	364.24	364.24	363.14	363.86	662811.0
2023-11-09 12:30:00	MSFT	Stock	363.84	364.22	363.1	363.51	602537.0

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

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