PREVIEW / stock_30min / 2021-04-29

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-29.parquet
  size:    2.2 MB
  rows:    110,983
  symbols: 2,993

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
2021-04-29 04:00:00	AAPL	Stock	137.0	137.8	136.9	137.33	139368.0
2021-04-29 04:30:00	AAPL	Stock	137.36	137.7	137.18	137.64	43952.0
2021-04-29 05:00:00	AAPL	Stock	137.56	137.72	137.18	137.31	31233.0
2021-04-29 05:30:00	AAPL	Stock	137.28	137.61	137.25	137.4	46311.0
2021-04-29 06:00:00	AAPL	Stock	137.49	137.65	137.1	137.12	34908.0
2021-04-29 06:30:00	AAPL	Stock	137.2	137.38	137.11	137.2	52293.0
2021-04-29 07:00:00	AAPL	Stock	137.22	137.72	137.02	137.5	381066.0
2021-04-29 07:30:00	AAPL	Stock	137.5	137.56	137.05	137.1	206305.0
2021-04-29 08:00:00	AAPL	Stock	137.36	137.71	136.6	136.78	858907.0
2021-04-29 08:30:00	AAPL	Stock	136.8	137.45	136.75	137.28	731458.0
2021-04-29 09:00:00	AAPL	Stock	137.3	137.47	136.42	136.47	905284.0
2021-04-29 09:30:00	AAPL	Stock	136.47	137.07	133.87	134.23	28299158.0
2021-04-29 10:00:00	AAPL	Stock	134.22	134.47	133.63	134.295	13194346.0
2021-04-29 10:30:00	AAPL	Stock	134.3	134.56	133.6	134.19	10826560.0
2021-04-29 11:00:00	AAPL	Stock	134.1805	134.66	133.94	134.5702	7459719.0
2021-04-29 11:30:00	AAPL	Stock	134.58	134.58	132.7	133.16	10511199.0
2021-04-29 12:00:00	AAPL	Stock	133.17	133.17	132.45	132.7812	8548664.0
2021-04-29 12:30:00	AAPL	Stock	132.78	133.2	132.6	132.98	5599190.0
2021-04-29 13:00:00	AAPL	Stock	132.985	133.69	132.8	133.55	6336918.0
2021-04-29 13:30:00	AAPL	Stock	133.55	133.87	133.105	133.82	4998606.0
2021-04-29 14:00:00	AAPL	Stock	133.83	134.32	133.74	134.21	6085128.0
2021-04-29 14:30:00	AAPL	Stock	134.21	134.57	134.08	134.2082	5698395.0
2021-04-29 15:00:00	AAPL	Stock	134.205	134.43	133.84	133.875	5369923.0
2021-04-29 15:30:00	AAPL	Stock	133.88	133.99	133.27	133.48	8112368.0
2021-04-29 16:00:00	AAPL	Stock	133.49	133.5	133.0	133.12	5021497.0
2021-04-29 16:30:00	AAPL	Stock	133.12	133.19	132.88	133.1	205068.0
2021-04-29 17:00:00	AAPL	Stock	133.1	133.48	133.0	133.08	74369.0
2021-04-29 17:30:00	AAPL	Stock	133.08	133.1	133.01	133.02	38079.0
2021-04-29 18:00:00	AAPL	Stock	133.04	133.1	132.98	133.05	56933.0
2021-04-29 18:30:00	AAPL	Stock	133.05	133.06	132.92	132.97	81313.0
2021-04-29 19:00:00	AAPL	Stock	132.96	133.0	132.95	132.98	43333.0
2021-04-29 19:30:00	AAPL	Stock	132.99	133.0	132.53	132.68	134096.0
2021-04-29 04:00:00	MSFT	Stock	255.4	256.32	255.05	256.18	25935.0
2021-04-29 04:30:00	MSFT	Stock	256.3	256.48	256.19	256.19	1659.0
2021-04-29 05:00:00	MSFT	Stock	256.3	256.3	255.05	255.31	18607.0
2021-04-29 05:30:00	MSFT	Stock	255.49	255.82	255.4	255.75	5148.0
2021-04-29 06:00:00	MSFT	Stock	255.75	255.75	255.45	255.45	4282.0
2021-04-29 06:30:00	MSFT	Stock	255.5	255.68	255.35	255.36	3053.0
2021-04-29 07:00:00	MSFT	Stock	255.64	255.7	254.95	255.15	36964.0
2021-04-29 07:30:00	MSFT	Stock	255.39	255.51	255.01	255.01	20968.0
2021-04-29 08:00:00	MSFT	Stock	255.4	255.72	254.69	255.27	89677.0
2021-04-29 08:30:00	MSFT	Stock	255.4	255.73	255.29	255.47	41552.0
2021-04-29 09:00:00	MSFT	Stock	255.46	255.86	255.1	255.53	92851.0
2021-04-29 09:30:00	MSFT	Stock	255.5	256.1	254.2	254.46	4013354.0
2021-04-29 10:00:00	MSFT	Stock	254.46	254.475	250.85	250.91	3816484.0
2021-04-29 10:30:00	MSFT	Stock	250.96	251.4	250.13	250.2764	2944588.0
2021-04-29 11:00:00	MSFT	Stock	250.27	250.37	249.0	249.2	3465927.0
2021-04-29 11:30:00	MSFT	Stock	249.21	250.52	249.07	249.5587	1982681.0
2021-04-29 12:00:00	MSFT	Stock	249.54	250.23	249.24	250.04	1521116.0
2021-04-29 12:30:00	MSFT	Stock	250.04	251.16	249.85	251.11	1378757.0

> showing 50 of 110,983 rows — these rows as CSV

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