PREVIEW / stock_30min / 2023-01-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-06.parquet
  size:    2.1 MB
  rows:    102,612
  symbols: 1,969

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-01-06 04:00:00	AAPL	Stock	125.52	125.52	124.64	124.8	26981.0
2023-01-06 04:30:00	AAPL	Stock	124.73	124.96	124.73	124.96	10936.0
2023-01-06 05:00:00	AAPL	Stock	124.96	125.13	124.92	125.12	8833.0
2023-01-06 05:30:00	AAPL	Stock	125.13	125.22	124.86	124.86	12407.0
2023-01-06 06:00:00	AAPL	Stock	124.85	125.16	124.84	125.16	3010.0
2023-01-06 06:30:00	AAPL	Stock	125.1	125.1	124.8	124.91	6718.0
2023-01-06 07:00:00	AAPL	Stock	124.91	124.98	124.77	124.95	24486.0
2023-01-06 07:30:00	AAPL	Stock	124.94	125.08	124.84	124.9	50363.0
2023-01-06 08:00:00	AAPL	Stock	124.86	125.79	124.4	124.6	229926.0
2023-01-06 08:30:00	AAPL	Stock	124.6	126.75	124.59	126.4	723580.0
2023-01-06 09:00:00	AAPL	Stock	126.39	126.52	125.6935	125.99	395964.0
2023-01-06 09:30:00	AAPL	Stock	126.0	127.19	124.89	125.8	9847565.0
2023-01-06 10:00:00	AAPL	Stock	125.8	127.35	125.8	126.375	7034302.0
2023-01-06 10:30:00	AAPL	Stock	126.375	127.51	126.3401	127.41	4747819.0
2023-01-06 11:00:00	AAPL	Stock	127.445	128.04	127.16	127.245	4522280.0
2023-01-06 11:30:00	AAPL	Stock	127.25	128.02	127.01	127.88	4215660.0
2023-01-06 12:00:00	AAPL	Stock	127.8899	128.48	127.88	128.3299	3582886.0
2023-01-06 12:30:00	AAPL	Stock	128.3217	128.39	127.78	127.96	2737392.0
2023-01-06 13:00:00	AAPL	Stock	127.96	128.4	127.89	128.25	2464235.0
2023-01-06 13:30:00	AAPL	Stock	128.24	128.88	128.24	128.845	2922220.0
2023-01-06 14:00:00	AAPL	Stock	128.85	129.55	128.7833	129.335	4220177.0
2023-01-06 14:30:00	AAPL	Stock	129.34	129.99	129.305	129.8491	4261125.0
2023-01-06 15:00:00	AAPL	Stock	129.85	130.29	129.7	129.81	5085955.0
2023-01-06 15:30:00	AAPL	Stock	129.815	130.05	129.34	129.5	8879658.0
2023-01-06 16:00:00	AAPL	Stock	129.49	129.66	129.18	129.28	10288285.0
2023-01-06 16:30:00	AAPL	Stock	129.27	129.62	129.22	129.341	113166.0
2023-01-06 17:00:00	AAPL	Stock	129.32	129.35	129.24	129.32	21170.0
2023-01-06 17:30:00	AAPL	Stock	129.32	129.3499	129.26	129.32	17506.0
2023-01-06 18:00:00	AAPL	Stock	129.29	129.36	129.29	129.36	11330.0
2023-01-06 18:30:00	AAPL	Stock	129.32	129.38	129.31	129.35	11066.0
2023-01-06 19:00:00	AAPL	Stock	129.37	129.38	129.35	129.35	7771.0
2023-01-06 19:30:00	AAPL	Stock	129.37	129.37	129.26	129.26	27645.0
2023-01-06 04:00:00	MSFT	Stock	222.47	222.55	221.7	221.7	7730.0
2023-01-06 04:30:00	MSFT	Stock	221.61	221.61	221.34	221.59	2844.0
2023-01-06 05:00:00	MSFT	Stock	221.85	222.2	221.68	222.01	1845.0
2023-01-06 05:30:00	MSFT	Stock	222.0	222.1	222.0	222.1	700.0
2023-01-06 06:00:00	MSFT	Stock	221.99	222.0	221.97	222.0	2124.0
2023-01-06 06:30:00	MSFT	Stock	221.9	221.92	221.71	221.8	1235.0
2023-01-06 07:00:00	MSFT	Stock	221.93	221.93	221.41	221.9	4291.0
2023-01-06 07:30:00	MSFT	Stock	221.98	222.28	221.92	222.23	11294.0
2023-01-06 08:00:00	MSFT	Stock	221.71	223.0	221.4	221.8	52192.0
2023-01-06 08:30:00	MSFT	Stock	221.95	225.99	221.95	225.25	233022.0
2023-01-06 09:00:00	MSFT	Stock	225.15	225.31	222.44	222.81	113068.0
2023-01-06 09:30:00	MSFT	Stock	223.0	223.65	219.35	220.015	5269107.0
2023-01-06 10:00:00	MSFT	Stock	220.1	222.465	220.0	221.395	2979593.0
2023-01-06 10:30:00	MSFT	Stock	221.41	223.17	221.3	222.82	1952578.0
2023-01-06 11:00:00	MSFT	Stock	222.85	223.35	222.05	222.26	1851487.0
2023-01-06 11:30:00	MSFT	Stock	222.27	223.46	221.86	222.904	1509635.0
2023-01-06 12:00:00	MSFT	Stock	222.905	223.0699	222.46	222.745	1372704.0
2023-01-06 12:30:00	MSFT	Stock	222.75	222.97	221.9099	222.3381	1140135.0

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

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