PREVIEW / stock_30min / 2023-09-08

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-08.parquet
  size:    2.0 MB
  rows:    95,453
  symbols: 1,445

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-08 04:00:00	AAPL	Stock	179.0	179.0	177.51	177.76	44851.0
2023-09-08 04:30:00	AAPL	Stock	177.75	178.13	177.75	177.75	3710.0
2023-09-08 05:00:00	AAPL	Stock	177.73	177.73	177.18	177.5	47268.0
2023-09-08 05:30:00	AAPL	Stock	177.54	177.77	177.5	177.53	20677.0
2023-09-08 06:00:00	AAPL	Stock	177.52	177.75	177.16	177.73	12456.0
2023-09-08 06:30:00	AAPL	Stock	177.75	177.82	177.16	177.8	27210.0
2023-09-08 07:00:00	AAPL	Stock	177.78	177.89	177.28	177.38	95195.0
2023-09-08 07:30:00	AAPL	Stock	177.35	177.56	177.24	177.48	37248.0
2023-09-08 08:00:00	AAPL	Stock	177.7913	179.75	177.06	177.22	206231.0
2023-09-08 08:30:00	AAPL	Stock	177.22	178.48	177.22	178.1901	285685.0
2023-09-08 09:00:00	AAPL	Stock	178.19	178.56	178.15	178.4	198555.0
2023-09-08 09:30:00	AAPL	Stock	178.45	180.239	178.33	179.075	9818232.0
2023-09-08 10:00:00	AAPL	Stock	179.0784	180.0252	179.04	179.525	4543510.0
2023-09-08 10:30:00	AAPL	Stock	179.53	179.855	178.93	178.9442	4046938.0
2023-09-08 11:00:00	AAPL	Stock	178.94	179.88	178.7	179.8118	4265539.0
2023-09-08 11:30:00	AAPL	Stock	179.82	180.2	179.44	179.545	3150542.0
2023-09-08 12:00:00	AAPL	Stock	179.55	179.99	179.28	179.555	2568754.0
2023-09-08 12:30:00	AAPL	Stock	179.55	179.7	179.21	179.6181	2153581.0
2023-09-08 13:00:00	AAPL	Stock	179.61	179.795	179.26	179.585	1772942.0
2023-09-08 13:30:00	AAPL	Stock	179.59	179.91	179.55	179.7	1788963.0
2023-09-08 14:00:00	AAPL	Stock	179.7037	179.89	178.7401	178.8802	3358889.0
2023-09-08 14:30:00	AAPL	Stock	178.885	179.055	178.02	178.205	3508284.0
2023-09-08 15:00:00	AAPL	Stock	178.2	178.41	177.81	177.945	3387657.0
2023-09-08 15:30:00	AAPL	Stock	177.94	178.34	177.79	178.19	5356159.0
2023-09-08 16:00:00	AAPL	Stock	178.18	178.6	178.17	178.59	4657304.0
2023-09-08 16:30:00	AAPL	Stock	178.56	178.76	178.55	178.59	84135.0
2023-09-08 17:00:00	AAPL	Stock	178.62	178.69	178.18	178.54	66341.0
2023-09-08 17:30:00	AAPL	Stock	178.505	178.76	178.505	178.65	23556.0
2023-09-08 18:00:00	AAPL	Stock	178.68	178.86	178.68	178.77	13944.0
2023-09-08 18:30:00	AAPL	Stock	178.7622	178.8	178.7002	178.76	6642.0
2023-09-08 19:00:00	AAPL	Stock	178.7585	178.7585	178.66	178.72	12001.0
2023-09-08 19:30:00	AAPL	Stock	178.7	178.78	178.67	178.71	9775.0
2023-09-08 04:00:00	MSFT	Stock	331.9	331.9	330.1	330.1	1963.0
2023-09-08 04:30:00	MSFT	Stock	330.4	330.4	330.4	330.4	100.0
2023-09-08 05:00:00	MSFT	Stock	330.2	330.2	329.56	329.56	816.0
2023-09-08 05:30:00	MSFT	Stock	329.63	329.64	329.5	329.5	675.0
2023-09-08 06:00:00	MSFT	Stock	329.5	329.69	329.5	329.69	200.0
2023-09-08 06:30:00	MSFT	Stock	330.1	330.1	330.1	330.1	100.0
2023-09-08 07:00:00	MSFT	Stock	330.04	330.05	329.6	329.6	1145.0
2023-09-08 07:30:00	MSFT	Stock	329.48	329.48	329.08	329.48	694.0
2023-09-08 08:00:00	MSFT	Stock	330.1	331.37	329.13	330.05	5598.0
2023-09-08 08:30:00	MSFT	Stock	330.05	330.3173	329.8	329.8	6598.0
2023-09-08 09:00:00	MSFT	Stock	329.84	330.18	329.47	330.0	15170.0
2023-09-08 09:30:00	MSFT	Stock	330.09	334.55	329.46	333.5	1652694.0
2023-09-08 10:00:00	MSFT	Stock	333.55	335.95	333.299	335.47	1432896.0
2023-09-08 10:30:00	MSFT	Stock	335.47	335.93	333.91	334.01	924322.0
2023-09-08 11:00:00	MSFT	Stock	333.98	335.29	333.6803	335.09	763067.0
2023-09-08 11:30:00	MSFT	Stock	335.11	336.16	335.11	335.28	1139917.0
2023-09-08 12:00:00	MSFT	Stock	335.27	335.5	334.63	334.81	554506.0
2023-09-08 12:30:00	MSFT	Stock	334.84	334.915	333.92	334.8	453364.0

> showing 50 of 95,453 rows — these rows as CSV

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