PREVIEW / stock_30min / 2023-07-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-24.parquet
  size:    2.1 MB
  rows:    101,036
  symbols: 1,561

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-24 04:00:00	AAPL	Stock	192.6	192.6	192.38	192.38	621.0
2023-07-24 04:30:00	AAPL	Stock	192.42	192.48	192.3	192.47	4426.0
2023-07-24 05:00:00	AAPL	Stock	192.59	192.7	192.59	192.7	2097.0
2023-07-24 05:30:00	AAPL	Stock	192.73	192.75	192.5	192.5	1872.0
2023-07-24 06:00:00	AAPL	Stock	192.49	192.77	192.36	192.55	10531.0
2023-07-24 06:30:00	AAPL	Stock	192.58	193.26	192.58	193.0	23276.0
2023-07-24 07:00:00	AAPL	Stock	193.02	193.02	192.77	192.95	42852.0
2023-07-24 07:30:00	AAPL	Stock	192.98	193.14	192.9	192.93	54012.0
2023-07-24 08:00:00	AAPL	Stock	192.9	193.13	191.9	192.85	96355.0
2023-07-24 08:30:00	AAPL	Stock	192.8208	192.99	192.7	192.7	63416.0
2023-07-24 09:00:00	AAPL	Stock	192.77	193.41	192.53	193.4	116052.0
2023-07-24 09:30:00	AAPL	Stock	193.41	194.91	193.18	193.51	7090066.0
2023-07-24 10:00:00	AAPL	Stock	193.51	193.83	192.96	193.73	3012785.0
2023-07-24 10:30:00	AAPL	Stock	193.7278	193.82	193.21	193.38	1771510.0
2023-07-24 11:00:00	AAPL	Stock	193.38	193.74	192.98	193.27	1677735.0
2023-07-24 11:30:00	AAPL	Stock	193.26	193.34	192.83	193.12	1597918.0
2023-07-24 12:00:00	AAPL	Stock	193.12	193.4201	192.89	193.165	1312541.0
2023-07-24 12:30:00	AAPL	Stock	193.18	193.25	192.89	193.06	1132226.0
2023-07-24 13:00:00	AAPL	Stock	193.065	193.1	192.91	192.98	1043030.0
2023-07-24 13:30:00	AAPL	Stock	192.97	193.11	192.765	192.966	1300328.0
2023-07-24 14:00:00	AAPL	Stock	192.98	193.4599	192.95	193.245	1317936.0
2023-07-24 14:30:00	AAPL	Stock	193.2425	193.25	192.595	192.76	1961545.0
2023-07-24 15:00:00	AAPL	Stock	192.7529	192.88	192.35	192.37	1439300.0
2023-07-24 15:30:00	AAPL	Stock	192.3723	192.79	192.25	192.735	2944219.0
2023-07-24 16:00:00	AAPL	Stock	192.75	192.95	192.66	192.82	5415431.0
2023-07-24 16:30:00	AAPL	Stock	192.82	192.86	192.75	192.85	29213.0
2023-07-24 17:00:00	AAPL	Stock	192.83	192.85	192.75	192.76	11002.0
2023-07-24 17:30:00	AAPL	Stock	192.77	192.85	192.77	192.82	1643.0
2023-07-24 18:00:00	AAPL	Stock	192.81	192.82	192.76	192.7854	5626.0
2023-07-24 18:30:00	AAPL	Stock	192.7703	192.82	192.76	192.82	6094.0
2023-07-24 19:00:00	AAPL	Stock	192.83	193.23	192.76	193.23	17706.0
2023-07-24 19:30:00	AAPL	Stock	193.11	193.68	193.1	193.45	80673.0
2023-07-24 04:00:00	MSFT	Stock	345.7	346.83	345.7	346.0	4200.0
2023-07-24 04:30:00	MSFT	Stock	346.04	346.37	345.8	345.81	3561.0
2023-07-24 05:00:00	MSFT	Stock	345.82	346.2	345.76	346.2	6674.0
2023-07-24 05:30:00	MSFT	Stock	346.24	346.24	346.06	346.2	1577.0
2023-07-24 06:00:00	MSFT	Stock	345.92	346.25	345.68	345.68	3896.0
2023-07-24 06:30:00	MSFT	Stock	345.68	345.83	345.5	345.5	3044.0
2023-07-24 07:00:00	MSFT	Stock	345.5	346.18	345.27	346.18	13044.0
2023-07-24 07:30:00	MSFT	Stock	346.18	346.46	346.06	346.06	13699.0
2023-07-24 08:00:00	MSFT	Stock	345.45	346.4312	344.46	345.79	41581.0
2023-07-24 08:30:00	MSFT	Stock	345.79	346.0	345.58	345.9999	21934.0
2023-07-24 09:00:00	MSFT	Stock	346.0101	346.11	344.79	345.78	89662.0
2023-07-24 09:30:00	MSFT	Stock	345.82	346.92	342.31	343.58	3108723.0
2023-07-24 10:00:00	MSFT	Stock	343.575	346.2	343.33	345.8015	1538828.0
2023-07-24 10:30:00	MSFT	Stock	345.8	346.49	344.02	344.32	1315624.0
2023-07-24 11:00:00	MSFT	Stock	344.33	346.24	343.855	344.51	1253942.0
2023-07-24 11:30:00	MSFT	Stock	344.5	344.54	343.29	344.15	931098.0
2023-07-24 12:00:00	MSFT	Stock	344.17	345.03	343.6417	344.26	662019.0
2023-07-24 12:30:00	MSFT	Stock	344.26	344.63	343.82	343.9105	474683.0

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

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