PREVIEW / stock_30min / 2022-07-19

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-19.parquet
  size:    2.1 MB
  rows:    104,047
  symbols: 2,306

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-07-19 04:00:00	AAPL	Stock	147.24	147.24	146.85	147.0	14628.0
2022-07-19 04:30:00	AAPL	Stock	146.95	147.4	146.95	147.4	11430.0
2022-07-19 05:00:00	AAPL	Stock	147.35	148.0	147.26	147.69	28531.0
2022-07-19 05:30:00	AAPL	Stock	147.68	147.77	147.56	147.61	14437.0
2022-07-19 06:00:00	AAPL	Stock	147.58	147.8	147.47	147.79	21947.0
2022-07-19 06:30:00	AAPL	Stock	147.83	147.98	147.54	147.67	25507.0
2022-07-19 07:00:00	AAPL	Stock	147.68	147.68	147.31	147.57	51480.0
2022-07-19 07:30:00	AAPL	Stock	147.57	147.65	147.34	147.53	69975.0
2022-07-19 08:00:00	AAPL	Stock	147.63	147.73	146.703	147.19	555964.0
2022-07-19 08:30:00	AAPL	Stock	147.17	147.8	147.15	147.581	279024.0
2022-07-19 09:00:00	AAPL	Stock	147.61	147.9792	147.44	147.92	213449.0
2022-07-19 09:30:00	AAPL	Stock	147.93	148.49	146.91	147.98	8776764.0
2022-07-19 10:00:00	AAPL	Stock	147.99	148.545	147.31	148.42	5299451.0
2022-07-19 10:30:00	AAPL	Stock	148.41	149.4099	148.24	149.4	4661221.0
2022-07-19 11:00:00	AAPL	Stock	149.41	150.14	149.4075	149.75	6328873.0
2022-07-19 11:30:00	AAPL	Stock	149.745	150.22	149.57	149.81	3165311.0
2022-07-19 12:00:00	AAPL	Stock	149.805	149.8797	149.3586	149.8098	2659324.0
2022-07-19 12:30:00	AAPL	Stock	149.82	150.21	149.733	150.08	3296321.0
2022-07-19 13:00:00	AAPL	Stock	150.0898	150.16	149.68	149.85	2791388.0
2022-07-19 13:30:00	AAPL	Stock	149.86	150.85	149.849	150.8168	3786372.0
2022-07-19 14:00:00	AAPL	Stock	150.815	150.94	150.53	150.595	3066079.0
2022-07-19 14:30:00	AAPL	Stock	150.595	150.79	150.28	150.68	2663646.0
2022-07-19 15:00:00	AAPL	Stock	150.68	150.81	150.45	150.62	3779242.0
2022-07-19 15:30:00	AAPL	Stock	150.62	151.23	150.37	150.97	8973077.0
2022-07-19 16:00:00	AAPL	Stock	150.97	151.5	150.93	151.41	11848914.0
2022-07-19 16:30:00	AAPL	Stock	151.41	151.87	151.0	151.72	131208.0
2022-07-19 17:00:00	AAPL	Stock	151.75	151.95	151.7	151.95	63507.0
2022-07-19 17:30:00	AAPL	Stock	151.92	152.11	151.88	152.04	108179.0
2022-07-19 18:00:00	AAPL	Stock	151.92	151.93	151.56	151.8	39311.0
2022-07-19 18:30:00	AAPL	Stock	151.78	151.87	151.61	151.75	29904.0
2022-07-19 19:00:00	AAPL	Stock	151.75	151.97	151.71	151.76	34256.0
2022-07-19 19:30:00	AAPL	Stock	151.76	151.88	151.5	151.8	62553.0
2022-07-19 04:00:00	MSFT	Stock	254.99	255.01	254.89	254.92	905.0
2022-07-19 04:30:00	MSFT	Stock	254.85	255.2	254.85	255.2	572.0
2022-07-19 05:00:00	MSFT	Stock	256.0	256.1	255.8	256.1	2355.0
2022-07-19 05:30:00	MSFT	Stock	256.09	256.12	256.0	256.06	1714.0
2022-07-19 06:00:00	MSFT	Stock	256.0	256.5	256.0	256.5	2165.0
2022-07-19 06:30:00	MSFT	Stock	256.48	256.95	256.48	256.78	829.0
2022-07-19 07:00:00	MSFT	Stock	256.6	256.63	256.0	256.44	13828.0
2022-07-19 07:30:00	MSFT	Stock	256.43	256.66	256.17	256.6	8617.0
2022-07-19 08:00:00	MSFT	Stock	256.5997	256.75	253.615	255.9	11767.0
2022-07-19 08:30:00	MSFT	Stock	255.81	256.65	255.81	256.5	13835.0
2022-07-19 09:00:00	MSFT	Stock	256.4999	258.45	256.35	257.71	40998.0
2022-07-19 09:30:00	MSFT	Stock	257.56	258.06	253.68	255.515	2320177.0
2022-07-19 10:00:00	MSFT	Stock	255.54	256.25	254.08	255.88	1315823.0
2022-07-19 10:30:00	MSFT	Stock	255.88	257.21	255.75	257.04	926582.0
2022-07-19 11:00:00	MSFT	Stock	257.07	257.73	256.86	257.47	662961.0
2022-07-19 11:30:00	MSFT	Stock	257.45	258.04	257.06	257.53	529994.0
2022-07-19 12:00:00	MSFT	Stock	257.52	257.685	256.7334	257.62	508942.0
2022-07-19 12:30:00	MSFT	Stock	257.625	258.04	257.49	257.9533	501003.0

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

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