PREVIEW / stock_30min / 2024-07-05

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-05.parquet
  size:    2.0 MB
  rows:    96,486
  symbols: 874

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
2024-07-05 04:00:00	AAPL	Stock	221.86	221.86	221.56	221.8	9983.0
2024-07-05 04:30:00	AAPL	Stock	221.73	221.75	221.31	221.31	4006.0
2024-07-05 05:00:00	AAPL	Stock	221.34	221.55	221.34	221.49	1519.0
2024-07-05 05:30:00	AAPL	Stock	221.51	221.69	221.5	221.5	1037.0
2024-07-05 06:00:00	AAPL	Stock	221.46	221.46	221.3	221.46	4033.0
2024-07-05 06:30:00	AAPL	Stock	221.46	221.46	221.46	221.46	100.0
2024-07-05 07:00:00	AAPL	Stock	221.38	221.62	221.1	221.62	17459.0
2024-07-05 07:30:00	AAPL	Stock	221.63	221.73	221.43	221.73	10229.0
2024-07-05 08:00:00	AAPL	Stock	221.15	221.99	221.05	221.33	73471.0
2024-07-05 08:30:00	AAPL	Stock	221.37	221.78	220.8	221.3	56152.0
2024-07-05 09:00:00	AAPL	Stock	221.4628	221.9266	221.2	221.65	120067.0
2024-07-05 09:30:00	AAPL	Stock	221.65	224.54	221.65	224.1052	7886061.0
2024-07-05 10:00:00	AAPL	Stock	224.11	225.44	223.91	225.1708	6194509.0
2024-07-05 10:30:00	AAPL	Stock	225.17	225.19	223.83	224.26	3332911.0
2024-07-05 11:00:00	AAPL	Stock	224.25	224.82	224.155	224.72	2305849.0
2024-07-05 11:30:00	AAPL	Stock	224.72	225.4191	224.68	225.3	2225081.0
2024-07-05 12:00:00	AAPL	Stock	225.3	225.42	224.93	225.21	1868545.0
2024-07-05 12:30:00	AAPL	Stock	225.23	225.3	224.73	225.07	1521067.0
2024-07-05 13:00:00	AAPL	Stock	225.065	225.37	224.89	225.355	1626645.0
2024-07-05 13:30:00	AAPL	Stock	225.355	225.64	225.07	225.135	2173236.0
2024-07-05 14:00:00	AAPL	Stock	225.1399	225.54	224.98	225.25	1576478.0
2024-07-05 14:30:00	AAPL	Stock	225.26	225.36	225.01	225.23	1418290.0
2024-07-05 15:00:00	AAPL	Stock	225.23	225.525	225.22	225.42	2168045.0
2024-07-05 15:30:00	AAPL	Stock	225.4199	226.45	225.36	226.32	6044530.0
2024-07-05 16:00:00	AAPL	Stock	226.32	226.85	226.22	226.338	9023029.0
2024-07-05 16:30:00	AAPL	Stock	226.31	226.47	226.2	226.2	105838.0
2024-07-05 17:00:00	AAPL	Stock	226.2	226.46	226.2	226.42	16794.0
2024-07-05 17:30:00	AAPL	Stock	226.45	226.45	226.3055	226.3116	11999.0
2024-07-05 18:00:00	AAPL	Stock	226.32	226.3898	226.3	226.3797	10789.0
2024-07-05 18:30:00	AAPL	Stock	226.35	226.39	226.3027	226.35	5231.0
2024-07-05 19:00:00	AAPL	Stock	226.35	226.46	226.31	226.44	31503.0
2024-07-05 19:30:00	AAPL	Stock	226.38	226.51	226.38	226.5092	17150.0
2024-07-05 04:00:00	MSFT	Stock	461.72	461.72	460.76	461.68	1968.0
2024-07-05 04:30:00	MSFT	Stock	461.68	461.8	461.26	461.26	885.0
2024-07-05 05:00:00	MSFT	Stock	461.0	461.1	461.0	461.1	1170.0
2024-07-05 06:00:00	MSFT	Stock	461.07	461.3	461.0	461.3	2798.0
2024-07-05 06:30:00	MSFT	Stock	461.4	461.47	461.3	461.45	1092.0
2024-07-05 07:00:00	MSFT	Stock	461.25	461.3	461.04	461.3	395.0
2024-07-05 07:30:00	MSFT	Stock	461.01	461.01	460.95	460.95	962.0
2024-07-05 08:00:00	MSFT	Stock	461.02	463.0	460.45	461.0	12909.0
2024-07-05 08:30:00	MSFT	Stock	460.34	461.4	459.6	460.6	9180.0
2024-07-05 09:00:00	MSFT	Stock	460.5	460.7	459.7	459.943	42527.0
2024-07-05 09:30:00	MSFT	Stock	459.63	466.04	458.965	466.04	1529709.0
2024-07-05 10:00:00	MSFT	Stock	466.05	467.07	464.8	466.0	901677.0
2024-07-05 10:30:00	MSFT	Stock	466.0	466.23	464.6	464.7299	482528.0
2024-07-05 11:00:00	MSFT	Stock	464.75	466.23	464.17	465.2	608254.0
2024-07-05 11:30:00	MSFT	Stock	465.27	466.77	465.1	466.455	376837.0
2024-07-05 12:00:00	MSFT	Stock	466.49	467.01	466.19	466.97	443366.0
2024-07-05 12:30:00	MSFT	Stock	466.93	467.03	466.379	466.48	229305.0
2024-07-05 13:00:00	MSFT	Stock	466.42	468.0616	466.39	467.83	338982.0

> showing 50 of 96,486 rows — these rows as CSV

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