PREVIEW / stock_30min / 2023-03-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-01.parquet
  size:    2.1 MB
  rows:    102,089
  symbols: 1,814

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-03-01 04:00:00	AAPL	Stock	147.66	148.33	147.66	148.02	17022.0
2023-03-01 04:30:00	AAPL	Stock	148.09	148.29	148.08	148.17	4238.0
2023-03-01 05:00:00	AAPL	Stock	148.16	148.21	148.12	148.21	1801.0
2023-03-01 05:30:00	AAPL	Stock	148.22	148.45	148.17	148.37	9538.0
2023-03-01 06:00:00	AAPL	Stock	148.4	148.49	148.35	148.42	4357.0
2023-03-01 06:30:00	AAPL	Stock	148.44	148.45	148.19	148.24	14336.0
2023-03-01 07:00:00	AAPL	Stock	148.19	148.25	148.04	148.12	39673.0
2023-03-01 07:30:00	AAPL	Stock	148.12	148.14	148.04	148.09	9954.0
2023-03-01 08:00:00	AAPL	Stock	148.1401	148.2001	147.5	147.5	90001.0
2023-03-01 08:30:00	AAPL	Stock	147.45	147.58	147.05	147.05	111165.0
2023-03-01 09:00:00	AAPL	Stock	147.07	147.31	146.56	146.85	180267.0
2023-03-01 09:30:00	AAPL	Stock	146.83	147.2285	146.31	146.92	5444563.0
2023-03-01 10:00:00	AAPL	Stock	146.93	147.15	145.49	145.66	4300336.0
2023-03-01 10:30:00	AAPL	Stock	145.65	146.77	145.6001	146.49	3101297.0
2023-03-01 11:00:00	AAPL	Stock	146.47	146.47	145.41	145.95	3030935.0
2023-03-01 11:30:00	AAPL	Stock	145.955	146.63	145.74	146.4487	1944008.0
2023-03-01 12:00:00	AAPL	Stock	146.46	146.88	146.32	146.43	1701505.0
2023-03-01 12:30:00	AAPL	Stock	146.42	146.61	146.31	146.385	1321542.0
2023-03-01 13:00:00	AAPL	Stock	146.3801	146.4	145.95	145.97	1468188.0
2023-03-01 13:30:00	AAPL	Stock	145.97	146.015	145.72	145.88	1458459.0
2023-03-01 14:00:00	AAPL	Stock	145.875	145.93	145.35	145.36	1948497.0
2023-03-01 14:30:00	AAPL	Stock	145.37	145.6	145.26	145.49	2073648.0
2023-03-01 15:00:00	AAPL	Stock	145.49	145.686	145.18	145.225	2971887.0
2023-03-01 15:30:00	AAPL	Stock	145.225	145.68	145.01	145.33	6380922.0
2023-03-01 16:00:00	AAPL	Stock	145.33	145.53	145.22	145.35	9664561.0
2023-03-01 16:30:00	AAPL	Stock	145.35	145.55	145.27	145.32	69145.0
2023-03-01 17:00:00	AAPL	Stock	145.33	145.4	145.11	145.15	19204.0
2023-03-01 17:30:00	AAPL	Stock	145.12	145.22	145.12	145.2198	19325.0
2023-03-01 18:00:00	AAPL	Stock	145.21	145.35	145.16	145.33	53184.0
2023-03-01 18:30:00	AAPL	Stock	145.32	145.4	145.3	145.33	7899.0
2023-03-01 19:00:00	AAPL	Stock	145.35	145.75	145.31	145.66	28552.0
2023-03-01 19:30:00	AAPL	Stock	145.69	145.69	145.1	145.12	18402.0
2023-03-01 04:00:00	MSFT	Stock	250.78	251.89	250.75	250.99	4870.0
2023-03-01 04:30:00	MSFT	Stock	251.17	251.24	250.71	250.84	3083.0
2023-03-01 05:00:00	MSFT	Stock	251.21	251.27	251.0	251.27	1671.0
2023-03-01 05:30:00	MSFT	Stock	251.25	251.63	251.25	251.46	3570.0
2023-03-01 06:00:00	MSFT	Stock	251.5	251.72	251.35	251.71	3599.0
2023-03-01 06:30:00	MSFT	Stock	251.66	251.85	251.64	251.79	4591.0
2023-03-01 07:00:00	MSFT	Stock	251.79	251.79	251.06	251.51	18788.0
2023-03-01 07:30:00	MSFT	Stock	251.52	251.77	251.41	251.41	8862.0
2023-03-01 08:00:00	MSFT	Stock	251.58	251.7513	249.94	250.68	31264.0
2023-03-01 08:30:00	MSFT	Stock	250.66	251.06	250.15	250.5	24670.0
2023-03-01 09:00:00	MSFT	Stock	250.6	252.15	250.25	250.89	90482.0
2023-03-01 09:30:00	MSFT	Stock	250.75	250.95	247.77	249.6	3099360.0
2023-03-01 10:00:00	MSFT	Stock	249.63	249.93	247.36	247.67	1478124.0
2023-03-01 10:30:00	MSFT	Stock	247.66	249.26	247.25	248.35	1248077.0
2023-03-01 11:00:00	MSFT	Stock	248.35	248.375	246.57	247.37	1277197.0
2023-03-01 11:30:00	MSFT	Stock	247.38	248.64	247.2201	248.42	1012891.0
2023-03-01 12:00:00	MSFT	Stock	248.43	248.62	247.75	247.7899	772841.0
2023-03-01 12:30:00	MSFT	Stock	247.82	248.4	247.71	247.81	841619.0

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

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