PREVIEW / stock_30min / 2023-03-10

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-10.parquet
  size:    2.1 MB
  rows:    104,984
  symbols: 1,792

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-10 04:00:00	AAPL	Stock	150.29	150.4	149.77	150.4	11658.0
2023-03-10 04:30:00	AAPL	Stock	150.66	150.91	150.41	150.64	6778.0
2023-03-10 05:00:00	AAPL	Stock	150.58	150.95	150.58	150.95	2995.0
2023-03-10 05:30:00	AAPL	Stock	150.71	150.71	150.51	150.51	7831.0
2023-03-10 06:00:00	AAPL	Stock	150.48	150.5	149.01	149.91	46524.0
2023-03-10 06:30:00	AAPL	Stock	149.84	150.29	149.84	150.06	20059.0
2023-03-10 07:00:00	AAPL	Stock	150.02	150.7	150.01	150.51	31156.0
2023-03-10 07:30:00	AAPL	Stock	150.4	150.81	150.05	150.64	20276.0
2023-03-10 08:00:00	AAPL	Stock	150.3	150.89	149.6	150.55	129998.0
2023-03-10 08:30:00	AAPL	Stock	150.6	152.0	149.99	151.04	304369.0
2023-03-10 09:00:00	AAPL	Stock	151.04	151.5	150.12	150.21	191587.0
2023-03-10 09:30:00	AAPL	Stock	150.21	150.51	148.89	149.775	7203369.0
2023-03-10 10:00:00	AAPL	Stock	149.79	150.49	149.27	149.4532	4756588.0
2023-03-10 10:30:00	AAPL	Stock	149.465	150.5199	149.17	150.46	3730296.0
2023-03-10 11:00:00	AAPL	Stock	150.44	150.62	149.7713	150.44	3396311.0
2023-03-10 11:30:00	AAPL	Stock	150.44	150.94	149.75	149.85	3228246.0
2023-03-10 12:00:00	AAPL	Stock	149.86	150.05	149.04	149.42	2369652.0
2023-03-10 12:30:00	AAPL	Stock	149.42	150.0	149.0301	149.1697	2317553.0
2023-03-10 13:00:00	AAPL	Stock	149.17	149.4	148.19	148.4	3015076.0
2023-03-10 13:30:00	AAPL	Stock	148.4	148.42	147.85	148.2	3388560.0
2023-03-10 14:00:00	AAPL	Stock	148.2	148.84	147.84	147.93	3289454.0
2023-03-10 14:30:00	AAPL	Stock	147.92	149.0	147.92	148.65	3571191.0
2023-03-10 15:00:00	AAPL	Stock	148.66	148.77	147.92	148.38	3911533.0
2023-03-10 15:30:00	AAPL	Stock	148.37	148.66	147.6096	148.48	6614166.0
2023-03-10 16:00:00	AAPL	Stock	148.48	148.6	148.34	148.42	8289431.0
2023-03-10 16:30:00	AAPL	Stock	148.42	149.16	148.3408	149.08	75974.0
2023-03-10 17:00:00	AAPL	Stock	149.04	149.04	148.5	148.8	60089.0
2023-03-10 17:30:00	AAPL	Stock	148.8	148.82	148.75	148.76	8242.0
2023-03-10 18:00:00	AAPL	Stock	148.76	148.81	148.65	148.65	4850.0
2023-03-10 18:30:00	AAPL	Stock	148.68	148.68	148.5	148.51	11186.0
2023-03-10 19:00:00	AAPL	Stock	148.45	148.5	148.25	148.38	6193.0
2023-03-10 19:30:00	AAPL	Stock	148.35	148.6	148.34	148.6	14471.0
2023-03-10 04:00:00	MSFT	Stock	251.6	252.08	251.4	252.01	5681.0
2023-03-10 04:30:00	MSFT	Stock	252.21	252.65	251.58	251.89	4698.0
2023-03-10 05:00:00	MSFT	Stock	252.23	252.75	252.23	252.75	1198.0
2023-03-10 05:30:00	MSFT	Stock	252.5	252.5	251.2	251.2	5026.0
2023-03-10 06:00:00	MSFT	Stock	251.55	251.75	250.71	251.68	16201.0
2023-03-10 06:30:00	MSFT	Stock	251.58	252.83	251.58	252.7	6440.0
2023-03-10 07:00:00	MSFT	Stock	252.26	252.3	252.02	252.1	2151.0
2023-03-10 07:30:00	MSFT	Stock	251.94	252.0	251.22	251.76	2639.0
2023-03-10 08:00:00	MSFT	Stock	252.29	252.39	250.56	251.65	27402.0
2023-03-10 08:30:00	MSFT	Stock	252.29	254.9726	250.0	253.1	78939.0
2023-03-10 09:00:00	MSFT	Stock	253.11	253.5	250.45	251.25	47910.0
2023-03-10 09:30:00	MSFT	Stock	251.1	251.85	247.77	248.67	2256252.0
2023-03-10 10:00:00	MSFT	Stock	248.76	251.065	248.73	249.29	1777970.0
2023-03-10 10:30:00	MSFT	Stock	249.3572	252.39	249.265	252.24	1593028.0
2023-03-10 11:00:00	MSFT	Stock	252.21	252.395	250.86	252.235	1402983.0
2023-03-10 11:30:00	MSFT	Stock	252.2	252.79	250.52	250.8	1217177.0
2023-03-10 12:00:00	MSFT	Stock	250.805	251.44	250.05	250.41	991791.0
2023-03-10 12:30:00	MSFT	Stock	250.39	251.17	249.78	249.82	708145.0

> showing 50 of 104,984 rows — these rows as CSV

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