PREVIEW / stock_30min / 2023-02-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-03.parquet
  size:    2.2 MB
  rows:    105,947
  symbols: 1,903

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-03 04:00:00	AAPL	Stock	145.45	145.5	144.8	145.5	38041.0
2023-02-03 04:30:00	AAPL	Stock	145.46	146.24	145.46	146.05	32170.0
2023-02-03 05:00:00	AAPL	Stock	146.01	146.2	145.68	145.77	22678.0
2023-02-03 05:30:00	AAPL	Stock	145.67	145.85	145.65	145.78	4779.0
2023-02-03 06:00:00	AAPL	Stock	145.77	145.9	145.51	145.83	13432.0
2023-02-03 06:30:00	AAPL	Stock	145.85	146.93	145.85	146.71	80662.0
2023-02-03 07:00:00	AAPL	Stock	146.71	148.26	146.63	147.0	469416.0
2023-02-03 07:30:00	AAPL	Stock	147.0	149.0	147.0	148.4	312073.0
2023-02-03 08:00:00	AAPL	Stock	147.62	150.09	144.0	149.17	1128071.0
2023-02-03 08:30:00	AAPL	Stock	149.04	149.5	147.346	147.74	1189873.0
2023-02-03 09:00:00	AAPL	Stock	147.76	148.69	147.5	147.94	712029.0
2023-02-03 09:30:00	AAPL	Stock	148.03	153.45	147.83	153.25	18900839.0
2023-02-03 10:00:00	AAPL	Stock	153.24	156.77	152.57	156.22	20145516.0
2023-02-03 10:30:00	AAPL	Stock	156.225	157.38	155.305	155.77	11540604.0
2023-02-03 11:00:00	AAPL	Stock	155.79	156.56	155.52	156.4921	6668469.0
2023-02-03 11:30:00	AAPL	Stock	156.5	157.2	155.61	155.72	7575705.0
2023-02-03 12:00:00	AAPL	Stock	155.72	156.9899	155.49	156.28	5541447.0
2023-02-03 12:30:00	AAPL	Stock	156.29	156.41	154.44	154.5789	5188534.0
2023-02-03 13:00:00	AAPL	Stock	154.58	155.1499	154.265	155.06	4978254.0
2023-02-03 13:30:00	AAPL	Stock	155.03	155.84	154.39	155.3464	6442978.0
2023-02-03 14:00:00	AAPL	Stock	155.35	155.58	154.69	155.18	3915933.0
2023-02-03 14:30:00	AAPL	Stock	155.1771	155.69	154.4	154.68	4859279.0
2023-02-03 15:00:00	AAPL	Stock	154.68	155.325	154.09	154.905	5102203.0
2023-02-03 15:30:00	AAPL	Stock	154.9	155.15	154.3	154.5	8337625.0
2023-02-03 16:00:00	AAPL	Stock	154.495	154.77	154.11	154.19	13720066.0
2023-02-03 16:30:00	AAPL	Stock	154.2	154.5	154.2	154.435	84515.0
2023-02-03 17:00:00	AAPL	Stock	154.43	154.5	154.26	154.39	96234.0
2023-02-03 17:30:00	AAPL	Stock	154.36	154.36	154.03	154.2	28058.0
2023-02-03 18:00:00	AAPL	Stock	154.15	154.35	154.05	154.28	25233.0
2023-02-03 18:30:00	AAPL	Stock	154.32	154.32	154.21	154.28	14200.0
2023-02-03 19:00:00	AAPL	Stock	154.29	154.36	154.25	154.35	14545.0
2023-02-03 19:30:00	AAPL	Stock	154.35	154.39	154.3	154.39	14010.0
2023-02-03 04:00:00	MSFT	Stock	260.7	261.18	260.43	260.8	9947.0
2023-02-03 04:30:00	MSFT	Stock	261.08	261.57	261.08	261.2	7224.0
2023-02-03 05:00:00	MSFT	Stock	261.2	261.35	261.0	261.0	2555.0
2023-02-03 05:30:00	MSFT	Stock	261.05	261.23	261.0	261.23	1900.0
2023-02-03 06:00:00	MSFT	Stock	261.41	262.1	261.34	262.1	9054.0
2023-02-03 06:30:00	MSFT	Stock	262.07	262.52	261.63	261.74	3575.0
2023-02-03 07:00:00	MSFT	Stock	262.0	262.32	261.47	261.67	25566.0
2023-02-03 07:30:00	MSFT	Stock	261.7	262.55	261.5	262.49	8984.0
2023-02-03 08:00:00	MSFT	Stock	261.78	263.939	260.36	262.6	39249.0
2023-02-03 08:30:00	MSFT	Stock	262.55	262.55	258.1	259.05	143736.0
2023-02-03 09:00:00	MSFT	Stock	259.2	264.6	258.0	259.56	82841.0
2023-02-03 09:30:00	MSFT	Stock	259.55	262.19	259.02	261.82	2863767.0
2023-02-03 10:00:00	MSFT	Stock	261.72	264.2	260.6	262.4649	1914953.0
2023-02-03 10:30:00	MSFT	Stock	262.47	263.1831	261.33	261.805	1205120.0
2023-02-03 11:00:00	MSFT	Stock	261.8	263.545	261.7	263.2101	831200.0
2023-02-03 11:30:00	MSFT	Stock	263.25	263.79	261.21	261.41	938600.0
2023-02-03 12:00:00	MSFT	Stock	261.42	262.8	261.25	262.45	580883.0
2023-02-03 12:30:00	MSFT	Stock	262.4564	262.7499	260.16	260.43	531576.0

> showing 50 of 105,947 rows — these rows as CSV

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