PREVIEW / stock_30min / 2024-07-02

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-02.parquet
  size:    2.0 MB
  rows:    96,805
  symbols: 917

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-02 04:00:00	AAPL	Stock	216.5	216.5	215.99	216.38	11609.0
2024-07-02 04:30:00	AAPL	Stock	216.38	216.39	216.0	216.1	11083.0
2024-07-02 05:00:00	AAPL	Stock	216.07	216.11	216.06	216.09	1956.0
2024-07-02 05:30:00	AAPL	Stock	216.05	216.05	215.57	215.9	8537.0
2024-07-02 06:00:00	AAPL	Stock	215.9	215.9	215.9	215.9	150.0
2024-07-02 06:30:00	AAPL	Stock	215.89	216.15	215.89	215.99	3508.0
2024-07-02 07:00:00	AAPL	Stock	216.05	216.09	215.5	215.75	14264.0
2024-07-02 07:30:00	AAPL	Stock	215.75	215.8	215.55	215.7	9908.0
2024-07-02 08:00:00	AAPL	Stock	215.92	216.49	215.51	215.9	90745.0
2024-07-02 08:30:00	AAPL	Stock	215.93	215.9999	215.56	215.7	38599.0
2024-07-02 09:00:00	AAPL	Stock	215.76	216.14	215.67	216.03	114511.0
2024-07-02 09:30:00	AAPL	Stock	216.15	218.01	215.1	217.985	6777572.0
2024-07-02 10:00:00	AAPL	Stock	218.0	218.9	217.67	218.7099	4855370.0
2024-07-02 10:30:00	AAPL	Stock	218.71	219.86	218.5638	219.5398	4836059.0
2024-07-02 11:00:00	AAPL	Stock	219.54	220.34	218.99	219.5102	5043853.0
2024-07-02 11:30:00	AAPL	Stock	219.53	220.11	219.25	219.27	2293241.0
2024-07-02 12:00:00	AAPL	Stock	219.26	219.44	218.76	219.165	1876461.0
2024-07-02 12:30:00	AAPL	Stock	219.16	219.4	218.92	219.17	1399592.0
2024-07-02 13:00:00	AAPL	Stock	219.1601	219.5	218.8308	219.4	1282911.0
2024-07-02 13:30:00	AAPL	Stock	219.4001	219.87	219.27	219.5998	1370213.0
2024-07-02 14:00:00	AAPL	Stock	219.59	220.07	219.47	220.03	1759681.0
2024-07-02 14:30:00	AAPL	Stock	220.03	220.33	219.61	219.78	1955381.0
2024-07-02 15:00:00	AAPL	Stock	219.78	219.92	219.51	219.62	1473785.0
2024-07-02 15:30:00	AAPL	Stock	219.61	220.38	219.36	220.37	4040907.0
2024-07-02 16:00:00	AAPL	Stock	220.34	220.39	219.7	220.27	8571160.0
2024-07-02 16:30:00	AAPL	Stock	219.74	220.27	219.44	219.68	141623.0
2024-07-02 17:00:00	AAPL	Stock	219.68	219.7	219.43	219.6863	53123.0
2024-07-02 17:30:00	AAPL	Stock	219.58	219.62	219.5198	219.55	6199.0
2024-07-02 18:00:00	AAPL	Stock	219.6	219.7	219.51	219.51	20263.0
2024-07-02 18:30:00	AAPL	Stock	219.6	219.68	219.57	219.5915	10281.0
2024-07-02 19:00:00	AAPL	Stock	219.6	219.6	219.3778	219.54	13128.0
2024-07-02 19:30:00	AAPL	Stock	219.44	219.5489	219.35	219.41	20362.0
2024-07-02 04:00:00	MSFT	Stock	456.2	456.2	455.15	455.69	5420.0
2024-07-02 04:30:00	MSFT	Stock	455.74	456.0	455.71	455.94	821.0
2024-07-02 05:00:00	MSFT	Stock	456.07	456.5	455.93	456.05	2408.0
2024-07-02 05:30:00	MSFT	Stock	455.6	455.6	455.45	455.45	1092.0
2024-07-02 06:00:00	MSFT	Stock	455.34	455.34	455.34	455.34	100.0
2024-07-02 06:30:00	MSFT	Stock	455.48	455.56	455.48	455.56	342.0
2024-07-02 07:00:00	MSFT	Stock	455.4	455.4	454.56	454.56	3836.0
2024-07-02 07:30:00	MSFT	Stock	454.7	454.76	454.38	454.38	2456.0
2024-07-02 08:00:00	MSFT	Stock	455.4986	456.4	454.29	454.7402	15999.0
2024-07-02 08:30:00	MSFT	Stock	455.0318	455.3039	454.7	455.3039	8485.0
2024-07-02 09:00:00	MSFT	Stock	455.25	455.25	453.2	453.2	25677.0
2024-07-02 09:30:00	MSFT	Stock	453.18	456.78	453.113	455.755	1331957.0
2024-07-02 10:00:00	MSFT	Stock	455.81	457.9499	455.53	456.69	636609.0
2024-07-02 10:30:00	MSFT	Stock	456.72	457.7	456.46	456.975	503904.0
2024-07-02 11:00:00	MSFT	Stock	456.99	457.06	455.85	456.82	480707.0
2024-07-02 11:30:00	MSFT	Stock	456.82	457.027	455.58	455.615	323792.0
2024-07-02 12:00:00	MSFT	Stock	455.62	455.7175	454.85	455.69	267176.0
2024-07-02 12:30:00	MSFT	Stock	455.655	456.53	455.35	456.4899	244533.0

> showing 50 of 96,805 rows — these rows as CSV

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