PREVIEW / stock_30min / 2022-01-13

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-13.parquet
  size:    2.2 MB
  rows:    107,879
  symbols: 2,593

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-01-13 04:00:00	AAPL	Stock	175.3	175.48	175.12	175.45	10049.0
2022-01-13 04:30:00	AAPL	Stock	175.46	175.46	175.25	175.3	6059.0
2022-01-13 05:00:00	AAPL	Stock	175.3	175.47	175.3	175.47	10304.0
2022-01-13 05:30:00	AAPL	Stock	175.48	175.62	175.36	175.4	3766.0
2022-01-13 06:00:00	AAPL	Stock	175.41	175.56	175.15	175.15	4184.0
2022-01-13 06:30:00	AAPL	Stock	175.28	175.3	175.01	175.3	3841.0
2022-01-13 07:00:00	AAPL	Stock	175.17	175.37	174.42	175.37	27249.0
2022-01-13 07:30:00	AAPL	Stock	175.36	175.5	175.27	175.35	19203.0
2022-01-13 08:00:00	AAPL	Stock	175.09	175.5	175.08	175.4	107583.0
2022-01-13 08:30:00	AAPL	Stock	175.4	175.75	175.21	175.59	264964.0
2022-01-13 09:00:00	AAPL	Stock	175.62	175.9	175.55	175.8	179662.0
2022-01-13 09:30:00	AAPL	Stock	175.78	176.62	175.55	176.02	8041566.0
2022-01-13 10:00:00	AAPL	Stock	176.02	176.18	174.88	175.58	5663091.0
2022-01-13 10:30:00	AAPL	Stock	175.57	175.75	174.7	175.43	5736878.0
2022-01-13 11:00:00	AAPL	Stock	175.41	175.48	174.53	175.06	4506592.0
2022-01-13 11:30:00	AAPL	Stock	175.045	175.4799	174.7347	175.365	3044543.0
2022-01-13 12:00:00	AAPL	Stock	175.36	175.545	173.48	173.61	5315571.0
2022-01-13 12:30:00	AAPL	Stock	173.61	173.92	172.82	173.2991	3855961.0
2022-01-13 13:00:00	AAPL	Stock	173.29	173.88	172.98	173.5672	3709818.0
2022-01-13 13:30:00	AAPL	Stock	173.55	173.99	173.3	173.8862	2579251.0
2022-01-13 14:00:00	AAPL	Stock	173.885	174.2	173.32	173.55	3185726.0
2022-01-13 14:30:00	AAPL	Stock	173.55	173.73	173.16	173.37	3058090.0
2022-01-13 15:00:00	AAPL	Stock	173.38	173.38	172.67	173.2399	4197508.0
2022-01-13 15:30:00	AAPL	Stock	173.23	173.53	171.79	172.32	9790370.0
2022-01-13 16:00:00	AAPL	Stock	172.28	172.6	171.95	172.09	9660803.0
2022-01-13 16:30:00	AAPL	Stock	172.11	172.43	172.06	172.23	60492.0
2022-01-13 17:00:00	AAPL	Stock	172.25	172.37	172.19	172.3	31766.0
2022-01-13 17:30:00	AAPL	Stock	172.3	172.3	172.2	172.25	37502.0
2022-01-13 18:00:00	AAPL	Stock	172.29	172.38	172.2	172.23	15159.0
2022-01-13 18:30:00	AAPL	Stock	172.22	172.35	172.2	172.33	10588.0
2022-01-13 19:00:00	AAPL	Stock	172.31	172.46	172.0	172.3	41830.0
2022-01-13 19:30:00	AAPL	Stock	172.21	172.4599	172.07	172.1	34139.0
2022-01-13 04:00:00	MSFT	Stock	317.73	318.1	317.73	318.1	456.0
2022-01-13 04:30:00	MSFT	Stock	318.59	318.59	318.45	318.45	247.0
2022-01-13 05:00:00	MSFT	Stock	318.58	318.58	318.58	318.58	100.0
2022-01-13 05:30:00	MSFT	Stock	318.79	319.11	318.79	318.8	1681.0
2022-01-13 06:00:00	MSFT	Stock	318.88	319.18	318.16	318.19	4210.0
2022-01-13 06:30:00	MSFT	Stock	318.25	318.25	317.71	317.71	692.0
2022-01-13 07:00:00	MSFT	Stock	318.0	318.24	317.45	318.2	4316.0
2022-01-13 07:30:00	MSFT	Stock	318.2	319.05	318.18	319.0	14459.0
2022-01-13 08:00:00	MSFT	Stock	318.6	319.3978	317.3201	319.11	16172.0
2022-01-13 08:30:00	MSFT	Stock	319.11	320.86	318.75	320.31	70549.0
2022-01-13 09:00:00	MSFT	Stock	320.4	321.48	320.21	320.55	33149.0
2022-01-13 09:30:00	MSFT	Stock	320.51	320.88	318.16	318.71	2158068.0
2022-01-13 10:00:00	MSFT	Stock	318.8745	318.97	316.91	317.77	1386253.0
2022-01-13 10:30:00	MSFT	Stock	317.73	318.01	314.28	314.32	1585787.0
2022-01-13 11:00:00	MSFT	Stock	314.28	314.7735	312.11	314.37	2075447.0
2022-01-13 11:30:00	MSFT	Stock	314.37	314.5696	312.83	313.6243	1080933.0
2022-01-13 12:00:00	MSFT	Stock	313.61	313.61	309.22	310.0	1981116.0
2022-01-13 12:30:00	MSFT	Stock	309.99	310.78	308.875	309.58	1847231.0

> showing 50 of 107,879 rows — these rows as CSV

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