PREVIEW / stock_30min / 2024-04-17

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-04-17.parquet
  size:    2.0 MB
  rows:    96,917
  symbols: 1,018

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
2024-04-17 04:00:00	AAPL	Stock	169.68	169.9	169.43	169.7	9825.0
2024-04-17 04:30:00	AAPL	Stock	169.72	169.8	169.71	169.8	3932.0
2024-04-17 05:00:00	AAPL	Stock	169.66	169.69	169.56	169.6	2696.0
2024-04-17 05:30:00	AAPL	Stock	169.68	169.77	169.68	169.71	1554.0
2024-04-17 06:00:00	AAPL	Stock	169.84	169.84	169.7	169.72	1372.0
2024-04-17 06:30:00	AAPL	Stock	169.81	170.05	169.64	169.64	6124.0
2024-04-17 07:00:00	AAPL	Stock	169.68	169.94	169.68	169.85	7116.0
2024-04-17 07:30:00	AAPL	Stock	169.9	169.95	169.7	169.7	11076.0
2024-04-17 08:00:00	AAPL	Stock	169.95	169.96	169.09	169.7	43361.0
2024-04-17 08:30:00	AAPL	Stock	169.77	170.03	169.75	169.96	21480.0
2024-04-17 09:00:00	AAPL	Stock	169.9	170.3	169.38	169.5595	117580.0
2024-04-17 09:30:00	AAPL	Stock	169.56	170.65	169.31	169.84	4813377.0
2024-04-17 10:00:00	AAPL	Stock	169.845	170.63	169.58	170.455	3163698.0
2024-04-17 10:30:00	AAPL	Stock	170.45	170.475	169.605	169.8465	2612267.0
2024-04-17 11:00:00	AAPL	Stock	169.84	170.14	169.21	169.22	2351514.0
2024-04-17 11:30:00	AAPL	Stock	169.22	169.36	168.87	168.9299	2264998.0
2024-04-17 12:00:00	AAPL	Stock	168.93	169.05	168.6	168.7	2156172.0
2024-04-17 12:30:00	AAPL	Stock	168.7	168.7153	168.07	168.35	2050656.0
2024-04-17 13:00:00	AAPL	Stock	168.36	168.97	168.3	168.82	1707128.0
2024-04-17 13:30:00	AAPL	Stock	168.83	169.0	168.51	168.92	1449293.0
2024-04-17 14:00:00	AAPL	Stock	168.94	168.96	168.53	168.61	1323270.0
2024-04-17 14:30:00	AAPL	Stock	168.62	169.18	168.2607	168.33	1827480.0
2024-04-17 15:00:00	AAPL	Stock	168.32	168.37	168.02	168.09	1807379.0
2024-04-17 15:30:00	AAPL	Stock	168.09	168.545	168.0	168.0	3996011.0
2024-04-17 16:00:00	AAPL	Stock	168.0	168.32	168.0	168.17	5250368.0
2024-04-17 16:30:00	AAPL	Stock	168.1509	168.2	168.0	168.15	104399.0
2024-04-17 17:00:00	AAPL	Stock	168.1301	168.37	168.0	168.37	34090.0
2024-04-17 17:30:00	AAPL	Stock	168.32	168.45	168.3	168.39	14761.0
2024-04-17 18:00:00	AAPL	Stock	168.0	168.4344	168.0	168.4	9177.0
2024-04-17 18:30:00	AAPL	Stock	168.4001	168.44	168.4	168.4	7631.0
2024-04-17 19:00:00	AAPL	Stock	168.31	168.44	168.25	168.29	3536.0
2024-04-17 19:30:00	AAPL	Stock	168.38	168.38	168.17	168.35	15610.0
2024-04-17 04:00:00	MSFT	Stock	415.27	416.35	415.27	416.35	1956.0
2024-04-17 04:30:00	MSFT	Stock	416.3	416.51	416.02	416.02	2527.0
2024-04-17 05:00:00	MSFT	Stock	415.82	416.2	415.82	416.2	531.0
2024-04-17 05:30:00	MSFT	Stock	416.42	416.46	416.42	416.46	422.0
2024-04-17 06:00:00	MSFT	Stock	416.65	417.36	416.65	416.72	2042.0
2024-04-17 06:30:00	MSFT	Stock	416.75	416.99	416.75	416.92	2488.0
2024-04-17 07:00:00	MSFT	Stock	416.79	417.21	416.55	416.7	4719.0
2024-04-17 07:30:00	MSFT	Stock	416.88	416.88	416.49	416.5	4218.0
2024-04-17 08:00:00	MSFT	Stock	417.0	417.1	413.76	416.5	52201.0
2024-04-17 08:30:00	MSFT	Stock	416.797	417.5469	416.5	417.3	8497.0
2024-04-17 09:00:00	MSFT	Stock	417.25	418.25	416.81	417.36	25968.0
2024-04-17 09:30:00	MSFT	Stock	417.25	418.88	416.2	416.72	1290886.0
2024-04-17 10:00:00	MSFT	Stock	416.77	416.94	414.52	415.84	774744.0
2024-04-17 10:30:00	MSFT	Stock	415.835	416.1	414.18	415.0217	485799.0
2024-04-17 11:00:00	MSFT	Stock	415.04	415.95	413.28	413.295	440018.0
2024-04-17 11:30:00	MSFT	Stock	413.29	413.42	412.12	413.05	517919.0
2024-04-17 12:00:00	MSFT	Stock	413.02	414.77	410.88	411.5	833968.0
2024-04-17 12:30:00	MSFT	Stock	411.47	411.875	410.33	411.19	453122.0

> showing 50 of 96,917 rows — these rows as CSV

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