PREVIEW / stock_30min / 2023-08-02

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-02.parquet
  size:    2.1 MB
  rows:    102,928
  symbols: 1,504

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-02 04:00:00	AAPL	Stock	193.56	194.09	193.28	193.45	24378.0
2023-08-02 04:30:00	AAPL	Stock	193.46	193.49	193.12	193.49	26587.0
2023-08-02 05:00:00	AAPL	Stock	193.52	194.1	193.5	193.75	17457.0
2023-08-02 05:30:00	AAPL	Stock	193.59	193.82	193.55	193.82	4510.0
2023-08-02 06:00:00	AAPL	Stock	193.9	194.03	193.76	194.0	24048.0
2023-08-02 06:30:00	AAPL	Stock	194.0	194.75	193.9	194.55	46346.0
2023-08-02 07:00:00	AAPL	Stock	194.6	194.95	194.53	194.86	49901.0
2023-08-02 07:30:00	AAPL	Stock	194.83	194.95	194.66	194.74	30717.0
2023-08-02 08:00:00	AAPL	Stock	194.7899	194.98	193.825	194.68	70949.0
2023-08-02 08:30:00	AAPL	Stock	194.66	194.86	194.45	194.69	104875.0
2023-08-02 09:00:00	AAPL	Stock	194.64	195.08	194.36	195.08	121255.0
2023-08-02 09:30:00	AAPL	Stock	195.04	195.18	193.37	194.0	5128800.0
2023-08-02 10:00:00	AAPL	Stock	194.0	194.27	192.95	193.2782	2979475.0
2023-08-02 10:30:00	AAPL	Stock	193.27	193.31	192.75	192.8001	2225449.0
2023-08-02 11:00:00	AAPL	Stock	192.8	193.13	192.52	193.01	2280074.0
2023-08-02 11:30:00	AAPL	Stock	193.0049	193.2712	192.58	192.58	1957529.0
2023-08-02 12:00:00	AAPL	Stock	192.588	192.63	191.8507	191.93	2663983.0
2023-08-02 12:30:00	AAPL	Stock	191.9326	192.84	191.86	192.84	1860639.0
2023-08-02 13:00:00	AAPL	Stock	192.83	193.12	192.69	192.99	1425930.0
2023-08-02 13:30:00	AAPL	Stock	192.99	193.25	192.71	192.8301	1166261.0
2023-08-02 14:00:00	AAPL	Stock	192.84	193.26	192.78	192.97	1225414.0
2023-08-02 14:30:00	AAPL	Stock	192.97	193.03	192.59	192.77	1287358.0
2023-08-02 15:00:00	AAPL	Stock	192.765	192.9489	192.2501	192.3	2005563.0
2023-08-02 15:30:00	AAPL	Stock	192.3	192.98	192.22	192.59	5037918.0
2023-08-02 16:00:00	AAPL	Stock	192.59	192.68	192.11	192.25	7373104.0
2023-08-02 16:30:00	AAPL	Stock	192.28	192.58	192.06	192.32	158131.0
2023-08-02 17:00:00	AAPL	Stock	192.32	192.58	192.03	192.2	489711.0
2023-08-02 17:30:00	AAPL	Stock	192.17	192.58	192.15	192.25	47565.0
2023-08-02 18:00:00	AAPL	Stock	192.28	192.9	192.28	192.8652	50009.0
2023-08-02 18:30:00	AAPL	Stock	192.81	192.88	192.6	192.88	23186.0
2023-08-02 19:00:00	AAPL	Stock	192.9	192.97	192.71	192.75	22528.0
2023-08-02 19:30:00	AAPL	Stock	192.7699	192.9	192.66	192.81	35806.0
2023-08-02 04:00:00	MSFT	Stock	332.0	332.35	331.3	331.75	7801.0
2023-08-02 04:30:00	MSFT	Stock	331.61	331.76	331.0	331.7	4710.0
2023-08-02 05:00:00	MSFT	Stock	332.05	332.65	332.0	332.31	2255.0
2023-08-02 05:30:00	MSFT	Stock	332.2	332.47	332.0	332.37	2816.0
2023-08-02 06:00:00	MSFT	Stock	332.47	332.9	332.47	332.8	2487.0
2023-08-02 06:30:00	MSFT	Stock	332.8	333.9	332.8	333.9	8131.0
2023-08-02 07:00:00	MSFT	Stock	333.85	334.4	333.85	334.29	10130.0
2023-08-02 07:30:00	MSFT	Stock	334.4	334.41	333.65	333.7	9065.0
2023-08-02 08:00:00	MSFT	Stock	333.73	334.4	333.2	333.2501	26168.0
2023-08-02 08:30:00	MSFT	Stock	333.2604	333.77	332.98	333.33	22947.0
2023-08-02 09:00:00	MSFT	Stock	333.3	334.21	332.86	333.55	21043.0
2023-08-02 09:30:00	MSFT	Stock	333.63	333.63	331.0901	331.45	2259322.0
2023-08-02 10:00:00	MSFT	Stock	331.45	331.67	329.61	330.07	1834474.0
2023-08-02 10:30:00	MSFT	Stock	330.05	330.69	328.92	329.17	1229033.0
2023-08-02 11:00:00	MSFT	Stock	329.14	330.47	328.7119	329.24	1110875.0
2023-08-02 11:30:00	MSFT	Stock	329.2405	329.77	328.05	328.05	1182089.0
2023-08-02 12:00:00	MSFT	Stock	328.045	328.2293	326.3551	326.672	1744182.0
2023-08-02 12:30:00	MSFT	Stock	326.6838	328.418	326.44	328.12	961593.0

> showing 50 of 102,928 rows — these rows as CSV

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