PREVIEW / stock_30min / 2023-05-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-18.parquet
  size:    2.1 MB
  rows:    101,423
  symbols: 1,645

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-05-18 04:00:00	AAPL	Stock	172.84	173.0	172.76	172.86	10228.0
2023-05-18 04:30:00	AAPL	Stock	172.85	172.85	172.8	172.8	2680.0
2023-05-18 05:00:00	AAPL	Stock	172.76	172.87	172.75	172.78	3861.0
2023-05-18 05:30:00	AAPL	Stock	172.8	172.85	172.8	172.83	965.0
2023-05-18 06:00:00	AAPL	Stock	172.77	172.84	172.77	172.81	3439.0
2023-05-18 06:30:00	AAPL	Stock	172.84	172.92	172.81	172.81	5849.0
2023-05-18 07:00:00	AAPL	Stock	172.81	172.92	172.77	172.78	21020.0
2023-05-18 07:30:00	AAPL	Stock	172.77	172.85	172.69	172.79	10766.0
2023-05-18 08:00:00	AAPL	Stock	172.89	172.92	172.43	172.73	88448.0
2023-05-18 08:30:00	AAPL	Stock	172.63	172.65	172.22	172.389	89317.0
2023-05-18 09:00:00	AAPL	Stock	172.39	173.2	172.38	173.09	159650.0
2023-05-18 09:30:00	AAPL	Stock	173.0	173.5	172.58	173.09	5579070.0
2023-05-18 10:00:00	AAPL	Stock	173.09	173.855	172.82	173.67	4022468.0
2023-05-18 10:30:00	AAPL	Stock	173.68	174.36	173.56	174.295	4114152.0
2023-05-18 11:00:00	AAPL	Stock	174.3	174.72	174.25	174.66	3515372.0
2023-05-18 11:30:00	AAPL	Stock	174.665	175.01	174.535	174.8057	3732649.0
2023-05-18 12:00:00	AAPL	Stock	174.8	174.875	174.16	174.36	2910265.0
2023-05-18 12:30:00	AAPL	Stock	174.37	174.5281	174.13	174.2797	1875336.0
2023-05-18 13:00:00	AAPL	Stock	174.28	174.85	174.26	174.28	2466190.0
2023-05-18 13:30:00	AAPL	Stock	174.28	174.44	173.76	173.8201	1909302.0
2023-05-18 14:00:00	AAPL	Stock	173.825	174.28	173.68	174.11	1791897.0
2023-05-18 14:30:00	AAPL	Stock	174.11	174.69	174.11	174.425	1954605.0
2023-05-18 15:00:00	AAPL	Stock	174.425	174.69	174.22	174.5	2897514.0
2023-05-18 15:30:00	AAPL	Stock	174.51	175.24	174.48	175.07	7817387.0
2023-05-18 16:00:00	AAPL	Stock	175.07	175.3	175.01	175.15	8681916.0
2023-05-18 16:30:00	AAPL	Stock	175.15	175.31	175.15	175.26	55664.0
2023-05-18 17:00:00	AAPL	Stock	175.2618	175.3	175.05	175.24	71522.0
2023-05-18 17:30:00	AAPL	Stock	175.24	175.3	175.24	175.26	23430.0
2023-05-18 18:00:00	AAPL	Stock	175.22	176.13	175.22	175.75	109440.0
2023-05-18 18:30:00	AAPL	Stock	175.7309	175.9	175.73	175.84	22296.0
2023-05-18 19:00:00	AAPL	Stock	175.81	175.81	175.75	175.75	20349.0
2023-05-18 19:30:00	AAPL	Stock	175.75	175.9	175.65	175.8999	35286.0
2023-05-18 04:00:00	MSFT	Stock	314.29	314.9	314.29	314.9	692.0
2023-05-18 04:30:00	MSFT	Stock	314.64	314.8	314.55	314.55	400.0
2023-05-18 05:00:00	MSFT	Stock	314.2	314.33	314.18	314.33	689.0
2023-05-18 05:30:00	MSFT	Stock	314.62	314.63	314.28	314.28	323.0
2023-05-18 06:00:00	MSFT	Stock	314.21	314.4	314.2	314.4	446.0
2023-05-18 07:00:00	MSFT	Stock	314.42	314.65	314.42	314.63	4321.0
2023-05-18 07:30:00	MSFT	Stock	314.57	314.62	314.5	314.62	854.0
2023-05-18 08:00:00	MSFT	Stock	314.4986	315.2	313.71	314.6	20121.0
2023-05-18 08:30:00	MSFT	Stock	314.6	314.6	314.0	314.26	28327.0
2023-05-18 09:00:00	MSFT	Stock	314.26	314.95	314.26	314.59	18297.0
2023-05-18 09:30:00	MSFT	Stock	314.53	315.87	313.72	315.34	2218257.0
2023-05-18 10:00:00	MSFT	Stock	315.35	316.54	314.53	316.2432	1506106.0
2023-05-18 10:30:00	MSFT	Stock	316.25	316.77	315.76	315.96	1180067.0
2023-05-18 11:00:00	MSFT	Stock	315.92	317.61	315.865	317.37	1184201.0
2023-05-18 11:30:00	MSFT	Stock	317.39	318.0	316.79	317.0	1012603.0
2023-05-18 12:00:00	MSFT	Stock	317.01	317.49	316.4	316.7329	992390.0
2023-05-18 12:30:00	MSFT	Stock	316.71	317.125	315.965	316.23	888929.0
2023-05-18 13:00:00	MSFT	Stock	316.23	317.51	316.23	316.6	857912.0

> showing 50 of 101,423 rows — these rows as CSV

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