PREVIEW / stock_30min / 2023-03-28

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-28.parquet
  size:    2.0 MB
  rows:    98,800
  symbols: 1,748

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-28 04:00:00	AAPL	Stock	157.95	158.06	157.26	157.58	13580.0
2023-03-28 04:30:00	AAPL	Stock	157.6	157.6	157.42	157.57	3984.0
2023-03-28 05:00:00	AAPL	Stock	157.55	157.64	157.55	157.6	2780.0
2023-03-28 05:30:00	AAPL	Stock	157.55	157.6	157.5	157.6	3813.0
2023-03-28 06:00:00	AAPL	Stock	157.6	157.67	157.6	157.67	2044.0
2023-03-28 06:30:00	AAPL	Stock	157.62	157.62	157.38	157.5	11026.0
2023-03-28 07:00:00	AAPL	Stock	157.57	157.67	157.4	157.66	62057.0
2023-03-28 07:30:00	AAPL	Stock	157.69	157.79	157.6	157.7	6220.0
2023-03-28 08:00:00	AAPL	Stock	157.4904	158.13	157.4	157.697	65420.0
2023-03-28 08:30:00	AAPL	Stock	157.76	157.76	157.41	157.6428	40670.0
2023-03-28 09:00:00	AAPL	Stock	157.59	158.14	157.48	157.99	82954.0
2023-03-28 09:30:00	AAPL	Stock	157.99	158.49	156.77	156.77	5461714.0
2023-03-28 10:00:00	AAPL	Stock	156.765	157.3101	156.55	157.025	3501169.0
2023-03-28 10:30:00	AAPL	Stock	157.03	157.03	156.08	156.45	3300008.0
2023-03-28 11:00:00	AAPL	Stock	156.44	156.9	156.39	156.6	2375890.0
2023-03-28 11:30:00	AAPL	Stock	156.6	157.03	156.575	156.91	2218926.0
2023-03-28 12:00:00	AAPL	Stock	156.92	156.95	156.54	156.776	1532787.0
2023-03-28 12:30:00	AAPL	Stock	156.78	156.83	156.435	156.54	1476121.0
2023-03-28 13:00:00	AAPL	Stock	156.56	156.63	156.38	156.455	1462449.0
2023-03-28 13:30:00	AAPL	Stock	156.45	156.56	155.98	156.085	2360631.0
2023-03-28 14:00:00	AAPL	Stock	156.08	156.5708	156.05	156.515	1853720.0
2023-03-28 14:30:00	AAPL	Stock	156.52	156.76	156.345	156.735	1600941.0
2023-03-28 15:00:00	AAPL	Stock	156.74	157.18	156.74	157.005	2438282.0
2023-03-28 15:30:00	AAPL	Stock	157.0	157.73	156.795	157.67	4570746.0
2023-03-28 16:00:00	AAPL	Stock	157.67	157.78	157.52	157.7	6066950.0
2023-03-28 16:30:00	AAPL	Stock	157.69	157.7	157.6251	157.65	46143.0
2023-03-28 17:00:00	AAPL	Stock	157.64	157.67	157.63	157.65	6406.0
2023-03-28 17:30:00	AAPL	Stock	157.6	157.66	157.6	157.65	2198.0
2023-03-28 18:00:00	AAPL	Stock	157.66	157.71	157.6	157.66	3779.0
2023-03-28 18:30:00	AAPL	Stock	157.67	157.7	157.5999	157.6	9472.0
2023-03-28 19:00:00	AAPL	Stock	157.63	157.66	157.6	157.65	7032.0
2023-03-28 19:30:00	AAPL	Stock	157.63	157.78	157.6	157.7	20401.0
2023-03-28 04:00:00	MSFT	Stock	276.75	276.75	274.15	275.15	5002.0
2023-03-28 04:30:00	MSFT	Stock	275.12	275.12	275.0	275.0	3474.0
2023-03-28 05:00:00	MSFT	Stock	274.99	275.36	274.99	275.36	1317.0
2023-03-28 05:30:00	MSFT	Stock	275.4	275.5	275.15	275.2	1068.0
2023-03-28 06:00:00	MSFT	Stock	275.2	276.0	275.2	275.7	1235.0
2023-03-28 06:30:00	MSFT	Stock	275.62	275.62	274.89	275.0	4096.0
2023-03-28 07:00:00	MSFT	Stock	275.36	275.9	275.36	275.9	3028.0
2023-03-28 07:30:00	MSFT	Stock	275.79	276.1	275.77	275.8	1496.0
2023-03-28 08:00:00	MSFT	Stock	275.5272	277.32	275.21	275.8	11762.0
2023-03-28 08:30:00	MSFT	Stock	275.8	275.8	275.37	275.71	13021.0
2023-03-28 09:00:00	MSFT	Stock	275.6	276.18	275.11	275.78	16985.0
2023-03-28 09:30:00	MSFT	Stock	275.79	276.14	272.74	273.7306	2527082.0
2023-03-28 10:00:00	MSFT	Stock	273.73	274.27	273.11	273.59	1101005.0
2023-03-28 10:30:00	MSFT	Stock	273.63	273.64	272.06	272.1346	1027647.0
2023-03-28 11:00:00	MSFT	Stock	272.15	273.67	272.0451	273.4115	1024877.0
2023-03-28 11:30:00	MSFT	Stock	273.44	274.1	273.26	273.7499	1323548.0
2023-03-28 12:00:00	MSFT	Stock	273.75	273.838	273.04	273.24	698345.0
2023-03-28 12:30:00	MSFT	Stock	273.22	273.565	273.0798	273.46	504276.0

> showing 50 of 98,800 rows — these rows as CSV

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