PREVIEW / stock_30min / 2023-06-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-07.parquet
  size:    2.1 MB
  rows:    102,387
  symbols: 1,617

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-07 04:00:00	AAPL	Stock	179.07	179.07	178.69	178.8	7212.0
2023-06-07 04:30:00	AAPL	Stock	178.76	178.84	178.75	178.75	2116.0
2023-06-07 05:00:00	AAPL	Stock	178.75	178.79	178.75	178.79	2124.0
2023-06-07 05:30:00	AAPL	Stock	178.86	178.98	178.86	178.98	1908.0
2023-06-07 06:00:00	AAPL	Stock	179.0	179.2	178.99	179.14	4356.0
2023-06-07 06:30:00	AAPL	Stock	179.08	179.08	178.2	178.81	18143.0
2023-06-07 07:00:00	AAPL	Stock	178.81	179.15	178.58	178.65	46426.0
2023-06-07 07:30:00	AAPL	Stock	178.65	179.06	178.65	179.06	27714.0
2023-06-07 08:00:00	AAPL	Stock	178.87	179.1999	178.5801	179.13	117431.0
2023-06-07 08:30:00	AAPL	Stock	179.11	179.15	178.75	178.85	77580.0
2023-06-07 09:00:00	AAPL	Stock	178.93	179.0	178.15	178.37	182408.0
2023-06-07 09:30:00	AAPL	Stock	178.44	181.21	178.22	180.425	7772727.0
2023-06-07 10:00:00	AAPL	Stock	180.42	180.64	178.91	179.28	4530277.0
2023-06-07 10:30:00	AAPL	Stock	179.28	179.52	178.49	178.73	3473254.0
2023-06-07 11:00:00	AAPL	Stock	178.71	179.37	178.57	178.975	2590745.0
2023-06-07 11:30:00	AAPL	Stock	178.975	179.61	178.81	178.88	2508930.0
2023-06-07 12:00:00	AAPL	Stock	178.909	179.05	178.18	178.37	1982382.0
2023-06-07 12:30:00	AAPL	Stock	178.37	178.72	178.0	178.1182	1967876.0
2023-06-07 13:00:00	AAPL	Stock	178.12	178.47	177.61	177.69	2561406.0
2023-06-07 13:30:00	AAPL	Stock	177.7	177.88	177.32	177.8	2028469.0
2023-06-07 14:00:00	AAPL	Stock	177.795	178.285	177.795	178.03	1797042.0
2023-06-07 14:30:00	AAPL	Stock	178.03	178.25	177.6	178.245	1672165.0
2023-06-07 15:00:00	AAPL	Stock	178.24	178.5	177.97	178.065	2265671.0
2023-06-07 15:30:00	AAPL	Stock	178.06	178.2	177.4239	177.83	6710760.0
2023-06-07 16:00:00	AAPL	Stock	177.83	177.92	177.71	177.75	8004639.0
2023-06-07 16:30:00	AAPL	Stock	177.7579	177.82	177.68	177.78	38445.0
2023-06-07 17:00:00	AAPL	Stock	177.77	177.82	177.64	177.7998	52834.0
2023-06-07 17:30:00	AAPL	Stock	177.76	177.8	177.71	177.75	14692.0
2023-06-07 18:00:00	AAPL	Stock	177.75	177.87	177.7101	177.83	10193.0
2023-06-07 18:30:00	AAPL	Stock	177.8	177.82	177.69	177.73	10064.0
2023-06-07 19:00:00	AAPL	Stock	177.76	177.81	177.74	177.7601	5616.0
2023-06-07 19:30:00	AAPL	Stock	177.78	177.92	177.7	177.92	15272.0
2023-06-07 04:00:00	MSFT	Stock	333.17	333.17	331.62	331.62	682.0
2023-06-07 04:30:00	MSFT	Stock	331.88	332.23	331.88	332.05	636.0
2023-06-07 05:00:00	MSFT	Stock	332.05	333.1	331.75	332.96	8034.0
2023-06-07 05:30:00	MSFT	Stock	332.6	332.6	332.2	332.2	1134.0
2023-06-07 06:00:00	MSFT	Stock	332.5	332.9	332.5	332.72	3577.0
2023-06-07 06:30:00	MSFT	Stock	332.93	333.0	332.67	332.75	2758.0
2023-06-07 07:00:00	MSFT	Stock	332.89	333.02	332.42	332.5	5134.0
2023-06-07 07:30:00	MSFT	Stock	332.58	333.2	332.58	333.19	6462.0
2023-06-07 08:00:00	MSFT	Stock	332.84	333.26	332.42	332.68	19094.0
2023-06-07 08:30:00	MSFT	Stock	332.68	333.0	332.54	332.62	16393.0
2023-06-07 09:00:00	MSFT	Stock	332.95	333.05	330.85	331.61	60758.0
2023-06-07 09:30:00	MSFT	Stock	331.65	334.49	330.46	330.655	2848588.0
2023-06-07 10:00:00	MSFT	Stock	330.67	330.69	327.58	328.8699	3195699.0
2023-06-07 10:30:00	MSFT	Stock	328.84	329.04	325.745	326.8	2473610.0
2023-06-07 11:00:00	MSFT	Stock	326.8	327.57	325.539	326.14	1744178.0
2023-06-07 11:30:00	MSFT	Stock	326.13	326.6	325.03	325.08	1564062.0
2023-06-07 12:00:00	MSFT	Stock	325.09	325.74	324.01	324.385	1677214.0
2023-06-07 12:30:00	MSFT	Stock	324.4	325.0	323.89	324.19	1456377.0

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

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