PREVIEW / stock_30min / 2022-08-17

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-17.parquet
  size:    2.2 MB
  rows:    106,926
  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-08-17 04:00:00	AAPL	Stock	173.8	173.8	172.67	173.01	25590.0
2022-08-17 04:30:00	AAPL	Stock	173.01	173.06	172.75	172.79	10968.0
2022-08-17 05:00:00	AAPL	Stock	172.87	173.05	172.87	173.05	7342.0
2022-08-17 05:30:00	AAPL	Stock	172.9	172.93	172.56	172.65	7324.0
2022-08-17 06:00:00	AAPL	Stock	172.61	172.69	172.5	172.59	14106.0
2022-08-17 06:30:00	AAPL	Stock	172.54	172.65	172.25	172.49	10621.0
2022-08-17 07:00:00	AAPL	Stock	172.57	172.7	172.22	172.22	90288.0
2022-08-17 07:30:00	AAPL	Stock	172.3	172.44	172.12	172.42	32673.0
2022-08-17 08:00:00	AAPL	Stock	172.6	173.47	172.13	172.7	289401.0
2022-08-17 08:30:00	AAPL	Stock	172.6	172.99	172.3	172.7	285005.0
2022-08-17 09:00:00	AAPL	Stock	172.69	173.0	172.32	172.85	324515.0
2022-08-17 09:30:00	AAPL	Stock	172.77	174.31	172.57	174.17	9107116.0
2022-08-17 10:00:00	AAPL	Stock	174.1696	174.45	173.43	174.04	5492714.0
2022-08-17 10:30:00	AAPL	Stock	174.05	174.09	173.08	173.175	4416634.0
2022-08-17 11:00:00	AAPL	Stock	173.18	173.94	173.1503	173.7892	3296204.0
2022-08-17 11:30:00	AAPL	Stock	173.79	173.995	173.08	173.3399	2877471.0
2022-08-17 12:00:00	AAPL	Stock	173.34	173.84	173.27	173.8	2324301.0
2022-08-17 12:30:00	AAPL	Stock	173.8	174.54	173.7302	174.07	3678385.0
2022-08-17 13:00:00	AAPL	Stock	174.07	174.78	173.91	174.61	3651548.0
2022-08-17 13:30:00	AAPL	Stock	174.6018	174.73	174.21	174.265	2256280.0
2022-08-17 14:00:00	AAPL	Stock	174.26	175.8389	174.1	175.665	8560992.0
2022-08-17 14:30:00	AAPL	Stock	175.67	176.15	175.28	175.34	5254268.0
2022-08-17 15:00:00	AAPL	Stock	175.34	175.8	174.41	175.0216	4666612.0
2022-08-17 15:30:00	AAPL	Stock	175.02	175.03	174.24	174.62	6046732.0
2022-08-17 16:00:00	AAPL	Stock	174.62	174.8	174.41	174.6	4576467.0
2022-08-17 16:30:00	AAPL	Stock	174.61	174.67	174.55	174.6286	18076.0
2022-08-17 17:00:00	AAPL	Stock	174.6	174.6	173.61	173.93	293957.0
2022-08-17 17:30:00	AAPL	Stock	173.95	173.95	173.71	173.88	64610.0
2022-08-17 18:00:00	AAPL	Stock	173.91	173.91	173.55	173.67	46631.0
2022-08-17 18:30:00	AAPL	Stock	173.7	173.75	173.55	173.57	35537.0
2022-08-17 19:00:00	AAPL	Stock	173.56	173.6	173.32	173.33	46452.0
2022-08-17 19:30:00	AAPL	Stock	173.34	173.39	173.2	173.2	75041.0
2022-08-17 04:00:00	MSFT	Stock	291.62	291.62	290.7	290.7	877.0
2022-08-17 04:30:00	MSFT	Stock	290.62	290.62	290.36	290.36	1935.0
2022-08-17 05:00:00	MSFT	Stock	290.77	290.95	290.77	290.95	604.0
2022-08-17 05:30:00	MSFT	Stock	290.66	290.66	290.06	290.07	1245.0
2022-08-17 06:00:00	MSFT	Stock	290.1	290.15	289.81	289.94	7822.0
2022-08-17 06:30:00	MSFT	Stock	290.0	290.1	289.8	290.0	1985.0
2022-08-17 07:00:00	MSFT	Stock	290.39	290.5	289.46	289.5	10760.0
2022-08-17 07:30:00	MSFT	Stock	289.45	289.75	289.4	289.65	5211.0
2022-08-17 08:00:00	MSFT	Stock	290.1027	291.36	289.4	289.56	29992.0
2022-08-17 08:30:00	MSFT	Stock	289.55	290.29	289.0767	289.9	37739.0
2022-08-17 09:00:00	MSFT	Stock	289.94	290.0106	289.22	289.7	35363.0
2022-08-17 09:30:00	MSFT	Stock	289.72	292.35	289.47	292.08	1765557.0
2022-08-17 10:00:00	MSFT	Stock	292.09	292.47	291.2	291.6306	924085.0
2022-08-17 10:30:00	MSFT	Stock	291.64	291.65	290.16	290.55	799567.0
2022-08-17 11:00:00	MSFT	Stock	290.57	291.53	290.28	291.255	585021.0
2022-08-17 11:30:00	MSFT	Stock	291.27	291.73	290.21	290.51	515800.0
2022-08-17 12:00:00	MSFT	Stock	290.52	291.32	290.48	291.2817	386180.0
2022-08-17 12:30:00	MSFT	Stock	291.29	291.83	291.1	291.51	370674.0

> showing 50 of 106,926 rows — these rows as CSV

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