PREVIEW / stock_30min / 2022-09-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-28.parquet
  size:    2.1 MB
  rows:    105,577
  symbols: 2,217

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
2022-09-28 04:00:00	AAPL	Stock	149.47	149.75	146.69	146.9	177535.0
2022-09-28 04:30:00	AAPL	Stock	146.83	147.09	146.5	146.68	75460.0
2022-09-28 05:00:00	AAPL	Stock	146.6	146.77	145.7	146.11	96482.0
2022-09-28 05:30:00	AAPL	Stock	146.15	146.15	145.69	145.75	20223.0
2022-09-28 06:00:00	AAPL	Stock	145.72	147.27	145.61	146.84	259010.0
2022-09-28 06:30:00	AAPL	Stock	146.87	147.01	145.7	145.91	152933.0
2022-09-28 07:00:00	AAPL	Stock	145.95	146.4	145.66	146.06	263475.0
2022-09-28 07:30:00	AAPL	Stock	146.03	146.3	145.8	146.0	212091.0
2022-09-28 08:00:00	AAPL	Stock	146.34	151.76	145.66	147.1	922869.0
2022-09-28 08:30:00	AAPL	Stock	147.12	148.37	146.8	147.84	889143.0
2022-09-28 09:00:00	AAPL	Stock	147.84	148.5	147.18	147.65	760719.0
2022-09-28 09:30:00	AAPL	Stock	147.64	148.37	144.84	145.8	22179313.0
2022-09-28 10:00:00	AAPL	Stock	145.805	147.43	145.16	147.3699	13138840.0
2022-09-28 10:30:00	AAPL	Stock	147.355	147.4288	146.2	146.239	9494822.0
2022-09-28 11:00:00	AAPL	Stock	146.24	147.32	146.06	146.85	7030252.0
2022-09-28 11:30:00	AAPL	Stock	146.86	147.415	146.34	147.3601	6458394.0
2022-09-28 12:00:00	AAPL	Stock	147.37	147.7	147.06	147.15	6023731.0
2022-09-28 12:30:00	AAPL	Stock	147.15	147.76	146.9	147.76	5088338.0
2022-09-28 13:00:00	AAPL	Stock	147.76	148.38	147.51	147.91	6144756.0
2022-09-28 13:30:00	AAPL	Stock	147.9127	148.0823	147.21	147.4	5283951.0
2022-09-28 14:00:00	AAPL	Stock	147.4	148.07	147.3528	147.9077	4528895.0
2022-09-28 14:30:00	AAPL	Stock	147.905	149.09	147.88	148.8	6838788.0
2022-09-28 15:00:00	AAPL	Stock	148.7988	149.79	148.74	149.42	7475076.0
2022-09-28 15:30:00	AAPL	Stock	149.425	150.6414	149.4129	149.8	12074313.0
2022-09-28 16:00:00	AAPL	Stock	149.84	149.94	147.5515	149.58	9941385.0
2022-09-28 16:30:00	AAPL	Stock	149.58	149.84	149.4032	149.53	371672.0
2022-09-28 17:00:00	AAPL	Stock	149.49	149.54	149.42	149.48	46164.0
2022-09-28 17:30:00	AAPL	Stock	149.4702	149.5	149.41	149.5	21162.0
2022-09-28 18:00:00	AAPL	Stock	149.51	149.83	149.49	149.6	40342.0
2022-09-28 18:30:00	AAPL	Stock	149.6	149.71	149.45	149.48	31823.0
2022-09-28 19:00:00	AAPL	Stock	149.51	149.56	149.4	149.42	29354.0
2022-09-28 19:30:00	AAPL	Stock	149.4	149.51	149.26	149.37	46226.0
2022-09-28 04:00:00	MSFT	Stock	234.49	234.49	233.71	233.91	11295.0
2022-09-28 04:30:00	MSFT	Stock	233.8	234.79	233.61	234.45	6443.0
2022-09-28 05:00:00	MSFT	Stock	234.38	234.38	232.74	233.5	6550.0
2022-09-28 05:30:00	MSFT	Stock	233.4	233.5	232.91	233.25	1835.0
2022-09-28 06:00:00	MSFT	Stock	233.01	236.41	233.0	235.8	23999.0
2022-09-28 06:30:00	MSFT	Stock	235.84	236.89	235.18	235.46	19222.0
2022-09-28 07:00:00	MSFT	Stock	235.03	235.03	234.03	235.0	13868.0
2022-09-28 07:30:00	MSFT	Stock	235.2	235.28	234.1	234.45	12512.0
2022-09-28 08:00:00	MSFT	Stock	235.0107	236.04	234.04	235.7	27514.0
2022-09-28 08:30:00	MSFT	Stock	235.9	237.45	235.79	236.5	30989.0
2022-09-28 09:00:00	MSFT	Stock	236.64	237.2	235.7303	236.64	50714.0
2022-09-28 09:30:00	MSFT	Stock	236.73	237.12	234.84	235.15	3085725.0
2022-09-28 10:00:00	MSFT	Stock	235.16	238.44	234.73	238.335	2015833.0
2022-09-28 10:30:00	MSFT	Stock	238.35	239.28	237.87	238.86	1615430.0
2022-09-28 11:00:00	MSFT	Stock	238.84	239.56	238.08	238.48	1622438.0
2022-09-28 11:30:00	MSFT	Stock	238.49	239.87	237.85	239.84	1006721.0
2022-09-28 12:00:00	MSFT	Stock	239.86	241.06	239.54	239.83	1191931.0
2022-09-28 12:30:00	MSFT	Stock	239.81	240.47	239.52	239.98	799544.0

> showing 50 of 105,577 rows — these rows as CSV

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