PREVIEW / stock_30min / 2023-11-16

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-16.parquet
  size:    2.0 MB
  rows:    97,661
  symbols: 1,294

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-11-16 04:00:00	AAPL	Stock	188.2	188.6	188.2	188.46	4878.0
2023-11-16 04:30:00	AAPL	Stock	188.46	188.55	188.35	188.36	1563.0
2023-11-16 05:00:00	AAPL	Stock	188.22	188.37	188.21	188.37	4429.0
2023-11-16 05:30:00	AAPL	Stock	188.37	188.4	188.3	188.3	3769.0
2023-11-16 06:00:00	AAPL	Stock	188.26	188.3	188.1	188.19	6555.0
2023-11-16 06:30:00	AAPL	Stock	188.19	188.22	187.9	188.05	10601.0
2023-11-16 07:00:00	AAPL	Stock	188.21	188.3	187.75	187.75	28487.0
2023-11-16 07:30:00	AAPL	Stock	187.74	188.25	187.7	188.2	19600.0
2023-11-16 08:00:00	AAPL	Stock	188.15	188.58	187.81	188.28	99644.0
2023-11-16 08:30:00	AAPL	Stock	188.44	189.18	188.2501	189.12	138956.0
2023-11-16 09:00:00	AAPL	Stock	189.13	189.69	188.92	189.55	193355.0
2023-11-16 09:30:00	AAPL	Stock	189.53	190.96	189.52	190.69	11706911.0
2023-11-16 10:00:00	AAPL	Stock	190.685	190.85	189.64	190.0854	3751594.0
2023-11-16 10:30:00	AAPL	Stock	190.1	190.21	189.01	189.455	3081326.0
2023-11-16 11:00:00	AAPL	Stock	189.46	189.57	188.81	189.01	2637326.0
2023-11-16 11:30:00	AAPL	Stock	189.01	189.405	188.72	189.29	2116594.0
2023-11-16 12:00:00	AAPL	Stock	189.29	189.66	189.19	189.645	1985996.0
2023-11-16 12:30:00	AAPL	Stock	189.64	189.98	189.5831	189.755	1565835.0
2023-11-16 13:00:00	AAPL	Stock	189.76	189.78	188.65	189.33	1717109.0
2023-11-16 13:30:00	AAPL	Stock	189.325	189.45	188.98	189.28	1554187.0
2023-11-16 14:00:00	AAPL	Stock	189.285	189.57	189.215	189.355	1316149.0
2023-11-16 14:30:00	AAPL	Stock	189.35	189.735	189.22	189.575	1982106.0
2023-11-16 15:00:00	AAPL	Stock	189.57	189.63	189.3303	189.425	1806566.0
2023-11-16 15:30:00	AAPL	Stock	189.425	189.87	189.34	189.77	4830336.0
2023-11-16 16:00:00	AAPL	Stock	189.76	190.16	189.67	190.04	5010259.0
2023-11-16 16:30:00	AAPL	Stock	190.03	190.16	189.71	190.1	102445.0
2023-11-16 17:00:00	AAPL	Stock	190.14	190.16	190.04	190.1499	24623.0
2023-11-16 17:30:00	AAPL	Stock	190.1	190.14	189.95	189.96	13779.0
2023-11-16 18:00:00	AAPL	Stock	190.03	190.03	189.81	189.81	15388.0
2023-11-16 18:30:00	AAPL	Stock	189.85	190.04	189.73	190.04	13333.0
2023-11-16 19:00:00	AAPL	Stock	190.05	190.5	190.05	190.2	20431.0
2023-11-16 19:30:00	AAPL	Stock	190.25	190.52	190.15	190.51	29330.0
2023-11-16 04:00:00	MSFT	Stock	371.21	372.2	371.12	372.05	3405.0
2023-11-16 04:30:00	MSFT	Stock	372.05	372.05	371.32	371.98	11448.0
2023-11-16 05:00:00	MSFT	Stock	371.99	372.45	371.99	372.4	3519.0
2023-11-16 05:30:00	MSFT	Stock	372.28	372.4	372.28	372.4	200.0
2023-11-16 06:00:00	MSFT	Stock	372.38	372.4	372.27	372.4	1727.0
2023-11-16 06:30:00	MSFT	Stock	372.41	372.63	372.4	372.63	1462.0
2023-11-16 07:00:00	MSFT	Stock	372.45	372.62	371.6	371.9	28890.0
2023-11-16 07:30:00	MSFT	Stock	371.85	372.37	371.79	371.8	45239.0
2023-11-16 08:00:00	MSFT	Stock	371.85	372.7267	370.0	371.2	68144.0
2023-11-16 08:30:00	MSFT	Stock	371.5	372.1	371.1883	371.9	37512.0
2023-11-16 09:00:00	MSFT	Stock	371.86	372.0	370.24	370.96	47147.0
2023-11-16 09:30:00	MSFT	Stock	370.95	376.07	370.18	375.395	3675763.0
2023-11-16 10:00:00	MSFT	Stock	375.4085	376.01	374.39	374.94	1662550.0
2023-11-16 10:30:00	MSFT	Stock	374.98	375.26	373.26	373.62	1400200.0
2023-11-16 11:00:00	MSFT	Stock	373.65	373.65	372.41	372.9862	1007033.0
2023-11-16 11:30:00	MSFT	Stock	373.0	374.1899	372.54	373.97	744106.0
2023-11-16 12:00:00	MSFT	Stock	374.03	375.2585	373.92	375.07	888780.0
2023-11-16 12:30:00	MSFT	Stock	375.05	375.58	374.81	375.17	709231.0

> showing 50 of 97,661 rows — these rows as CSV

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