PREVIEW / stock_30min / 2021-09-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-14.parquet
  size:    2.2 MB
  rows:    108,946
  symbols: 2,745

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-09-14 04:00:00	AAPL	Stock	149.45	149.96	149.45	149.66	11809.0
2021-09-14 04:30:00	AAPL	Stock	149.78	150.04	149.78	150.04	13989.0
2021-09-14 05:00:00	AAPL	Stock	150.09	150.13	150.0	150.0	8447.0
2021-09-14 05:30:00	AAPL	Stock	150.0	150.02	149.84	149.94	57821.0
2021-09-14 06:00:00	AAPL	Stock	149.9	150.12	149.9	150.03	16058.0
2021-09-14 06:30:00	AAPL	Stock	150.01	150.02	149.93	150.0	4525.0
2021-09-14 07:00:00	AAPL	Stock	149.98	150.0	149.8	149.81	46825.0
2021-09-14 07:30:00	AAPL	Stock	149.83	150.12	149.64	149.8	238775.0
2021-09-14 08:00:00	AAPL	Stock	149.8599	150.11	149.63	149.9	222931.0
2021-09-14 08:30:00	AAPL	Stock	149.94	150.44	149.92	150.26	534754.0
2021-09-14 09:00:00	AAPL	Stock	150.27	150.8	150.23	150.36	460684.0
2021-09-14 09:30:00	AAPL	Stock	150.36	151.07	149.63	149.875	11209861.0
2021-09-14 10:00:00	AAPL	Stock	149.875	150.02	149.46	149.6988	6028648.0
2021-09-14 10:30:00	AAPL	Stock	149.695	149.7693	149.185	149.665	4875272.0
2021-09-14 11:00:00	AAPL	Stock	149.669	149.965	149.575	149.8457	4020820.0
2021-09-14 11:30:00	AAPL	Stock	149.85	150.44	149.81	150.251	4741146.0
2021-09-14 12:00:00	AAPL	Stock	150.26	150.38	149.32	149.441	4638638.0
2021-09-14 12:30:00	AAPL	Stock	149.44	149.495	148.8	149.0	4217685.0
2021-09-14 13:00:00	AAPL	Stock	148.99	149.17	148.28	148.94	6318450.0
2021-09-14 13:30:00	AAPL	Stock	148.9399	149.09	148.37	148.59	6578292.0
2021-09-14 14:00:00	AAPL	Stock	148.5701	148.61	146.91	147.6	10803282.0
2021-09-14 14:30:00	AAPL	Stock	147.6001	147.77	147.24	147.745	6456276.0
2021-09-14 15:00:00	AAPL	Stock	147.75	147.8701	147.21	147.27	5233759.0
2021-09-14 15:30:00	AAPL	Stock	147.2601	148.33	147.2301	148.19	9636998.0
2021-09-14 16:00:00	AAPL	Stock	148.12	148.45	148.12	148.24	8956755.0
2021-09-14 16:30:00	AAPL	Stock	148.24	148.29	148.16	148.16	66920.0
2021-09-14 17:00:00	AAPL	Stock	148.15	148.23	148.14	148.2	37550.0
2021-09-14 17:30:00	AAPL	Stock	148.21	148.21	148.12	148.16	29173.0
2021-09-14 18:00:00	AAPL	Stock	148.16	148.22	148.01	148.15	25624.0
2021-09-14 18:30:00	AAPL	Stock	148.1501	148.2	148.1	148.19	20093.0
2021-09-14 19:00:00	AAPL	Stock	148.19	148.2	148.15	148.19	18454.0
2021-09-14 19:30:00	AAPL	Stock	148.18	148.2	148.15	148.19	51533.0
2021-09-14 04:00:00	MSFT	Stock	297.59	297.7	297.2	297.2	774.0
2021-09-14 04:30:00	MSFT	Stock	297.65	298.04	297.65	298.04	2659.0
2021-09-14 05:30:00	MSFT	Stock	297.9	297.9	297.54	297.63	888.0
2021-09-14 06:00:00	MSFT	Stock	297.73	297.84	297.73	297.84	308.0
2021-09-14 06:30:00	MSFT	Stock	297.51	297.6	297.51	297.6	2686.0
2021-09-14 07:00:00	MSFT	Stock	297.5	297.5	297.43	297.49	3090.0
2021-09-14 07:30:00	MSFT	Stock	297.5	297.56	296.7	296.7	4512.0
2021-09-14 08:00:00	MSFT	Stock	297.4501	297.54	296.83	297.04	9082.0
2021-09-14 08:30:00	MSFT	Stock	297.25	298.9999	296.99	298.6799	42074.0
2021-09-14 09:00:00	MSFT	Stock	298.55	299.8	298.0876	299.45	35700.0
2021-09-14 09:30:00	MSFT	Stock	299.51	300.08	298.1	299.05	2076627.0
2021-09-14 10:00:00	MSFT	Stock	299.06	299.9	298.5	299.8798	1077056.0
2021-09-14 10:30:00	MSFT	Stock	299.88	299.93	298.7	299.5235	1015696.0
2021-09-14 11:00:00	MSFT	Stock	299.53	300.53	299.53	300.1967	1067063.0
2021-09-14 11:30:00	MSFT	Stock	300.18	300.92	299.91	300.9	697442.0
2021-09-14 12:00:00	MSFT	Stock	300.9186	301.39	300.75	301.1698	891250.0
2021-09-14 12:30:00	MSFT	Stock	301.17	301.27	300.14	300.53	609175.0
2021-09-14 13:00:00	MSFT	Stock	300.52	300.77	300.07	300.44	516019.0

> showing 50 of 108,946 rows — these rows as CSV

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