PREVIEW / stock_30min / 2023-09-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-01.parquet
  size:    2.0 MB
  rows:    97,225
  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-09-01 04:00:00	AAPL	Stock	188.32	188.32	188.15	188.23	4448.0
2023-09-01 04:30:00	AAPL	Stock	188.24	188.28	188.23	188.23	3136.0
2023-09-01 05:00:00	AAPL	Stock	188.28	188.5	188.28	188.4	8306.0
2023-09-01 05:30:00	AAPL	Stock	188.4	188.43	188.36	188.36	6448.0
2023-09-01 06:00:00	AAPL	Stock	188.37	188.48	188.35	188.48	6721.0
2023-09-01 06:30:00	AAPL	Stock	188.53	188.63	188.45	188.46	4257.0
2023-09-01 07:00:00	AAPL	Stock	188.49	188.66	188.49	188.64	9969.0
2023-09-01 07:30:00	AAPL	Stock	188.65	188.7	188.45	188.46	26655.0
2023-09-01 08:00:00	AAPL	Stock	188.65	188.7431	188.03	188.55	89916.0
2023-09-01 08:30:00	AAPL	Stock	188.57	189.39	188.5	189.18	263401.0
2023-09-01 09:00:00	AAPL	Stock	189.18	189.6	189.02	189.57	182468.0
2023-09-01 09:30:00	AAPL	Stock	189.57	189.92	188.28	188.94	5535333.0
2023-09-01 10:00:00	AAPL	Stock	188.92	189.49	188.4	189.28	3887072.0
2023-09-01 10:30:00	AAPL	Stock	189.27	189.28	188.311	188.4	2593884.0
2023-09-01 11:00:00	AAPL	Stock	188.4	188.84	188.35	188.66	1909252.0
2023-09-01 11:30:00	AAPL	Stock	188.68	188.895	188.3601	188.525	1701440.0
2023-09-01 12:00:00	AAPL	Stock	188.51	189.21	188.4801	189.115	1844579.0
2023-09-01 12:30:00	AAPL	Stock	189.11	189.27	188.84	189.175	1587146.0
2023-09-01 13:00:00	AAPL	Stock	189.17	189.32	188.93	189.0	1205069.0
2023-09-01 13:30:00	AAPL	Stock	188.99	189.225	188.85	189.17	1237655.0
2023-09-01 14:00:00	AAPL	Stock	189.175	189.2	188.63	188.7201	1376950.0
2023-09-01 14:30:00	AAPL	Stock	188.72	188.91	188.52	188.8899	1552965.0
2023-09-01 15:00:00	AAPL	Stock	188.88	189.08	188.75	189.05	1581435.0
2023-09-01 15:30:00	AAPL	Stock	189.05	189.54	188.94	189.47	4184405.0
2023-09-01 16:00:00	AAPL	Stock	189.47	189.47	189.01	189.17	6330883.0
2023-09-01 16:30:00	AAPL	Stock	189.18	189.46	189.16	189.24	96288.0
2023-09-01 17:00:00	AAPL	Stock	189.23	189.24	189.16	189.2	20695.0
2023-09-01 17:30:00	AAPL	Stock	189.17	189.23	189.14	189.22	13761.0
2023-09-01 18:00:00	AAPL	Stock	189.218	189.34	189.19	189.25	5535.0
2023-09-01 18:30:00	AAPL	Stock	189.26	189.3	189.25	189.25	6052.0
2023-09-01 19:00:00	AAPL	Stock	189.25	189.3	189.23	189.27	2573.0
2023-09-01 19:30:00	AAPL	Stock	189.26	189.3	189.2	189.2999	11435.0
2023-09-01 04:00:00	MSFT	Stock	328.43	328.67	328.43	328.48	1732.0
2023-09-01 04:30:00	MSFT	Stock	328.41	328.49	328.41	328.49	200.0
2023-09-01 05:00:00	MSFT	Stock	328.6	328.6	328.44	328.6	927.0
2023-09-01 05:30:00	MSFT	Stock	328.55	328.55	328.55	328.55	107.0
2023-09-01 06:00:00	MSFT	Stock	328.55	328.55	328.55	328.55	377.0
2023-09-01 06:30:00	MSFT	Stock	328.75	328.75	328.75	328.75	200.0
2023-09-01 07:00:00	MSFT	Stock	328.91	328.95	328.55	328.76	1592.0
2023-09-01 07:30:00	MSFT	Stock	328.49	328.78	328.49	328.78	1673.0
2023-09-01 08:00:00	MSFT	Stock	328.76	329.24	328.13	328.8	24992.0
2023-09-01 08:30:00	MSFT	Stock	328.8	332.0	328.63	331.0	80853.0
2023-09-01 09:00:00	MSFT	Stock	330.98	332.0	330.63	331.3	37136.0
2023-09-01 09:30:00	MSFT	Stock	331.24	331.99	327.45	329.0038	1654637.0
2023-09-01 10:00:00	MSFT	Stock	328.97	330.1	327.8	330.07	949214.0
2023-09-01 10:30:00	MSFT	Stock	330.07	330.07	327.865	328.065	742965.0
2023-09-01 11:00:00	MSFT	Stock	328.05	329.0	327.93	328.63	474824.0
2023-09-01 11:30:00	MSFT	Stock	328.65	328.87	327.57	327.63	443306.0
2023-09-01 12:00:00	MSFT	Stock	327.62	328.26	327.48	328.11	358550.0
2023-09-01 12:30:00	MSFT	Stock	328.095	328.33	327.62	328.07	426055.0

> showing 50 of 97,225 rows — these rows as CSV

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