PREVIEW / stock_30min / 2024-06-27

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-06-27.parquet
  size:    2.0 MB
  rows:    97,682
  symbols: 915

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-27 04:00:00	AAPL	Stock	213.08	213.23	212.8	212.8	2461.0
2024-06-27 04:30:00	AAPL	Stock	212.88	213.12	212.88	213.1	2248.0
2024-06-27 05:00:00	AAPL	Stock	213.19	214.2	213.19	214.07	14250.0
2024-06-27 05:30:00	AAPL	Stock	214.07	214.11	213.8	213.8	2811.0
2024-06-27 06:00:00	AAPL	Stock	213.84	214.34	213.84	214.28	9436.0
2024-06-27 06:30:00	AAPL	Stock	214.17	214.21	213.95	213.99	1500.0
2024-06-27 07:00:00	AAPL	Stock	214.06	214.11	213.78	214.0	25148.0
2024-06-27 07:30:00	AAPL	Stock	214.0	214.33	213.97	214.16	9957.0
2024-06-27 08:00:00	AAPL	Stock	213.92	214.33	213.0	214.0	104088.0
2024-06-27 08:30:00	AAPL	Stock	214.04	214.49	214.04	214.41	51426.0
2024-06-27 09:00:00	AAPL	Stock	214.4195	214.83	214.12	214.83	134810.0
2024-06-27 09:30:00	AAPL	Stock	214.7	215.7395	213.74	214.41	8068175.0
2024-06-27 10:00:00	AAPL	Stock	214.42	214.85	213.39	213.81	3516041.0
2024-06-27 10:30:00	AAPL	Stock	213.81	213.96	212.35	213.28	3320877.0
2024-06-27 11:00:00	AAPL	Stock	213.275	213.68	212.79	212.9705	2056859.0
2024-06-27 11:30:00	AAPL	Stock	212.97	213.47	212.57	213.205	1774401.0
2024-06-27 12:00:00	AAPL	Stock	213.2	213.86	213.05	213.855	1564737.0
2024-06-27 12:30:00	AAPL	Stock	213.8514	214.19	213.62	213.67	1553869.0
2024-06-27 13:00:00	AAPL	Stock	213.67	214.064	213.56	214.0	1162310.0
2024-06-27 13:30:00	AAPL	Stock	213.994	214.07	213.62	213.635	1053487.0
2024-06-27 14:00:00	AAPL	Stock	213.635	213.645	213.05	213.42	1431163.0
2024-06-27 14:30:00	AAPL	Stock	213.42	213.785	213.27	213.74	980540.0
2024-06-27 15:00:00	AAPL	Stock	213.75	214.02	213.65	213.8289	1322229.0
2024-06-27 15:30:00	AAPL	Stock	213.83	214.12	213.14	214.11	4177380.0
2024-06-27 16:00:00	AAPL	Stock	214.07	214.5	213.58	214.33	7195844.0
2024-06-27 16:30:00	AAPL	Stock	214.31	214.31	214.1	214.15	24530.0
2024-06-27 17:00:00	AAPL	Stock	214.15	214.27	214.15	214.23	6513.0
2024-06-27 17:30:00	AAPL	Stock	214.27	214.28	214.0	214.19	8100.0
2024-06-27 18:00:00	AAPL	Stock	214.1201	214.39	214.12	214.29	10167.0
2024-06-27 18:30:00	AAPL	Stock	214.39	214.5	214.26	214.47	16443.0
2024-06-27 19:00:00	AAPL	Stock	214.4666	214.4666	214.4	214.46	10306.0
2024-06-27 19:30:00	AAPL	Stock	214.47	214.51	214.4	214.45	13252.0
2024-06-27 04:00:00	MSFT	Stock	451.52	451.72	451.51	451.62	898.0
2024-06-27 04:30:00	MSFT	Stock	451.53	451.63	451.53	451.63	598.0
2024-06-27 05:00:00	MSFT	Stock	451.6	451.6	451.6	451.6	292.0
2024-06-27 05:30:00	MSFT	Stock	452.0	452.0	452.0	452.0	298.0
2024-06-27 06:00:00	MSFT	Stock	452.16	452.16	452.16	452.16	209.0
2024-06-27 06:30:00	MSFT	Stock	452.39	452.39	452.22	452.22	339.0
2024-06-27 07:00:00	MSFT	Stock	452.2	452.25	451.92	452.25	3261.0
2024-06-27 07:30:00	MSFT	Stock	452.2	452.2	451.69	451.84	1998.0
2024-06-27 08:00:00	MSFT	Stock	451.9319	452.39	451.6501	451.71	7478.0
2024-06-27 08:30:00	MSFT	Stock	451.85	452.5	451.85	452.5	7245.0
2024-06-27 09:00:00	MSFT	Stock	452.3	452.5	452.0115	452.0115	6134.0
2024-06-27 09:30:00	MSFT	Stock	452.02	455.761	451.77	454.895	1359502.0
2024-06-27 10:00:00	MSFT	Stock	454.85	456.17	454.52	456.05	756453.0
2024-06-27 10:30:00	MSFT	Stock	456.07	456.07	454.45	455.32	557203.0
2024-06-27 11:00:00	MSFT	Stock	455.31	455.7	454.268	454.68	316623.0
2024-06-27 11:30:00	MSFT	Stock	454.68	454.68	452.87	453.7351	434230.0
2024-06-27 12:00:00	MSFT	Stock	453.65	454.66	453.63	454.14	315703.0
2024-06-27 12:30:00	MSFT	Stock	454.15	454.2	453.66	453.895	221063.0

> showing 50 of 97,682 rows — these rows as CSV

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