PREVIEW / stock_30min / 2023-01-11

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-11.parquet
  size:    2.1 MB
  rows:    104,611
  symbols: 1,959

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-11 04:00:00	AAPL	Stock	130.95	131.3	130.8	131.23	17178.0
2023-01-11 04:30:00	AAPL	Stock	131.24	131.24	131.05	131.05	6238.0
2023-01-11 05:00:00	AAPL	Stock	131.21	131.32	131.1	131.13	8175.0
2023-01-11 05:30:00	AAPL	Stock	131.16	131.19	130.96	130.96	7407.0
2023-01-11 06:00:00	AAPL	Stock	130.96	130.96	130.85	130.94	4522.0
2023-01-11 06:30:00	AAPL	Stock	131.0	131.18	130.8	130.8	22919.0
2023-01-11 07:00:00	AAPL	Stock	130.88	130.94	130.46	130.6	35537.0
2023-01-11 07:30:00	AAPL	Stock	130.65	130.84	130.63	130.7	18738.0
2023-01-11 08:00:00	AAPL	Stock	130.85	131.18	130.404	131.06	136974.0
2023-01-11 08:30:00	AAPL	Stock	131.06	131.68	130.87	131.5	254987.0
2023-01-11 09:00:00	AAPL	Stock	131.5	131.59	131.06	131.22	221327.0
2023-01-11 09:30:00	AAPL	Stock	131.24	131.59	130.46	130.8781	7498433.0
2023-01-11 10:00:00	AAPL	Stock	130.895	132.1084	130.49	132.02	5789345.0
2023-01-11 10:30:00	AAPL	Stock	132.02	132.07	131.09	131.475	4710312.0
2023-01-11 11:00:00	AAPL	Stock	131.48	131.79	131.375	131.685	2912830.0
2023-01-11 11:30:00	AAPL	Stock	131.68	132.37	131.47	132.29	3229659.0
2023-01-11 12:00:00	AAPL	Stock	132.3	132.86	132.2296	132.8	3315066.0
2023-01-11 12:30:00	AAPL	Stock	132.8	132.93	132.51	132.75	2928012.0
2023-01-11 13:00:00	AAPL	Stock	132.76	133.24	132.41	132.8	3174799.0
2023-01-11 13:30:00	AAPL	Stock	132.808	132.875	132.21	132.4001	2294075.0
2023-01-11 14:00:00	AAPL	Stock	132.41	132.65	132.165	132.405	2340432.0
2023-01-11 14:30:00	AAPL	Stock	132.4089	132.87	132.32	132.5299	2470566.0
2023-01-11 15:00:00	AAPL	Stock	132.53	133.06	132.495	132.9218	3076077.0
2023-01-11 15:30:00	AAPL	Stock	132.93	133.51	132.66	133.48	7692499.0
2023-01-11 16:00:00	AAPL	Stock	133.48	133.5	133.14	133.44	9221052.0
2023-01-11 16:30:00	AAPL	Stock	133.45	133.49	133.34	133.43	118759.0
2023-01-11 17:00:00	AAPL	Stock	133.42	133.45	133.35	133.42	36799.0
2023-01-11 17:30:00	AAPL	Stock	133.45	133.47	133.43	133.44	54836.0
2023-01-11 18:00:00	AAPL	Stock	133.44	133.46	133.36	133.43	23043.0
2023-01-11 18:30:00	AAPL	Stock	133.43	133.47	133.4299	133.44	8061.0
2023-01-11 19:00:00	AAPL	Stock	133.45	133.47	133.39	133.42	18841.0
2023-01-11 19:30:00	AAPL	Stock	133.44	133.49	133.39	133.49	32923.0
2023-01-11 04:00:00	MSFT	Stock	229.2	229.73	228.74	229.7	1447.0
2023-01-11 04:30:00	MSFT	Stock	229.6	229.68	229.5	229.68	2877.0
2023-01-11 05:00:00	MSFT	Stock	229.6	229.6	229.6	229.6	313.0
2023-01-11 05:30:00	MSFT	Stock	229.58	229.58	229.3	229.3	1016.0
2023-01-11 06:00:00	MSFT	Stock	229.37	229.37	228.93	229.29	9528.0
2023-01-11 06:30:00	MSFT	Stock	229.8	229.8	229.61	229.61	3004.0
2023-01-11 07:00:00	MSFT	Stock	229.51	229.69	229.0	229.5	20540.0
2023-01-11 07:30:00	MSFT	Stock	229.49	230.1	229.49	229.66	8741.0
2023-01-11 08:00:00	MSFT	Stock	229.4	230.65	227.5	230.33	46924.0
2023-01-11 08:30:00	MSFT	Stock	230.34	230.88	230.01	230.75	40616.0
2023-01-11 09:00:00	MSFT	Stock	230.56	231.65	230.16	231.32	62339.0
2023-01-11 09:30:00	MSFT	Stock	231.27	233.8699	231.11	231.9828	3204414.0
2023-01-11 10:00:00	MSFT	Stock	231.97	233.6799	231.45	233.545	1453505.0
2023-01-11 10:30:00	MSFT	Stock	233.56	233.62	232.1704	232.555	1069023.0
2023-01-11 11:00:00	MSFT	Stock	232.54	233.88	232.52	233.41	850039.0
2023-01-11 11:30:00	MSFT	Stock	233.41	233.99	233.11	233.785	814720.0
2023-01-11 12:00:00	MSFT	Stock	233.8	234.29	233.64	233.73	1057892.0
2023-01-11 12:30:00	MSFT	Stock	233.74	233.964	233.47	233.79	618788.0

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

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