PREVIEW / stock_30min / 2023-03-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-09.parquet
  size:    2.1 MB
  rows:    102,785
  symbols: 1,798

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-03-09 04:00:00	AAPL	Stock	152.16	152.3	151.97	152.04	12519.0
2023-03-09 04:30:00	AAPL	Stock	151.99	151.99	151.86	151.86	4808.0
2023-03-09 05:00:00	AAPL	Stock	151.87	151.99	151.73	151.73	3086.0
2023-03-09 05:30:00	AAPL	Stock	151.99	151.99	151.91	151.91	1509.0
2023-03-09 06:00:00	AAPL	Stock	151.97	152.29	151.97	152.29	5016.0
2023-03-09 06:30:00	AAPL	Stock	152.23	152.39	152.23	152.24	8427.0
2023-03-09 07:00:00	AAPL	Stock	152.3	152.57	152.22	152.57	22911.0
2023-03-09 07:30:00	AAPL	Stock	152.58	152.66	152.32	152.52	21913.0
2023-03-09 08:00:00	AAPL	Stock	152.35	152.8	151.8615	152.55	61337.0
2023-03-09 08:30:00	AAPL	Stock	152.57	153.65	152.57	153.65	176278.0
2023-03-09 09:00:00	AAPL	Stock	153.65	153.86	153.29	153.45	234090.0
2023-03-09 09:30:00	AAPL	Stock	153.49	154.385	152.9488	154.2949	5409141.0
2023-03-09 10:00:00	AAPL	Stock	154.295	154.535	153.63	153.9853	3557515.0
2023-03-09 10:30:00	AAPL	Stock	154.0	154.51	153.87	153.8885	2750029.0
2023-03-09 11:00:00	AAPL	Stock	153.88	154.4	153.7	154.095	2268137.0
2023-03-09 11:30:00	AAPL	Stock	154.1	154.4513	153.995	154.1	1804448.0
2023-03-09 12:00:00	AAPL	Stock	154.11	154.22	153.5689	154.1302	2112152.0
2023-03-09 12:30:00	AAPL	Stock	154.14	154.195	153.45	153.55	1991465.0
2023-03-09 13:00:00	AAPL	Stock	153.56	153.63	152.52	152.6474	2554766.0
2023-03-09 13:30:00	AAPL	Stock	152.64	152.64	151.83	151.9513	2691258.0
2023-03-09 14:00:00	AAPL	Stock	151.96	152.12	151.51	151.6291	2763214.0
2023-03-09 14:30:00	AAPL	Stock	151.635	151.9	151.22	151.3025	2502660.0
2023-03-09 15:00:00	AAPL	Stock	151.31	151.41	150.225	150.4301	3603969.0
2023-03-09 15:30:00	AAPL	Stock	150.4583	151.1799	150.28	150.55	5955357.0
2023-03-09 16:00:00	AAPL	Stock	150.56	150.67	150.37	150.56	6376729.0
2023-03-09 16:30:00	AAPL	Stock	150.56	150.7	150.55	150.6101	50718.0
2023-03-09 17:00:00	AAPL	Stock	150.61	150.75	150.57	150.6602	155197.0
2023-03-09 17:30:00	AAPL	Stock	150.6601	150.69	150.55	150.5623	38755.0
2023-03-09 18:00:00	AAPL	Stock	150.57	150.57	150.11	150.35	40440.0
2023-03-09 18:30:00	AAPL	Stock	150.38	150.5	150.33	150.4	4935.0
2023-03-09 19:00:00	AAPL	Stock	150.4	150.5	150.19	150.25	18308.0
2023-03-09 19:30:00	AAPL	Stock	150.29	150.48	150.23	150.4	22519.0
2023-03-09 04:00:00	MSFT	Stock	252.75	252.75	252.15	252.15	1007.0
2023-03-09 04:30:00	MSFT	Stock	252.17	252.3	252.02	252.02	1980.0
2023-03-09 05:00:00	MSFT	Stock	252.11	252.11	251.81	252.0	2452.0
2023-03-09 05:30:00	MSFT	Stock	252.0	252.28	252.0	252.28	1001.0
2023-03-09 06:00:00	MSFT	Stock	252.3	252.33	252.15	252.32	1836.0
2023-03-09 06:30:00	MSFT	Stock	252.3	252.42	252.25	252.42	1461.0
2023-03-09 07:00:00	MSFT	Stock	252.54	252.62	252.26	252.26	3299.0
2023-03-09 07:30:00	MSFT	Stock	252.26	252.47	252.2	252.4	1919.0
2023-03-09 08:00:00	MSFT	Stock	252.16	253.6	252.0	252.02	17472.0
2023-03-09 08:30:00	MSFT	Stock	252.22	255.2	252.22	255.01	36977.0
2023-03-09 09:00:00	MSFT	Stock	255.34	255.95	254.96	255.89	53276.0
2023-03-09 09:30:00	MSFT	Stock	255.94	258.32	255.4	258.0092	2342000.0
2023-03-09 10:00:00	MSFT	Stock	258.02	258.96	257.77	258.56	1501143.0
2023-03-09 10:30:00	MSFT	Stock	258.57	259.56	258.42	258.51	1306158.0
2023-03-09 11:00:00	MSFT	Stock	258.51	258.6	257.67	257.8	1028343.0
2023-03-09 11:30:00	MSFT	Stock	257.8	259.0	257.76	258.18	833375.0
2023-03-09 12:00:00	MSFT	Stock	258.2	258.3	257.14	257.83	952811.0
2023-03-09 12:30:00	MSFT	Stock	257.84	257.94	256.13	256.62	838918.0

> showing 50 of 102,785 rows — these rows as CSV

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