PREVIEW / stock_30min / 2024-07-17

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-17.parquet
  size:    2.1 MB
  rows:    101,432
  symbols: 899

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-17 04:00:00	AAPL	Stock	233.41	233.41	230.28	230.45	57405.0
2024-07-17 04:30:00	AAPL	Stock	230.4	231.15	230.39	231.14	13414.0
2024-07-17 05:00:00	AAPL	Stock	231.0	231.6	231.0	231.45	11367.0
2024-07-17 05:30:00	AAPL	Stock	231.38	231.38	230.92	231.0	12772.0
2024-07-17 06:00:00	AAPL	Stock	230.94	231.01	230.6	230.64	18389.0
2024-07-17 06:30:00	AAPL	Stock	230.63	231.0	230.02	230.15	29842.0
2024-07-17 07:00:00	AAPL	Stock	230.49	230.8	229.5	230.31	90466.0
2024-07-17 07:30:00	AAPL	Stock	230.31	230.31	229.5	229.8	77673.0
2024-07-17 08:00:00	AAPL	Stock	230.5469	234.27	229.4121	230.1	342081.0
2024-07-17 08:30:00	AAPL	Stock	230.1	230.35	229.85	230.1002	68440.0
2024-07-17 09:00:00	AAPL	Stock	230.1001	230.31	229.25	229.4	152844.0
2024-07-17 09:30:00	AAPL	Stock	229.46	231.4599	227.9	229.01	8189130.0
2024-07-17 10:00:00	AAPL	Stock	229.0	229.065	226.64	227.82	4953113.0
2024-07-17 10:30:00	AAPL	Stock	227.8	228.4889	227.45	227.77	2184754.0
2024-07-17 11:00:00	AAPL	Stock	227.765	228.835	227.74	228.62	2146778.0
2024-07-17 11:30:00	AAPL	Stock	228.63	229.01	228.095	228.71	1886218.0
2024-07-17 12:00:00	AAPL	Stock	228.72	228.83	228.27	228.48	1369130.0
2024-07-17 12:30:00	AAPL	Stock	228.49	229.01	228.32	228.71	1646280.0
2024-07-17 13:00:00	AAPL	Stock	228.72	228.795	228.15	228.69	1335329.0
2024-07-17 13:30:00	AAPL	Stock	228.68	228.92	228.26	228.631	1335239.0
2024-07-17 14:00:00	AAPL	Stock	228.64	229.78	228.5075	229.5191	2118497.0
2024-07-17 14:30:00	AAPL	Stock	229.518	229.8	228.96	229.2	1597668.0
2024-07-17 15:00:00	AAPL	Stock	229.195	229.67	229.01	229.14	1621139.0
2024-07-17 15:30:00	AAPL	Stock	229.14	229.82	228.57	228.88	4837620.0
2024-07-17 16:00:00	AAPL	Stock	228.88	229.17	228.59	229.14	7607700.0
2024-07-17 16:30:00	AAPL	Stock	229.1301	229.34	228.88	229.05	75776.0
2024-07-17 17:00:00	AAPL	Stock	229.05	229.17	228.94	228.94	10456.0
2024-07-17 17:30:00	AAPL	Stock	228.97	228.97	228.86	228.93	6940.0
2024-07-17 18:00:00	AAPL	Stock	228.97	229.35	228.97	229.05	21637.0
2024-07-17 18:30:00	AAPL	Stock	229.05	229.19	229.0106	229.1859	10275.0
2024-07-17 19:00:00	AAPL	Stock	229.1	229.2882	229.05	229.19	14755.0
2024-07-17 19:30:00	AAPL	Stock	229.22	229.3438	229.13	229.13	11887.0
2024-07-17 04:00:00	MSFT	Stock	446.0	446.0	442.79	442.79	6308.0
2024-07-17 04:30:00	MSFT	Stock	443.04	443.29	442.51	443.2	2610.0
2024-07-17 05:00:00	MSFT	Stock	443.29	443.3	443.05	443.3	1589.0
2024-07-17 05:30:00	MSFT	Stock	443.0	444.2	442.62	444.2	2378.0
2024-07-17 06:00:00	MSFT	Stock	444.42	444.42	443.9	443.9	1050.0
2024-07-17 06:30:00	MSFT	Stock	443.65	445.49	443.65	444.77	7870.0
2024-07-17 07:00:00	MSFT	Stock	444.99	445.33	443.51	443.64	13700.0
2024-07-17 07:30:00	MSFT	Stock	443.5	444.0	442.8	443.55	9185.0
2024-07-17 08:00:00	MSFT	Stock	445.09	447.33	442.7425	444.37	22364.0
2024-07-17 08:30:00	MSFT	Stock	444.26	444.5	444.0	444.17	12938.0
2024-07-17 09:00:00	MSFT	Stock	444.2	444.2	442.08	442.37	42190.0
2024-07-17 09:30:00	MSFT	Stock	442.58	444.35	441.0	443.83	2111626.0
2024-07-17 10:00:00	MSFT	Stock	443.775	443.8818	440.01	441.13	1028625.0
2024-07-17 10:30:00	MSFT	Stock	441.04	442.24	439.66	440.0	970315.0
2024-07-17 11:00:00	MSFT	Stock	440.02	441.56	439.18	441.18	867637.0
2024-07-17 11:30:00	MSFT	Stock	441.25	441.52	440.3207	440.75	427221.0
2024-07-17 12:00:00	MSFT	Stock	440.8	441.07	440.15	440.44	471390.0
2024-07-17 12:30:00	MSFT	Stock	440.49	441.52	439.94	440.8901	659738.0

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

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