PREVIEW / stock_30min / 2024-09-18

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-09-18.parquet
  size:    2.0 MB
  rows:    97,862
  symbols: 783

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-09-18 04:00:00	AAPL	Stock	216.2	216.2	215.51	215.51	14342.0
2024-09-18 04:30:00	AAPL	Stock	215.53	216.0	215.5	216.0	8177.0
2024-09-18 05:00:00	AAPL	Stock	216.12	216.2	215.9	215.94	2045.0
2024-09-18 05:30:00	AAPL	Stock	215.94	215.95	215.75	215.88	4753.0
2024-09-18 06:00:00	AAPL	Stock	215.97	216.15	215.94	216.0	37481.0
2024-09-18 06:30:00	AAPL	Stock	216.15	216.8	216.15	216.72	19601.0
2024-09-18 07:00:00	AAPL	Stock	216.74	217.1	216.61	216.71	33190.0
2024-09-18 07:30:00	AAPL	Stock	216.7	216.7	216.3	216.49	16980.0
2024-09-18 08:00:00	AAPL	Stock	217.0	217.1	216.0	216.76	55202.0
2024-09-18 08:30:00	AAPL	Stock	216.75	217.13	216.75	217.13	49934.0
2024-09-18 09:00:00	AAPL	Stock	217.13	217.97	216.99	217.6	131037.0
2024-09-18 09:30:00	AAPL	Stock	217.55	219.55	217.54	219.205	5508130.0
2024-09-18 10:00:00	AAPL	Stock	219.21	220.74	218.98	220.735	3396131.0
2024-09-18 10:30:00	AAPL	Stock	220.7301	221.61	220.46	220.93	3755462.0
2024-09-18 11:00:00	AAPL	Stock	220.935	221.3999	220.25	220.62	2388505.0
2024-09-18 11:30:00	AAPL	Stock	220.64	220.655	219.52	219.6115	2084154.0
2024-09-18 12:00:00	AAPL	Stock	219.61	220.8699	219.55	220.805	1515216.0
2024-09-18 12:30:00	AAPL	Stock	220.8	221.36	220.26	221.285	1713336.0
2024-09-18 13:00:00	AAPL	Stock	221.285	221.34	220.88	221.2101	1283980.0
2024-09-18 13:30:00	AAPL	Stock	221.22	221.53	220.34	220.6816	1539484.0
2024-09-18 14:00:00	AAPL	Stock	220.63	222.71	219.93	221.4073	3920498.0
2024-09-18 14:30:00	AAPL	Stock	221.47	221.85	219.84	220.0501	2401411.0
2024-09-18 15:00:00	AAPL	Stock	220.048	221.77	218.93	221.5	2899668.0
2024-09-18 15:30:00	AAPL	Stock	221.53	221.82	219.88	220.69	4557960.0
2024-09-18 16:00:00	AAPL	Stock	220.69	221.89	220.2	221.45	7594072.0
2024-09-18 16:30:00	AAPL	Stock	221.5	221.8	220.69	221.4	107482.0
2024-09-18 17:00:00	AAPL	Stock	221.3225	221.6685	221.3225	221.47	21595.0
2024-09-18 17:30:00	AAPL	Stock	221.5	221.5	221.13	221.23	11900.0
2024-09-18 18:00:00	AAPL	Stock	221.28	221.7473	221.28	221.68	10453.0
2024-09-18 18:30:00	AAPL	Stock	221.68	221.7408	221.4802	221.6	9610.0
2024-09-18 19:00:00	AAPL	Stock	221.58	221.85	221.5	221.57	35841.0
2024-09-18 19:30:00	AAPL	Stock	221.57	222.25	221.47	222.25	20122.0
2024-09-18 04:00:00	MSFT	Stock	436.87	436.87	436.0	436.0	1515.0
2024-09-18 04:30:00	MSFT	Stock	436.0	436.14	436.0	436.0	358.0
2024-09-18 05:00:00	MSFT	Stock	436.26	436.49	436.26	436.41	568.0
2024-09-18 05:30:00	MSFT	Stock	436.66	436.8	436.66	436.8	645.0
2024-09-18 06:00:00	MSFT	Stock	436.75	436.75	434.52	434.52	3576.0
2024-09-18 06:30:00	MSFT	Stock	436.09	436.57	436.09	436.57	1789.0
2024-09-18 07:00:00	MSFT	Stock	436.6	437.2	436.5	437.04	5713.0
2024-09-18 07:30:00	MSFT	Stock	437.19	437.22	436.56	436.56	1322.0
2024-09-18 08:00:00	MSFT	Stock	436.8	437.278	435.72	436.1	20064.0
2024-09-18 08:30:00	MSFT	Stock	436.38	436.7	435.89	436.4	5962.0
2024-09-18 09:00:00	MSFT	Stock	436.5012	436.8	435.0	435.0	18980.0
2024-09-18 09:30:00	MSFT	Stock	434.99	435.78	431.5717	432.47	1157543.0
2024-09-18 10:00:00	MSFT	Stock	432.4719	433.33	431.38	432.1856	545170.0
2024-09-18 10:30:00	MSFT	Stock	432.185	432.8	431.51	431.94	418988.0
2024-09-18 11:00:00	MSFT	Stock	431.935	432.28	431.3	431.9001	362703.0
2024-09-18 11:30:00	MSFT	Stock	431.94	431.945	430.45	430.925	352870.0
2024-09-18 12:00:00	MSFT	Stock	430.91	432.56	430.6616	432.5501	376602.0
2024-09-18 12:30:00	MSFT	Stock	432.57	432.84	431.63	432.72	282943.0

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

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