PREVIEW / stock_30min / 2024-10-18

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-10-18.parquet
  size:    2.1 MB
  rows:    99,430
  symbols: 736

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-10-18 04:00:00	AAPL	Stock	233.3	234.7	233.3	234.47	54261.0
2024-10-18 04:30:00	AAPL	Stock	234.5	234.52	234.1	234.41	13633.0
2024-10-18 05:00:00	AAPL	Stock	234.5	234.89	234.47	234.7	17249.0
2024-10-18 05:30:00	AAPL	Stock	234.8	235.2	234.75	235.02	32841.0
2024-10-18 06:00:00	AAPL	Stock	234.95	235.34	234.95	235.29	19242.0
2024-10-18 06:30:00	AAPL	Stock	235.3	236.05	235.24	235.75	57207.0
2024-10-18 07:00:00	AAPL	Stock	235.76	236.98	235.21	236.61	139561.0
2024-10-18 07:30:00	AAPL	Stock	236.59	236.99	236.3	236.35	76185.0
2024-10-18 08:00:00	AAPL	Stock	235.69	236.99	231.57	236.79	257403.0
2024-10-18 08:30:00	AAPL	Stock	236.75	237.0	236.2625	236.3124	111860.0
2024-10-18 09:00:00	AAPL	Stock	236.35	237.23	235.18	235.85	691211.0
2024-10-18 09:30:00	AAPL	Stock	236.18	236.18	234.01	235.42	10457724.0
2024-10-18 10:00:00	AAPL	Stock	235.43	235.8799	234.64	234.77	2718588.0
2024-10-18 10:30:00	AAPL	Stock	234.76	234.92	234.275	234.69	1562344.0
2024-10-18 11:00:00	AAPL	Stock	234.7	235.15	234.64	235.04	1238531.0
2024-10-18 11:30:00	AAPL	Stock	235.04	235.34	234.75	235.0275	955587.0
2024-10-18 12:00:00	AAPL	Stock	235.02	235.15	234.8601	234.99	638339.0
2024-10-18 12:30:00	AAPL	Stock	234.99	235.645	234.94	235.464	1078364.0
2024-10-18 13:00:00	AAPL	Stock	235.465	235.86	235.18	235.24	1182539.0
2024-10-18 13:30:00	AAPL	Stock	235.24	235.72	235.0416	235.648	957384.0
2024-10-18 14:00:00	AAPL	Stock	235.64	235.75	235.31	235.53	834506.0
2024-10-18 14:30:00	AAPL	Stock	235.54	235.64	235.41	235.56	665698.0
2024-10-18 15:00:00	AAPL	Stock	235.55	235.555	235.03	235.3	1209268.0
2024-10-18 15:30:00	AAPL	Stock	235.305	235.305	234.8	234.98	2491355.0
2024-10-18 16:00:00	AAPL	Stock	235.0	235.08	234.91	234.93	5804329.0
2024-10-18 16:30:00	AAPL	Stock	234.94	235.07	234.94	235.02	880665.0
2024-10-18 17:00:00	AAPL	Stock	235.02	235.03	234.95	234.95	34046.0
2024-10-18 17:30:00	AAPL	Stock	234.95	234.95	234.88	234.898	6111.0
2024-10-18 18:00:00	AAPL	Stock	234.89	234.9	234.85	234.85	6597.0
2024-10-18 18:30:00	AAPL	Stock	234.85	234.87	234.7	234.7856	5195.0
2024-10-18 19:00:00	AAPL	Stock	234.86	234.88	234.792	234.87	1305.0
2024-10-18 19:30:00	AAPL	Stock	234.88	234.9	234.85	234.89	2685.0
2024-10-18 04:00:00	MSFT	Stock	417.25	418.38	417.25	417.88	3804.0
2024-10-18 04:30:00	MSFT	Stock	418.0	418.19	418.0	418.19	280.0
2024-10-18 05:00:00	MSFT	Stock	417.9	417.9	417.41	417.41	1377.0
2024-10-18 05:30:00	MSFT	Stock	417.0	417.6	417.0	417.0	549.0
2024-10-18 06:00:00	MSFT	Stock	417.0	417.0	417.0	417.0	187.0
2024-10-18 06:30:00	MSFT	Stock	417.32	417.32	417.32	417.32	800.0
2024-10-18 07:00:00	MSFT	Stock	417.2	417.25	416.81	417.25	3404.0
2024-10-18 07:30:00	MSFT	Stock	417.17	417.25	417.15	417.17	2721.0
2024-10-18 08:00:00	MSFT	Stock	417.05	417.46	416.8	416.8002	12730.0
2024-10-18 08:30:00	MSFT	Stock	417.1781	417.18	416.87	416.87	10274.0
2024-10-18 09:00:00	MSFT	Stock	417.0	419.42	415.76	417.17	133302.0
2024-10-18 09:30:00	MSFT	Stock	417.17	419.65	416.7	417.31	3402524.0
2024-10-18 10:00:00	MSFT	Stock	417.365	418.03	416.8	417.5131	438861.0
2024-10-18 10:30:00	MSFT	Stock	417.52	417.67	416.2703	416.41	338239.0
2024-10-18 11:00:00	MSFT	Stock	416.405	418.2782	416.32	418.2599	327483.0
2024-10-18 11:30:00	MSFT	Stock	418.235	418.73	416.68	416.97	309790.0
2024-10-18 12:00:00	MSFT	Stock	416.9901	417.07	416.2601	416.6919	269302.0
2024-10-18 12:30:00	MSFT	Stock	416.72	417.75	416.564	417.17	259046.0

> showing 50 of 99,430 rows — these rows as CSV

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