PREVIEW / stock_30min / 2023-05-05

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-05.parquet
  size:    2.1 MB
  rows:    101,744
  symbols: 1,655

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-05-05 04:00:00	AAPL	Stock	170.0	170.0	169.28	169.35	33421.0
2023-05-05 04:30:00	AAPL	Stock	169.32	169.51	169.32	169.51	32449.0
2023-05-05 05:00:00	AAPL	Stock	169.49	169.5	169.35	169.41	14529.0
2023-05-05 05:30:00	AAPL	Stock	169.4	169.68	169.4	169.6	19263.0
2023-05-05 06:00:00	AAPL	Stock	169.63	169.84	169.54	169.57	30029.0
2023-05-05 06:30:00	AAPL	Stock	169.57	169.84	169.46	169.49	19250.0
2023-05-05 07:00:00	AAPL	Stock	169.49	170.42	169.44	170.38	146449.0
2023-05-05 07:30:00	AAPL	Stock	170.4	170.4	169.83	170.09	84660.0
2023-05-05 08:00:00	AAPL	Stock	169.4999	170.44	169.36	169.72	514571.0
2023-05-05 08:30:00	AAPL	Stock	169.75	170.71	169.0	170.01	800920.0
2023-05-05 09:00:00	AAPL	Stock	170.01	171.0	169.83	171.0	482081.0
2023-05-05 09:30:00	AAPL	Stock	171.0	173.75	170.76	173.12	22128846.0
2023-05-05 10:00:00	AAPL	Stock	173.14	173.55	172.72	173.37	7790984.0
2023-05-05 10:30:00	AAPL	Stock	173.37	174.2	173.18	173.56	8684670.0
2023-05-05 11:00:00	AAPL	Stock	173.5648	173.9	173.33	173.8377	4737566.0
2023-05-05 11:30:00	AAPL	Stock	173.84	174.05	173.55	173.7937	4274300.0
2023-05-05 12:00:00	AAPL	Stock	173.795	174.05	173.23	173.265	3851203.0
2023-05-05 12:30:00	AAPL	Stock	173.265	173.64	173.21	173.465	3116500.0
2023-05-05 13:00:00	AAPL	Stock	173.47	173.64	173.24	173.64	2862016.0
2023-05-05 13:30:00	AAPL	Stock	173.645	174.09	173.6424	173.8819	3581559.0
2023-05-05 14:00:00	AAPL	Stock	173.8858	174.0925	173.69	174.08	2996022.0
2023-05-05 14:30:00	AAPL	Stock	174.075	174.18	173.77	174.145	3349054.0
2023-05-05 15:00:00	AAPL	Stock	174.15	174.3	173.3	173.745	4824074.0
2023-05-05 15:30:00	AAPL	Stock	173.745	174.08	173.35	173.62	8588009.0
2023-05-05 16:00:00	AAPL	Stock	173.63	173.69	173.0	173.44	9377196.0
2023-05-05 16:30:00	AAPL	Stock	173.44	173.57	173.4	173.49	180541.0
2023-05-05 17:00:00	AAPL	Stock	173.5	173.55	173.23	173.2943	70679.0
2023-05-05 17:30:00	AAPL	Stock	173.2412	173.31	173.03	173.05	88211.0
2023-05-05 18:00:00	AAPL	Stock	173.06	173.14	173.05	173.1	21535.0
2023-05-05 18:30:00	AAPL	Stock	173.1	173.27	173.0901	173.27	47323.0
2023-05-05 19:00:00	AAPL	Stock	173.27	173.27	173.1	173.18	18090.0
2023-05-05 19:30:00	AAPL	Stock	173.18	173.2	173.08	173.08	36488.0
2023-05-05 04:00:00	MSFT	Stock	305.86	306.7	305.86	306.7	800.0
2023-05-05 04:30:00	MSFT	Stock	306.5	306.6	306.2	306.2	2786.0
2023-05-05 05:00:00	MSFT	Stock	306.07	306.3	306.0	306.3	2774.0
2023-05-05 05:30:00	MSFT	Stock	306.28	306.9	306.28	306.9	1795.0
2023-05-05 06:00:00	MSFT	Stock	306.9	306.95	306.8	306.95	2351.0
2023-05-05 06:30:00	MSFT	Stock	306.94	307.1	306.94	307.1	508.0
2023-05-05 07:00:00	MSFT	Stock	307.0	307.28	306.8	307.2	4393.0
2023-05-05 07:30:00	MSFT	Stock	307.1	307.15	306.8	307.15	13515.0
2023-05-05 08:00:00	MSFT	Stock	306.9478	307.2899	305.95	307.2	23450.0
2023-05-05 08:30:00	MSFT	Stock	307.0	307.05	305.5749	305.7	45798.0
2023-05-05 09:00:00	MSFT	Stock	305.8	306.79	305.27	305.9	48916.0
2023-05-05 09:30:00	MSFT	Stock	305.72	307.15	304.27	307.0499	2292283.0
2023-05-05 10:00:00	MSFT	Stock	307.05	308.49	306.8818	308.27	1708475.0
2023-05-05 10:30:00	MSFT	Stock	308.3164	309.42	308.165	308.84	1477749.0
2023-05-05 11:00:00	MSFT	Stock	308.86	309.3796	308.24	309.37	1056979.0
2023-05-05 11:30:00	MSFT	Stock	309.365	309.5873	308.705	309.015	973800.0
2023-05-05 12:00:00	MSFT	Stock	309.03	309.14	308.5	308.8246	613707.0
2023-05-05 12:30:00	MSFT	Stock	308.84	309.55	308.5	309.4668	667767.0

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

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