PREVIEW / stock_30min / 2022-09-29

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-29.parquet
  size:    2.1 MB
  rows:    103,723
  symbols: 2,228

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-29 04:00:00	AAPL	Stock	148.19	148.19	147.33	147.75	38412.0
2022-09-29 04:30:00	AAPL	Stock	147.75	147.8	147.39	147.49	34150.0
2022-09-29 05:00:00	AAPL	Stock	147.6	148.03	147.47	147.75	17553.0
2022-09-29 05:30:00	AAPL	Stock	147.73	148.19	147.66	148.0	49272.0
2022-09-29 06:00:00	AAPL	Stock	148.05	148.1	145.38	145.7	213305.0
2022-09-29 06:30:00	AAPL	Stock	145.85	146.6	145.5	146.23	148750.0
2022-09-29 07:00:00	AAPL	Stock	146.38	146.97	146.29	146.65	266821.0
2022-09-29 07:30:00	AAPL	Stock	146.68	147.0	146.22	146.59	170279.0
2022-09-29 08:00:00	AAPL	Stock	146.64	149.466	146.0012	146.74	418029.0
2022-09-29 08:30:00	AAPL	Stock	146.74	146.95	145.79	146.55	489162.0
2022-09-29 09:00:00	AAPL	Stock	146.51	147.2	145.6	146.03	516802.0
2022-09-29 09:30:00	AAPL	Stock	146.1	146.72	143.73	144.1	17209877.0
2022-09-29 10:00:00	AAPL	Stock	144.1	144.29	142.73	143.4301	11540830.0
2022-09-29 10:30:00	AAPL	Stock	143.43	143.63	142.731	143.2	7161312.0
2022-09-29 11:00:00	AAPL	Stock	143.19	143.4142	142.35	142.88	6452310.0
2022-09-29 11:30:00	AAPL	Stock	142.88	143.92	142.8	143.585	5279059.0
2022-09-29 12:00:00	AAPL	Stock	143.59	143.94	142.75	142.865	4900526.0
2022-09-29 12:30:00	AAPL	Stock	142.86	142.875	142.13	142.1459	3883998.0
2022-09-29 13:00:00	AAPL	Stock	142.145	142.6	141.97	142.315	3891827.0
2022-09-29 13:30:00	AAPL	Stock	142.311	142.73	141.45	141.489	5628267.0
2022-09-29 14:00:00	AAPL	Stock	141.48	141.51	140.68	141.27	6436184.0
2022-09-29 14:30:00	AAPL	Stock	141.26	141.665	140.71	140.74	5938238.0
2022-09-29 15:00:00	AAPL	Stock	140.735	141.85	140.72	141.4874	7552840.0
2022-09-29 15:30:00	AAPL	Stock	141.48	142.65	141.445	142.59	13669445.0
2022-09-29 16:00:00	AAPL	Stock	142.59	142.93	142.3	142.3	10083809.0
2022-09-29 16:30:00	AAPL	Stock	142.31	142.48	141.95	142.02	192227.0
2022-09-29 17:00:00	AAPL	Stock	142.0002	142.07	141.75	141.81	69823.0
2022-09-29 17:30:00	AAPL	Stock	141.84	141.92	141.6	141.89	40230.0
2022-09-29 18:00:00	AAPL	Stock	141.87	142.41	141.87	141.92	74889.0
2022-09-29 18:30:00	AAPL	Stock	141.93	142.16	141.91	142.15	20224.0
2022-09-29 19:00:00	AAPL	Stock	142.19	142.38	142.19	142.31	24991.0
2022-09-29 19:30:00	AAPL	Stock	142.3	142.5	142.3	142.41	48120.0
2022-09-29 04:00:00	MSFT	Stock	238.02	238.59	237.6	238.39	3826.0
2022-09-29 04:30:00	MSFT	Stock	238.34	238.34	237.84	237.84	587.0
2022-09-29 05:00:00	MSFT	Stock	238.17	239.0	238.17	239.0	1457.0
2022-09-29 05:30:00	MSFT	Stock	238.75	239.39	238.67	239.03	1533.0
2022-09-29 06:00:00	MSFT	Stock	238.8	239.02	237.98	237.98	2605.0
2022-09-29 07:00:00	MSFT	Stock	238.53	239.25	238.53	239.22	8612.0
2022-09-29 07:30:00	MSFT	Stock	239.2	239.25	238.52	238.52	5339.0
2022-09-29 08:00:00	MSFT	Stock	239.05	240.468	237.8	238.65	28871.0
2022-09-29 08:30:00	MSFT	Stock	238.48	238.78	237.02	237.7529	23121.0
2022-09-29 09:00:00	MSFT	Stock	237.75	239.3818	237.69	238.94	60404.0
2022-09-29 09:30:00	MSFT	Stock	239.15	239.95	236.0	236.04	2343453.0
2022-09-29 10:00:00	MSFT	Stock	236.06	236.415	234.41	235.1201	1606212.0
2022-09-29 10:30:00	MSFT	Stock	235.1	235.98	234.48	235.44	1532761.0
2022-09-29 11:00:00	MSFT	Stock	235.43	236.31	235.15	235.81	941597.0
2022-09-29 11:30:00	MSFT	Stock	235.805	237.07	235.43	236.77	1064844.0
2022-09-29 12:00:00	MSFT	Stock	236.77	236.91	235.53	235.647	827480.0
2022-09-29 12:30:00	MSFT	Stock	235.625	236.169	235.11	235.24	566110.0
2022-09-29 13:00:00	MSFT	Stock	235.22	235.78	235.0	235.52	614256.0

> showing 50 of 103,723 rows — these rows as CSV

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