PREVIEW / stock_30min / 2023-01-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-18.parquet
  size:    2.1 MB
  rows:    104,264
  symbols: 1,938

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-01-18 04:00:00	AAPL	Stock	136.28	136.3	136.07	136.3	9471.0
2023-01-18 04:30:00	AAPL	Stock	136.15	136.23	136.07	136.17	5592.0
2023-01-18 05:00:00	AAPL	Stock	136.18	136.22	136.07	136.11	7979.0
2023-01-18 05:30:00	AAPL	Stock	136.12	136.45	136.02	136.41	6322.0
2023-01-18 06:00:00	AAPL	Stock	136.44	136.44	136.42	136.44	2350.0
2023-01-18 06:30:00	AAPL	Stock	136.4	136.57	136.32	136.57	6178.0
2023-01-18 07:00:00	AAPL	Stock	136.52	136.66	136.43	136.66	31492.0
2023-01-18 07:30:00	AAPL	Stock	136.63	136.88	136.63	136.88	32892.0
2023-01-18 08:00:00	AAPL	Stock	136.5995	136.89	135.601	136.7	165856.0
2023-01-18 08:30:00	AAPL	Stock	136.75	137.2699	136.22	136.96	300207.0
2023-01-18 09:00:00	AAPL	Stock	136.92	137.19	136.79	136.82	263335.0
2023-01-18 09:30:00	AAPL	Stock	136.82	138.0	136.68	137.98	9181511.0
2023-01-18 10:00:00	AAPL	Stock	137.98	138.61	137.21	137.9819	6670352.0
2023-01-18 10:30:00	AAPL	Stock	137.99	138.0	136.55	137.055	4369497.0
2023-01-18 11:00:00	AAPL	Stock	137.05	137.3699	136.4	136.68	3863238.0
2023-01-18 11:30:00	AAPL	Stock	136.68	136.73	135.8	136.1559	3726539.0
2023-01-18 12:00:00	AAPL	Stock	136.1578	136.2799	135.44	135.583	3197223.0
2023-01-18 12:30:00	AAPL	Stock	135.58	135.825	135.42	135.7	2228947.0
2023-01-18 13:00:00	AAPL	Stock	135.7	135.96	135.33	135.72	2418727.0
2023-01-18 13:30:00	AAPL	Stock	135.73	136.27	135.38	136.06	2799252.0
2023-01-18 14:00:00	AAPL	Stock	136.07	136.11	135.65	136.07	2112112.0
2023-01-18 14:30:00	AAPL	Stock	136.06	136.16	135.72	135.805	2012741.0
2023-01-18 15:00:00	AAPL	Stock	135.8	136.11	135.64	135.7615	2542882.0
2023-01-18 15:30:00	AAPL	Stock	135.76	135.82	135.03	135.2	5251464.0
2023-01-18 16:00:00	AAPL	Stock	135.2	135.25	134.9	134.95	8750347.0
2023-01-18 16:30:00	AAPL	Stock	134.97	135.21	134.95	135.05	547394.0
2023-01-18 17:00:00	AAPL	Stock	135.05	135.07	134.88	134.9115	24250.0
2023-01-18 17:30:00	AAPL	Stock	134.92	134.9574	134.7617	134.86	26608.0
2023-01-18 18:00:00	AAPL	Stock	134.9	135.16	134.85	134.94	36527.0
2023-01-18 18:30:00	AAPL	Stock	134.94	134.97	134.76	134.79	21013.0
2023-01-18 19:00:00	AAPL	Stock	134.79	134.8	134.65	134.65	18048.0
2023-01-18 19:30:00	AAPL	Stock	134.69	134.73	134.4	134.44	30705.0
2023-01-18 04:00:00	MSFT	Stock	240.41	240.41	239.99	240.15	1327.0
2023-01-18 04:30:00	MSFT	Stock	240.12	240.15	240.11	240.15	482.0
2023-01-18 05:00:00	MSFT	Stock	239.89	239.89	239.7	239.8	727.0
2023-01-18 05:30:00	MSFT	Stock	239.59	240.0	239.59	239.94	600.0
2023-01-18 06:00:00	MSFT	Stock	239.92	240.35	239.92	240.21	1466.0
2023-01-18 06:30:00	MSFT	Stock	240.21	240.61	240.2	240.61	4604.0
2023-01-18 07:00:00	MSFT	Stock	240.65	240.78	240.47	240.56	14670.0
2023-01-18 07:30:00	MSFT	Stock	240.58	241.45	240.58	241.41	6679.0
2023-01-18 08:00:00	MSFT	Stock	240.71	241.5	239.75	241.27	21819.0
2023-01-18 08:30:00	MSFT	Stock	241.38	242.98	240.7	241.65	40941.0
2023-01-18 09:00:00	MSFT	Stock	241.75	244.0	241.23	241.61	259386.0
2023-01-18 09:30:00	MSFT	Stock	241.565	242.38	240.11	241.11	3385476.0
2023-01-18 10:00:00	MSFT	Stock	241.09	242.05	239.98	240.41	1769606.0
2023-01-18 10:30:00	MSFT	Stock	240.44	240.455	237.56	238.27	1887595.0
2023-01-18 11:00:00	MSFT	Stock	238.25	238.5	236.82	237.18	1305277.0
2023-01-18 11:30:00	MSFT	Stock	237.19	237.49	236.35	237.38	1279779.0
2023-01-18 12:00:00	MSFT	Stock	237.37	237.566	236.89	237.115	777195.0
2023-01-18 12:30:00	MSFT	Stock	237.09	237.68	237.045	237.2033	760120.0

> showing 50 of 104,264 rows — these rows as CSV

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