PREVIEW / stock_30min / 2022-10-17

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-17.parquet
  size:    2.1 MB
  rows:    102,197
  symbols: 2,167

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-10-17 04:00:00	AAPL	Stock	142.99	142.99	139.58	139.71	22778.0
2022-10-17 04:30:00	AAPL	Stock	139.79	139.93	139.77	139.9	15292.0
2022-10-17 05:00:00	AAPL	Stock	139.81	139.93	139.76	139.93	6221.0
2022-10-17 05:30:00	AAPL	Stock	139.93	140.1	139.92	139.94	14290.0
2022-10-17 06:00:00	AAPL	Stock	139.98	140.44	139.98	140.11	22429.0
2022-10-17 06:30:00	AAPL	Stock	140.2	140.33	139.85	140.33	34176.0
2022-10-17 07:00:00	AAPL	Stock	140.31	140.42	139.89	140.25	70982.0
2022-10-17 07:30:00	AAPL	Stock	140.23	140.44	140.12	140.37	24859.0
2022-10-17 08:00:00	AAPL	Stock	140.2	140.71	139.07	140.71	218567.0
2022-10-17 08:30:00	AAPL	Stock	140.73	141.2	140.56	141.0497	220365.0
2022-10-17 09:00:00	AAPL	Stock	141.05	141.75	140.76	141.07	433382.0
2022-10-17 09:30:00	AAPL	Stock	141.065	142.69	140.49	142.0	13002835.0
2022-10-17 10:00:00	AAPL	Stock	142.005	142.22	141.48	141.625	6036348.0
2022-10-17 10:30:00	AAPL	Stock	141.62	142.0	140.71	140.9772	5897775.0
2022-10-17 11:00:00	AAPL	Stock	140.975	141.22	140.27	141.155	5383796.0
2022-10-17 11:30:00	AAPL	Stock	141.14	141.89	141.0223	141.68	4236387.0
2022-10-17 12:00:00	AAPL	Stock	141.68	141.85	141.19	141.7103	3090014.0
2022-10-17 12:30:00	AAPL	Stock	141.71	141.93	141.39	141.8293	2689533.0
2022-10-17 13:00:00	AAPL	Stock	141.83	142.47	141.67	142.425	3655537.0
2022-10-17 13:30:00	AAPL	Stock	142.42	142.59	142.15	142.3578	3218025.0
2022-10-17 14:00:00	AAPL	Stock	142.37	142.62	142.1659	142.35	3265566.0
2022-10-17 14:30:00	AAPL	Stock	142.35	142.83	142.28	142.68	3038931.0
2022-10-17 15:00:00	AAPL	Stock	142.67	142.7586	142.29	142.57	3678520.0
2022-10-17 15:30:00	AAPL	Stock	142.57	142.9	142.11	142.4	6693153.0
2022-10-17 16:00:00	AAPL	Stock	142.4	142.61	142.1	142.5	11011752.0
2022-10-17 16:30:00	AAPL	Stock	142.47	142.62	142.41	142.5	108850.0
2022-10-17 17:00:00	AAPL	Stock	142.46	142.59	142.43	142.58	24769.0
2022-10-17 17:30:00	AAPL	Stock	142.58	142.72	142.51	142.68	28922.0
2022-10-17 18:00:00	AAPL	Stock	142.67	143.09	142.66	143.03	65974.0
2022-10-17 18:30:00	AAPL	Stock	143.0	143.1	142.93	143.07	29121.0
2022-10-17 19:00:00	AAPL	Stock	143.08	143.35	143.02	143.35	22242.0
2022-10-17 19:30:00	AAPL	Stock	143.35	143.5	143.25	143.45	47655.0
2022-10-17 04:00:00	MSFT	Stock	232.0	232.05	231.08	231.08	15853.0
2022-10-17 04:30:00	MSFT	Stock	231.29	231.45	231.29	231.45	200.0
2022-10-17 05:00:00	MSFT	Stock	231.5	231.52	231.5	231.52	720.0
2022-10-17 05:30:00	MSFT	Stock	231.6	231.68	231.55	231.55	1817.0
2022-10-17 06:00:00	MSFT	Stock	231.45	232.93	231.4	232.12	5523.0
2022-10-17 06:30:00	MSFT	Stock	232.15	232.15	231.7	231.82	2049.0
2022-10-17 07:00:00	MSFT	Stock	232.0	232.0	231.34	231.8	9443.0
2022-10-17 07:30:00	MSFT	Stock	231.8	232.3	231.6	232.3	5116.0
2022-10-17 08:00:00	MSFT	Stock	231.7215	232.4	227.989	232.13	31963.0
2022-10-17 08:30:00	MSFT	Stock	232.3	233.49	232.27	233.33	38731.0
2022-10-17 09:00:00	MSFT	Stock	233.48	235.93	233.36	235.93	92639.0
2022-10-17 09:30:00	MSFT	Stock	235.82	238.96	235.68	237.181	3371579.0
2022-10-17 10:00:00	MSFT	Stock	237.18	238.06	236.6	236.98	1161083.0
2022-10-17 10:30:00	MSFT	Stock	237.0	237.35	235.4211	235.879	1187066.0
2022-10-17 11:00:00	MSFT	Stock	235.87	236.71	235.135	236.68	1091056.0
2022-10-17 11:30:00	MSFT	Stock	236.655	237.49	236.17	237.11	1013598.0
2022-10-17 12:00:00	MSFT	Stock	237.09	237.24	236.12	236.49	713920.0
2022-10-17 12:30:00	MSFT	Stock	236.51	237.09	235.78	236.06	680529.0

> showing 50 of 102,197 rows — these rows as CSV

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