PREVIEW / stock_30min / 2024-06-07

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-06-07.parquet
  size:    2.1 MB
  rows:    98,877
  symbols: 963

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
2024-06-07 04:00:00	AAPL	Stock	195.02	195.03	194.7	194.81	9268.0
2024-06-07 04:30:00	AAPL	Stock	194.9	194.9	194.73	194.73	2388.0
2024-06-07 05:00:00	AAPL	Stock	194.7	194.78	194.7	194.78	527.0
2024-06-07 05:30:00	AAPL	Stock	194.91	194.92	194.89	194.89	1131.0
2024-06-07 06:00:00	AAPL	Stock	194.88	194.9	194.84	194.89	1175.0
2024-06-07 06:30:00	AAPL	Stock	194.89	194.94	194.87	194.9	1484.0
2024-06-07 07:00:00	AAPL	Stock	194.97	195.05	194.73	194.84	23248.0
2024-06-07 07:30:00	AAPL	Stock	194.88	195.12	194.88	195.12	7995.0
2024-06-07 08:00:00	AAPL	Stock	195.0	195.2999	194.74	195.16	64077.0
2024-06-07 08:30:00	AAPL	Stock	195.22	195.51	193.45	193.72	363035.0
2024-06-07 09:00:00	AAPL	Stock	193.65	195.0	193.6	194.9082	145447.0
2024-06-07 09:30:00	AAPL	Stock	194.65	195.75	194.14	194.68	5047699.0
2024-06-07 10:00:00	AAPL	Stock	194.69	195.19	194.58	194.805	2645615.0
2024-06-07 10:30:00	AAPL	Stock	194.805	195.97	194.74	195.63	2771108.0
2024-06-07 11:00:00	AAPL	Stock	195.64	195.64	194.91	195.62	2490730.0
2024-06-07 11:30:00	AAPL	Stock	195.625	195.94	195.6	195.85	2392524.0
2024-06-07 12:00:00	AAPL	Stock	195.86	196.185	195.63	195.955	2539214.0
2024-06-07 12:30:00	AAPL	Stock	195.96	196.41	195.71	196.32	1947104.0
2024-06-07 13:00:00	AAPL	Stock	196.32	196.49	195.96	196.36	1805937.0
2024-06-07 13:30:00	AAPL	Stock	196.36	196.58	196.17	196.505	1736868.0
2024-06-07 14:00:00	AAPL	Stock	196.5	196.52	195.72	195.87	3016467.0
2024-06-07 14:30:00	AAPL	Stock	195.86	195.92	195.58	195.86	1389616.0
2024-06-07 15:00:00	AAPL	Stock	195.87	196.44	195.77	196.4395	2214245.0
2024-06-07 15:30:00	AAPL	Stock	196.435	196.94	196.23	196.9	6499359.0
2024-06-07 16:00:00	AAPL	Stock	196.86	196.94	196.7703	196.85	5496210.0
2024-06-07 16:30:00	AAPL	Stock	196.84	196.95	196.8	196.95	172850.0
2024-06-07 17:00:00	AAPL	Stock	196.9501	196.97	196.88	196.94	49111.0
2024-06-07 17:30:00	AAPL	Stock	196.9394	196.94	196.53	196.74	27274.0
2024-06-07 18:00:00	AAPL	Stock	196.8266	196.8266	196.7	196.75	9162.0
2024-06-07 18:30:00	AAPL	Stock	196.7338	196.8	196.6569	196.78	10860.0
2024-06-07 19:00:00	AAPL	Stock	196.79	196.79	196.7	196.75	13620.0
2024-06-07 19:30:00	AAPL	Stock	196.7	196.9	196.7	196.9	15503.0
2024-06-07 04:00:00	MSFT	Stock	424.89	424.89	424.43	424.43	889.0
2024-06-07 04:30:00	MSFT	Stock	424.16	424.17	424.0	424.0	400.0
2024-06-07 05:00:00	MSFT	Stock	423.96	424.04	423.96	424.04	329.0
2024-06-07 05:30:00	MSFT	Stock	424.21	424.23	424.2	424.23	364.0
2024-06-07 06:00:00	MSFT	Stock	424.24	424.28	424.24	424.28	300.0
2024-06-07 06:30:00	MSFT	Stock	424.33	424.33	424.1	424.1	425.0
2024-06-07 07:00:00	MSFT	Stock	424.38	424.39	424.14	424.14	1103.0
2024-06-07 07:30:00	MSFT	Stock	424.53	425.11	424.53	425.0	2099.0
2024-06-07 08:00:00	MSFT	Stock	424.4	425.4903	424.03	425.4435	16004.0
2024-06-07 08:30:00	MSFT	Stock	425.5	426.25	423.05	424.2	21885.0
2024-06-07 09:00:00	MSFT	Stock	424.29	426.0	423.8	426.0	18175.0
2024-06-07 09:30:00	MSFT	Stock	426.2	426.2	423.77	425.08	1092437.0
2024-06-07 10:00:00	MSFT	Stock	425.06	425.22	423.935	424.1	363714.0
2024-06-07 10:30:00	MSFT	Stock	424.04	425.88	423.72	425.06	489122.0
2024-06-07 11:00:00	MSFT	Stock	425.1	425.1	423.66	425.0	347223.0
2024-06-07 11:30:00	MSFT	Stock	425.0	425.53	424.57	425.21	347836.0
2024-06-07 12:00:00	MSFT	Stock	425.19	425.42	424.8005	425.26	267989.0
2024-06-07 12:30:00	MSFT	Stock	425.27	426.16	424.55	425.9401	321387.0

> showing 50 of 98,877 rows — these rows as CSV

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