PREVIEW / stock_30min / 2023-10-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-09.parquet
  size:    2.0 MB
  rows:    95,263
  symbols: 1,360

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-10-09 04:00:00	AAPL	Stock	176.0	176.3	175.73	175.8	13639.0
2023-10-09 04:30:00	AAPL	Stock	175.81	176.18	175.81	176.18	8028.0
2023-10-09 05:00:00	AAPL	Stock	176.1	176.17	176.04	176.11	3838.0
2023-10-09 05:30:00	AAPL	Stock	176.01	176.01	175.84	175.88	6550.0
2023-10-09 06:00:00	AAPL	Stock	175.99	176.35	175.99	176.16	12187.0
2023-10-09 06:30:00	AAPL	Stock	176.18	176.21	176.0	176.0	16561.0
2023-10-09 07:00:00	AAPL	Stock	175.98	176.08	175.85	175.99	38605.0
2023-10-09 07:30:00	AAPL	Stock	175.99	176.03	175.85	176.01	11379.0
2023-10-09 08:00:00	AAPL	Stock	175.94	176.4	175.5	176.24	113558.0
2023-10-09 08:30:00	AAPL	Stock	176.22	176.4899	176.09	176.3387	82175.0
2023-10-09 09:00:00	AAPL	Stock	176.35	177.14	176.35	176.8	131799.0
2023-10-09 09:30:00	AAPL	Stock	176.8	177.299	175.8	177.18	4624240.0
2023-10-09 10:00:00	AAPL	Stock	177.18	177.36	176.3121	176.87	2812314.0
2023-10-09 10:30:00	AAPL	Stock	176.87	176.98	176.2006	176.37	1960163.0
2023-10-09 11:00:00	AAPL	Stock	176.365	177.125	176.19	177.085	2035659.0
2023-10-09 11:30:00	AAPL	Stock	177.075	177.23	176.87	177.195	1729084.0
2023-10-09 12:00:00	AAPL	Stock	177.2	178.07	177.18	177.61	2456888.0
2023-10-09 12:30:00	AAPL	Stock	177.6	177.77	177.435	177.6	1243326.0
2023-10-09 13:00:00	AAPL	Stock	177.61	177.97	177.56	177.95	1030184.0
2023-10-09 13:30:00	AAPL	Stock	177.96	178.79	177.94	178.72	2620210.0
2023-10-09 14:00:00	AAPL	Stock	178.72	178.97	178.5803	178.84	2068248.0
2023-10-09 14:30:00	AAPL	Stock	178.845	179.04	178.42	178.8879	2306320.0
2023-10-09 15:00:00	AAPL	Stock	178.89	179.05	178.665	178.9	2102137.0
2023-10-09 15:30:00	AAPL	Stock	178.9	179.05	178.665	179.0	4014559.0
2023-10-09 16:00:00	AAPL	Stock	178.99	179.01	178.83	178.9	4470824.0
2023-10-09 16:30:00	AAPL	Stock	178.9	178.99	178.81	178.87	54302.0
2023-10-09 17:00:00	AAPL	Stock	178.84	178.9	178.84	178.9	4055.0
2023-10-09 17:30:00	AAPL	Stock	178.88	178.88	178.81	178.82	6750.0
2023-10-09 18:00:00	AAPL	Stock	178.87	178.87	178.79	178.85	8800.0
2023-10-09 18:30:00	AAPL	Stock	178.86	178.89	178.8	178.85	8625.0
2023-10-09 19:00:00	AAPL	Stock	178.85	178.95	178.82	178.85	5254.0
2023-10-09 19:30:00	AAPL	Stock	178.88	179.0	178.86	178.88	15716.0
2023-10-09 04:00:00	MSFT	Stock	324.0	326.07	324.0	325.5	7996.0
2023-10-09 04:30:00	MSFT	Stock	325.03	326.6	325.03	326.52	2380.0
2023-10-09 05:00:00	MSFT	Stock	326.46	326.49	325.61	326.27	2349.0
2023-10-09 05:30:00	MSFT	Stock	326.29	326.29	325.9	325.9	524.0
2023-10-09 06:00:00	MSFT	Stock	325.9	326.1	325.58	326.1	3035.0
2023-10-09 06:30:00	MSFT	Stock	325.95	326.33	325.95	326.33	3956.0
2023-10-09 07:00:00	MSFT	Stock	326.33	326.4	325.11	325.11	22119.0
2023-10-09 07:30:00	MSFT	Stock	325.2	325.4	324.85	325.03	16271.0
2023-10-09 08:00:00	MSFT	Stock	326.21	326.4166	323.77	325.74	55476.0
2023-10-09 08:30:00	MSFT	Stock	325.99	325.99	324.62	325.11	18290.0
2023-10-09 09:00:00	MSFT	Stock	325.1077	325.99	324.47	324.75	58388.0
2023-10-09 09:30:00	MSFT	Stock	324.75	327.37	323.18	327.0111	2593998.0
2023-10-09 10:00:00	MSFT	Stock	326.995	327.96	325.68	326.6221	1417106.0
2023-10-09 10:30:00	MSFT	Stock	326.63	327.1	325.8	326.17	756276.0
2023-10-09 11:00:00	MSFT	Stock	326.13	326.97	325.388	326.845	525621.0
2023-10-09 11:30:00	MSFT	Stock	326.84	327.605	326.83	327.47	490735.0
2023-10-09 12:00:00	MSFT	Stock	327.475	328.46	327.19	327.82	832805.0
2023-10-09 12:30:00	MSFT	Stock	327.825	328.31	327.55	327.885	435881.0

> showing 50 of 95,263 rows — these rows as CSV

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