PREVIEW / stock_30min / 2023-02-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-27.parquet
  size:    2.1 MB
  rows:    101,342
  symbols: 1,840

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-02-27 04:00:00	AAPL	Stock	146.95	147.17	146.85	147.08	15795.0
2023-02-27 04:30:00	AAPL	Stock	147.07	147.07	146.8	146.85	9031.0
2023-02-27 05:00:00	AAPL	Stock	146.87	147.09	146.87	147.0	2392.0
2023-02-27 05:30:00	AAPL	Stock	147.0	147.0	146.93	146.93	1785.0
2023-02-27 06:00:00	AAPL	Stock	146.97	147.0	146.95	147.0	1954.0
2023-02-27 06:30:00	AAPL	Stock	147.08	147.09	146.99	147.02	2211.0
2023-02-27 07:00:00	AAPL	Stock	147.0	147.2	146.97	147.07	19738.0
2023-02-27 07:30:00	AAPL	Stock	147.05	147.33	147.04	147.07	26105.0
2023-02-27 08:00:00	AAPL	Stock	147.05	147.35	146.344	147.25	87450.0
2023-02-27 08:30:00	AAPL	Stock	147.24	148.25	147.24	148.02	110077.0
2023-02-27 09:00:00	AAPL	Stock	148.0553	148.09	147.57	147.71	80813.0
2023-02-27 09:30:00	AAPL	Stock	147.71	148.56	147.67	148.53	4906218.0
2023-02-27 10:00:00	AAPL	Stock	148.525	149.17	148.24	148.71	3455525.0
2023-02-27 10:30:00	AAPL	Stock	148.72	148.759	147.78	148.17	3319254.0
2023-02-27 11:00:00	AAPL	Stock	148.165	148.25	147.5701	147.8499	2425859.0
2023-02-27 11:30:00	AAPL	Stock	147.85	147.97	147.45	147.93	1563451.0
2023-02-27 12:00:00	AAPL	Stock	147.95	148.16	147.68	148.1	1499982.0
2023-02-27 12:30:00	AAPL	Stock	148.1	148.45	147.957	148.3401	1822049.0
2023-02-27 13:00:00	AAPL	Stock	148.36	148.65	148.28	148.455	1590960.0
2023-02-27 13:30:00	AAPL	Stock	148.47	148.53	148.0501	148.48	1558332.0
2023-02-27 14:00:00	AAPL	Stock	148.48	148.7901	148.265	148.41	2150465.0
2023-02-27 14:30:00	AAPL	Stock	148.405	148.59	148.06	148.0601	1575661.0
2023-02-27 15:00:00	AAPL	Stock	148.06	148.215	147.855	148.1589	1847515.0
2023-02-27 15:30:00	AAPL	Stock	148.16	148.17	147.7	147.9189	4317805.0
2023-02-27 16:00:00	AAPL	Stock	147.92	148.1	147.89	148.08	6590409.0
2023-02-27 16:30:00	AAPL	Stock	148.03	148.09	147.92	147.95	24277.0
2023-02-27 17:00:00	AAPL	Stock	147.95	148.0	147.94	147.96	5519.0
2023-02-27 17:30:00	AAPL	Stock	147.96	147.99	147.95	147.9899	1159.0
2023-02-27 18:00:00	AAPL	Stock	147.99	148.12	147.99	148.02	7957.0
2023-02-27 18:30:00	AAPL	Stock	148.01	148.08	148.01	148.02	2865.0
2023-02-27 19:00:00	AAPL	Stock	148.0299	148.15	147.99	147.99	11463.0
2023-02-27 19:30:00	AAPL	Stock	148.0	148.07	147.99	148.03	22333.0
2023-02-27 04:00:00	MSFT	Stock	250.58	250.89	250.5	250.89	718.0
2023-02-27 04:30:00	MSFT	Stock	250.89	250.93	250.35	250.43	2493.0
2023-02-27 05:00:00	MSFT	Stock	250.33	250.83	250.33	250.59	1482.0
2023-02-27 05:30:00	MSFT	Stock	250.55	250.63	250.44	250.44	1700.0
2023-02-27 06:00:00	MSFT	Stock	250.61	250.61	250.61	250.61	100.0
2023-02-27 06:30:00	MSFT	Stock	250.69	250.69	250.51	250.62	1677.0
2023-02-27 07:00:00	MSFT	Stock	250.55	250.68	250.3	250.43	6174.0
2023-02-27 07:30:00	MSFT	Stock	250.43	250.46	250.1	250.2	2593.0
2023-02-27 08:00:00	MSFT	Stock	250.51	250.8259	249.843	250.55	19732.0
2023-02-27 08:30:00	MSFT	Stock	250.55	252.68	250.52	251.95	39227.0
2023-02-27 09:00:00	MSFT	Stock	251.96	252.65	251.61	252.5	41427.0
2023-02-27 09:30:00	MSFT	Stock	252.5	252.82	250.76	251.83	1767975.0
2023-02-27 10:00:00	MSFT	Stock	251.84	252.79	251.51	251.88	1252703.0
2023-02-27 10:30:00	MSFT	Stock	251.87	252.0	250.18	250.72	1226623.0
2023-02-27 11:00:00	MSFT	Stock	250.73	250.78	249.76	250.02	960777.0
2023-02-27 11:30:00	MSFT	Stock	250.04	250.47	249.52	250.3599	759934.0
2023-02-27 12:00:00	MSFT	Stock	250.37	250.42	249.685	250.12	582600.0
2023-02-27 12:30:00	MSFT	Stock	250.15	250.75	250.05	250.74	402844.0

> showing 50 of 101,342 rows — these rows as CSV

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