PREVIEW / stock_30min / 2024-01-17

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-01-17.parquet
  size:    2.0 MB
  rows:    98,302
  symbols: 1,169

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
2024-01-17 04:00:00	AAPL	Stock	182.6	182.6	181.48	181.76	15400.0
2024-01-17 04:30:00	AAPL	Stock	181.86	181.98	181.8	181.9	8134.0
2024-01-17 05:00:00	AAPL	Stock	181.93	181.96	181.8	181.81	15278.0
2024-01-17 05:30:00	AAPL	Stock	181.75	181.75	181.67	181.67	6038.0
2024-01-17 06:00:00	AAPL	Stock	181.7	181.9	181.7	181.88	3579.0
2024-01-17 06:30:00	AAPL	Stock	181.89	182.2	181.85	182.2	6763.0
2024-01-17 07:00:00	AAPL	Stock	182.19	182.5	182.14	182.37	18588.0
2024-01-17 07:30:00	AAPL	Stock	182.37	182.38	182.0	182.25	25640.0
2024-01-17 08:00:00	AAPL	Stock	182.2928	183.63	181.75	181.82	205195.0
2024-01-17 08:30:00	AAPL	Stock	181.82	181.8265	181.2	181.33	104007.0
2024-01-17 09:00:00	AAPL	Stock	181.31	181.65	181.1	181.31	149676.0
2024-01-17 09:30:00	AAPL	Stock	181.33	181.56	180.3	181.26	6488313.0
2024-01-17 10:00:00	AAPL	Stock	181.24	181.84	181.19	181.7	3127141.0
2024-01-17 10:30:00	AAPL	Stock	181.685	181.85	181.3	181.4997	2379392.0
2024-01-17 11:00:00	AAPL	Stock	181.495	182.065	181.485	181.805	2405870.0
2024-01-17 11:30:00	AAPL	Stock	181.81	181.9133	181.488	181.73	1830524.0
2024-01-17 12:00:00	AAPL	Stock	181.74	182.33	181.74	182.12	1753071.0
2024-01-17 12:30:00	AAPL	Stock	182.12	182.32	181.83	182.24	1322661.0
2024-01-17 13:00:00	AAPL	Stock	182.2301	182.535	181.86	182.12	1447228.0
2024-01-17 13:30:00	AAPL	Stock	182.115	182.25	181.37	182.085	3127677.0
2024-01-17 14:00:00	AAPL	Stock	182.0899	182.55	182.0025	182.5356	1576337.0
2024-01-17 14:30:00	AAPL	Stock	182.5378	182.6801	182.12	182.195	2236375.0
2024-01-17 15:00:00	AAPL	Stock	182.2	182.3684	182.0501	182.2055	1652899.0
2024-01-17 15:30:00	AAPL	Stock	182.205	182.93	182.18	182.66	3629631.0
2024-01-17 16:00:00	AAPL	Stock	182.68	182.71	182.51	182.57	4959224.0
2024-01-17 16:30:00	AAPL	Stock	182.57	182.68	182.54	182.58	37884.0
2024-01-17 17:00:00	AAPL	Stock	182.54	182.54	182.35	182.42	18535.0
2024-01-17 17:30:00	AAPL	Stock	182.39	182.45	182.21	182.4	4840.0
2024-01-17 18:00:00	AAPL	Stock	182.45	182.5	182.3	182.5	16791.0
2024-01-17 18:30:00	AAPL	Stock	182.45	182.49	182.4	182.45	5513.0
2024-01-17 19:00:00	AAPL	Stock	182.41	182.48	182.24	182.3	6831.0
2024-01-17 19:30:00	AAPL	Stock	182.36	182.5	182.31	182.47	7225.0
2024-01-17 04:00:00	MSFT	Stock	389.98	389.98	387.7	388.7	3381.0
2024-01-17 04:30:00	MSFT	Stock	389.4	389.57	389.2	389.2	3445.0
2024-01-17 05:00:00	MSFT	Stock	389.0	389.43	389.0	389.4	1263.0
2024-01-17 05:30:00	MSFT	Stock	389.22	389.22	388.71	388.71	1985.0
2024-01-17 06:00:00	MSFT	Stock	388.7	388.88	388.7	388.88	790.0
2024-01-17 06:30:00	MSFT	Stock	389.33	390.93	389.33	390.93	4813.0
2024-01-17 07:00:00	MSFT	Stock	390.88	391.31	390.63	391.2	19071.0
2024-01-17 07:30:00	MSFT	Stock	391.11	391.2	390.21	390.36	9454.0
2024-01-17 08:00:00	MSFT	Stock	390.99	391.3	388.0	390.3	111963.0
2024-01-17 08:30:00	MSFT	Stock	390.22	390.22	388.33	388.54	34147.0
2024-01-17 09:00:00	MSFT	Stock	388.697	389.5	387.3	387.75	28385.0
2024-01-17 09:30:00	MSFT	Stock	387.75	388.55	384.81	385.82	2192154.0
2024-01-17 10:00:00	MSFT	Stock	385.805	387.22	385.12	387.01	974302.0
2024-01-17 10:30:00	MSFT	Stock	386.99	387.6	386.07	387.3673	728674.0
2024-01-17 11:00:00	MSFT	Stock	387.36	389.45	387.35	389.21	933294.0
2024-01-17 11:30:00	MSFT	Stock	389.21	390.11	389.21	389.75	896632.0
2024-01-17 12:00:00	MSFT	Stock	389.75	390.02	388.48	388.72	619475.0
2024-01-17 12:30:00	MSFT	Stock	388.68	389.52	388.57	389.51	355584.0

> showing 50 of 98,302 rows — these rows as CSV

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