PREVIEW / stock_30min / 2023-08-16

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-16.parquet
  size:    2.0 MB
  rows:    99,538
  symbols: 1,479

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-08-16 04:00:00	AAPL	Stock	178.03	178.05	177.99	178.02	4252.0
2023-08-16 04:30:00	AAPL	Stock	177.97	178.07	177.96	178.01	3790.0
2023-08-16 05:00:00	AAPL	Stock	178.06	178.13	177.8	177.85	16076.0
2023-08-16 05:30:00	AAPL	Stock	177.9	177.99	177.65	177.86	5030.0
2023-08-16 06:00:00	AAPL	Stock	177.89	177.98	177.45	177.96	9065.0
2023-08-16 06:30:00	AAPL	Stock	177.98	177.98	177.81	177.86	4261.0
2023-08-16 07:00:00	AAPL	Stock	177.83	177.84	177.38	177.52	11309.0
2023-08-16 07:30:00	AAPL	Stock	177.54	177.74	177.53	177.72	8681.0
2023-08-16 08:00:00	AAPL	Stock	177.39	178.35	177.28	177.4	71121.0
2023-08-16 08:30:00	AAPL	Stock	177.45	177.53	177.03	177.07	82704.0
2023-08-16 09:00:00	AAPL	Stock	177.07	177.48	177.0	177.11	103709.0
2023-08-16 09:30:00	AAPL	Stock	177.13	178.19	176.84	177.9771	4348475.0
2023-08-16 10:00:00	AAPL	Stock	177.975	178.54	177.625	177.82	2543402.0
2023-08-16 10:30:00	AAPL	Stock	177.81	178.31	177.77	178.215	2177898.0
2023-08-16 11:00:00	AAPL	Stock	178.22	178.335	177.68	177.81	1675963.0
2023-08-16 11:30:00	AAPL	Stock	177.8	177.91	177.5	177.66	1683755.0
2023-08-16 12:00:00	AAPL	Stock	177.66	177.665	177.305	177.42	1703557.0
2023-08-16 12:30:00	AAPL	Stock	177.41	177.84	177.32	177.5973	1381061.0
2023-08-16 13:00:00	AAPL	Stock	177.59	177.95	177.38	177.865	1571952.0
2023-08-16 13:30:00	AAPL	Stock	177.86	178.3771	177.7001	178.08	1338776.0
2023-08-16 14:00:00	AAPL	Stock	178.1	178.22	177.31	178.1	2191834.0
2023-08-16 14:30:00	AAPL	Stock	178.1	178.31	177.53	177.7586	1696649.0
2023-08-16 15:00:00	AAPL	Stock	177.76	177.76	176.85	177.12	2710266.0
2023-08-16 15:30:00	AAPL	Stock	177.13	177.3092	176.5	176.5586	4560526.0
2023-08-16 16:00:00	AAPL	Stock	176.55	176.61	176.08	176.08	3978766.0
2023-08-16 16:30:00	AAPL	Stock	176.11	176.57	176.1	176.36	106899.0
2023-08-16 17:00:00	AAPL	Stock	176.35	176.57	176.31	176.45	66925.0
2023-08-16 17:30:00	AAPL	Stock	176.49	176.49	176.36	176.4	14326.0
2023-08-16 18:00:00	AAPL	Stock	176.42	176.47	176.4	176.4	15343.0
2023-08-16 18:30:00	AAPL	Stock	176.45	176.45	176.35	176.36	8608.0
2023-08-16 19:00:00	AAPL	Stock	176.35	176.35	176.14	176.15	19973.0
2023-08-16 19:30:00	AAPL	Stock	176.16	176.17	176.07	176.09	29364.0
2023-08-16 04:00:00	MSFT	Stock	321.81	323.0	321.81	322.7	6505.0
2023-08-16 04:30:00	MSFT	Stock	322.66	322.85	322.66	322.85	581.0
2023-08-16 05:00:00	MSFT	Stock	322.59	322.6	322.16	322.16	1338.0
2023-08-16 05:30:00	MSFT	Stock	321.76	321.76	321.42	321.69	619.0
2023-08-16 06:00:00	MSFT	Stock	321.69	321.69	321.51	321.69	300.0
2023-08-16 06:30:00	MSFT	Stock	321.51	321.51	321.51	321.51	100.0
2023-08-16 07:00:00	MSFT	Stock	321.47	321.56	320.84	320.9	3075.0
2023-08-16 07:30:00	MSFT	Stock	321.2	321.47	321.2	321.3	3270.0
2023-08-16 08:00:00	MSFT	Stock	321.5	321.53	320.8521	321.12	8194.0
2023-08-16 08:30:00	MSFT	Stock	321.01	321.2	320.5002	320.5002	10165.0
2023-08-16 09:00:00	MSFT	Stock	320.71	321.41	320.57	320.72	30417.0
2023-08-16 09:30:00	MSFT	Stock	320.8	322.61	319.8035	321.69	1340550.0
2023-08-16 10:00:00	MSFT	Stock	321.69	323.79	321.13	322.7476	1035259.0
2023-08-16 10:30:00	MSFT	Stock	322.76	323.57	322.22	323.39	828579.0
2023-08-16 11:00:00	MSFT	Stock	323.4	324.42	323.01	323.46	839709.0
2023-08-16 11:30:00	MSFT	Stock	323.4183	323.5	322.0	322.26	506365.0
2023-08-16 12:00:00	MSFT	Stock	322.23	322.31	321.25	321.69	535236.0
2023-08-16 12:30:00	MSFT	Stock	321.7	322.2986	321.315	321.33	345946.0

> showing 50 of 99,538 rows — these rows as CSV

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