PREVIEW / stock_30min / 2022-07-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-14.parquet
  size:    2.0 MB
  rows:    101,757
  symbols: 2,300

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-14 04:00:00	AAPL	Stock	144.49	144.97	144.36	144.51	19610.0
2022-07-14 04:30:00	AAPL	Stock	144.46	144.59	143.68	144.17	23873.0
2022-07-14 05:00:00	AAPL	Stock	144.13	144.25	143.9	144.01	6722.0
2022-07-14 05:30:00	AAPL	Stock	144.13	144.37	143.94	144.34	5140.0
2022-07-14 06:00:00	AAPL	Stock	144.25	144.36	144.19	144.25	973.0
2022-07-14 06:30:00	AAPL	Stock	144.24	144.43	143.91	144.39	12714.0
2022-07-14 07:00:00	AAPL	Stock	144.36	144.37	143.9	143.95	43796.0
2022-07-14 07:30:00	AAPL	Stock	143.95	144.19	143.89	144.12	41628.0
2022-07-14 08:00:00	AAPL	Stock	144.2	145.68	143.84	144.2299	242298.0
2022-07-14 08:30:00	AAPL	Stock	144.25	144.77	143.9	144.33	212185.0
2022-07-14 09:00:00	AAPL	Stock	144.29	144.59	144.0	144.09	143712.0
2022-07-14 09:30:00	AAPL	Stock	144.08	144.7699	143.25	144.08	7692408.0
2022-07-14 10:00:00	AAPL	Stock	144.0836	144.61	143.6101	144.37	4847325.0
2022-07-14 10:30:00	AAPL	Stock	144.37	145.08	143.92	144.822	4554846.0
2022-07-14 11:00:00	AAPL	Stock	144.82	146.07	144.79	146.03	5024864.0
2022-07-14 11:30:00	AAPL	Stock	146.03	147.17	145.7101	147.1509	5946777.0
2022-07-14 12:00:00	AAPL	Stock	147.155	147.32	146.42	146.5	3591995.0
2022-07-14 12:30:00	AAPL	Stock	146.499	146.8	146.1001	146.6273	2922812.0
2022-07-14 13:00:00	AAPL	Stock	146.6301	147.5	146.32	147.41	3448455.0
2022-07-14 13:30:00	AAPL	Stock	147.415	147.66	147.051	147.545	3598239.0
2022-07-14 14:00:00	AAPL	Stock	147.55	148.56	147.48	148.465	4549221.0
2022-07-14 14:30:00	AAPL	Stock	148.47	148.8416	148.31	148.6794	4135024.0
2022-07-14 15:00:00	AAPL	Stock	148.68	148.95	148.27	148.86	4079299.0
2022-07-14 15:30:00	AAPL	Stock	148.85	148.95	148.03	148.48	6495231.0
2022-07-14 16:00:00	AAPL	Stock	148.47	148.67	148.31	148.43	5728225.0
2022-07-14 16:30:00	AAPL	Stock	148.4145	148.63	148.41	148.57	272670.0
2022-07-14 17:00:00	AAPL	Stock	148.58	148.64	148.55	148.64	12611.0
2022-07-14 17:30:00	AAPL	Stock	148.65	148.7393	148.61	148.71	8906.0
2022-07-14 18:00:00	AAPL	Stock	148.7	148.91	148.66	148.84	26665.0
2022-07-14 18:30:00	AAPL	Stock	148.87	149.19	148.82	149.06	41615.0
2022-07-14 19:00:00	AAPL	Stock	149.0	149.1	149.0	149.05	10406.0
2022-07-14 19:30:00	AAPL	Stock	149.04	149.4	149.04	149.37	35153.0
2022-07-14 04:00:00	MSFT	Stock	251.09	251.57	250.8	250.8	1432.0
2022-07-14 04:30:00	MSFT	Stock	250.44	250.44	249.5	250.05	2125.0
2022-07-14 05:00:00	MSFT	Stock	250.0	250.5	249.99	250.5	810.0
2022-07-14 05:30:00	MSFT	Stock	250.04	250.55	250.02	250.55	2490.0
2022-07-14 06:30:00	MSFT	Stock	250.94	251.05	250.08	250.97	5184.0
2022-07-14 07:00:00	MSFT	Stock	250.78	250.89	250.16	250.16	10167.0
2022-07-14 07:30:00	MSFT	Stock	250.47	250.5	250.0	250.4	2624.0
2022-07-14 08:00:00	MSFT	Stock	250.5545	250.94	249.6991	250.3001	15102.0
2022-07-14 08:30:00	MSFT	Stock	250.41	251.2	249.72	250.28	27639.0
2022-07-14 09:00:00	MSFT	Stock	250.278	251.2	249.69	250.87	31575.0
2022-07-14 09:30:00	MSFT	Stock	250.67	251.4	247.8	247.8101	1845340.0
2022-07-14 10:00:00	MSFT	Stock	247.81	248.1974	246.23	246.27	1640185.0
2022-07-14 10:30:00	MSFT	Stock	246.27	249.55	245.94	248.6	1641357.0
2022-07-14 11:00:00	MSFT	Stock	248.61	250.75	248.41	250.63	1173973.0
2022-07-14 11:30:00	MSFT	Stock	250.65	252.07	250.0	251.49	1119740.0
2022-07-14 12:00:00	MSFT	Stock	251.55	251.91	250.4801	250.54	736342.0
2022-07-14 12:30:00	MSFT	Stock	250.5582	251.0386	249.87	250.46	654692.0
2022-07-14 13:00:00	MSFT	Stock	250.46	252.37	250.195	252.265	718222.0

> showing 50 of 101,757 rows — these rows as CSV

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