PREVIEW / stock_30min / 2023-10-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-27.parquet
  size:    1.9 MB
  rows:    94,729
  symbols: 1,361

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
2023-10-27 04:00:00	AAPL	Stock	167.4	167.68	167.19	167.3	20952.0
2023-10-27 04:30:00	AAPL	Stock	167.3	167.66	167.26	167.59	4901.0
2023-10-27 05:00:00	AAPL	Stock	167.58	167.68	167.3	167.3	16098.0
2023-10-27 05:30:00	AAPL	Stock	167.33	167.35	167.12	167.23	8897.0
2023-10-27 06:00:00	AAPL	Stock	167.39	167.52	167.3	167.3	3684.0
2023-10-27 06:30:00	AAPL	Stock	167.33	167.5	167.0	167.0	7547.0
2023-10-27 07:00:00	AAPL	Stock	167.12	167.3	166.6	166.6	39997.0
2023-10-27 07:30:00	AAPL	Stock	166.6	166.77	166.46	166.46	21130.0
2023-10-27 08:00:00	AAPL	Stock	167.02	167.47	166.31	166.6	114209.0
2023-10-27 08:30:00	AAPL	Stock	166.56	167.1	166.28	167.0898	147550.0
2023-10-27 09:00:00	AAPL	Stock	167.0865	167.44	166.65	166.91	170480.0
2023-10-27 09:30:00	AAPL	Stock	166.91	168.42	166.88	167.89	6467900.0
2023-10-27 10:00:00	AAPL	Stock	167.88	168.77	167.61	168.16	3966968.0
2023-10-27 10:30:00	AAPL	Stock	168.16	168.48	167.39	168.435	2879102.0
2023-10-27 11:00:00	AAPL	Stock	168.44	168.96	168.1901	168.735	2585899.0
2023-10-27 11:30:00	AAPL	Stock	168.75	168.8181	168.02	168.37	1723563.0
2023-10-27 12:00:00	AAPL	Stock	168.35	168.49	167.52	167.76	1695963.0
2023-10-27 12:30:00	AAPL	Stock	167.77	167.9631	167.29	167.42	1541539.0
2023-10-27 13:00:00	AAPL	Stock	167.43	167.58	166.83	167.19	2438267.0
2023-10-27 13:30:00	AAPL	Stock	167.18	167.91	166.93	167.66	2823001.0
2023-10-27 14:00:00	AAPL	Stock	167.65	167.98	167.3	167.695	2522139.0
2023-10-27 14:30:00	AAPL	Stock	167.7	168.23	167.45	167.62	2484015.0
2023-10-27 15:00:00	AAPL	Stock	167.62	168.24	167.55	167.99	2536166.0
2023-10-27 15:30:00	AAPL	Stock	167.99	168.34	167.49	168.285	5697762.0
2023-10-27 16:00:00	AAPL	Stock	168.29	168.3301	167.52	167.9403	10208553.0
2023-10-27 16:30:00	AAPL	Stock	167.94	168.22	167.8134	167.88	72333.0
2023-10-27 17:00:00	AAPL	Stock	167.86	167.8701	167.78	167.78	6263.0
2023-10-27 17:30:00	AAPL	Stock	167.821	168.0	167.821	167.97	4458.0
2023-10-27 18:00:00	AAPL	Stock	167.97	168.09	167.97	168.09	5637.0
2023-10-27 18:30:00	AAPL	Stock	168.05	168.05	167.9727	168.03	6529.0
2023-10-27 19:00:00	AAPL	Stock	168.0	168.04	168.0	168.02	5581.0
2023-10-27 19:30:00	AAPL	Stock	168.0001	168.05	168.0	168.02	6576.0
2023-10-27 04:00:00	MSFT	Stock	330.93	332.49	330.93	331.6	10514.0
2023-10-27 04:30:00	MSFT	Stock	331.74	331.9	331.6	331.9	2822.0
2023-10-27 05:00:00	MSFT	Stock	332.09	332.42	331.63	331.63	1989.0
2023-10-27 05:30:00	MSFT	Stock	331.6	331.6	331.39	331.5	1365.0
2023-10-27 06:00:00	MSFT	Stock	331.77	332.0	331.22	331.22	2085.0
2023-10-27 06:30:00	MSFT	Stock	331.6	331.65	330.57	330.57	2014.0
2023-10-27 07:00:00	MSFT	Stock	331.18	331.42	330.0	330.55	10052.0
2023-10-27 07:30:00	MSFT	Stock	330.55	331.0	330.55	330.6	6295.0
2023-10-27 08:00:00	MSFT	Stock	330.9	331.62	330.1501	331.14	33324.0
2023-10-27 08:30:00	MSFT	Stock	331.0	332.0	330.5	331.42	42543.0
2023-10-27 09:00:00	MSFT	Stock	331.49	332.22	329.37	330.36	87872.0
2023-10-27 09:30:00	MSFT	Stock	330.36	333.73	329.8	333.63	3640666.0
2023-10-27 10:00:00	MSFT	Stock	333.66	334.88	332.53	334.1	2181539.0
2023-10-27 10:30:00	MSFT	Stock	334.09	334.685	332.77	334.14	1453383.0
2023-10-27 11:00:00	MSFT	Stock	334.17	336.72	334.11	335.9101	1552528.0
2023-10-27 11:30:00	MSFT	Stock	335.99	336.08	333.6701	334.38	825499.0
2023-10-27 12:00:00	MSFT	Stock	334.32	334.86	332.89	333.32	714606.0
2023-10-27 12:30:00	MSFT	Stock	333.28	333.84	332.29	332.43	668858.0

> showing 50 of 94,729 rows — these rows as CSV

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