PREVIEW / stock_30min / 2023-06-29

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-29.parquet
  size:    2.1 MB
  rows:    100,737
  symbols: 1,578

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-06-29 04:00:00	AAPL	Stock	189.25	189.52	189.13	189.5	6145.0
2023-06-29 04:30:00	AAPL	Stock	189.56	189.56	189.38	189.41	5845.0
2023-06-29 05:00:00	AAPL	Stock	189.53	189.53	189.4	189.4	5283.0
2023-06-29 05:30:00	AAPL	Stock	189.4	189.65	189.4	189.61	1085.0
2023-06-29 06:00:00	AAPL	Stock	189.69	189.81	189.51	189.78	4095.0
2023-06-29 06:30:00	AAPL	Stock	189.79	189.79	189.7	189.7	1683.0
2023-06-29 07:00:00	AAPL	Stock	189.65	189.85	189.6	189.82	19414.0
2023-06-29 07:30:00	AAPL	Stock	189.84	189.85	189.67	189.83	13486.0
2023-06-29 08:00:00	AAPL	Stock	189.7596	189.85	189.21	189.81	88596.0
2023-06-29 08:30:00	AAPL	Stock	189.81	189.91	189.25	189.35	144291.0
2023-06-29 09:00:00	AAPL	Stock	189.35	189.4247	188.78	189.07	179999.0
2023-06-29 09:30:00	AAPL	Stock	189.01	190.07	189.01	189.6993	7336508.0
2023-06-29 10:00:00	AAPL	Stock	189.7	189.975	189.06	189.47	3681099.0
2023-06-29 10:30:00	AAPL	Stock	189.46	189.57	188.94	189.33	2795437.0
2023-06-29 11:00:00	AAPL	Stock	189.34	189.9	189.26	189.89	2040240.0
2023-06-29 11:30:00	AAPL	Stock	189.89	189.91	189.63	189.78	1564313.0
2023-06-29 12:00:00	AAPL	Stock	189.78	189.9	189.21	189.675	1701154.0
2023-06-29 12:30:00	AAPL	Stock	189.67	189.72	189.19	189.345	954117.0
2023-06-29 13:00:00	AAPL	Stock	189.34	189.54	189.11	189.49	1432288.0
2023-06-29 13:30:00	AAPL	Stock	189.49	189.57	189.28	189.44	1201226.0
2023-06-29 14:00:00	AAPL	Stock	189.44	189.73	189.18	189.6506	1718424.0
2023-06-29 14:30:00	AAPL	Stock	189.66	189.79	189.54	189.7474	1351931.0
2023-06-29 15:00:00	AAPL	Stock	189.75	189.78	189.32	189.4776	1720879.0
2023-06-29 15:30:00	AAPL	Stock	189.47	189.62	189.17	189.6	4553640.0
2023-06-29 16:00:00	AAPL	Stock	189.6	190.45	189.57	190.14	4555021.0
2023-06-29 16:30:00	AAPL	Stock	190.14	190.18	189.59	189.97	139216.0
2023-06-29 17:00:00	AAPL	Stock	189.99	190.14	189.95	190.11	75980.0
2023-06-29 17:30:00	AAPL	Stock	190.06	190.06	189.81	189.81	47481.0
2023-06-29 18:00:00	AAPL	Stock	189.81	190.0	189.7	190.0	79460.0
2023-06-29 18:30:00	AAPL	Stock	189.99	190.19	189.99	190.18	24507.0
2023-06-29 19:00:00	AAPL	Stock	190.15	190.22	190.08	190.2	26274.0
2023-06-29 19:30:00	AAPL	Stock	190.16	190.35	190.1	190.3	94029.0
2023-06-29 04:00:00	MSFT	Stock	336.25	336.25	335.41	335.41	2141.0
2023-06-29 04:30:00	MSFT	Stock	335.37	335.4	334.74	335.36	2619.0
2023-06-29 05:00:00	MSFT	Stock	335.0	335.21	334.61	334.78	3876.0
2023-06-29 05:30:00	MSFT	Stock	334.58	335.01	334.21	334.91	1729.0
2023-06-29 06:00:00	MSFT	Stock	334.66	335.39	334.51	335.26	1304.0
2023-06-29 06:30:00	MSFT	Stock	335.61	335.7	335.5	335.7	1215.0
2023-06-29 07:00:00	MSFT	Stock	335.8	336.78	335.8	336.51	7867.0
2023-06-29 07:30:00	MSFT	Stock	336.49	336.5	335.91	336.38	4556.0
2023-06-29 08:00:00	MSFT	Stock	335.66	337.48	335.63	336.54	14842.0
2023-06-29 08:30:00	MSFT	Stock	336.48	336.81	334.8	335.16	19915.0
2023-06-29 09:00:00	MSFT	Stock	335.06	335.06	334.35	334.76	21048.0
2023-06-29 09:30:00	MSFT	Stock	334.7	335.95	333.71	334.765	1647849.0
2023-06-29 10:00:00	MSFT	Stock	334.76	335.41	333.01	333.35	937564.0
2023-06-29 10:30:00	MSFT	Stock	333.35	334.33	332.62	334.15	892287.0
2023-06-29 11:00:00	MSFT	Stock	334.17	335.88	334.17	335.71	887484.0
2023-06-29 11:30:00	MSFT	Stock	335.7	336.11	335.13	335.29	582040.0
2023-06-29 12:00:00	MSFT	Stock	335.305	335.89	334.32	335.23	535417.0
2023-06-29 12:30:00	MSFT	Stock	335.22	335.31	333.78	334.09	422897.0

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

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