PREVIEW / stock_30min / 2023-01-10

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-10.parquet
  size:    2.1 MB
  rows:    102,648
  symbols: 1,904

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-01-10 04:00:00	AAPL	Stock	130.02	130.16	129.84	130.03	27463.0
2023-01-10 04:30:00	AAPL	Stock	130.05	130.28	130.05	130.13	6453.0
2023-01-10 05:00:00	AAPL	Stock	130.17	130.19	130.1	130.14	5691.0
2023-01-10 05:30:00	AAPL	Stock	130.23	130.5	130.23	130.5	5913.0
2023-01-10 06:00:00	AAPL	Stock	130.44	130.46	130.01	130.16	11013.0
2023-01-10 06:30:00	AAPL	Stock	130.16	130.16	130.02	130.12	11085.0
2023-01-10 07:00:00	AAPL	Stock	130.12	130.12	129.32	129.52	45162.0
2023-01-10 07:30:00	AAPL	Stock	129.59	129.78	129.4	129.75	24255.0
2023-01-10 08:00:00	AAPL	Stock	130.0334	130.4385	129.3	129.67	106257.0
2023-01-10 08:30:00	AAPL	Stock	129.69	129.88	129.59	129.85	83060.0
2023-01-10 09:00:00	AAPL	Stock	129.88	130.59	129.71	130.2791	237771.0
2023-01-10 09:30:00	AAPL	Stock	130.28	131.2636	129.51	129.99	7805007.0
2023-01-10 10:00:00	AAPL	Stock	129.99	130.8367	129.33	129.41	5738103.0
2023-01-10 10:30:00	AAPL	Stock	129.4001	129.4001	128.12	129.09	5553497.0
2023-01-10 11:00:00	AAPL	Stock	129.1	129.23	128.73	129.03	3879947.0
2023-01-10 11:30:00	AAPL	Stock	129.02	129.19	128.66	128.88	2925551.0
2023-01-10 12:00:00	AAPL	Stock	128.87	129.24	128.45	129.12	3008139.0
2023-01-10 12:30:00	AAPL	Stock	129.11	129.86	129.0517	129.73	2497013.0
2023-01-10 13:00:00	AAPL	Stock	129.73	130.0	129.42	129.6599	3217512.0
2023-01-10 13:30:00	AAPL	Stock	129.6501	130.27	129.57	130.225	3140172.0
2023-01-10 14:00:00	AAPL	Stock	130.23	130.69	130.18	130.3612	3301730.0
2023-01-10 14:30:00	AAPL	Stock	130.37	130.42	129.98	130.115	2302275.0
2023-01-10 15:00:00	AAPL	Stock	130.115	130.25	129.76	130.15	2867258.0
2023-01-10 15:30:00	AAPL	Stock	130.14	130.75	130.01	130.75	4911661.0
2023-01-10 16:00:00	AAPL	Stock	130.75	130.8	130.66	130.69	4661647.0
2023-01-10 16:30:00	AAPL	Stock	130.7	130.76	130.7	130.7	38977.0
2023-01-10 17:00:00	AAPL	Stock	130.71	130.75	130.7	130.75	5710.0
2023-01-10 17:30:00	AAPL	Stock	130.7112	130.76	130.71	130.72	17669.0
2023-01-10 18:00:00	AAPL	Stock	130.72	130.72	130.58	130.69	11008.0
2023-01-10 18:30:00	AAPL	Stock	130.7	130.76	130.67	130.75	26294.0
2023-01-10 19:00:00	AAPL	Stock	130.75	130.9	130.75	130.82	21125.0
2023-01-10 19:30:00	AAPL	Stock	130.85	130.99	130.81	130.97	25724.0
2023-01-10 04:00:00	MSFT	Stock	227.18	227.38	227.12	227.32	4416.0
2023-01-10 04:30:00	MSFT	Stock	227.49	227.72	227.49	227.7	1024.0
2023-01-10 05:00:00	MSFT	Stock	227.7	227.75	227.4	227.6	2345.0
2023-01-10 05:30:00	MSFT	Stock	227.75	228.07	227.75	228.07	1769.0
2023-01-10 06:00:00	MSFT	Stock	227.03	227.03	227.03	227.03	486.0
2023-01-10 06:30:00	MSFT	Stock	227.2	227.2	226.16	226.3	2965.0
2023-01-10 07:00:00	MSFT	Stock	226.5	226.5	225.72	226.0	9124.0
2023-01-10 07:30:00	MSFT	Stock	226.06	226.7	225.99	226.65	8748.0
2023-01-10 08:00:00	MSFT	Stock	226.4453	227.3961	225.8	226.43	26496.0
2023-01-10 08:30:00	MSFT	Stock	226.42	228.639	226.35	228.6	45239.0
2023-01-10 09:00:00	MSFT	Stock	228.79	230.0	227.2	227.66	158067.0
2023-01-10 09:30:00	MSFT	Stock	227.66	230.97	227.61	229.9	3052106.0
2023-01-10 10:00:00	MSFT	Stock	229.9	231.31	229.07	229.35	1816396.0
2023-01-10 10:30:00	MSFT	Stock	229.3555	229.3555	227.33	228.73	1535531.0
2023-01-10 11:00:00	MSFT	Stock	228.7201	229.54	228.4419	228.595	782130.0
2023-01-10 11:30:00	MSFT	Stock	228.58	228.73	227.66	228.23	943729.0
2023-01-10 12:00:00	MSFT	Stock	228.21	228.49	227.47	228.08	747598.0
2023-01-10 12:30:00	MSFT	Stock	228.0901	228.9	228.03	228.2799	656884.0

> showing 50 of 102,648 rows — these rows as CSV

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