PREVIEW / stock_30min / 2023-07-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-18.parquet
  size:    2.1 MB
  rows:    101,421
  symbols: 1,540

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-18 04:00:00	AAPL	Stock	193.82	193.91	193.8	193.9	5556.0
2023-07-18 04:30:00	AAPL	Stock	193.91	193.94	193.71	193.73	3896.0
2023-07-18 05:00:00	AAPL	Stock	193.77	193.81	193.77	193.81	645.0
2023-07-18 05:30:00	AAPL	Stock	193.74	193.79	193.74	193.78	3214.0
2023-07-18 06:00:00	AAPL	Stock	193.81	193.81	193.71	193.71	1040.0
2023-07-18 06:30:00	AAPL	Stock	193.67	193.81	193.67	193.81	3181.0
2023-07-18 07:00:00	AAPL	Stock	193.89	193.92	193.74	193.75	17657.0
2023-07-18 07:30:00	AAPL	Stock	193.75	193.81	193.72	193.75	11522.0
2023-07-18 08:00:00	AAPL	Stock	193.82	194.35	193.7103	193.8	90185.0
2023-07-18 08:30:00	AAPL	Stock	193.82	193.94	193.42	193.68	118345.0
2023-07-18 09:00:00	AAPL	Stock	193.74	193.8	193.04	193.28	159417.0
2023-07-18 09:30:00	AAPL	Stock	193.4	193.58	192.795	193.3201	5123768.0
2023-07-18 10:00:00	AAPL	Stock	193.325	193.45	192.8	192.985	2794920.0
2023-07-18 10:30:00	AAPL	Stock	193.0	193.57	192.89	193.365	2450000.0
2023-07-18 11:00:00	AAPL	Stock	193.37	193.655	193.1104	193.145	1800625.0
2023-07-18 11:30:00	AAPL	Stock	193.145	193.26	192.76	193.2	2987446.0
2023-07-18 12:00:00	AAPL	Stock	193.2001	193.245	192.57	192.705	2428689.0
2023-07-18 12:30:00	AAPL	Stock	192.7	192.73	192.415	192.52	2140819.0
2023-07-18 13:00:00	AAPL	Stock	192.51	192.9399	192.5	192.935	1430295.0
2023-07-18 13:30:00	AAPL	Stock	192.94	193.17	192.9	192.985	1161397.0
2023-07-18 14:00:00	AAPL	Stock	192.99	193.79	192.95	193.76	2083546.0
2023-07-18 14:30:00	AAPL	Stock	193.77	193.97	193.54	193.7899	1935458.0
2023-07-18 15:00:00	AAPL	Stock	193.7925	194.1477	193.5314	193.94	2407042.0
2023-07-18 15:30:00	AAPL	Stock	193.92	194.33	193.54	193.73	5894880.0
2023-07-18 16:00:00	AAPL	Stock	193.73	193.73	193.3	193.37	5370983.0
2023-07-18 16:30:00	AAPL	Stock	193.37	193.73	193.3	193.33	38923.0
2023-07-18 17:00:00	AAPL	Stock	193.35	193.4	193.32	193.38	8749.0
2023-07-18 17:30:00	AAPL	Stock	193.35	193.4	193.33	193.38	16031.0
2023-07-18 18:00:00	AAPL	Stock	193.3512	193.73	193.3512	193.4504	17927.0
2023-07-18 18:30:00	AAPL	Stock	193.5	193.55	193.381	193.41	9038.0
2023-07-18 19:00:00	AAPL	Stock	193.47	193.47	193.38	193.38	6004.0
2023-07-18 19:30:00	AAPL	Stock	193.38	193.46	193.34	193.41	25739.0
2023-07-18 04:00:00	MSFT	Stock	344.9	345.31	344.9	345.29	1897.0
2023-07-18 04:30:00	MSFT	Stock	345.21	345.21	344.3	344.53	615.0
2023-07-18 05:00:00	MSFT	Stock	344.55	344.55	344.16	344.16	1047.0
2023-07-18 05:30:00	MSFT	Stock	344.23	344.23	344.23	344.23	195.0
2023-07-18 06:30:00	MSFT	Stock	344.75	346.0	344.75	346.0	5574.0
2023-07-18 07:00:00	MSFT	Stock	345.72	346.16	345.72	346.0	5901.0
2023-07-18 07:30:00	MSFT	Stock	345.81	345.99	345.43	345.91	4464.0
2023-07-18 08:00:00	MSFT	Stock	345.48	346.95	344.55	346.7759	33985.0
2023-07-18 08:30:00	MSFT	Stock	346.33	347.0	345.6823	345.7	30614.0
2023-07-18 09:00:00	MSFT	Stock	346.0	346.79	345.79	345.98	26430.0
2023-07-18 09:30:00	MSFT	Stock	346.02	346.03	342.17	343.37	2448094.0
2023-07-18 10:00:00	MSFT	Stock	343.39	344.1999	342.62	343.37	1068436.0
2023-07-18 10:30:00	MSFT	Stock	343.3606	344.53	343.22	344.3645	947345.0
2023-07-18 11:00:00	MSFT	Stock	344.37	344.79	344.02	344.16	655817.0
2023-07-18 11:30:00	MSFT	Stock	344.17	358.95	344.15	357.165	10197530.0
2023-07-18 12:00:00	MSFT	Stock	357.19	364.16	356.6	364.08	6993675.0
2023-07-18 12:30:00	MSFT	Stock	364.05	366.78	362.21	362.58	6937787.0
2023-07-18 13:00:00	MSFT	Stock	362.5974	364.5	362.5	363.73	2918796.0

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

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