PREVIEW / stock_30min / 2023-07-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-03.parquet
  size:    1.4 MB
  rows:    65,309
  symbols: 1,481

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-03 04:00:00	AAPL	Stock	193.99	194.25	193.73	193.73	35821.0
2023-07-03 04:30:00	AAPL	Stock	193.76	193.85	193.71	193.71	11922.0
2023-07-03 05:00:00	AAPL	Stock	193.72	193.8	193.68	193.7	9225.0
2023-07-03 05:30:00	AAPL	Stock	193.8	193.8	193.54	193.62	9426.0
2023-07-03 06:00:00	AAPL	Stock	193.63	193.63	193.0	193.43	10133.0
2023-07-03 06:30:00	AAPL	Stock	193.48	193.48	193.2	193.22	5498.0
2023-07-03 07:00:00	AAPL	Stock	193.31	193.65	193.22	193.61	66509.0
2023-07-03 07:30:00	AAPL	Stock	193.6	193.6	193.33	193.41	33430.0
2023-07-03 08:00:00	AAPL	Stock	193.43	195.27	193.25	193.5	205543.0
2023-07-03 08:30:00	AAPL	Stock	193.48	193.65	193.2	193.53	94293.0
2023-07-03 09:00:00	AAPL	Stock	193.51	193.95	193.37	193.8	184026.0
2023-07-03 09:30:00	AAPL	Stock	193.71	193.88	192.8	192.94	6773934.0
2023-07-03 10:00:00	AAPL	Stock	192.93	193.15	192.805	192.915	3103665.0
2023-07-03 10:30:00	AAPL	Stock	192.915	192.93	191.76	191.979	4305772.0
2023-07-03 11:00:00	AAPL	Stock	191.975	192.45	191.91	192.355	2682558.0
2023-07-03 11:30:00	AAPL	Stock	192.36	192.5	192.1601	192.23	1835144.0
2023-07-03 12:00:00	AAPL	Stock	192.225	192.31	192.04	192.115	1346805.0
2023-07-03 12:30:00	AAPL	Stock	192.11	192.55	192.01	192.47	2828814.0
2023-07-03 13:00:00	AAPL	Stock	192.46	192.57	192.04	192.36	2734746.0
2023-07-03 13:30:00	AAPL	Stock	192.32	192.46	192.3	192.45	27555.0
2023-07-03 14:00:00	AAPL	Stock	192.38	192.52	192.36	192.48	43635.0
2023-07-03 14:30:00	AAPL	Stock	192.45	192.46	192.42	192.43	2214.0
2023-07-03 15:00:00	AAPL	Stock	192.43	192.46	192.33	192.37	8006.0
2023-07-03 15:30:00	AAPL	Stock	192.37	192.46	192.33	192.41	18273.0
2023-07-03 16:00:00	AAPL	Stock	192.39	192.4	192.38	192.38	3694.0
2023-07-03 16:30:00	AAPL	Stock	192.42	192.45	192.4	192.45	4740.0
2023-07-03 04:00:00	MSFT	Stock	340.65	341.11	340.54	340.75	4781.0
2023-07-03 04:30:00	MSFT	Stock	340.96	341.21	340.88	340.9	1270.0
2023-07-03 05:00:00	MSFT	Stock	340.77	340.79	340.77	340.79	224.0
2023-07-03 05:30:00	MSFT	Stock	340.59	340.59	340.18	340.5	1927.0
2023-07-03 06:00:00	MSFT	Stock	340.56	340.56	339.05	339.9	2143.0
2023-07-03 06:30:00	MSFT	Stock	339.97	339.97	339.68	339.68	1293.0
2023-07-03 07:00:00	MSFT	Stock	339.9	340.05	339.47	339.5	9791.0
2023-07-03 07:30:00	MSFT	Stock	339.52	339.69	339.11	339.59	5000.0
2023-07-03 08:00:00	MSFT	Stock	339.86	342.42	339.23	339.5	23554.0
2023-07-03 08:30:00	MSFT	Stock	339.65	339.89	339.22	339.89	8915.0
2023-07-03 09:00:00	MSFT	Stock	339.71	339.8	338.5	339.5	31466.0
2023-07-03 09:30:00	MSFT	Stock	339.2	340.9	338.16	339.66	2233826.0
2023-07-03 10:00:00	MSFT	Stock	339.69	340.36	338.615	338.752	924186.0
2023-07-03 10:30:00	MSFT	Stock	338.74	338.75	336.91	336.95	1165905.0
2023-07-03 11:00:00	MSFT	Stock	336.955	337.462	336.571	336.9071	996537.0
2023-07-03 11:30:00	MSFT	Stock	336.89	337.34	336.88	336.9068	547463.0
2023-07-03 12:00:00	MSFT	Stock	336.93	337.53	336.765	336.9	555462.0
2023-07-03 12:30:00	MSFT	Stock	336.9	338.33	336.84	337.98	854391.0
2023-07-03 13:00:00	MSFT	Stock	337.99	338.27	337.5701	337.8	1438170.0
2023-07-03 13:30:00	MSFT	Stock	337.65	337.8	337.48	337.5	1520.0
2023-07-03 14:00:00	MSFT	Stock	337.6488	337.99	337.6003	337.91	12044.0
2023-07-03 14:30:00	MSFT	Stock	337.98	337.99	337.72	337.845	1166.0
2023-07-03 15:00:00	MSFT	Stock	337.85	337.85	337.85	337.85	200.0
2023-07-03 15:30:00	MSFT	Stock	337.8	338.09	337.8	337.97	827.0

> showing 50 of 65,309 rows — these rows as CSV

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