PREVIEW / stock_30min / 2023-04-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-14.parquet
  size:    2.1 MB
  rows:    100,561
  symbols: 1,680

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-14 04:00:00	AAPL	Stock	165.3	165.78	165.09	165.09	5464.0
2023-04-14 04:30:00	AAPL	Stock	165.05	165.1	165.05	165.05	829.0
2023-04-14 05:00:00	AAPL	Stock	165.0	165.0	164.94	164.99	774.0
2023-04-14 05:30:00	AAPL	Stock	164.89	164.97	164.89	164.94	1844.0
2023-04-14 06:00:00	AAPL	Stock	164.93	164.93	164.77	164.85	8547.0
2023-04-14 06:30:00	AAPL	Stock	164.85	164.95	164.3	164.31	13265.0
2023-04-14 07:00:00	AAPL	Stock	164.55	164.72	164.35	164.53	37483.0
2023-04-14 07:30:00	AAPL	Stock	164.53	164.64	164.4	164.55	33022.0
2023-04-14 08:00:00	AAPL	Stock	165.05	165.25	164.35	164.77	139499.0
2023-04-14 08:30:00	AAPL	Stock	164.8	165.15	163.87	164.1018	233847.0
2023-04-14 09:00:00	AAPL	Stock	164.18	164.61	164.15	164.59	94864.0
2023-04-14 09:30:00	AAPL	Stock	164.59	166.32	164.52	165.7813	7128797.0
2023-04-14 10:00:00	AAPL	Stock	165.76	166.3	164.84	164.97	4619139.0
2023-04-14 10:30:00	AAPL	Stock	164.99	165.16	164.575	164.91	2522326.0
2023-04-14 11:00:00	AAPL	Stock	164.915	165.4799	164.7	165.0281	2155506.0
2023-04-14 11:30:00	AAPL	Stock	165.03	165.105	164.61	164.9187	1551784.0
2023-04-14 12:00:00	AAPL	Stock	164.93	164.94	164.32	164.43	1788263.0
2023-04-14 12:30:00	AAPL	Stock	164.42	164.43	163.82	164.0	1902151.0
2023-04-14 13:00:00	AAPL	Stock	164.0	164.6	163.935	164.285	1620995.0
2023-04-14 13:30:00	AAPL	Stock	164.285	164.4799	164.0	164.4471	1789656.0
2023-04-14 14:00:00	AAPL	Stock	164.45	164.99	164.15	164.96	1802256.0
2023-04-14 14:30:00	AAPL	Stock	164.965	165.57	164.73	164.983	2384193.0
2023-04-14 15:00:00	AAPL	Stock	164.985	165.09	164.4	164.935	2277556.0
2023-04-14 15:30:00	AAPL	Stock	164.94	165.28	164.83	165.21	4141688.0
2023-04-14 16:00:00	AAPL	Stock	165.195	165.28	165.1	165.27	5840925.0
2023-04-14 16:30:00	AAPL	Stock	165.25	165.43	165.2	165.33	89101.0
2023-04-14 17:00:00	AAPL	Stock	165.3	165.3	165.1433	165.19	9246.0
2023-04-14 17:30:00	AAPL	Stock	165.19	165.2383	165.16	165.17	2154.0
2023-04-14 18:00:00	AAPL	Stock	165.17	165.18	165.15	165.17	7054.0
2023-04-14 18:30:00	AAPL	Stock	165.2	165.24	165.1503	165.2	10244.0
2023-04-14 19:00:00	AAPL	Stock	165.21	165.2199	165.15	165.1999	4399.0
2023-04-14 19:30:00	AAPL	Stock	165.16	165.2	164.85	165.0	19809.0
2023-04-14 04:00:00	MSFT	Stock	289.9	289.9	289.39	289.39	1894.0
2023-04-14 04:30:00	MSFT	Stock	289.38	289.47	289.31	289.45	1120.0
2023-04-14 05:00:00	MSFT	Stock	289.35	289.5	289.27	289.5	361.0
2023-04-14 05:30:00	MSFT	Stock	289.5	289.5	289.25	289.25	344.0
2023-04-14 06:00:00	MSFT	Stock	289.0	289.01	289.0	289.01	571.0
2023-04-14 06:30:00	MSFT	Stock	289.1	289.35	287.5	288.0	9597.0
2023-04-14 07:00:00	MSFT	Stock	288.4	288.7	287.43	288.16	7886.0
2023-04-14 07:30:00	MSFT	Stock	288.16	288.2	287.6	287.67	14839.0
2023-04-14 08:00:00	MSFT	Stock	288.3	290.0	287.42	287.9	37907.0
2023-04-14 08:30:00	MSFT	Stock	288.1	288.22	286.48	286.82	37798.0
2023-04-14 09:00:00	MSFT	Stock	286.82	287.36	286.5	286.85	30959.0
2023-04-14 09:30:00	MSFT	Stock	286.89	288.359	286.44	287.85	2143742.0
2023-04-14 10:00:00	MSFT	Stock	287.83	288.48	285.82	286.0884	1358690.0
2023-04-14 10:30:00	MSFT	Stock	286.07	286.53	285.47	286.29	860171.0
2023-04-14 11:00:00	MSFT	Stock	286.33	287.31	285.71	286.38	706594.0
2023-04-14 11:30:00	MSFT	Stock	286.38	286.8221	285.94	286.26	706048.0
2023-04-14 12:00:00	MSFT	Stock	286.255	286.315	285.229	285.48	855284.0
2023-04-14 12:30:00	MSFT	Stock	285.43	285.45	284.07	284.19	965715.0

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

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