PREVIEW / stock_30min / 2022-06-08

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-08.parquet
  size:    2.1 MB
  rows:    104,797
  symbols: 2,326

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-06-08 04:00:00	AAPL	Stock	147.85	148.5	147.85	148.4	14098.0
2022-06-08 04:30:00	AAPL	Stock	148.45	148.53	148.41	148.44	4830.0
2022-06-08 05:00:00	AAPL	Stock	148.44	148.45	148.27	148.45	3078.0
2022-06-08 05:30:00	AAPL	Stock	148.36	148.45	148.36	148.45	1791.0
2022-06-08 06:00:00	AAPL	Stock	148.25	148.25	147.88	147.92	4203.0
2022-06-08 06:30:00	AAPL	Stock	147.93	148.4	147.9	148.4	13080.0
2022-06-08 07:00:00	AAPL	Stock	148.33	148.46	148.25	148.41	24456.0
2022-06-08 07:30:00	AAPL	Stock	148.44	148.94	148.35	148.45	45444.0
2022-06-08 08:00:00	AAPL	Stock	148.2982	148.8499	148.06	148.15	269738.0
2022-06-08 08:30:00	AAPL	Stock	148.17	148.4	147.75	148.25	157542.0
2022-06-08 09:00:00	AAPL	Stock	148.25	148.66	148.0	148.51	178392.0
2022-06-08 09:30:00	AAPL	Stock	148.58	149.8697	148.1106	149.73	8352285.0
2022-06-08 10:00:00	AAPL	Stock	149.73	149.77	148.57	149.13	4891864.0
2022-06-08 10:30:00	AAPL	Stock	149.14	149.52	148.73	149.01	3399546.0
2022-06-08 11:00:00	AAPL	Stock	149.01	149.6472	148.65	149.3601	3036982.0
2022-06-08 11:30:00	AAPL	Stock	149.37	149.6	149.06	149.06	2171942.0
2022-06-08 12:00:00	AAPL	Stock	149.06	149.37	148.55	148.8	2085710.0
2022-06-08 12:30:00	AAPL	Stock	148.8	148.81	147.74	148.23	2547194.0
2022-06-08 13:00:00	AAPL	Stock	148.22	148.24	147.85	147.85	1930481.0
2022-06-08 13:30:00	AAPL	Stock	147.84	148.38	147.46	148.2538	2456951.0
2022-06-08 14:00:00	AAPL	Stock	148.26	148.43	147.66	147.85	2279258.0
2022-06-08 14:30:00	AAPL	Stock	147.8301	148.14	147.57	147.8706	2090510.0
2022-06-08 15:00:00	AAPL	Stock	147.871	148.39	147.5649	148.22	2493450.0
2022-06-08 15:30:00	AAPL	Stock	148.23	148.47	147.65	148.0	4172628.0
2022-06-08 16:00:00	AAPL	Stock	147.96	148.29	147.78	147.94	4909183.0
2022-06-08 16:30:00	AAPL	Stock	147.92	147.98	147.85	147.92	16452.0
2022-06-08 17:00:00	AAPL	Stock	147.96	148.0	147.9	148.0	7909.0
2022-06-08 17:30:00	AAPL	Stock	148.02	148.06	147.88	147.94	28334.0
2022-06-08 18:00:00	AAPL	Stock	147.96	148.0	147.91	147.96	8314.0
2022-06-08 18:30:00	AAPL	Stock	147.98	148.05	147.94	148.0	11239.0
2022-06-08 19:00:00	AAPL	Stock	147.97	148.05	147.9	147.93	12865.0
2022-06-08 19:30:00	AAPL	Stock	147.96	147.98	147.87	147.92	11923.0
2022-06-08 04:00:00	MSFT	Stock	271.45	271.45	270.93	271.29	400.0
2022-06-08 04:30:00	MSFT	Stock	271.36	271.55	271.36	271.5	1068.0
2022-06-08 05:00:00	MSFT	Stock	271.3	271.3	271.3	271.3	100.0
2022-06-08 06:00:00	MSFT	Stock	271.4	271.4	271.02	271.16	1573.0
2022-06-08 06:30:00	MSFT	Stock	271.5	272.0	271.5	271.99	2247.0
2022-06-08 07:00:00	MSFT	Stock	271.75	272.15	271.73	272.14	2187.0
2022-06-08 07:30:00	MSFT	Stock	272.15	272.34	271.77	271.87	1596.0
2022-06-08 08:00:00	MSFT	Stock	272.176	272.34	271.5213	271.5213	19288.0
2022-06-08 08:30:00	MSFT	Stock	271.55	271.6482	271.01	271.4	10951.0
2022-06-08 09:00:00	MSFT	Stock	271.29	272.0	270.88	271.76	14563.0
2022-06-08 09:30:00	MSFT	Stock	271.76	272.92	270.65	272.17	1608531.0
2022-06-08 10:00:00	MSFT	Stock	272.2	272.6299	271.1	272.13	1063050.0
2022-06-08 10:30:00	MSFT	Stock	272.095	273.0	271.12	271.32	706700.0
2022-06-08 11:00:00	MSFT	Stock	271.33	272.4	270.96	272.375	646307.0
2022-06-08 11:30:00	MSFT	Stock	272.37	272.62	271.78	272.03	616669.0
2022-06-08 12:00:00	MSFT	Stock	272.025	272.35	271.28	271.84	676102.0
2022-06-08 12:30:00	MSFT	Stock	271.82	271.86	270.62	271.19	684874.0
2022-06-08 13:00:00	MSFT	Stock	271.2	271.24	270.4801	270.67	409369.0

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

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