PREVIEW / stock_30min / 2023-03-24

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-24.parquet
  size:    2.0 MB
  rows:    99,860
  symbols: 1,728

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-03-24 04:00:00	AAPL	Stock	159.43	159.7	159.02	159.5	22198.0
2023-03-24 04:30:00	AAPL	Stock	159.4	159.4	158.87	159.04	7435.0
2023-03-24 05:00:00	AAPL	Stock	159.05	159.4	159.01	159.04	4474.0
2023-03-24 05:30:00	AAPL	Stock	159.01	159.01	158.1	158.33	14493.0
2023-03-24 06:00:00	AAPL	Stock	158.25	158.63	158.07	158.15	7742.0
2023-03-24 06:30:00	AAPL	Stock	158.21	158.55	158.01	158.05	14829.0
2023-03-24 07:00:00	AAPL	Stock	158.2	158.48	158.05	158.4	26523.0
2023-03-24 07:30:00	AAPL	Stock	158.45	158.5	158.0	158.02	18874.0
2023-03-24 08:00:00	AAPL	Stock	158.18	159.3	157.82	158.25	115798.0
2023-03-24 08:30:00	AAPL	Stock	158.2	158.84	158.03	158.82	189230.0
2023-03-24 09:00:00	AAPL	Stock	158.83	158.88	158.15	158.88	112653.0
2023-03-24 09:30:00	AAPL	Stock	158.88	159.39	157.85	159.19	5797270.0
2023-03-24 10:00:00	AAPL	Stock	159.2	159.56	158.25	159.02	4515389.0
2023-03-24 10:30:00	AAPL	Stock	159.03	159.17	158.64	159.17	3130283.0
2023-03-24 11:00:00	AAPL	Stock	159.18	159.4	158.11	158.29	3556438.0
2023-03-24 11:30:00	AAPL	Stock	158.295	159.19	158.05	159.09	2962937.0
2023-03-24 12:00:00	AAPL	Stock	159.1	159.47	158.18	158.4	2707377.0
2023-03-24 12:30:00	AAPL	Stock	158.4	158.98	158.29	158.7499	2049899.0
2023-03-24 13:00:00	AAPL	Stock	158.74	159.44	158.565	159.33	2197708.0
2023-03-24 13:30:00	AAPL	Stock	159.32	159.67	158.92	159.15	2585828.0
2023-03-24 14:00:00	AAPL	Stock	159.15	159.6	159.102	159.56	2088757.0
2023-03-24 14:30:00	AAPL	Stock	159.5691	159.95	159.52	159.6731	2539230.0
2023-03-24 15:00:00	AAPL	Stock	159.68	160.06	159.36	159.84	2803967.0
2023-03-24 15:30:00	AAPL	Stock	159.845	160.34	159.73	160.25	4919822.0
2023-03-24 16:00:00	AAPL	Stock	160.27	160.39	160.1	160.25	7198498.0
2023-03-24 16:30:00	AAPL	Stock	160.23	160.37	160.15	160.31	96509.0
2023-03-24 17:00:00	AAPL	Stock	160.35	160.36	159.82	160.04	146257.0
2023-03-24 17:30:00	AAPL	Stock	160.07	160.08	159.9	160.08	22695.0
2023-03-24 18:00:00	AAPL	Stock	160.07	160.14	160.03	160.14	16458.0
2023-03-24 18:30:00	AAPL	Stock	160.05	160.13	160.05	160.08	3217.0
2023-03-24 19:00:00	AAPL	Stock	160.07	160.09	159.92	159.99	10799.0
2023-03-24 19:30:00	AAPL	Stock	160.02	160.2	160.0	160.2	18949.0
2023-03-24 04:00:00	MSFT	Stock	278.89	278.89	277.6	278.19	12078.0
2023-03-24 04:30:00	MSFT	Stock	278.19	278.19	277.0	277.66	4600.0
2023-03-24 05:00:00	MSFT	Stock	277.34	278.04	277.34	277.8	3711.0
2023-03-24 05:30:00	MSFT	Stock	277.4	277.4	276.73	277.1	2217.0
2023-03-24 06:00:00	MSFT	Stock	276.8	276.93	276.2	276.7	8760.0
2023-03-24 06:30:00	MSFT	Stock	276.7	276.86	275.82	275.88	18027.0
2023-03-24 07:00:00	MSFT	Stock	276.2	276.22	275.05	275.66	24593.0
2023-03-24 07:30:00	MSFT	Stock	275.88	276.4	275.41	275.41	6020.0
2023-03-24 08:00:00	MSFT	Stock	276.3	278.83	274.8	276.18	29372.0
2023-03-24 08:30:00	MSFT	Stock	276.35	276.9868	276.03	276.9143	22308.0
2023-03-24 09:00:00	MSFT	Stock	276.7	277.25	275.6	277.14	32132.0
2023-03-24 09:30:00	MSFT	Stock	277.14	277.93	275.28	277.7	2523588.0
2023-03-24 10:00:00	MSFT	Stock	277.77	278.26	276.61	277.96	1562650.0
2023-03-24 10:30:00	MSFT	Stock	277.96	278.935	277.69	278.88	1796302.0
2023-03-24 11:00:00	MSFT	Stock	278.91	279.71	276.96	277.25	1748541.0
2023-03-24 11:30:00	MSFT	Stock	277.25	279.45	276.7158	279.25	1317742.0
2023-03-24 12:00:00	MSFT	Stock	279.26	279.77	277.2273	277.74	1229933.0
2023-03-24 12:30:00	MSFT	Stock	277.76	278.62	277.52	278.2	1004323.0

> showing 50 of 99,860 rows — these rows as CSV

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