PREVIEW / stock_30min / 2024-04-09

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-04-09.parquet
  size:    2.0 MB
  rows:    97,142
  symbols: 1,041

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
2024-04-09 04:00:00	AAPL	Stock	168.51	168.51	168.19	168.26	8840.0
2024-04-09 04:30:00	AAPL	Stock	168.39	168.39	168.21	168.32	1491.0
2024-04-09 05:00:00	AAPL	Stock	168.29	168.36	168.24	168.3	5219.0
2024-04-09 05:30:00	AAPL	Stock	168.25	168.3	168.25	168.3	2691.0
2024-04-09 06:00:00	AAPL	Stock	168.28	168.28	168.21	168.22	3611.0
2024-04-09 06:30:00	AAPL	Stock	168.2	168.2	167.8	168.0	18760.0
2024-04-09 07:00:00	AAPL	Stock	168.01	168.3	168.0	168.3	15384.0
2024-04-09 07:30:00	AAPL	Stock	168.28	168.31	168.2	168.3	14603.0
2024-04-09 08:00:00	AAPL	Stock	168.02	168.6	168.02	168.32	56182.0
2024-04-09 08:30:00	AAPL	Stock	168.34	168.8906	168.32	168.7	63093.0
2024-04-09 09:00:00	AAPL	Stock	168.72	169.1009	168.36	168.76	120004.0
2024-04-09 09:30:00	AAPL	Stock	168.77	169.88	168.5	169.605	4927428.0
2024-04-09 10:00:00	AAPL	Stock	169.59	170.08	169.355	169.47	2976786.0
2024-04-09 10:30:00	AAPL	Stock	169.48	169.49	168.48	168.85	2929231.0
2024-04-09 11:00:00	AAPL	Stock	168.84	168.89	168.59	168.695	1811308.0
2024-04-09 11:30:00	AAPL	Stock	168.7	169.16	168.69	168.975	1625896.0
2024-04-09 12:00:00	AAPL	Stock	168.9726	169.15	168.83	169.07	1427130.0
2024-04-09 12:30:00	AAPL	Stock	169.07	169.25	168.9	169.06	1310533.0
2024-04-09 13:00:00	AAPL	Stock	169.07	169.56	168.94	169.27	1605513.0
2024-04-09 13:30:00	AAPL	Stock	169.27	169.5	168.9401	168.95	1390195.0
2024-04-09 14:00:00	AAPL	Stock	168.955	168.9755	168.5	168.585	2157165.0
2024-04-09 14:30:00	AAPL	Stock	168.58	168.685	168.51	168.5945	1207205.0
2024-04-09 15:00:00	AAPL	Stock	168.59	169.26	168.35	169.2525	2326661.0
2024-04-09 15:30:00	AAPL	Stock	169.25	169.73	168.92	169.69	4591784.0
2024-04-09 16:00:00	AAPL	Stock	169.67	169.79	169.43	169.59	4811258.0
2024-04-09 16:30:00	AAPL	Stock	169.5701	169.67	169.45	169.57	101950.0
2024-04-09 17:00:00	AAPL	Stock	169.56	169.57	169.44	169.56	8508.0
2024-04-09 17:30:00	AAPL	Stock	169.57	169.6	169.56	169.58	11073.0
2024-04-09 18:00:00	AAPL	Stock	169.6	169.6	169.58	169.58	6782.0
2024-04-09 18:30:00	AAPL	Stock	169.58	169.74	169.58	169.68	35455.0
2024-04-09 19:00:00	AAPL	Stock	169.71	169.74	169.68	169.72	9989.0
2024-04-09 19:30:00	AAPL	Stock	169.74	169.76	169.67	169.76	14960.0
2024-04-09 04:00:00	MSFT	Stock	425.2	425.2	425.2	425.2	1550.0
2024-04-09 04:30:00	MSFT	Stock	425.75	425.75	425.75	425.75	100.0
2024-04-09 05:00:00	MSFT	Stock	425.61	425.61	425.57	425.57	592.0
2024-04-09 06:30:00	MSFT	Stock	424.7	424.7	424.0	424.18	2139.0
2024-04-09 07:00:00	MSFT	Stock	424.59	425.35	424.59	425.22	2845.0
2024-04-09 07:30:00	MSFT	Stock	425.59	425.59	425.59	425.59	124.0
2024-04-09 08:00:00	MSFT	Stock	425.31	426.4	424.65	426.4	10385.0
2024-04-09 08:30:00	MSFT	Stock	426.36	426.6001	425.6	425.6	7090.0
2024-04-09 09:00:00	MSFT	Stock	426.0	426.98	425.85	426.65	16167.0
2024-04-09 09:30:00	MSFT	Stock	426.44	427.74	424.53	425.99	1043712.0
2024-04-09 10:00:00	MSFT	Stock	426.03	426.75	424.8	425.21	603360.0
2024-04-09 10:30:00	MSFT	Stock	425.2	425.2	421.62	423.02	749369.0
2024-04-09 11:00:00	MSFT	Stock	422.995	423.57	422.6513	422.98	368576.0
2024-04-09 11:30:00	MSFT	Stock	422.99	424.15	422.81	423.79	332270.0
2024-04-09 12:00:00	MSFT	Stock	423.78	424.63	423.73	424.34	298010.0
2024-04-09 12:30:00	MSFT	Stock	424.37	424.67	423.39	423.68	243580.0
2024-04-09 13:00:00	MSFT	Stock	423.659	424.71	423.54	424.35	221184.0
2024-04-09 13:30:00	MSFT	Stock	424.33	424.8	423.48	423.78	245163.0

> showing 50 of 97,142 rows — these rows as CSV

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