PREVIEW / stock_30min / 2022-09-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-20.parquet
  size:    2.1 MB
  rows:    102,475
  symbols: 2,231

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-09-20 04:00:00	AAPL	Stock	154.54	154.54	153.68	153.93	21855.0
2022-09-20 04:30:00	AAPL	Stock	153.94	154.12	153.85	153.85	7820.0
2022-09-20 05:00:00	AAPL	Stock	153.89	153.89	153.54	153.69	20412.0
2022-09-20 05:30:00	AAPL	Stock	153.72	153.75	153.5	153.5	9259.0
2022-09-20 06:00:00	AAPL	Stock	153.52	153.66	153.45	153.6	7080.0
2022-09-20 06:30:00	AAPL	Stock	153.67	153.8	153.53	153.54	13492.0
2022-09-20 07:00:00	AAPL	Stock	153.67	154.05	153.65	153.9	92986.0
2022-09-20 07:30:00	AAPL	Stock	153.9	153.94	153.55	153.55	33501.0
2022-09-20 08:00:00	AAPL	Stock	153.7793	155.3	153.31	153.31	175154.0
2022-09-20 08:30:00	AAPL	Stock	153.31	153.73	153.25	153.56	75045.0
2022-09-20 09:00:00	AAPL	Stock	153.6	153.7	153.1	153.24	135367.0
2022-09-20 09:30:00	AAPL	Stock	153.4	154.88	153.08	154.76	10761069.0
2022-09-20 10:00:00	AAPL	Stock	154.76	155.13	154.13	154.805	6987433.0
2022-09-20 10:30:00	AAPL	Stock	154.805	155.44	154.4904	155.37	5150481.0
2022-09-20 11:00:00	AAPL	Stock	155.385	156.89	155.22	156.6	7865537.0
2022-09-20 11:30:00	AAPL	Stock	156.58	157.88	156.14	157.825	8185657.0
2022-09-20 12:00:00	AAPL	Stock	157.83	158.08	157.19	157.26	6512219.0
2022-09-20 12:30:00	AAPL	Stock	157.26	157.34	156.6201	157.06	5330101.0
2022-09-20 13:00:00	AAPL	Stock	157.03	157.1	156.01	156.04	5054512.0
2022-09-20 13:30:00	AAPL	Stock	156.04	156.19	155.4	155.615	5411654.0
2022-09-20 14:00:00	AAPL	Stock	155.61	156.58	155.56	156.2201	5362507.0
2022-09-20 14:30:00	AAPL	Stock	156.21	156.59	155.53	156.42	5196395.0
2022-09-20 15:00:00	AAPL	Stock	156.4101	157.19	156.21	157.0	5841770.0
2022-09-20 15:30:00	AAPL	Stock	157.0	157.76	156.62	156.9	10147534.0
2022-09-20 16:00:00	AAPL	Stock	156.92	157.2	156.85	157.01	6333817.0
2022-09-20 16:30:00	AAPL	Stock	157.01	157.1	156.9	157.09	99314.0
2022-09-20 17:00:00	AAPL	Stock	157.05	157.1109	156.96	156.96	34782.0
2022-09-20 17:30:00	AAPL	Stock	156.98	157.12	156.96	157.0	37176.0
2022-09-20 18:00:00	AAPL	Stock	157.03	157.04	156.78	156.78	22328.0
2022-09-20 18:30:00	AAPL	Stock	156.76	156.82	156.67	156.81	29457.0
2022-09-20 19:00:00	AAPL	Stock	156.81	156.87	156.45	156.56	21030.0
2022-09-20 19:30:00	AAPL	Stock	156.51	156.68	156.46	156.49	45111.0
2022-09-20 04:00:00	MSFT	Stock	244.07	244.1	242.92	243.22	3478.0
2022-09-20 04:30:00	MSFT	Stock	243.7	243.8	243.22	243.22	905.0
2022-09-20 05:00:00	MSFT	Stock	243.28	243.28	242.31	242.32	4033.0
2022-09-20 05:30:00	MSFT	Stock	242.7	242.7	242.29	242.3	1043.0
2022-09-20 06:00:00	MSFT	Stock	242.32	242.5	242.25	242.46	648.0
2022-09-20 06:30:00	MSFT	Stock	243.0	243.0	242.75	242.75	545.0
2022-09-20 07:00:00	MSFT	Stock	243.0	243.35	242.9	243.35	4933.0
2022-09-20 07:30:00	MSFT	Stock	243.15	243.19	242.88	242.9	2728.0
2022-09-20 08:00:00	MSFT	Stock	242.9116	243.909	242.1817	242.2	39458.0
2022-09-20 08:30:00	MSFT	Stock	242.2	242.9998	242.2	242.7	11107.0
2022-09-20 09:00:00	MSFT	Stock	242.74	243.5	241.7	241.99	44284.0
2022-09-20 09:30:00	MSFT	Stock	242.05	243.45	241.08	242.47	2345539.0
2022-09-20 10:00:00	MSFT	Stock	242.47	242.76	241.24	242.0	1653790.0
2022-09-20 10:30:00	MSFT	Stock	241.98	242.98	241.324	242.7742	1183364.0
2022-09-20 11:00:00	MSFT	Stock	242.76	243.0368	242.25	242.4649	847260.0
2022-09-20 11:30:00	MSFT	Stock	242.4225	243.44	242.0	243.322	779681.0
2022-09-20 12:00:00	MSFT	Stock	243.35	243.51	242.15	242.1964	707973.0
2022-09-20 12:30:00	MSFT	Stock	242.19	242.25	241.54	241.9617	813353.0

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

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