PREVIEW / stock_30min / 2023-02-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-24.parquet
  size:    2.1 MB
  rows:    100,461
  symbols: 1,818

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-24 04:00:00	AAPL	Stock	148.19	148.74	148.19	148.5	3755.0
2023-02-24 04:30:00	AAPL	Stock	148.47	148.49	148.31	148.37	3784.0
2023-02-24 05:00:00	AAPL	Stock	148.34	148.34	148.15	148.2	6882.0
2023-02-24 05:30:00	AAPL	Stock	148.2	148.29	148.19	148.29	2056.0
2023-02-24 06:00:00	AAPL	Stock	148.16	148.2	148.0	148.06	7618.0
2023-02-24 06:30:00	AAPL	Stock	148.04	148.07	147.75	147.99	6223.0
2023-02-24 07:00:00	AAPL	Stock	147.98	148.11	147.93	148.05	21405.0
2023-02-24 07:30:00	AAPL	Stock	148.04	148.07	147.94	148.0	14461.0
2023-02-24 08:00:00	AAPL	Stock	148.003	149.39	147.9	148.14	58646.0
2023-02-24 08:30:00	AAPL	Stock	148.05	148.05	146.75	146.99	207731.0
2023-02-24 09:00:00	AAPL	Stock	147.05	147.28	146.95	147.13	131783.0
2023-02-24 09:30:00	AAPL	Stock	147.1	147.19	146.12	146.41	6289245.0
2023-02-24 10:00:00	AAPL	Stock	146.4	146.91	146.195	146.29	4702360.0
2023-02-24 10:30:00	AAPL	Stock	146.29	146.4799	145.95	146.09	3505164.0
2023-02-24 11:00:00	AAPL	Stock	146.1	146.58	145.73	146.39	2644357.0
2023-02-24 11:30:00	AAPL	Stock	146.4	146.9	146.11	146.4153	2331969.0
2023-02-24 12:00:00	AAPL	Stock	146.415	146.51	146.06	146.251	1785497.0
2023-02-24 12:30:00	AAPL	Stock	146.26	146.4382	145.88	145.98	1651822.0
2023-02-24 13:00:00	AAPL	Stock	145.98	146.3595	145.7202	146.215	2096161.0
2023-02-24 13:30:00	AAPL	Stock	146.22	146.24	145.89	146.1	1830332.0
2023-02-24 14:00:00	AAPL	Stock	146.1	146.37	145.93	146.11	1883573.0
2023-02-24 14:30:00	AAPL	Stock	146.12	146.62	145.77	146.5	2402380.0
2023-02-24 15:00:00	AAPL	Stock	146.5119	146.69	146.11	146.12	2359509.0
2023-02-24 15:30:00	AAPL	Stock	146.115	146.8	145.805	146.71	6298584.0
2023-02-24 16:00:00	AAPL	Stock	146.72	146.8	146.52	146.68	8806923.0
2023-02-24 16:30:00	AAPL	Stock	146.67	146.71	146.62	146.62	92796.0
2023-02-24 17:00:00	AAPL	Stock	146.6215	146.63	146.5	146.5101	33500.0
2023-02-24 17:30:00	AAPL	Stock	146.55	146.59	146.46	146.46	26186.0
2023-02-24 18:00:00	AAPL	Stock	146.5	146.55	146.5	146.5101	5110.0
2023-02-24 18:30:00	AAPL	Stock	146.5899	146.59	146.5	146.5101	10683.0
2023-02-24 19:00:00	AAPL	Stock	146.53	146.53	146.49	146.49	8185.0
2023-02-24 19:30:00	AAPL	Stock	146.5	146.5	146.3	146.4	19156.0
2023-02-24 04:00:00	MSFT	Stock	253.61	253.97	253.53	253.65	4384.0
2023-02-24 04:30:00	MSFT	Stock	253.6	253.6	253.41	253.5	2394.0
2023-02-24 05:00:00	MSFT	Stock	253.5	253.52	253.25	253.27	2482.0
2023-02-24 05:30:00	MSFT	Stock	253.26	253.29	253.2	253.29	1389.0
2023-02-24 06:00:00	MSFT	Stock	253.19	253.19	252.61	252.61	2269.0
2023-02-24 06:30:00	MSFT	Stock	252.83	252.88	252.41	252.41	1543.0
2023-02-24 07:00:00	MSFT	Stock	252.71	253.15	252.6	252.98	10031.0
2023-02-24 07:30:00	MSFT	Stock	253.0	253.1	252.75	252.87	9299.0
2023-02-24 08:00:00	MSFT	Stock	255.05	255.05	252.51	253.01	34563.0
2023-02-24 08:30:00	MSFT	Stock	252.97	252.98	250.11	250.46	78174.0
2023-02-24 09:00:00	MSFT	Stock	250.34	250.5	249.82	249.9	61969.0
2023-02-24 09:30:00	MSFT	Stock	249.96	251.0	249.06	249.5516	2404956.0
2023-02-24 10:00:00	MSFT	Stock	249.52	250.13	248.91	249.38	1191186.0
2023-02-24 10:30:00	MSFT	Stock	249.36	249.43	248.24	248.5	1118429.0
2023-02-24 11:00:00	MSFT	Stock	248.53	249.39	248.295	249.05	818958.0
2023-02-24 11:30:00	MSFT	Stock	249.06	249.79	248.58	249.43	766386.0
2023-02-24 12:00:00	MSFT	Stock	249.46	249.61	248.97	249.35	572937.0
2023-02-24 12:30:00	MSFT	Stock	249.35	249.59	248.6	248.6901	470532.0

> showing 50 of 100,461 rows — these rows as CSV

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