PREVIEW / stock_30min / 2023-07-19

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-19.parquet
  size:    2.1 MB
  rows:    102,485
  symbols: 1,553

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-19 04:00:00	AAPL	Stock	193.64	193.64	193.5	193.63	4217.0
2023-07-19 04:30:00	AAPL	Stock	193.63	193.66	193.45	193.6	2872.0
2023-07-19 05:00:00	AAPL	Stock	193.55	193.55	193.39	193.41	1579.0
2023-07-19 05:30:00	AAPL	Stock	193.57	193.66	193.57	193.59	1986.0
2023-07-19 06:00:00	AAPL	Stock	193.53	193.54	193.29	193.29	9060.0
2023-07-19 06:30:00	AAPL	Stock	193.27	193.28	193.11	193.12	3256.0
2023-07-19 07:00:00	AAPL	Stock	193.38	193.66	193.38	193.47	26525.0
2023-07-19 07:30:00	AAPL	Stock	193.49	193.49	193.25	193.4	19535.0
2023-07-19 08:00:00	AAPL	Stock	193.41	193.96	193.2607	193.5	70262.0
2023-07-19 08:30:00	AAPL	Stock	193.4009	193.79	193.4	193.67	56924.0
2023-07-19 09:00:00	AAPL	Stock	193.67	193.71	192.96	193.07	195406.0
2023-07-19 09:30:00	AAPL	Stock	193.1	193.54	192.69	192.81	4965736.0
2023-07-19 10:00:00	AAPL	Stock	192.82	193.05	192.65	192.78	2919846.0
2023-07-19 10:30:00	AAPL	Stock	192.78	193.35	192.7	192.9472	2400261.0
2023-07-19 11:00:00	AAPL	Stock	192.95	193.39	192.79	193.131	1644350.0
2023-07-19 11:30:00	AAPL	Stock	193.13	193.6	193.1	193.38	1671510.0
2023-07-19 12:00:00	AAPL	Stock	193.37	198.23	193.36	195.11	20457689.0
2023-07-19 12:30:00	AAPL	Stock	195.11	195.7	194.6	195.07	5148013.0
2023-07-19 13:00:00	AAPL	Stock	195.1	195.1899	194.31	194.34	3191375.0
2023-07-19 13:30:00	AAPL	Stock	194.34	194.9	194.0652	194.8	2279280.0
2023-07-19 14:00:00	AAPL	Stock	194.81	194.9301	194.275	194.645	2224216.0
2023-07-19 14:30:00	AAPL	Stock	194.65	195.56	194.64	195.55	2381795.0
2023-07-19 15:00:00	AAPL	Stock	195.55	195.72	195.22	195.38	2384363.0
2023-07-19 15:30:00	AAPL	Stock	195.37	195.45	194.93	195.08	3890558.0
2023-07-19 16:00:00	AAPL	Stock	195.0	195.23	194.73	194.75	8244424.0
2023-07-19 16:30:00	AAPL	Stock	194.73	195.1	194.73	194.89	107725.0
2023-07-19 17:00:00	AAPL	Stock	194.88	194.93	194.7	194.7398	22142.0
2023-07-19 17:30:00	AAPL	Stock	194.71	194.8	194.4201	194.6	35798.0
2023-07-19 18:00:00	AAPL	Stock	194.6433	194.7	194.1	194.2668	40540.0
2023-07-19 18:30:00	AAPL	Stock	194.12	194.25	194.0101	194.02	44819.0
2023-07-19 19:00:00	AAPL	Stock	194.03	194.1	193.39	193.95	73992.0
2023-07-19 19:30:00	AAPL	Stock	193.9	193.94	193.63	193.73	26261.0
2023-07-19 04:00:00	MSFT	Stock	360.79	362.9	360.0	362.6	32859.0
2023-07-19 04:30:00	MSFT	Stock	362.8	362.9	361.83	361.83	11578.0
2023-07-19 05:00:00	MSFT	Stock	362.01	362.01	361.6	362.0	2806.0
2023-07-19 05:30:00	MSFT	Stock	362.3	362.53	362.28	362.28	1208.0
2023-07-19 06:00:00	MSFT	Stock	362.2	362.4	362.05	362.3	6915.0
2023-07-19 06:30:00	MSFT	Stock	361.91	362.0	361.7	361.86	9749.0
2023-07-19 07:00:00	MSFT	Stock	361.9	362.19	361.21	361.92	23305.0
2023-07-19 07:30:00	MSFT	Stock	361.91	362.0	361.26	361.7	14511.0
2023-07-19 08:00:00	MSFT	Stock	362.0	363.0	361.1	361.74	96584.0
2023-07-19 08:30:00	MSFT	Stock	361.7	361.9	360.0	360.85	66450.0
2023-07-19 09:00:00	MSFT	Stock	360.85	361.79	360.6	361.75	66117.0
2023-07-19 09:30:00	MSFT	Stock	361.75	362.46	357.8	359.37	4644534.0
2023-07-19 10:00:00	MSFT	Stock	359.395	360.0	357.25	357.69	1972741.0
2023-07-19 10:30:00	MSFT	Stock	357.67	361.56	357.6	359.49	2049004.0
2023-07-19 11:00:00	MSFT	Stock	359.51	360.72	358.845	360.08	1166000.0
2023-07-19 11:30:00	MSFT	Stock	360.08	360.35	358.83	359.235	1058380.0
2023-07-19 12:00:00	MSFT	Stock	359.21	359.65	355.09	355.77	3172531.0
2023-07-19 12:30:00	MSFT	Stock	355.74	356.79	354.36	354.69	1352004.0

> showing 50 of 102,485 rows — these rows as CSV

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