PREVIEW / stock_30min / 2023-04-25

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-25.parquet
  size:    2.1 MB
  rows:    100,956
  symbols: 1,687

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-25 04:00:00	AAPL	Stock	164.93	164.93	164.23	164.3	20472.0
2023-04-25 04:30:00	AAPL	Stock	164.39	164.64	164.38	164.49	5156.0
2023-04-25 05:00:00	AAPL	Stock	164.52	164.64	164.5	164.63	1440.0
2023-04-25 05:30:00	AAPL	Stock	164.63	164.65	164.62	164.62	952.0
2023-04-25 06:00:00	AAPL	Stock	164.64	164.78	164.6	164.62	7187.0
2023-04-25 06:30:00	AAPL	Stock	164.63	165.1	164.63	165.0	24280.0
2023-04-25 07:00:00	AAPL	Stock	165.0	165.08	164.89	165.0	32709.0
2023-04-25 07:30:00	AAPL	Stock	165.0	165.01	164.75	164.87	10512.0
2023-04-25 08:00:00	AAPL	Stock	164.95	165.02	164.09	164.8	73320.0
2023-04-25 08:30:00	AAPL	Stock	164.8	164.95	164.5	164.85	54159.0
2023-04-25 09:00:00	AAPL	Stock	164.8051	165.34	164.8051	165.18	85046.0
2023-04-25 09:30:00	AAPL	Stock	165.19	166.305	165.05	166.05	5519739.0
2023-04-25 10:00:00	AAPL	Stock	166.04	166.28	165.06	165.34	3452114.0
2023-04-25 10:30:00	AAPL	Stock	165.34	165.4779	165.0595	165.22	2392210.0
2023-04-25 11:00:00	AAPL	Stock	165.23	165.65	164.99	165.22	2107189.0
2023-04-25 11:30:00	AAPL	Stock	165.21	165.2282	164.78	164.865	1987955.0
2023-04-25 12:00:00	AAPL	Stock	164.86	164.9263	164.58	164.63	1693176.0
2023-04-25 12:30:00	AAPL	Stock	164.62	164.67	164.38	164.62	1551743.0
2023-04-25 13:00:00	AAPL	Stock	164.6226	164.82	163.8	164.34	2484494.0
2023-04-25 13:30:00	AAPL	Stock	164.33	164.46	163.84	163.92	1402173.0
2023-04-25 14:00:00	AAPL	Stock	163.9224	164.35	163.75	164.3206	2073009.0
2023-04-25 14:30:00	AAPL	Stock	164.33	164.53	163.995	164.0001	1758124.0
2023-04-25 15:00:00	AAPL	Stock	164.0	164.42	163.98	164.12	1987741.0
2023-04-25 15:30:00	AAPL	Stock	164.12	164.2403	163.73	163.8	5399976.0
2023-04-25 16:00:00	AAPL	Stock	163.81	164.43	163.52	163.91	6520882.0
2023-04-25 16:30:00	AAPL	Stock	163.92	164.0292	163.76	163.9799	140822.0
2023-04-25 17:00:00	AAPL	Stock	163.98	164.19	163.84	164.19	64735.0
2023-04-25 17:30:00	AAPL	Stock	164.16	164.4	164.16	164.32	46007.0
2023-04-25 18:00:00	AAPL	Stock	164.32	164.72	164.15	164.5	99072.0
2023-04-25 18:30:00	AAPL	Stock	164.52	164.58	164.4	164.52	32845.0
2023-04-25 19:00:00	AAPL	Stock	164.5	164.58	164.4	164.4	22512.0
2023-04-25 19:30:00	AAPL	Stock	164.48	164.48	164.15	164.16	41217.0
2023-04-25 04:00:00	MSFT	Stock	280.98	280.98	280.0	280.0	11004.0
2023-04-25 04:30:00	MSFT	Stock	279.93	280.5	279.79	280.25	4697.0
2023-04-25 05:00:00	MSFT	Stock	280.3	280.45	280.3	280.45	553.0
2023-04-25 06:00:00	MSFT	Stock	280.72	281.0	280.59	280.76	1865.0
2023-04-25 06:30:00	MSFT	Stock	280.81	281.0	280.73	281.0	1052.0
2023-04-25 07:00:00	MSFT	Stock	281.1	281.25	280.45	280.55	13955.0
2023-04-25 07:30:00	MSFT	Stock	280.7	280.8	280.22	280.28	4460.0
2023-04-25 08:00:00	MSFT	Stock	280.89	281.11	279.01	280.71	17112.0
2023-04-25 08:30:00	MSFT	Stock	280.8	280.824	280.2	280.25	12200.0
2023-04-25 09:00:00	MSFT	Stock	280.1	280.83	278.82	279.28	43698.0
2023-04-25 09:30:00	MSFT	Stock	279.37	281.6	278.975	280.8199	2397487.0
2023-04-25 10:00:00	MSFT	Stock	280.79	281.01	278.79	279.3199	1727560.0
2023-04-25 10:30:00	MSFT	Stock	279.32	280.09	278.94	279.73	1147429.0
2023-04-25 11:00:00	MSFT	Stock	279.7401	280.48	279.32	279.37	1181205.0
2023-04-25 11:30:00	MSFT	Stock	279.35	279.44	277.62	278.27	1605569.0
2023-04-25 12:00:00	MSFT	Stock	278.28	278.37	277.3304	278.07	1235782.0
2023-04-25 12:30:00	MSFT	Stock	278.07	278.09	277.0	277.945	1181410.0
2023-04-25 13:00:00	MSFT	Stock	277.945	278.51	277.23	278.3399	1200328.0

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

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