PREVIEW / stock_30min / 2023-04-04

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-04.parquet
  size:    2.0 MB
  rows:    99,815
  symbols: 1,738

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-04-04 04:00:00	AAPL	Stock	165.91	165.95	165.8	165.93	1864.0
2023-04-04 04:30:00	AAPL	Stock	165.99	166.1	165.86	166.1	11544.0
2023-04-04 05:00:00	AAPL	Stock	166.09	166.4	166.09	166.4	6543.0
2023-04-04 05:30:00	AAPL	Stock	166.41	166.98	166.41	166.92	5587.0
2023-04-04 06:00:00	AAPL	Stock	166.89	167.0	166.86	166.86	5736.0
2023-04-04 06:30:00	AAPL	Stock	166.9	166.96	166.72	166.77	6286.0
2023-04-04 07:00:00	AAPL	Stock	166.77	166.89	166.65	166.82	27223.0
2023-04-04 07:30:00	AAPL	Stock	166.85	166.9	166.72	166.74	18973.0
2023-04-04 08:00:00	AAPL	Stock	166.85	166.9	165.33	166.59	67860.0
2023-04-04 08:30:00	AAPL	Stock	166.58	166.65	166.42	166.5663	45613.0
2023-04-04 09:00:00	AAPL	Stock	166.54	166.7	166.35	166.56	89386.0
2023-04-04 09:30:00	AAPL	Stock	166.59	166.7	165.418	166.29	5164068.0
2023-04-04 10:00:00	AAPL	Stock	166.3	166.84	165.89	166.25	3555487.0
2023-04-04 10:30:00	AAPL	Stock	166.26	166.49	165.93	166.108	2480068.0
2023-04-04 11:00:00	AAPL	Stock	166.1101	166.27	165.75	166.15	2264422.0
2023-04-04 11:30:00	AAPL	Stock	166.14	166.4156	166.04	166.18	2269015.0
2023-04-04 12:00:00	AAPL	Stock	166.18	166.29	165.5901	165.83	2125788.0
2023-04-04 12:30:00	AAPL	Stock	165.82	166.11	165.74	165.94	1599708.0
2023-04-04 13:00:00	AAPL	Stock	165.94	166.23	165.715	166.0799	1425307.0
2023-04-04 13:30:00	AAPL	Stock	166.0701	166.21	165.9018	166.0109	1271187.0
2023-04-04 14:00:00	AAPL	Stock	166.01	166.1099	165.76	165.7601	1099350.0
2023-04-04 14:30:00	AAPL	Stock	165.765	165.9	165.33	165.41	1635491.0
2023-04-04 15:00:00	AAPL	Stock	165.415	165.63	165.335	165.348	1890072.0
2023-04-04 15:30:00	AAPL	Stock	165.34	165.66	165.11	165.65	4131338.0
2023-04-04 16:00:00	AAPL	Stock	165.65	165.67	165.53	165.62	6857792.0
2023-04-04 16:30:00	AAPL	Stock	165.58	165.64	165.56	165.64	13192.0
2023-04-04 17:00:00	AAPL	Stock	165.61	165.63	165.54	165.54	8230.0
2023-04-04 17:30:00	AAPL	Stock	165.6	165.64	165.52	165.52	4842.0
2023-04-04 18:00:00	AAPL	Stock	165.57	165.68	165.53	165.53	4443.0
2023-04-04 18:30:00	AAPL	Stock	165.59	165.67	165.55	165.64	4773.0
2023-04-04 19:00:00	AAPL	Stock	165.6	165.75	165.6	165.73	9567.0
2023-04-04 19:30:00	AAPL	Stock	165.75	165.85	165.7	165.79	13960.0
2023-04-04 04:30:00	MSFT	Stock	287.07	287.42	287.06	287.29	3029.0
2023-04-04 05:00:00	MSFT	Stock	287.27	288.07	287.27	288.05	582.0
2023-04-04 05:30:00	MSFT	Stock	288.05	289.77	288.05	289.77	4013.0
2023-04-04 06:00:00	MSFT	Stock	289.4	289.63	289.2	289.4	2101.0
2023-04-04 06:30:00	MSFT	Stock	289.43	289.6	289.21	289.31	6726.0
2023-04-04 07:00:00	MSFT	Stock	289.05	289.85	289.05	289.75	36542.0
2023-04-04 07:30:00	MSFT	Stock	289.75	289.88	289.3	289.3	8174.0
2023-04-04 08:00:00	MSFT	Stock	289.48	289.8879	285.74	288.98	42174.0
2023-04-04 08:30:00	MSFT	Stock	288.85	288.89	288.12	288.32	19361.0
2023-04-04 09:00:00	MSFT	Stock	288.26	288.5	286.5	287.03	37689.0
2023-04-04 09:30:00	MSFT	Stock	287.18	289.62	286.33	288.69	2707965.0
2023-04-04 10:00:00	MSFT	Stock	288.69	290.4499	288.3159	289.13	2404354.0
2023-04-04 10:30:00	MSFT	Stock	289.15	289.9599	288.78	289.14	1291241.0
2023-04-04 11:00:00	MSFT	Stock	289.13	289.13	287.77	288.3381	1497451.0
2023-04-04 11:30:00	MSFT	Stock	288.32	289.6101	288.24	289.07	1212263.0
2023-04-04 12:00:00	MSFT	Stock	289.09	289.2	287.825	288.56	992381.0
2023-04-04 12:30:00	MSFT	Stock	288.5486	288.65	288.05	288.05	577200.0
2023-04-04 13:00:00	MSFT	Stock	288.06	288.38	287.766	288.085	738520.0

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

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