PREVIEW / stock_30min / 2023-04-28

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-28.parquet
  size:    2.1 MB
  rows:    101,509
  symbols: 1,676

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-04-28 04:00:00	AAPL	Stock	167.76	167.76	167.57	167.59	4485.0
2023-04-28 04:30:00	AAPL	Stock	167.56	167.58	167.48	167.55	6880.0
2023-04-28 05:00:00	AAPL	Stock	167.42	167.61	167.41	167.61	4792.0
2023-04-28 05:30:00	AAPL	Stock	167.59	167.6	167.42	167.48	6493.0
2023-04-28 06:00:00	AAPL	Stock	167.45	167.62	167.42	167.61	5029.0
2023-04-28 06:30:00	AAPL	Stock	167.53	167.59	167.5	167.52	1137.0
2023-04-28 07:00:00	AAPL	Stock	167.51	167.75	167.49	167.6	32108.0
2023-04-28 07:30:00	AAPL	Stock	167.6	167.72	167.48	167.52	17587.0
2023-04-28 08:00:00	AAPL	Stock	167.6007	167.87	167.27	167.69	98866.0
2023-04-28 08:30:00	AAPL	Stock	167.69	168.19	167.48	167.9	116571.0
2023-04-28 09:00:00	AAPL	Stock	167.95	168.48	167.91	168.48	145297.0
2023-04-28 09:30:00	AAPL	Stock	168.48	169.04	167.8801	168.51	5617542.0
2023-04-28 10:00:00	AAPL	Stock	168.51	169.85	168.23	169.8385	4708599.0
2023-04-28 10:30:00	AAPL	Stock	169.83	169.85	168.57	168.78	4258318.0
2023-04-28 11:00:00	AAPL	Stock	168.78	168.795	168.03	168.29	2685152.0
2023-04-28 11:30:00	AAPL	Stock	168.3	168.83	168.2	168.76	1875275.0
2023-04-28 12:00:00	AAPL	Stock	168.77	168.97	168.36	168.67	1739082.0
2023-04-28 12:30:00	AAPL	Stock	168.662	168.85	168.33	168.8353	1741471.0
2023-04-28 13:00:00	AAPL	Stock	168.83	168.89	168.51	168.76	1695583.0
2023-04-28 13:30:00	AAPL	Stock	168.76	168.7623	168.15	168.35	1964021.0
2023-04-28 14:00:00	AAPL	Stock	168.345	168.52	168.22	168.295	1701164.0
2023-04-28 14:30:00	AAPL	Stock	168.295	168.5917	168.12	168.5701	1937960.0
2023-04-28 15:00:00	AAPL	Stock	168.57	169.03	168.5219	168.815	2511771.0
2023-04-28 15:30:00	AAPL	Stock	168.82	169.71	168.79	169.69	5596485.0
2023-04-28 16:00:00	AAPL	Stock	169.69	169.77	169.44	169.5	7965426.0
2023-04-28 16:30:00	AAPL	Stock	169.48	169.68	169.42	169.46	122070.0
2023-04-28 17:00:00	AAPL	Stock	169.46	169.55	169.23	169.23	43161.0
2023-04-28 17:30:00	AAPL	Stock	169.2499	169.68	169.12	169.18	37461.0
2023-04-28 18:00:00	AAPL	Stock	169.15	169.38	169.15	169.31	14762.0
2023-04-28 18:30:00	AAPL	Stock	169.36	169.42	169.36	169.39	10336.0
2023-04-28 19:00:00	AAPL	Stock	169.39	169.39	169.3	169.32	7058.0
2023-04-28 19:30:00	AAPL	Stock	169.32	169.59	169.27	169.59	29737.0
2023-04-28 04:00:00	MSFT	Stock	304.3	304.63	303.6	303.6	6543.0
2023-04-28 04:30:00	MSFT	Stock	303.6	303.7	303.14	303.23	8737.0
2023-04-28 05:00:00	MSFT	Stock	303.35	303.7	303.0	303.61	13832.0
2023-04-28 05:30:00	MSFT	Stock	303.61	304.5	303.6	304.05	15248.0
2023-04-28 06:00:00	MSFT	Stock	304.15	304.25	304.0	304.22	11465.0
2023-04-28 06:30:00	MSFT	Stock	304.16	304.45	304.1	304.2	6431.0
2023-04-28 07:00:00	MSFT	Stock	304.32	304.41	304.1	304.4	4348.0
2023-04-28 07:30:00	MSFT	Stock	304.5	304.5	303.75	304.1	18951.0
2023-04-28 08:00:00	MSFT	Stock	304.35	304.45	303.2	304.25	39284.0
2023-04-28 08:30:00	MSFT	Stock	304.25	304.7588	303.78	304.6	26972.0
2023-04-28 09:00:00	MSFT	Stock	304.6	304.81	303.6	304.06	42463.0
2023-04-28 09:30:00	MSFT	Stock	304.17	307.33	303.31	307.03	4500288.0
2023-04-28 10:00:00	MSFT	Stock	307.06	308.93	306.42	308.8161	3365871.0
2023-04-28 10:30:00	MSFT	Stock	308.8	308.8	305.0	305.56	3012742.0
2023-04-28 11:00:00	MSFT	Stock	305.56	305.86	304.7	304.92	1607123.0
2023-04-28 11:30:00	MSFT	Stock	304.93	306.03	304.93	305.63	1091375.0
2023-04-28 12:00:00	MSFT	Stock	305.6964	306.64	304.35	304.725	1276047.0
2023-04-28 12:30:00	MSFT	Stock	304.74	305.5	304.1	305.02	1094510.0

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

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