PREVIEW / stock_30min / 2023-09-12

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-12.parquet
  size:    2.0 MB
  rows:    96,993
  symbols: 1,428

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-09-12 04:00:00	AAPL	Stock	179.78	179.78	179.07	179.43	12035.0
2023-09-12 04:30:00	AAPL	Stock	179.42	179.49	179.3	179.44	6068.0
2023-09-12 05:00:00	AAPL	Stock	179.49	179.8	179.49	179.76	7048.0
2023-09-12 05:30:00	AAPL	Stock	179.74	179.89	179.56	179.86	5014.0
2023-09-12 06:00:00	AAPL	Stock	179.86	179.95	179.78	179.93	4706.0
2023-09-12 06:30:00	AAPL	Stock	179.93	180.02	179.72	179.9	21660.0
2023-09-12 07:00:00	AAPL	Stock	179.91	179.96	179.69	179.78	40198.0
2023-09-12 07:30:00	AAPL	Stock	179.81	179.81	179.7	179.75	19885.0
2023-09-12 08:00:00	AAPL	Stock	179.91	180.0	179.55	179.97	137564.0
2023-09-12 08:30:00	AAPL	Stock	179.89	180.2	179.68	179.75	102630.0
2023-09-12 09:00:00	AAPL	Stock	179.74	179.74	179.2607	179.49	213438.0
2023-09-12 09:30:00	AAPL	Stock	179.45	180.13	178.45	178.73	6202704.0
2023-09-12 10:00:00	AAPL	Stock	178.73	178.7399	177.46	177.55	5206611.0
2023-09-12 10:30:00	AAPL	Stock	177.55	177.78	176.23	176.345	6671756.0
2023-09-12 11:00:00	AAPL	Stock	176.345	176.72	176.25	176.7	3062046.0
2023-09-12 11:30:00	AAPL	Stock	176.712	177.12	176.68	176.6801	3145420.0
2023-09-12 12:00:00	AAPL	Stock	176.685	177.1802	176.52	176.605	2514513.0
2023-09-12 12:30:00	AAPL	Stock	176.61	177.27	176.395	176.9691	2692091.0
2023-09-12 13:00:00	AAPL	Stock	176.97	177.87	176.64	177.5699	3785911.0
2023-09-12 13:30:00	AAPL	Stock	177.57	177.8501	175.45	176.3999	8080225.0
2023-09-12 14:00:00	AAPL	Stock	176.39	176.78	174.82	176.1	10123805.0
2023-09-12 14:30:00	AAPL	Stock	176.11	176.75	175.14	175.3287	5837735.0
2023-09-12 15:00:00	AAPL	Stock	175.33	175.78	175.0004	175.72	4089013.0
2023-09-12 15:30:00	AAPL	Stock	175.72	176.46	175.4901	176.31	7993972.0
2023-09-12 16:00:00	AAPL	Stock	176.31	176.83	176.21	176.32	6652328.0
2023-09-12 16:30:00	AAPL	Stock	176.31	176.46	176.3	176.3603	124315.0
2023-09-12 17:00:00	AAPL	Stock	176.4	176.58	176.37	176.49	61167.0
2023-09-12 17:30:00	AAPL	Stock	176.51	176.51	176.35	176.45	37681.0
2023-09-12 18:00:00	AAPL	Stock	176.4	176.48	176.37	176.3821	17866.0
2023-09-12 18:30:00	AAPL	Stock	176.3821	176.44	176.34	176.39	18869.0
2023-09-12 19:00:00	AAPL	Stock	176.38	176.3899	176.35	176.35	17321.0
2023-09-12 19:30:00	AAPL	Stock	176.37	176.44	176.33	176.35	25455.0
2023-09-12 04:00:00	MSFT	Stock	336.46	336.58	336.06	336.4	2127.0
2023-09-12 04:30:00	MSFT	Stock	336.19	336.19	336.0	336.0	1187.0
2023-09-12 05:00:00	MSFT	Stock	335.9	335.9	335.9	335.9	100.0
2023-09-12 06:30:00	MSFT	Stock	336.31	336.31	336.31	336.31	300.0
2023-09-12 07:00:00	MSFT	Stock	336.38	336.51	335.85	335.85	8951.0
2023-09-12 07:30:00	MSFT	Stock	335.93	335.93	335.56	335.56	576.0
2023-09-12 08:00:00	MSFT	Stock	336.2	336.93	335.45	335.8	14793.0
2023-09-12 08:30:00	MSFT	Stock	335.79	336.19	335.2	335.49	14567.0
2023-09-12 09:00:00	MSFT	Stock	335.3	336.45	334.87	335.89	25693.0
2023-09-12 09:30:00	MSFT	Stock	335.88	336.79	335.17	335.845	1117057.0
2023-09-12 10:00:00	MSFT	Stock	335.845	335.88	334.18	334.35	764836.0
2023-09-12 10:30:00	MSFT	Stock	334.31	334.85	333.26	333.445	822191.0
2023-09-12 11:00:00	MSFT	Stock	333.45	333.98	332.22	332.63	796416.0
2023-09-12 11:30:00	MSFT	Stock	332.64	333.48	332.64	333.1101	515595.0
2023-09-12 12:00:00	MSFT	Stock	333.13	334.0599	333.045	333.4722	448928.0
2023-09-12 12:30:00	MSFT	Stock	333.45	333.68	332.98	333.25	275394.0
2023-09-12 13:00:00	MSFT	Stock	333.3	334.24	332.9404	333.88	359133.0
2023-09-12 13:30:00	MSFT	Stock	333.93	334.15	332.31	332.34	376346.0

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

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