PREVIEW / stock_30min / 2023-06-21

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-21.parquet
  size:    2.1 MB
  rows:    100,651
  symbols: 1,604

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-21 04:00:00	AAPL	Stock	184.75	184.82	184.7	184.75	3708.0
2023-06-21 04:30:00	AAPL	Stock	184.77	184.83	184.71	184.71	2193.0
2023-06-21 05:00:00	AAPL	Stock	184.79	184.79	184.7	184.7	1006.0
2023-06-21 05:30:00	AAPL	Stock	184.8	184.8	184.8	184.8	100.0
2023-06-21 06:00:00	AAPL	Stock	184.7	184.7	184.7	184.7	145.0
2023-06-21 06:30:00	AAPL	Stock	184.73	184.78	184.71	184.72	2883.0
2023-06-21 07:00:00	AAPL	Stock	184.81	184.88	184.62	184.62	23687.0
2023-06-21 07:30:00	AAPL	Stock	184.63	184.75	184.5	184.7	11429.0
2023-06-21 08:00:00	AAPL	Stock	184.7015	185.1	183.93	184.22	141958.0
2023-06-21 08:30:00	AAPL	Stock	184.22	184.47	184.12	184.32	103153.0
2023-06-21 09:00:00	AAPL	Stock	184.34	184.97	184.16	184.9	110513.0
2023-06-21 09:30:00	AAPL	Stock	184.9	185.41	183.88	184.11	5484306.0
2023-06-21 10:00:00	AAPL	Stock	184.1	184.41	183.87	184.12	2820314.0
2023-06-21 10:30:00	AAPL	Stock	184.11	184.14	183.2	183.495	2994641.0
2023-06-21 11:00:00	AAPL	Stock	183.5	183.65	182.5901	183.14	3216628.0
2023-06-21 11:30:00	AAPL	Stock	183.13	183.82	183.085	183.26	1953002.0
2023-06-21 12:00:00	AAPL	Stock	183.2531	184.08	183.14	184.065	1894877.0
2023-06-21 12:30:00	AAPL	Stock	184.07	184.34	183.87	184.24	1840152.0
2023-06-21 13:00:00	AAPL	Stock	184.23	184.27	183.97	184.13	1130029.0
2023-06-21 13:30:00	AAPL	Stock	184.1103	184.65	184.11	184.585	1369609.0
2023-06-21 14:00:00	AAPL	Stock	184.595	185.11	184.43	185.1	1698597.0
2023-06-21 14:30:00	AAPL	Stock	185.1	185.1992	184.755	184.9	1522193.0
2023-06-21 15:00:00	AAPL	Stock	184.905	184.91	184.37	184.505	1718823.0
2023-06-21 15:30:00	AAPL	Stock	184.5	184.54	183.79	183.96	3737661.0
2023-06-21 16:00:00	AAPL	Stock	183.95	184.05	183.72	183.72	9965716.0
2023-06-21 16:30:00	AAPL	Stock	183.71	183.96	183.7	183.7815	54210.0
2023-06-21 17:00:00	AAPL	Stock	183.7811	183.96	183.75	183.75	27176.0
2023-06-21 17:30:00	AAPL	Stock	183.77	183.7852	183.7	183.7	12495.0
2023-06-21 18:00:00	AAPL	Stock	183.76	183.85	183.6359	183.69	10382.0
2023-06-21 18:30:00	AAPL	Stock	183.67	183.79	183.66	183.71	12202.0
2023-06-21 19:00:00	AAPL	Stock	183.7	183.85	183.7	183.75	5538.0
2023-06-21 19:30:00	AAPL	Stock	183.7101	183.79	183.65	183.67	5572.0
2023-06-21 04:00:00	MSFT	Stock	337.49	337.54	337.3	337.45	1179.0
2023-06-21 04:30:00	MSFT	Stock	337.6	337.6	337.53	337.53	640.0
2023-06-21 05:00:00	MSFT	Stock	337.29	337.29	337.29	337.29	117.0
2023-06-21 05:30:00	MSFT	Stock	337.49	337.49	337.49	337.49	100.0
2023-06-21 06:00:00	MSFT	Stock	337.29	337.29	337.03	337.16	1725.0
2023-06-21 06:30:00	MSFT	Stock	337.36	337.36	337.06	337.06	3051.0
2023-06-21 07:00:00	MSFT	Stock	337.49	337.49	336.63	336.8	7405.0
2023-06-21 07:30:00	MSFT	Stock	336.72	336.72	336.26	336.6	4675.0
2023-06-21 08:00:00	MSFT	Stock	336.7	338.5	336.26	336.8173	12219.0
2023-06-21 08:30:00	MSFT	Stock	336.5	337.0	336.0101	336.66	14204.0
2023-06-21 09:00:00	MSFT	Stock	336.69	336.9099	335.97	336.18	17914.0
2023-06-21 09:30:00	MSFT	Stock	336.29	337.73	334.32	335.17	2097127.0
2023-06-21 10:00:00	MSFT	Stock	335.14	335.34	333.63	334.32	1206769.0
2023-06-21 10:30:00	MSFT	Stock	334.33	334.826	333.07	334.042	1222571.0
2023-06-21 11:00:00	MSFT	Stock	334.04	334.15	332.07	332.9801	1092836.0
2023-06-21 11:30:00	MSFT	Stock	332.98	333.73	332.3	332.4291	856232.0
2023-06-21 12:00:00	MSFT	Stock	332.49	334.48	332.33	333.69	926776.0
2023-06-21 12:30:00	MSFT	Stock	333.66	334.57	333.48	334.23	540275.0

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

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