PREVIEW / stock_30min / 2023-12-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-12-18.parquet
  size:    2.2 MB
  rows:    103,823
  symbols: 1,266

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-12-18 04:00:00	AAPL	Stock	196.32	196.49	195.83	196.03	7228.0
2023-12-18 04:30:00	AAPL	Stock	196.0	196.05	195.5	195.77	12182.0
2023-12-18 05:00:00	AAPL	Stock	195.8	196.1	195.8	196.03	3252.0
2023-12-18 05:30:00	AAPL	Stock	196.1	196.2	195.99	196.05	3282.0
2023-12-18 06:00:00	AAPL	Stock	196.07	196.07	195.95	196.05	4371.0
2023-12-18 06:30:00	AAPL	Stock	196.07	196.31	196.05	196.21	5341.0
2023-12-18 07:00:00	AAPL	Stock	196.32	196.45	196.2	196.32	15427.0
2023-12-18 07:30:00	AAPL	Stock	196.31	196.5	196.12	196.48	8659.0
2023-12-18 08:00:00	AAPL	Stock	196.44	196.5	193.5	196.31	102583.0
2023-12-18 08:30:00	AAPL	Stock	196.4	196.4599	196.08	196.22	49276.0
2023-12-18 09:00:00	AAPL	Stock	196.22	196.22	195.59	196.13	123348.0
2023-12-18 09:30:00	AAPL	Stock	196.11	196.63	194.39	194.925	8050848.0
2023-12-18 10:00:00	AAPL	Stock	194.95	195.59	194.71	195.365	4213874.0
2023-12-18 10:30:00	AAPL	Stock	195.36	195.525	194.62	194.96	2918212.0
2023-12-18 11:00:00	AAPL	Stock	194.95	195.035	194.65	194.93	1988332.0
2023-12-18 11:30:00	AAPL	Stock	194.93	195.29	194.695	194.835	2263839.0
2023-12-18 12:00:00	AAPL	Stock	194.835	195.35	194.81	195.2501	1449559.0
2023-12-18 12:30:00	AAPL	Stock	195.25	195.4688	195.155	195.46	1393964.0
2023-12-18 13:00:00	AAPL	Stock	195.465	196.1633	195.46	196.145	1789004.0
2023-12-18 13:30:00	AAPL	Stock	196.15	196.23	195.995	196.205	1273150.0
2023-12-18 14:00:00	AAPL	Stock	196.21	196.48	196.01	196.2099	1980949.0
2023-12-18 14:30:00	AAPL	Stock	196.21	196.345	196.1	196.26	1474418.0
2023-12-18 15:00:00	AAPL	Stock	196.27	196.45	196.15	196.2	1452553.0
2023-12-18 15:30:00	AAPL	Stock	196.21	196.44	195.78	195.8623	3964203.0
2023-12-18 16:00:00	AAPL	Stock	195.89	195.9207	195.71	195.72	7005260.0
2023-12-18 16:30:00	AAPL	Stock	195.72	195.89	195.0	195.8	409608.0
2023-12-18 17:00:00	AAPL	Stock	195.78	195.83	195.75	195.77	14742.0
2023-12-18 17:30:00	AAPL	Stock	195.84	195.86	195.72	195.75	14416.0
2023-12-18 18:00:00	AAPL	Stock	195.75	195.89	195.69	195.7	46224.0
2023-12-18 18:30:00	AAPL	Stock	195.7	195.7802	195.7	195.7802	7577.0
2023-12-18 19:00:00	AAPL	Stock	195.86	195.89	195.74	195.75	6501.0
2023-12-18 19:30:00	AAPL	Stock	195.76	195.88	195.7501	195.85	13329.0
2023-12-18 04:00:00	MSFT	Stock	370.3	370.31	370.14	370.3	1946.0
2023-12-18 04:30:00	MSFT	Stock	370.12	370.12	369.81	369.81	1793.0
2023-12-18 05:00:00	MSFT	Stock	369.8	369.9	369.8	369.9	6488.0
2023-12-18 05:30:00	MSFT	Stock	369.9	370.0	369.7	369.7	1487.0
2023-12-18 06:00:00	MSFT	Stock	369.25	369.25	369.1	369.1	986.0
2023-12-18 06:30:00	MSFT	Stock	369.09	369.14	368.69	368.69	970.0
2023-12-18 07:00:00	MSFT	Stock	368.9	369.72	368.9	369.72	4417.0
2023-12-18 07:30:00	MSFT	Stock	369.75	369.75	369.7	369.7	598.0
2023-12-18 08:00:00	MSFT	Stock	368.89	370.44	368.89	369.95	22802.0
2023-12-18 08:30:00	MSFT	Stock	370.0	370.2	369.61	370.0	10169.0
2023-12-18 09:00:00	MSFT	Stock	370.08	370.1	368.27	369.32	32624.0
2023-12-18 09:30:00	MSFT	Stock	369.65	371.24	368.68	369.76	2169433.0
2023-12-18 10:00:00	MSFT	Stock	369.79	372.71	369.63	372.49	1535376.0
2023-12-18 10:30:00	MSFT	Stock	372.46	372.66	370.56	370.63	846945.0
2023-12-18 11:00:00	MSFT	Stock	370.595	371.239	370.3245	370.99	660097.0
2023-12-18 11:30:00	MSFT	Stock	370.97	371.39	370.9077	371.11	503366.0
2023-12-18 12:00:00	MSFT	Stock	371.12	371.89	371.08	371.4	507222.0
2023-12-18 12:30:00	MSFT	Stock	371.44	371.55	370.6301	371.04	682282.0

> showing 50 of 103,823 rows — these rows as CSV

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