PREVIEW / stock_30min / 2023-02-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-02-01.parquet
  size:    2.2 MB
  rows:    106,610
  symbols: 1,896

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-01 04:00:00	AAPL	Stock	144.29	144.29	144.01	144.25	7212.0
2023-02-01 04:30:00	AAPL	Stock	144.22	144.22	144.08	144.08	3388.0
2023-02-01 05:00:00	AAPL	Stock	144.14	144.18	143.93	143.94	7690.0
2023-02-01 05:30:00	AAPL	Stock	143.95	143.99	143.9	143.93	3557.0
2023-02-01 06:00:00	AAPL	Stock	144.0	144.08	143.96	144.07	4093.0
2023-02-01 06:30:00	AAPL	Stock	144.05	144.1	144.02	144.1	3743.0
2023-02-01 07:00:00	AAPL	Stock	144.06	144.35	144.05	144.3	36840.0
2023-02-01 07:30:00	AAPL	Stock	144.28	144.4	144.2	144.34	19075.0
2023-02-01 08:00:00	AAPL	Stock	144.12	144.44	143.8	144.1913	127170.0
2023-02-01 08:30:00	AAPL	Stock	144.2	144.33	144.08	144.1761	51694.0
2023-02-01 09:00:00	AAPL	Stock	144.2	144.36	143.77	143.87	126532.0
2023-02-01 09:30:00	AAPL	Stock	143.94	144.01	142.59	143.19	6035392.0
2023-02-01 10:00:00	AAPL	Stock	143.19	143.3999	142.71	142.96	3645264.0
2023-02-01 10:30:00	AAPL	Stock	142.97	143.275	142.35	142.59	3425712.0
2023-02-01 11:00:00	AAPL	Stock	142.59	143.02	142.33	142.91	2427904.0
2023-02-01 11:30:00	AAPL	Stock	142.91	143.005	142.255	142.34	2241747.0
2023-02-01 12:00:00	AAPL	Stock	142.34	142.44	141.72	141.96	3358406.0
2023-02-01 12:30:00	AAPL	Stock	141.9517	142.27	141.9515	142.19	2076461.0
2023-02-01 13:00:00	AAPL	Stock	142.18	142.26	141.84	142.01	1890466.0
2023-02-01 13:30:00	AAPL	Stock	142.02	142.71	142.011	142.48	2457265.0
2023-02-01 14:00:00	AAPL	Stock	142.4493	143.19	141.52	142.39	4194980.0
2023-02-01 14:30:00	AAPL	Stock	142.39	145.17	141.32	144.355	8647019.0
2023-02-01 15:00:00	AAPL	Stock	144.37	145.6	144.33	145.53	6258621.0
2023-02-01 15:30:00	AAPL	Stock	145.535	146.61	145.13	145.46	10078054.0
2023-02-01 16:00:00	AAPL	Stock	145.45	146.25	144.71	145.4	9549864.0
2023-02-01 16:30:00	AAPL	Stock	145.33	145.98	145.32	145.69	226383.0
2023-02-01 17:00:00	AAPL	Stock	145.6899	146.18	145.62	146.12	116528.0
2023-02-01 17:30:00	AAPL	Stock	146.1	146.2	145.88	145.99	90871.0
2023-02-01 18:00:00	AAPL	Stock	145.99	146.3	145.98	146.2	86161.0
2023-02-01 18:30:00	AAPL	Stock	146.16	146.24	145.88	146.0	74247.0
2023-02-01 19:00:00	AAPL	Stock	146.0	146.08	145.62	145.95	81618.0
2023-02-01 19:30:00	AAPL	Stock	145.87	146.1	145.83	146.07	57341.0
2023-02-01 04:00:00	MSFT	Stock	247.61	247.62	247.13	247.62	2071.0
2023-02-01 04:30:00	MSFT	Stock	247.38	247.38	247.36	247.37	678.0
2023-02-01 05:00:00	MSFT	Stock	247.45	247.45	247.12	247.12	1348.0
2023-02-01 05:30:00	MSFT	Stock	247.0	247.0	246.95	246.98	555.0
2023-02-01 06:00:00	MSFT	Stock	246.99	246.99	246.99	246.99	242.0
2023-02-01 07:00:00	MSFT	Stock	247.25	247.9	247.25	247.84	7538.0
2023-02-01 07:30:00	MSFT	Stock	247.84	247.99	247.8	247.89	4915.0
2023-02-01 08:00:00	MSFT	Stock	247.2504	247.99	247.11	247.7	18337.0
2023-02-01 08:30:00	MSFT	Stock	247.75	247.89	247.45	247.76	11073.0
2023-02-01 09:00:00	MSFT	Stock	247.86	248.17	247.73	247.85	27171.0
2023-02-01 09:30:00	MSFT	Stock	247.83	248.4499	246.23	247.23	1528879.0
2023-02-01 10:00:00	MSFT	Stock	247.26	247.405	245.63	246.2	1009071.0
2023-02-01 10:30:00	MSFT	Stock	246.27	247.305	245.75	246.15	1537018.0
2023-02-01 11:00:00	MSFT	Stock	246.15	246.86	245.8	246.85	561015.0
2023-02-01 11:30:00	MSFT	Stock	246.85	247.29	246.5905	247.1899	503209.0
2023-02-01 12:00:00	MSFT	Stock	247.2	247.318	246.72	247.07	493409.0
2023-02-01 12:30:00	MSFT	Stock	247.0717	247.28	246.82	246.91	463225.0
2023-02-01 13:00:00	MSFT	Stock	246.9	247.46	246.81	247.03	555070.0

> showing 50 of 106,610 rows — these rows as CSV

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