PREVIEW / stock_30min / 2022-08-23

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-23.parquet
  size:    2.1 MB
  rows:    104,211
  symbols: 2,187

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
2022-08-23 04:00:00	AAPL	Stock	167.35	168.38	167.35	168.0	25088.0
2022-08-23 04:30:00	AAPL	Stock	167.93	168.06	167.92	167.93	6662.0
2022-08-23 05:00:00	AAPL	Stock	167.87	167.88	167.79	167.86	3787.0
2022-08-23 05:30:00	AAPL	Stock	167.85	168.09	167.73	168.09	6543.0
2022-08-23 06:00:00	AAPL	Stock	168.02	168.17	167.8	167.8	40870.0
2022-08-23 06:30:00	AAPL	Stock	167.78	168.09	167.78	167.95	16460.0
2022-08-23 07:00:00	AAPL	Stock	167.89	167.99	167.65	167.8	38037.0
2022-08-23 07:30:00	AAPL	Stock	167.8	168.07	167.75	168.0	18429.0
2022-08-23 08:00:00	AAPL	Stock	167.9001	168.0988	166.47	167.81	166382.0
2022-08-23 08:30:00	AAPL	Stock	167.79	167.83	167.32	167.35	209831.0
2022-08-23 09:00:00	AAPL	Stock	167.34	167.38	166.94	167.13	244507.0
2022-08-23 09:30:00	AAPL	Stock	167.12	168.41	167.08	168.01	6887051.0
2022-08-23 10:00:00	AAPL	Stock	168.02	168.71	167.7	168.0083	4071394.0
2022-08-23 10:30:00	AAPL	Stock	168.0191	168.39	167.02	167.0804	3195360.0
2022-08-23 11:00:00	AAPL	Stock	167.08	167.66	166.65	167.18	3655688.0
2022-08-23 11:30:00	AAPL	Stock	167.18	167.83	167.175	167.82	2327438.0
2022-08-23 12:00:00	AAPL	Stock	167.81	167.89	167.21	167.29	2159846.0
2022-08-23 12:30:00	AAPL	Stock	167.29	168.0495	167.28	167.885	2345305.0
2022-08-23 13:00:00	AAPL	Stock	167.89	168.175	167.5	168.08	2061035.0
2022-08-23 13:30:00	AAPL	Stock	168.09	168.1638	167.31	167.581	2044893.0
2022-08-23 14:00:00	AAPL	Stock	167.585	168.05	167.425	167.87	1772382.0
2022-08-23 14:30:00	AAPL	Stock	167.87	167.98	167.54	167.79	1885808.0
2022-08-23 15:00:00	AAPL	Stock	167.8	168.03	167.65	167.72	2056988.0
2022-08-23 15:30:00	AAPL	Stock	167.7331	167.8	166.84	167.23	5636816.0
2022-08-23 16:00:00	AAPL	Stock	167.23	167.23	167.01	167.12	4003775.0
2022-08-23 16:30:00	AAPL	Stock	167.1	167.23	166.95	166.98	37456.0
2022-08-23 17:00:00	AAPL	Stock	166.95	166.98	166.85	166.95	21288.0
2022-08-23 17:30:00	AAPL	Stock	166.95	166.96	166.88	166.96	4698.0
2022-08-23 18:00:00	AAPL	Stock	166.96	167.1	166.95	167.0	10677.0
2022-08-23 18:30:00	AAPL	Stock	167.0	167.08	167.0	167.08	9854.0
2022-08-23 19:00:00	AAPL	Stock	167.1	167.2	167.1	167.16	6812.0
2022-08-23 19:30:00	AAPL	Stock	167.12	167.18	167.06	167.12	7987.0
2022-08-23 04:00:00	MSFT	Stock	278.32	278.56	278.12	278.12	1661.0
2022-08-23 04:30:00	MSFT	Stock	277.74	277.91	277.74	277.85	421.0
2022-08-23 05:00:00	MSFT	Stock	277.58	277.75	277.43	277.61	1237.0
2022-08-23 05:30:00	MSFT	Stock	277.41	277.86	277.41	277.86	1050.0
2022-08-23 06:00:00	MSFT	Stock	277.85	277.88	277.4	277.45	9296.0
2022-08-23 06:30:00	MSFT	Stock	277.45	278.0	277.45	277.87	648.0
2022-08-23 07:00:00	MSFT	Stock	277.75	277.77	277.4	277.6	1602.0
2022-08-23 07:30:00	MSFT	Stock	277.9	277.9	277.65	277.8	2602.0
2022-08-23 08:00:00	MSFT	Stock	277.9326	278.2153	277.056	277.558	13429.0
2022-08-23 08:30:00	MSFT	Stock	277.76	277.76	276.7949	276.85	11430.0
2022-08-23 09:00:00	MSFT	Stock	276.9	277.0	276.22	276.57	31789.0
2022-08-23 09:30:00	MSFT	Stock	276.55	278.4	276.34	277.345	1495077.0
2022-08-23 10:00:00	MSFT	Stock	277.35	278.86	276.93	277.39	935684.0
2022-08-23 10:30:00	MSFT	Stock	277.41	277.85	276.13	276.23	960052.0
2022-08-23 11:00:00	MSFT	Stock	276.225	276.82	275.9	276.28	657107.0
2022-08-23 11:30:00	MSFT	Stock	276.2801	276.9	276.28	276.55	521672.0
2022-08-23 12:00:00	MSFT	Stock	276.57	276.67	275.4	275.535	583413.0
2022-08-23 12:30:00	MSFT	Stock	275.52	276.71	275.5	276.57	463889.0

> showing 50 of 104,211 rows — these rows as CSV

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