PREVIEW / stock_30min / 2023-02-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-13.parquet
  size:    2.1 MB
  rows:    101,413
  symbols: 1,864

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-13 04:00:00	AAPL	Stock	150.78	151.03	150.43	150.73	11415.0
2023-02-13 04:30:00	AAPL	Stock	150.8	150.88	150.51	150.62	7776.0
2023-02-13 05:00:00	AAPL	Stock	150.59	150.7	150.57	150.6	10371.0
2023-02-13 05:30:00	AAPL	Stock	150.64	150.89	150.64	150.82	6742.0
2023-02-13 06:00:00	AAPL	Stock	150.88	150.95	150.74	150.82	5275.0
2023-02-13 06:30:00	AAPL	Stock	150.93	150.96	150.77	150.92	6604.0
2023-02-13 07:00:00	AAPL	Stock	150.98	151.7	150.98	151.62	39959.0
2023-02-13 07:30:00	AAPL	Stock	151.6	151.61	151.3	151.38	17231.0
2023-02-13 08:00:00	AAPL	Stock	151.07	151.69	149.98	151.33	128576.0
2023-02-13 08:30:00	AAPL	Stock	151.3	151.37	151.05	151.05	79306.0
2023-02-13 09:00:00	AAPL	Stock	151.05	151.36	150.7506	150.96	146529.0
2023-02-13 09:30:00	AAPL	Stock	150.96	152.19	150.92	152.1807	5154567.0
2023-02-13 10:00:00	AAPL	Stock	152.19	152.58	151.8675	152.43	3201055.0
2023-02-13 10:30:00	AAPL	Stock	152.36	152.785	152.01	152.62	3382338.0
2023-02-13 11:00:00	AAPL	Stock	152.64	153.21	152.64	153.1423	3769681.0
2023-02-13 11:30:00	AAPL	Stock	153.15	153.69	152.9678	153.42	3206000.0
2023-02-13 12:00:00	AAPL	Stock	153.44	154.26	153.41	154.0699	3599508.0
2023-02-13 12:30:00	AAPL	Stock	154.07	154.2523	153.73	153.805	2410344.0
2023-02-13 13:00:00	AAPL	Stock	153.805	154.02	153.47	153.96	2467709.0
2023-02-13 13:30:00	AAPL	Stock	153.965	154.17	153.7	153.98	2086553.0
2023-02-13 14:00:00	AAPL	Stock	153.98	154.02	153.3	153.38	1785494.0
2023-02-13 14:30:00	AAPL	Stock	153.38	153.4086	152.76	153.07	2624939.0
2023-02-13 15:00:00	AAPL	Stock	153.07	153.64	152.76	153.6315	3222529.0
2023-02-13 15:30:00	AAPL	Stock	153.6302	153.98	153.45	153.84	6116324.0
2023-02-13 16:00:00	AAPL	Stock	153.84	153.85	153.66	153.85	9918962.0
2023-02-13 16:30:00	AAPL	Stock	153.78	153.85	153.71	153.71	44974.0
2023-02-13 17:00:00	AAPL	Stock	153.74	153.88	153.71	153.7626	180048.0
2023-02-13 17:30:00	AAPL	Stock	153.84	153.89	153.76	153.8	18064.0
2023-02-13 18:00:00	AAPL	Stock	153.83	153.84	153.75	153.8	8105.0
2023-02-13 18:30:00	AAPL	Stock	153.76	153.8	153.63	153.71	11561.0
2023-02-13 19:00:00	AAPL	Stock	153.7	153.7	153.6101	153.65	18810.0
2023-02-13 19:30:00	AAPL	Stock	153.66	153.7	153.6	153.7	27966.0
2023-02-13 04:00:00	MSFT	Stock	264.63	265.78	264.63	265.37	14821.0
2023-02-13 04:30:00	MSFT	Stock	265.38	265.62	265.05	265.39	13554.0
2023-02-13 05:00:00	MSFT	Stock	265.35	265.64	265.04	265.64	7272.0
2023-02-13 05:30:00	MSFT	Stock	265.7	266.38	265.7	266.38	4914.0
2023-02-13 06:00:00	MSFT	Stock	266.34	266.4	265.96	266.3	6214.0
2023-02-13 06:30:00	MSFT	Stock	266.3	266.68	266.1	266.3	6515.0
2023-02-13 07:00:00	MSFT	Stock	266.4	267.35	266.1	267.14	25541.0
2023-02-13 07:30:00	MSFT	Stock	267.1	267.1	266.4	266.42	22068.0
2023-02-13 08:00:00	MSFT	Stock	266.6	267.45	262.443	266.59	89309.0
2023-02-13 08:30:00	MSFT	Stock	266.59	266.59	265.78	266.105	33959.0
2023-02-13 09:00:00	MSFT	Stock	266.06	267.84	266.0	267.59	66552.0
2023-02-13 09:30:00	MSFT	Stock	267.59	272.61	267.15	272.49	6334945.0
2023-02-13 10:00:00	MSFT	Stock	272.49	273.0	271.2	271.885	3638357.0
2023-02-13 10:30:00	MSFT	Stock	271.9	272.4	270.89	271.67	2410402.0
2023-02-13 11:00:00	MSFT	Stock	271.68	273.66	271.68	273.51	2173881.0
2023-02-13 11:30:00	MSFT	Stock	273.54	274.6	273.12	273.655	2878759.0
2023-02-13 12:00:00	MSFT	Stock	273.65	273.84	272.56	272.73	1651390.0
2023-02-13 12:30:00	MSFT	Stock	272.74	272.87	271.79	272.33	1681762.0

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

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