PREVIEW / stock_30min / 2022-11-29

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-11-29.parquet
  size:    2.1 MB
  rows:    101,043
  symbols: 2,066

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-11-29 04:00:00	AAPL	Stock	145.04	145.68	145.04	145.25	28325.0
2022-11-29 04:30:00	AAPL	Stock	145.29	145.29	144.7	144.92	21268.0
2022-11-29 05:00:00	AAPL	Stock	144.92	145.1	144.87	145.1	1400.0
2022-11-29 05:30:00	AAPL	Stock	145.09	145.34	145.09	145.13	11933.0
2022-11-29 06:00:00	AAPL	Stock	145.12	145.17	144.9	145.0	5064.0
2022-11-29 06:30:00	AAPL	Stock	145.1	145.29	145.0	145.24	10180.0
2022-11-29 07:00:00	AAPL	Stock	145.16	145.27	144.98	144.98	46684.0
2022-11-29 07:30:00	AAPL	Stock	144.98	145.08	144.78	145.06	28820.0
2022-11-29 08:00:00	AAPL	Stock	145.2	145.47	143.86	144.6501	131880.0
2022-11-29 08:30:00	AAPL	Stock	144.63	144.63	144.31	144.58	130066.0
2022-11-29 09:00:00	AAPL	Stock	144.62	144.91	144.22	144.29	216441.0
2022-11-29 09:30:00	AAPL	Stock	144.28	144.39	142.96	143.14	7557409.0
2022-11-29 10:00:00	AAPL	Stock	143.145	144.35	143.08	144.3399	5850519.0
2022-11-29 10:30:00	AAPL	Stock	144.335	144.81	143.74	144.2779	5399096.0
2022-11-29 11:00:00	AAPL	Stock	144.275	144.34	141.2	141.81	10389257.0
2022-11-29 11:30:00	AAPL	Stock	141.81	142.38	141.4306	142.1	5115031.0
2022-11-29 12:00:00	AAPL	Stock	142.11	142.11	141.3155	141.38	4012770.0
2022-11-29 12:30:00	AAPL	Stock	141.3899	141.7	141.29	141.5346	3059052.0
2022-11-29 13:00:00	AAPL	Stock	141.535	141.57	140.53	140.535	3534990.0
2022-11-29 13:30:00	AAPL	Stock	140.54	141.19	140.4958	141.145	3447574.0
2022-11-29 14:00:00	AAPL	Stock	141.15	141.61	140.78	140.86	2950233.0
2022-11-29 14:30:00	AAPL	Stock	140.87	140.91	140.39	140.5801	3408296.0
2022-11-29 15:00:00	AAPL	Stock	140.585	140.91	140.54	140.59	3599763.0
2022-11-29 15:30:00	AAPL	Stock	140.5932	141.34	140.355	141.16	7915914.0
2022-11-29 16:00:00	AAPL	Stock	141.16	141.33	141.02	141.21	6615882.0
2022-11-29 16:30:00	AAPL	Stock	141.22	141.3	141.17	141.29	57344.0
2022-11-29 17:00:00	AAPL	Stock	141.28	141.28	141.17	141.25	39903.0
2022-11-29 17:30:00	AAPL	Stock	141.25	141.25	141.01	141.15	27843.0
2022-11-29 18:00:00	AAPL	Stock	141.15	141.19	141.01	141.06	14350.0
2022-11-29 18:30:00	AAPL	Stock	141.03	141.06	140.99	140.99	20906.0
2022-11-29 19:00:00	AAPL	Stock	141.0	141.1397	140.95	141.02	15594.0
2022-11-29 19:30:00	AAPL	Stock	141.07	141.31	141.07	141.31	19002.0
2022-11-29 04:00:00	MSFT	Stock	243.0	243.0	242.35	242.47	2501.0
2022-11-29 04:30:00	MSFT	Stock	242.24	242.24	242.16	242.16	256.0
2022-11-29 05:00:00	MSFT	Stock	242.1	242.19	242.1	242.19	962.0
2022-11-29 05:30:00	MSFT	Stock	242.5	242.5	242.22	242.22	2485.0
2022-11-29 06:00:00	MSFT	Stock	242.44	242.44	242.0	242.25	3554.0
2022-11-29 06:30:00	MSFT	Stock	242.3	242.38	242.1	242.33	3552.0
2022-11-29 07:00:00	MSFT	Stock	242.3	242.35	242.0	242.0	18577.0
2022-11-29 07:30:00	MSFT	Stock	242.0	242.18	241.73	242.18	6947.0
2022-11-29 08:00:00	MSFT	Stock	242.09	242.6015	241.156	241.7	45066.0
2022-11-29 08:30:00	MSFT	Stock	241.6	241.63	241.12	241.53	18790.0
2022-11-29 09:00:00	MSFT	Stock	241.6501	241.84	240.95	241.4	21026.0
2022-11-29 09:30:00	MSFT	Stock	241.38	242.79	240.33	240.64	1778448.0
2022-11-29 10:00:00	MSFT	Stock	240.61	241.34	240.1075	241.15	810624.0
2022-11-29 10:30:00	MSFT	Stock	241.18	241.485	240.6	240.65	611612.0
2022-11-29 11:00:00	MSFT	Stock	240.63	240.74	238.21	238.61	1305941.0
2022-11-29 11:30:00	MSFT	Stock	238.61	239.6792	238.44	239.67	673214.0
2022-11-29 12:00:00	MSFT	Stock	239.67	240.0818	239.42	239.58	589883.0
2022-11-29 12:30:00	MSFT	Stock	239.58	240.39	239.54	240.1398	506654.0

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

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