PREVIEW / stock_30min / 2023-01-09

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-09.parquet
  size:    2.1 MB
  rows:    104,961
  symbols: 1,965

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-09 04:00:00	AAPL	Stock	129.6	130.33	129.6	130.2	26962.0
2023-01-09 04:30:00	AAPL	Stock	130.2	130.5	130.19	130.29	16625.0
2023-01-09 05:00:00	AAPL	Stock	130.26	130.5	130.2	130.35	10073.0
2023-01-09 05:30:00	AAPL	Stock	130.4	130.4	130.15	130.25	5910.0
2023-01-09 06:00:00	AAPL	Stock	130.21	130.35	130.02	130.15	9111.0
2023-01-09 06:30:00	AAPL	Stock	130.11	130.32	130.11	130.22	8961.0
2023-01-09 07:00:00	AAPL	Stock	130.25	130.36	130.16	130.2	61106.0
2023-01-09 07:30:00	AAPL	Stock	130.19	130.4	130.19	130.25	34611.0
2023-01-09 08:00:00	AAPL	Stock	130.2	130.63	129.955	130.32	165708.0
2023-01-09 08:30:00	AAPL	Stock	130.34	130.5	130.2	130.2	127865.0
2023-01-09 09:00:00	AAPL	Stock	130.24	130.57	130.13	130.52	133517.0
2023-01-09 09:30:00	AAPL	Stock	130.48	132.06	130.465	132.015	8543523.0
2023-01-09 10:00:00	AAPL	Stock	132.01	132.735	131.96	132.565	6513240.0
2023-01-09 10:30:00	AAPL	Stock	132.575	133.14	132.4636	132.74	4674826.0
2023-01-09 11:00:00	AAPL	Stock	132.74	133.41	132.67	133.085	4388838.0
2023-01-09 11:30:00	AAPL	Stock	133.09	133.18	132.8	132.945	3197521.0
2023-01-09 12:00:00	AAPL	Stock	132.94	132.955	132.57	132.745	2631326.0
2023-01-09 12:30:00	AAPL	Stock	132.74	132.83	132.25	132.459	2214103.0
2023-01-09 13:00:00	AAPL	Stock	132.46	132.64	132.26	132.495	2271339.0
2023-01-09 13:30:00	AAPL	Stock	132.495	132.5101	131.19	131.395	3784681.0
2023-01-09 14:00:00	AAPL	Stock	131.39	131.726	131.2411	131.495	3735484.0
2023-01-09 14:30:00	AAPL	Stock	131.49	131.5667	130.59	130.67	2918911.0
2023-01-09 15:00:00	AAPL	Stock	130.68	130.82	130.34	130.445	3099611.0
2023-01-09 15:30:00	AAPL	Stock	130.45	130.57	129.89	130.19	5361211.0
2023-01-09 16:00:00	AAPL	Stock	130.19	131.709	130.04	130.06	7141708.0
2023-01-09 16:30:00	AAPL	Stock	130.09	130.15	130.04	130.1	18805.0
2023-01-09 17:00:00	AAPL	Stock	130.12	130.12	130.03	130.07	17082.0
2023-01-09 17:30:00	AAPL	Stock	130.04	130.08	130.03	130.04	6086.0
2023-01-09 18:00:00	AAPL	Stock	130.05	130.07	129.95	130.06	39858.0
2023-01-09 18:30:00	AAPL	Stock	130.05	130.06	130.0	130.04	13054.0
2023-01-09 19:00:00	AAPL	Stock	130.01	130.04	129.77	129.8	46355.0
2023-01-09 19:30:00	AAPL	Stock	129.78	129.85	129.76	129.85	25271.0
2023-01-09 04:00:00	MSFT	Stock	225.16	226.0	225.16	225.9	4165.0
2023-01-09 04:30:00	MSFT	Stock	226.06	226.1	226.05	226.05	2158.0
2023-01-09 05:00:00	MSFT	Stock	225.88	226.16	225.88	226.09	2016.0
2023-01-09 05:30:00	MSFT	Stock	226.01	226.2	225.74	226.2	6844.0
2023-01-09 06:00:00	MSFT	Stock	226.0	226.3	225.7	225.72	6808.0
2023-01-09 06:30:00	MSFT	Stock	225.85	225.9	225.7	225.85	1194.0
2023-01-09 07:00:00	MSFT	Stock	225.85	226.0	225.72	226.0	7626.0
2023-01-09 07:30:00	MSFT	Stock	226.0	226.2	225.99	226.1	4530.0
2023-01-09 08:00:00	MSFT	Stock	225.8	226.69	225.63	226.35	37985.0
2023-01-09 08:30:00	MSFT	Stock	226.2901	226.72	226.0	226.15	19053.0
2023-01-09 09:00:00	MSFT	Stock	226.16	226.58	225.6794	226.58	69785.0
2023-01-09 09:30:00	MSFT	Stock	226.45	229.05	226.41	228.97	2538389.0
2023-01-09 10:00:00	MSFT	Stock	228.98	229.3314	228.172	228.925	1379804.0
2023-01-09 10:30:00	MSFT	Stock	228.95	230.23	228.8956	229.4899	1572858.0
2023-01-09 11:00:00	MSFT	Stock	229.49	231.2366	229.49	230.53	1478176.0
2023-01-09 11:30:00	MSFT	Stock	230.53	230.75	230.2	230.33	1018659.0
2023-01-09 12:00:00	MSFT	Stock	230.33	230.92	230.02	230.825	1078717.0
2023-01-09 12:30:00	MSFT	Stock	230.8268	230.84	230.15	230.73	780531.0

> showing 50 of 104,961 rows — these rows as CSV

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