PREVIEW / stock_30min / 2023-08-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-18.parquet
  size:    2.0 MB
  rows:    99,366
  symbols: 1,444

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-08-18 04:00:00	AAPL	Stock	173.4	173.83	173.37	173.4	11555.0
2023-08-18 04:30:00	AAPL	Stock	173.4	173.56	173.4	173.5	5635.0
2023-08-18 05:00:00	AAPL	Stock	173.55	173.62	173.19	173.19	5070.0
2023-08-18 05:30:00	AAPL	Stock	173.2	173.37	173.03	173.16	8506.0
2023-08-18 06:00:00	AAPL	Stock	173.16	173.28	173.11	173.11	15254.0
2023-08-18 06:30:00	AAPL	Stock	173.1	173.12	172.89	173.03	9181.0
2023-08-18 07:00:00	AAPL	Stock	173.1	173.12	172.11	172.11	61126.0
2023-08-18 07:30:00	AAPL	Stock	172.12	172.4	171.96	172.36	104528.0
2023-08-18 08:00:00	AAPL	Stock	173.01	174.0	171.93	172.2	261989.0
2023-08-18 08:30:00	AAPL	Stock	172.22	172.59	172.05	172.5	120473.0
2023-08-18 09:00:00	AAPL	Stock	172.47	172.8	171.7	172.31	283581.0
2023-08-18 09:30:00	AAPL	Stock	172.3	173.35	171.96	172.48	7252654.0
2023-08-18 10:00:00	AAPL	Stock	172.46	173.36	172.4314	172.8	3840702.0
2023-08-18 10:30:00	AAPL	Stock	172.81	173.77	172.76	173.71	3227393.0
2023-08-18 11:00:00	AAPL	Stock	173.7059	173.95	173.33	173.46	2237868.0
2023-08-18 11:30:00	AAPL	Stock	173.45	174.37	173.281	174.315	2313769.0
2023-08-18 12:00:00	AAPL	Stock	174.3	174.44	173.7401	173.82	2158055.0
2023-08-18 12:30:00	AAPL	Stock	173.82	174.365	173.8	173.9782	1666167.0
2023-08-18 13:00:00	AAPL	Stock	173.98	174.36	173.8201	174.275	1888723.0
2023-08-18 13:30:00	AAPL	Stock	174.275	174.47	174.125	174.41	1577083.0
2023-08-18 14:00:00	AAPL	Stock	174.41	174.7499	174.295	174.55	2099866.0
2023-08-18 14:30:00	AAPL	Stock	174.535	174.88	174.34	174.42	1861531.0
2023-08-18 15:00:00	AAPL	Stock	174.425	174.55	174.095	174.495	2052161.0
2023-08-18 15:30:00	AAPL	Stock	174.49	175.1	174.15	174.49	5429998.0
2023-08-18 16:00:00	AAPL	Stock	174.5	174.65	174.42	174.45	8532626.0
2023-08-18 16:30:00	AAPL	Stock	174.46	174.49	174.27	174.36	183444.0
2023-08-18 17:00:00	AAPL	Stock	174.34	174.5	174.33	174.49	7756.0
2023-08-18 17:30:00	AAPL	Stock	174.52	174.58	174.5	174.57	12709.0
2023-08-18 18:00:00	AAPL	Stock	174.56	174.6	174.49	174.55	6213.0
2023-08-18 18:30:00	AAPL	Stock	174.6	174.6	174.5	174.5	8024.0
2023-08-18 19:00:00	AAPL	Stock	174.5	174.52	174.47	174.5	18214.0
2023-08-18 19:30:00	AAPL	Stock	174.49	174.7	174.47	174.7	15723.0
2023-08-18 04:00:00	MSFT	Stock	315.65	315.99	315.05	315.05	4817.0
2023-08-18 04:30:00	MSFT	Stock	315.0	315.3	314.99	315.3	2683.0
2023-08-18 05:00:00	MSFT	Stock	315.5	315.5	315.06	315.06	200.0
2023-08-18 05:30:00	MSFT	Stock	315.02	315.84	314.99	315.28	2480.0
2023-08-18 06:00:00	MSFT	Stock	315.16	315.41	315.16	315.23	1168.0
2023-08-18 06:30:00	MSFT	Stock	314.85	314.85	314.52	314.52	838.0
2023-08-18 07:00:00	MSFT	Stock	314.77	314.77	313.46	313.46	10766.0
2023-08-18 07:30:00	MSFT	Stock	313.47	313.64	312.81	313.41	14240.0
2023-08-18 08:00:00	MSFT	Stock	314.73	315.99	312.65	312.95	34924.0
2023-08-18 08:30:00	MSFT	Stock	312.9499	313.43	312.72	313.31	34122.0
2023-08-18 09:00:00	MSFT	Stock	313.3	314.99	311.95	314.44	90045.0
2023-08-18 09:30:00	MSFT	Stock	314.5	315.2	312.57	313.3101	3184630.0
2023-08-18 10:00:00	MSFT	Stock	313.31	313.8	311.5508	312.12	1563289.0
2023-08-18 10:30:00	MSFT	Stock	312.12	314.46	312.09	314.27	940591.0
2023-08-18 11:00:00	MSFT	Stock	314.3	315.71	314.066	314.8504	1216078.0
2023-08-18 11:30:00	MSFT	Stock	314.8219	316.46	314.103	316.3	818862.0
2023-08-18 12:00:00	MSFT	Stock	316.28	316.91	315.21	315.3888	1042204.0
2023-08-18 12:30:00	MSFT	Stock	315.31	316.75	315.23	315.6699	577797.0

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

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