PREVIEW / stock_30min / 2023-06-26

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-26.parquet
  size:    2.1 MB
  rows:    100,584
  symbols: 1,601

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-06-26 04:00:00	AAPL	Stock	186.55	186.85	186.54	186.7	14465.0
2023-06-26 04:30:00	AAPL	Stock	186.7	186.7	186.0	186.22	25135.0
2023-06-26 05:00:00	AAPL	Stock	186.37	186.4	186.3	186.4	1760.0
2023-06-26 05:30:00	AAPL	Stock	186.35	186.43	186.35	186.43	409.0
2023-06-26 06:00:00	AAPL	Stock	186.34	186.35	186.33	186.33	900.0
2023-06-26 06:30:00	AAPL	Stock	186.2	186.2	186.2	186.2	100.0
2023-06-26 07:00:00	AAPL	Stock	186.25	186.54	186.25	186.45	10848.0
2023-06-26 07:30:00	AAPL	Stock	186.45	186.63	186.41	186.6	11329.0
2023-06-26 08:00:00	AAPL	Stock	186.3318	187.45	186.3	186.8	46953.0
2023-06-26 08:30:00	AAPL	Stock	186.81	187.0	186.69	186.91	42264.0
2023-06-26 09:00:00	AAPL	Stock	186.89	187.0	186.51	186.8	82982.0
2023-06-26 09:30:00	AAPL	Stock	186.8	187.83	186.34	187.5811	4502141.0
2023-06-26 10:00:00	AAPL	Stock	187.585	188.05	187.44	187.7498	3241885.0
2023-06-26 10:30:00	AAPL	Stock	187.75	187.84	186.96	187.62	2467610.0
2023-06-26 11:00:00	AAPL	Stock	187.61	187.6357	186.41	186.53	2468980.0
2023-06-26 11:30:00	AAPL	Stock	186.53	187.05	186.46	186.885	2108486.0
2023-06-26 12:00:00	AAPL	Stock	186.885	186.98	185.97	186.25	2459675.0
2023-06-26 12:30:00	AAPL	Stock	186.24	186.38	185.65	186.05	2039321.0
2023-06-26 13:00:00	AAPL	Stock	186.05	186.05	185.61	185.985	1606666.0
2023-06-26 13:30:00	AAPL	Stock	186.0	186.05	185.7201	185.82	1454450.0
2023-06-26 14:00:00	AAPL	Stock	185.8323	186.17	185.7701	185.99	1440169.0
2023-06-26 14:30:00	AAPL	Stock	185.98	186.41	185.93	186.15	1783924.0
2023-06-26 15:00:00	AAPL	Stock	186.15	186.25	185.95	186.075	1554564.0
2023-06-26 15:30:00	AAPL	Stock	186.07	186.1801	185.23	185.31	5622087.0
2023-06-26 16:00:00	AAPL	Stock	185.3	185.54	185.0	185.49	6392939.0
2023-06-26 16:30:00	AAPL	Stock	185.46	185.5	185.23	185.3	71582.0
2023-06-26 17:00:00	AAPL	Stock	185.29	185.34	185.0301	185.22	43065.0
2023-06-26 17:30:00	AAPL	Stock	185.2199	185.26	185.16	185.24	17247.0
2023-06-26 18:00:00	AAPL	Stock	185.26	185.38	185.21	185.24	15110.0
2023-06-26 18:30:00	AAPL	Stock	185.25	185.39	185.194	185.3	8382.0
2023-06-26 19:00:00	AAPL	Stock	185.29	185.59	185.27	185.56	69400.0
2023-06-26 19:30:00	AAPL	Stock	185.5499	185.58	185.43	185.52	8980.0
2023-06-26 04:00:00	MSFT	Stock	334.89	334.96	334.51	334.53	3320.0
2023-06-26 04:30:00	MSFT	Stock	334.53	334.53	334.23	334.25	2452.0
2023-06-26 05:00:00	MSFT	Stock	334.4	334.4	334.4	334.4	302.0
2023-06-26 05:30:00	MSFT	Stock	334.32	334.6	334.32	334.6	1059.0
2023-06-26 06:00:00	MSFT	Stock	334.5	334.51	334.5	334.51	796.0
2023-06-26 07:00:00	MSFT	Stock	334.7	334.8	334.51	334.51	2745.0
2023-06-26 07:30:00	MSFT	Stock	334.55	335.09	334.55	334.55	4932.0
2023-06-26 08:00:00	MSFT	Stock	334.9	336.89	333.5	334.3	14246.0
2023-06-26 08:30:00	MSFT	Stock	334.34	334.8004	334.0	334.479	6734.0
2023-06-26 09:00:00	MSFT	Stock	334.48	335.14	333.85	333.87	20822.0
2023-06-26 09:30:00	MSFT	Stock	333.85	335.58	332.511	335.41	1493681.0
2023-06-26 10:00:00	MSFT	Stock	335.395	336.11	334.76	335.19	903303.0
2023-06-26 10:30:00	MSFT	Stock	335.19	335.28	332.77	334.46	854691.0
2023-06-26 11:00:00	MSFT	Stock	334.4432	334.5099	330.85	331.7	1227269.0
2023-06-26 11:30:00	MSFT	Stock	331.68	332.33	330.99	331.37	744759.0
2023-06-26 12:00:00	MSFT	Stock	331.37	331.76	329.7	330.6401	1016763.0
2023-06-26 12:30:00	MSFT	Stock	330.66	330.71	329.415	330.41	710380.0
2023-06-26 13:00:00	MSFT	Stock	330.44	330.54	329.47	330.221	631786.0

> showing 50 of 100,584 rows — these rows as CSV

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