PREVIEW / stock_30min / 2023-02-22

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-22.parquet
  size:    2.1 MB
  rows:    101,535
  symbols: 1,823

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-02-22 04:00:00	AAPL	Stock	148.94	150.0	148.25	148.5	22698.0
2023-02-22 04:30:00	AAPL	Stock	148.5	148.81	148.25	148.74	15418.0
2023-02-22 05:00:00	AAPL	Stock	148.75	148.77	148.5	148.55	6847.0
2023-02-22 05:30:00	AAPL	Stock	148.52	148.53	148.45	148.53	1220.0
2023-02-22 06:00:00	AAPL	Stock	148.5	148.5	148.32	148.36	2836.0
2023-02-22 06:30:00	AAPL	Stock	148.36	148.47	148.11	148.46	15818.0
2023-02-22 07:00:00	AAPL	Stock	148.5	149.24	148.22	149.19	57889.0
2023-02-22 07:30:00	AAPL	Stock	149.17	149.46	148.91	149.18	65226.0
2023-02-22 08:00:00	AAPL	Stock	148.41	149.47	148.2706	148.79	133385.0
2023-02-22 08:30:00	AAPL	Stock	148.84	149.1	148.76	148.98	59922.0
2023-02-22 09:00:00	AAPL	Stock	149.0	149.08	148.59	148.92	83398.0
2023-02-22 09:30:00	AAPL	Stock	148.81	149.5	147.86	147.93	6432392.0
2023-02-22 10:00:00	AAPL	Stock	147.93	148.21	147.18	147.48	3859521.0
2023-02-22 10:30:00	AAPL	Stock	147.49	148.4	147.16	148.1401	2571899.0
2023-02-22 11:00:00	AAPL	Stock	148.15	148.28	147.7	147.86	1716493.0
2023-02-22 11:30:00	AAPL	Stock	147.88	148.32	147.69	148.064	1660167.0
2023-02-22 12:00:00	AAPL	Stock	148.08	148.34	147.84	148.1101	1372430.0
2023-02-22 12:30:00	AAPL	Stock	148.1222	149.11	148.1222	148.93	3060909.0
2023-02-22 13:00:00	AAPL	Stock	148.925	149.43	148.7645	149.375	2024246.0
2023-02-22 13:30:00	AAPL	Stock	149.38	149.4134	148.93	149.1699	1576872.0
2023-02-22 14:00:00	AAPL	Stock	149.17	149.95	148.57	148.96	3928933.0
2023-02-22 14:30:00	AAPL	Stock	148.96	149.09	148.26	148.37	2781807.0
2023-02-22 15:00:00	AAPL	Stock	148.37	148.81	148.21	148.38	2509655.0
2023-02-22 15:30:00	AAPL	Stock	148.385	149.01	148.185	148.93	4238843.0
2023-02-22 16:00:00	AAPL	Stock	148.94	148.96	148.78	148.8	7009476.0
2023-02-22 16:30:00	AAPL	Stock	148.8291	149.6	148.6118	149.35	102834.0
2023-02-22 17:00:00	AAPL	Stock	149.36	149.48	149.26	149.34	40415.0
2023-02-22 17:30:00	AAPL	Stock	149.35	149.44	149.2505	149.35	33913.0
2023-02-22 18:00:00	AAPL	Stock	149.31	149.31	149.02	149.23	30730.0
2023-02-22 18:30:00	AAPL	Stock	149.26	149.26	149.06	149.16	13289.0
2023-02-22 19:00:00	AAPL	Stock	149.18	149.3	149.18	149.19	12261.0
2023-02-22 19:30:00	AAPL	Stock	149.23	149.25	149.1	149.18	16979.0
2023-02-22 04:00:00	MSFT	Stock	255.5	255.5	252.1	252.5	11844.0
2023-02-22 04:30:00	MSFT	Stock	252.26	252.88	251.54	252.88	3560.0
2023-02-22 05:00:00	MSFT	Stock	252.65	252.66	252.12	252.34	727.0
2023-02-22 05:30:00	MSFT	Stock	252.63	252.63	252.63	252.63	300.0
2023-02-22 06:00:00	MSFT	Stock	252.7	252.7	252.19	252.19	504.0
2023-02-22 06:30:00	MSFT	Stock	251.61	251.97	251.0	251.83	9560.0
2023-02-22 07:00:00	MSFT	Stock	252.01	253.42	252.0	253.42	7918.0
2023-02-22 07:30:00	MSFT	Stock	253.46	254.13	253.46	253.6	14141.0
2023-02-22 08:00:00	MSFT	Stock	252.5	254.23	252.43	253.17	33481.0
2023-02-22 08:30:00	MSFT	Stock	253.35	253.7	253.1612	253.47	26244.0
2023-02-22 09:00:00	MSFT	Stock	253.5	254.19	252.84	253.97	23111.0
2023-02-22 09:30:00	MSFT	Stock	254.09	254.34	253.0	253.345	2344270.0
2023-02-22 10:00:00	MSFT	Stock	253.345	253.365	251.67	251.85	1297621.0
2023-02-22 10:30:00	MSFT	Stock	251.84	253.18	251.39	252.855	892042.0
2023-02-22 11:00:00	MSFT	Stock	252.87	252.94	251.85	252.35	846779.0
2023-02-22 11:30:00	MSFT	Stock	252.36	252.68	251.948	252.5	661177.0
2023-02-22 12:00:00	MSFT	Stock	252.5	252.9499	252.17	252.79	545413.0
2023-02-22 12:30:00	MSFT	Stock	252.8	253.08	252.47	252.86	613296.0

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

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