PREVIEW / stock_30min / 2023-02-02

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-02.parquet
  size:    2.3 MB
  rows:    109,914
  symbols: 1,912

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
2023-02-02 04:00:00	AAPL	Stock	147.14	147.49	146.56	147.0	79604.0
2023-02-02 04:30:00	AAPL	Stock	147.0	147.02	146.9	146.98	16681.0
2023-02-02 05:00:00	AAPL	Stock	146.98	147.15	146.96	146.99	34126.0
2023-02-02 05:30:00	AAPL	Stock	146.98	147.0	146.83	146.96	9968.0
2023-02-02 06:00:00	AAPL	Stock	147.0	147.09	146.7	147.03	14450.0
2023-02-02 06:30:00	AAPL	Stock	146.99	147.06	146.82	146.94	18256.0
2023-02-02 07:00:00	AAPL	Stock	146.95	147.25	146.7	147.15	76507.0
2023-02-02 07:30:00	AAPL	Stock	147.16	147.7	147.15	147.69	95430.0
2023-02-02 08:00:00	AAPL	Stock	147.66	147.8	146.0	147.7109	427283.0
2023-02-02 08:30:00	AAPL	Stock	147.7	148.38	147.45	148.33	404778.0
2023-02-02 09:00:00	AAPL	Stock	148.33	149.0	148.06	148.8	523176.0
2023-02-02 09:30:00	AAPL	Stock	148.82	149.51	148.35	148.59	10293904.0
2023-02-02 10:00:00	AAPL	Stock	148.5888	149.06	148.17	148.97	5260049.0
2023-02-02 10:30:00	AAPL	Stock	148.98	150.5	148.94	150.1508	7297779.0
2023-02-02 11:00:00	AAPL	Stock	150.16	150.2	149.57	150.034	4384421.0
2023-02-02 11:30:00	AAPL	Stock	150.04	150.44	149.72	149.76	3952430.0
2023-02-02 12:00:00	AAPL	Stock	149.77	150.09	149.43	149.9156	3724962.0
2023-02-02 12:30:00	AAPL	Stock	149.92	150.28	149.63	149.92	3256920.0
2023-02-02 13:00:00	AAPL	Stock	149.93	150.305	149.9	149.95	3681934.0
2023-02-02 13:30:00	AAPL	Stock	149.95	150.99	149.9127	150.955	4006437.0
2023-02-02 14:00:00	AAPL	Stock	150.955	151.18	150.12	150.23	4236302.0
2023-02-02 14:30:00	AAPL	Stock	150.23	150.31	148.95	149.045	5204725.0
2023-02-02 15:00:00	AAPL	Stock	149.05	149.76	148.72	149.595	5749150.0
2023-02-02 15:30:00	AAPL	Stock	149.595	150.92	149.46	150.92	9596546.0
2023-02-02 16:00:00	AAPL	Stock	150.93	152.0795	149.02	151.4	11647551.0
2023-02-02 16:30:00	AAPL	Stock	151.18	151.4	142.3	145.0	5813442.0
2023-02-02 17:00:00	AAPL	Stock	144.9	150.82	143.95	145.4	2011334.0
2023-02-02 17:30:00	AAPL	Stock	145.4	151.51	145.05	149.8799	2565876.0
2023-02-02 18:00:00	AAPL	Stock	149.77	149.89	146.75	147.65	823894.0
2023-02-02 18:30:00	AAPL	Stock	147.65	148.45	145.75	145.9	451376.0
2023-02-02 19:00:00	AAPL	Stock	145.8501	146.22	145.17	145.9	275923.0
2023-02-02 19:30:00	AAPL	Stock	145.96	146.0	145.5	145.99	209954.0
2023-02-02 04:00:00	MSFT	Stock	254.03	254.82	253.15	253.8	24465.0
2023-02-02 04:30:00	MSFT	Stock	253.75	254.3	253.71	254.3	7419.0
2023-02-02 05:00:00	MSFT	Stock	254.3	254.61	254.3	254.6	3562.0
2023-02-02 05:30:00	MSFT	Stock	254.32	254.32	253.99	254.2	11682.0
2023-02-02 06:00:00	MSFT	Stock	254.2	254.49	253.97	254.37	9434.0
2023-02-02 06:30:00	MSFT	Stock	254.36	254.49	253.73	253.9	9028.0
2023-02-02 07:00:00	MSFT	Stock	253.8	254.16	253.47	254.0	14885.0
2023-02-02 07:30:00	MSFT	Stock	254.08	254.9	254.08	254.9	32556.0
2023-02-02 08:00:00	MSFT	Stock	253.9	255.45	252.119	255.21	51905.0
2023-02-02 08:30:00	MSFT	Stock	255.5	256.5	255.4	255.9	45899.0
2023-02-02 09:00:00	MSFT	Stock	255.8	259.25	255.559	258.87	177881.0
2023-02-02 09:30:00	MSFT	Stock	258.87	260.66	258.05	258.12	4306107.0
2023-02-02 10:00:00	MSFT	Stock	258.15	259.13	257.25	258.89	1961049.0
2023-02-02 10:30:00	MSFT	Stock	258.9	260.79	258.9	260.16	1821023.0
2023-02-02 11:00:00	MSFT	Stock	260.17	261.32	259.85	261.14	1507810.0
2023-02-02 11:30:00	MSFT	Stock	261.13	263.1399	261.11	261.4	1937349.0
2023-02-02 12:00:00	MSFT	Stock	261.41	261.88	260.6402	260.81	1101961.0
2023-02-02 12:30:00	MSFT	Stock	260.82	261.855	260.76	261.59	969924.0

> showing 50 of 109,914 rows — these rows as CSV

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