PREVIEW / stock_30min / 2023-11-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-03.parquet
  size:    2.0 MB
  rows:    99,228
  symbols: 1,341

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-11-03 04:00:00	AAPL	Stock	172.08	172.5	171.93	172.27	42859.0
2023-11-03 04:30:00	AAPL	Stock	172.3	172.63	171.51	171.6	44383.0
2023-11-03 05:00:00	AAPL	Stock	171.52	171.99	171.5	171.6	19311.0
2023-11-03 05:30:00	AAPL	Stock	171.6	172.11	171.54	172.02	25652.0
2023-11-03 06:00:00	AAPL	Stock	172.09	172.3	172.0	172.06	12341.0
2023-11-03 06:30:00	AAPL	Stock	172.05	172.13	171.88	172.13	28086.0
2023-11-03 07:00:00	AAPL	Stock	172.02	172.79	172.0	172.74	128340.0
2023-11-03 07:30:00	AAPL	Stock	172.75	174.53	172.67	174.01	314655.0
2023-11-03 08:00:00	AAPL	Stock	172.02	174.55	171.89	174.4	745657.0
2023-11-03 08:30:00	AAPL	Stock	174.45	175.3	173.76	174.06	962634.0
2023-11-03 09:00:00	AAPL	Stock	174.11	174.5	173.33	174.26	378251.0
2023-11-03 09:30:00	AAPL	Stock	174.24	176.4	173.35	175.35	14464005.0
2023-11-03 10:00:00	AAPL	Stock	175.36	175.8	174.46	174.71	6395886.0
2023-11-03 10:30:00	AAPL	Stock	174.7	175.94	174.66	175.7201	4762751.0
2023-11-03 11:00:00	AAPL	Stock	175.725	175.79	174.75	174.8	3274218.0
2023-11-03 11:30:00	AAPL	Stock	174.8	175.68	174.6	175.4301	2720222.0
2023-11-03 12:00:00	AAPL	Stock	175.44	176.49	175.309	176.34	3614143.0
2023-11-03 12:30:00	AAPL	Stock	176.35	176.45	175.89	176.1993	2619944.0
2023-11-03 13:00:00	AAPL	Stock	176.1803	176.42	175.71	175.7679	1887774.0
2023-11-03 13:30:00	AAPL	Stock	175.7617	175.89	175.18	175.56	2736471.0
2023-11-03 14:00:00	AAPL	Stock	175.56	175.83	175.07	175.7899	2397878.0
2023-11-03 14:30:00	AAPL	Stock	175.78	176.24	175.68	176.11	2569160.0
2023-11-03 15:00:00	AAPL	Stock	176.11	176.4675	175.85	176.0401	2934121.0
2023-11-03 15:30:00	AAPL	Stock	176.04	176.82	175.95	176.63	5744272.0
2023-11-03 16:00:00	AAPL	Stock	176.56	176.85	176.56	176.71	7393772.0
2023-11-03 16:30:00	AAPL	Stock	176.71	176.78	176.65	176.74	104457.0
2023-11-03 17:00:00	AAPL	Stock	176.7201	176.81	176.64	176.64	72377.0
2023-11-03 17:30:00	AAPL	Stock	176.654	176.66	176.62	176.64	322097.0
2023-11-03 18:00:00	AAPL	Stock	176.64	176.67	176.64	176.66	9094.0
2023-11-03 18:30:00	AAPL	Stock	176.67	176.6918	176.65	176.69	7903.0
2023-11-03 19:00:00	AAPL	Stock	176.69	176.69	176.61	176.66	18963.0
2023-11-03 19:30:00	AAPL	Stock	176.66	176.71	176.64	176.66	17813.0
2023-11-03 04:00:00	MSFT	Stock	349.74	349.74	348.63	349.32	3346.0
2023-11-03 04:30:00	MSFT	Stock	349.48	349.81	349.48	349.51	1832.0
2023-11-03 05:00:00	MSFT	Stock	349.67	349.67	349.5	349.67	1824.0
2023-11-03 05:30:00	MSFT	Stock	349.5	349.65	349.4	349.65	2979.0
2023-11-03 06:00:00	MSFT	Stock	349.45	349.69	349.42	349.45	3773.0
2023-11-03 06:30:00	MSFT	Stock	349.33	349.33	349.31	349.31	1101.0
2023-11-03 07:00:00	MSFT	Stock	349.34	349.47	348.89	349.47	11101.0
2023-11-03 07:30:00	MSFT	Stock	349.53	349.55	349.02	349.02	6749.0
2023-11-03 08:00:00	MSFT	Stock	349.15	349.64	348.8	348.95	21940.0
2023-11-03 08:30:00	MSFT	Stock	349.3	351.63	349.3	349.94	73878.0
2023-11-03 09:00:00	MSFT	Stock	349.73	349.98	349.0	349.63	32399.0
2023-11-03 09:30:00	MSFT	Stock	349.63	350.6	347.33	350.0555	2500372.0
2023-11-03 10:00:00	MSFT	Stock	350.09	351.86	349.6274	350.545	1571120.0
2023-11-03 10:30:00	MSFT	Stock	350.52	351.43	349.67	350.84	1104075.0
2023-11-03 11:00:00	MSFT	Stock	350.855	351.1338	350.02	350.83	722042.0
2023-11-03 11:30:00	MSFT	Stock	350.86	351.73	350.8101	351.33	783106.0
2023-11-03 12:00:00	MSFT	Stock	351.335	352.95	351.14	352.78	728111.0
2023-11-03 12:30:00	MSFT	Stock	352.78	353.3999	352.75	353.29	572571.0

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

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