PREVIEW / stock_30min / 2024-04-18

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-04-18.parquet
  size:    2.0 MB
  rows:    96,363
  symbols: 990

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-18 04:00:00	AAPL	Stock	168.8	169.0	168.45	168.51	13238.0
2024-04-18 04:30:00	AAPL	Stock	168.52	168.54	168.37	168.48	2854.0
2024-04-18 05:00:00	AAPL	Stock	168.48	168.66	168.09	168.1	15595.0
2024-04-18 05:30:00	AAPL	Stock	168.1	168.41	168.09	168.41	2264.0
2024-04-18 06:00:00	AAPL	Stock	168.39	168.39	168.1	168.25	5154.0
2024-04-18 06:30:00	AAPL	Stock	168.28	168.4	168.28	168.3	1296.0
2024-04-18 07:00:00	AAPL	Stock	168.37	168.5	168.32	168.35	15992.0
2024-04-18 07:30:00	AAPL	Stock	168.36	168.43	167.84	167.95	25768.0
2024-04-18 08:00:00	AAPL	Stock	168.42	169.0	167.14	167.26	92744.0
2024-04-18 08:30:00	AAPL	Stock	167.4	167.8599	167.25	167.58	63986.0
2024-04-18 09:00:00	AAPL	Stock	167.64	168.07	167.5	168.0	67405.0
2024-04-18 09:30:00	AAPL	Stock	168.07	168.64	167.55	167.7001	4601309.0
2024-04-18 10:00:00	AAPL	Stock	167.7	168.15	167.33	168.0399	2918410.0
2024-04-18 10:30:00	AAPL	Stock	168.04	168.28	167.86	168.16	2166923.0
2024-04-18 11:00:00	AAPL	Stock	168.16	168.245	167.98	167.99	1536925.0
2024-04-18 11:30:00	AAPL	Stock	168.0	168.02	167.78	167.84	1474434.0
2024-04-18 12:00:00	AAPL	Stock	167.84	167.96	167.4	167.565	1506999.0
2024-04-18 12:30:00	AAPL	Stock	167.565	167.7	166.74	166.81	2659449.0
2024-04-18 13:00:00	AAPL	Stock	166.8007	167.12	166.63	166.98	2111784.0
2024-04-18 13:30:00	AAPL	Stock	166.99	167.1	166.55	166.84	1589719.0
2024-04-18 14:00:00	AAPL	Stock	166.84	167.11	166.63	166.8599	1770947.0
2024-04-18 14:30:00	AAPL	Stock	166.87	166.98	166.64	166.73	1314303.0
2024-04-18 15:00:00	AAPL	Stock	166.73	167.255	166.72	167.1	1728044.0
2024-04-18 15:30:00	AAPL	Stock	167.1	167.375	166.775	167.0101	3530330.0
2024-04-18 16:00:00	AAPL	Stock	167.01	167.44	166.92	167.0101	4214815.0
2024-04-18 16:30:00	AAPL	Stock	167.0103	167.07	166.92	166.97	51819.0
2024-04-18 17:00:00	AAPL	Stock	166.98	166.98	166.9	166.9	19483.0
2024-04-18 17:30:00	AAPL	Stock	166.92	166.92	166.85	166.89	7504.0
2024-04-18 18:00:00	AAPL	Stock	166.9	167.1	166.9	167.034	13782.0
2024-04-18 18:30:00	AAPL	Stock	167.04	167.0479	166.85	166.8526	18624.0
2024-04-18 19:00:00	AAPL	Stock	166.85	166.87	166.6	166.77	15550.0
2024-04-18 19:30:00	AAPL	Stock	166.75	166.84	166.7	166.8	22545.0
2024-04-18 04:00:00	MSFT	Stock	414.1	414.1	412.5	412.99	1907.0
2024-04-18 04:30:00	MSFT	Stock	413.3	413.3	413.28	413.28	476.0
2024-04-18 05:00:00	MSFT	Stock	413.07	413.07	412.0	412.0	2173.0
2024-04-18 05:30:00	MSFT	Stock	412.79	412.9	412.79	412.9	958.0
2024-04-18 06:00:00	MSFT	Stock	412.9	413.0	412.58	412.58	1300.0
2024-04-18 06:30:00	MSFT	Stock	413.24	413.24	413.0	413.0	418.0
2024-04-18 07:00:00	MSFT	Stock	412.84	413.0	412.75	412.75	5209.0
2024-04-18 07:30:00	MSFT	Stock	412.91	413.11	412.85	413.01	3080.0
2024-04-18 08:00:00	MSFT	Stock	412.89	414.46	412.4214	412.4214	15870.0
2024-04-18 08:30:00	MSFT	Stock	412.6	413.0	412.3501	412.84	9937.0
2024-04-18 09:00:00	MSFT	Stock	412.6	412.94	410.2	410.75	23143.0
2024-04-18 09:30:00	MSFT	Stock	410.79	411.5	407.46	408.295	1483406.0
2024-04-18 10:00:00	MSFT	Stock	408.25	408.56	407.09	407.9499	1015444.0
2024-04-18 10:30:00	MSFT	Stock	407.9131	411.43	407.85	410.45	802015.0
2024-04-18 11:00:00	MSFT	Stock	410.495	411.695	410.25	410.685	387032.0
2024-04-18 11:30:00	MSFT	Stock	410.7	411.89	410.69	411.3301	535722.0
2024-04-18 12:00:00	MSFT	Stock	411.34	411.68	409.15	409.4586	332533.0
2024-04-18 12:30:00	MSFT	Stock	409.45	409.59	407.66	407.75	404492.0

> showing 50 of 96,363 rows — these rows as CSV

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