PREVIEW / stock_30min / 2023-07-12

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-12.parquet
  size:    2.1 MB
  rows:    103,370
  symbols: 1,543

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-07-12 04:00:00	AAPL	Stock	188.3	188.5	188.3	188.37	4274.0
2023-07-12 04:30:00	AAPL	Stock	188.44	188.45	188.4	188.43	1528.0
2023-07-12 05:00:00	AAPL	Stock	188.46	188.79	188.45	188.67	9077.0
2023-07-12 05:30:00	AAPL	Stock	188.73	188.73	188.59	188.61	2900.0
2023-07-12 06:00:00	AAPL	Stock	188.53	188.53	188.43	188.5	6292.0
2023-07-12 06:30:00	AAPL	Stock	188.53	188.64	188.5	188.5	3403.0
2023-07-12 07:00:00	AAPL	Stock	188.52	188.71	188.52	188.71	9338.0
2023-07-12 07:30:00	AAPL	Stock	188.74	188.74	188.63	188.65	9537.0
2023-07-12 08:00:00	AAPL	Stock	188.59	188.8	188.11	188.8	69806.0
2023-07-12 08:30:00	AAPL	Stock	188.81	189.5	188.7	189.23	409360.0
2023-07-12 09:00:00	AAPL	Stock	189.22	189.72	189.21	189.66	262769.0
2023-07-12 09:30:00	AAPL	Stock	189.68	191.7	189.45	190.71	9675331.0
2023-07-12 10:00:00	AAPL	Stock	190.72	190.99	190.24	190.35	4335222.0
2023-07-12 10:30:00	AAPL	Stock	190.35	190.66	189.565	189.6699	3151519.0
2023-07-12 11:00:00	AAPL	Stock	189.67	189.9	189.22	189.53	3201928.0
2023-07-12 11:30:00	AAPL	Stock	189.53	189.695	188.47	188.6399	2869361.0
2023-07-12 12:00:00	AAPL	Stock	188.63	189.21	188.57	189.155	2017804.0
2023-07-12 12:30:00	AAPL	Stock	189.155	189.82	189.1	189.361	1893380.0
2023-07-12 13:00:00	AAPL	Stock	189.365	189.96	189.365	189.86	1712685.0
2023-07-12 13:30:00	AAPL	Stock	189.8599	190.03	189.75	189.92	1316668.0
2023-07-12 14:00:00	AAPL	Stock	189.93	190.39	189.815	190.34	1460073.0
2023-07-12 14:30:00	AAPL	Stock	190.33	190.4027	189.87	189.98	1785351.0
2023-07-12 15:00:00	AAPL	Stock	189.985	190.24	189.7	189.86	1976675.0
2023-07-12 15:30:00	AAPL	Stock	189.87	190.02	189.57	189.82	4757565.0
2023-07-12 16:00:00	AAPL	Stock	189.82	189.89	189.67	189.72	7064472.0
2023-07-12 16:30:00	AAPL	Stock	189.7109	189.77	189.61	189.65	109799.0
2023-07-12 17:00:00	AAPL	Stock	189.68	189.77	189.53	189.6792	630038.0
2023-07-12 17:30:00	AAPL	Stock	189.67	189.68	189.5823	189.6616	5673.0
2023-07-12 18:00:00	AAPL	Stock	189.72	189.88	189.69	189.88	12509.0
2023-07-12 18:30:00	AAPL	Stock	189.87	190.0	189.87	189.99	14636.0
2023-07-12 19:00:00	AAPL	Stock	189.98	189.98	189.8	189.92	11579.0
2023-07-12 19:30:00	AAPL	Stock	189.9	189.99	189.8	189.99	9656.0
2023-07-12 04:00:00	MSFT	Stock	333.06	333.14	332.51	332.51	1167.0
2023-07-12 04:30:00	MSFT	Stock	332.48	332.72	332.48	332.63	566.0
2023-07-12 05:00:00	MSFT	Stock	332.6	332.7	332.6	332.6	1079.0
2023-07-12 05:30:00	MSFT	Stock	332.99	332.99	332.99	332.99	200.0
2023-07-12 06:00:00	MSFT	Stock	333.05	333.33	333.05	333.33	2081.0
2023-07-12 06:30:00	MSFT	Stock	333.33	333.67	333.33	333.67	3712.0
2023-07-12 07:00:00	MSFT	Stock	333.5	334.25	333.5	334.25	6875.0
2023-07-12 07:30:00	MSFT	Stock	334.32	334.88	334.13	334.13	7662.0
2023-07-12 08:00:00	MSFT	Stock	333.5	334.88	333.09	333.9	32192.0
2023-07-12 08:30:00	MSFT	Stock	334.2	336.5	334.2	336.07	163933.0
2023-07-12 09:00:00	MSFT	Stock	336.1	336.63	335.41	336.63	75061.0
2023-07-12 09:30:00	MSFT	Stock	336.63	339.98	335.68	339.26	4012068.0
2023-07-12 10:00:00	MSFT	Stock	339.28	341.652	338.8901	340.455	2178519.0
2023-07-12 10:30:00	MSFT	Stock	340.47	341.29	339.43	339.75	1465847.0
2023-07-12 11:00:00	MSFT	Stock	339.74	339.76	338.3301	338.5	1039939.0
2023-07-12 11:30:00	MSFT	Stock	338.52	338.64	335.67	336.43	1462269.0
2023-07-12 12:00:00	MSFT	Stock	336.4355	337.23	336.33	336.8	816557.0
2023-07-12 12:30:00	MSFT	Stock	336.815	338.13	336.71	337.56	785239.0

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

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