PREVIEW / stock_30min / 2023-10-19

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-19.parquet
  size:    2.0 MB
  rows:    96,292
  symbols: 1,340

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-10-19 04:00:00	AAPL	Stock	175.24	175.39	174.91	175.0	18053.0
2023-10-19 04:30:00	AAPL	Stock	175.0	175.17	174.95	174.96	5166.0
2023-10-19 05:00:00	AAPL	Stock	174.91	175.12	174.91	175.12	4103.0
2023-10-19 05:30:00	AAPL	Stock	175.19	175.55	175.19	175.55	5941.0
2023-10-19 06:00:00	AAPL	Stock	175.55	175.6	175.43	175.6	4377.0
2023-10-19 06:30:00	AAPL	Stock	175.66	175.79	175.66	175.73	4415.0
2023-10-19 07:00:00	AAPL	Stock	175.71	175.75	175.55	175.55	9326.0
2023-10-19 07:30:00	AAPL	Stock	175.59	175.6	175.19	175.3	26818.0
2023-10-19 08:00:00	AAPL	Stock	175.64	175.82	174.78	175.47	54752.0
2023-10-19 08:30:00	AAPL	Stock	175.56	176.4	175.29	176.21	89260.0
2023-10-19 09:00:00	AAPL	Stock	176.17	176.4	175.77	176.0	226727.0
2023-10-19 09:30:00	AAPL	Stock	176.0	176.855	175.845	176.8401	4474009.0
2023-10-19 10:00:00	AAPL	Stock	176.85	177.33	176.18	176.28	3319752.0
2023-10-19 10:30:00	AAPL	Stock	176.28	176.87	176.16	176.465	2302031.0
2023-10-19 11:00:00	AAPL	Stock	176.46	176.67	175.635	176.2499	2345197.0
2023-10-19 11:30:00	AAPL	Stock	176.25	176.72	176.11	176.48	2114957.0
2023-10-19 12:00:00	AAPL	Stock	176.4724	177.762	176.1	176.68	3960623.0
2023-10-19 12:30:00	AAPL	Stock	176.69	177.21	175.46	177.0561	4108381.0
2023-10-19 13:00:00	AAPL	Stock	177.06	177.84	177.045	177.48	2610202.0
2023-10-19 13:30:00	AAPL	Stock	177.49	177.83	176.56	176.78	2211419.0
2023-10-19 14:00:00	AAPL	Stock	176.76	177.02	176.51	176.59	1654693.0
2023-10-19 14:30:00	AAPL	Stock	176.59	176.59	175.52	175.62	2532672.0
2023-10-19 15:00:00	AAPL	Stock	175.6251	175.9377	175.56	175.74	2212561.0
2023-10-19 15:30:00	AAPL	Stock	175.73	176.06	175.19	175.45	5038882.0
2023-10-19 16:00:00	AAPL	Stock	175.45	175.46	174.91	175.21	7747706.0
2023-10-19 16:30:00	AAPL	Stock	175.23	175.33	175.17	175.26	47182.0
2023-10-19 17:00:00	AAPL	Stock	175.24	175.46	175.05	175.0663	43492.0
2023-10-19 17:30:00	AAPL	Stock	175.13	175.15	175.01	175.04	9075.0
2023-10-19 18:00:00	AAPL	Stock	175.03	175.16	175.01	175.04	9654.0
2023-10-19 18:30:00	AAPL	Stock	175.03	175.08	174.97	174.97	10051.0
2023-10-19 19:00:00	AAPL	Stock	174.9	175.0	174.75	174.85	15162.0
2023-10-19 19:30:00	AAPL	Stock	174.86	174.95	174.85	174.85	12636.0
2023-10-19 04:00:00	MSFT	Stock	329.9	330.68	329.59	330.68	5443.0
2023-10-19 04:30:00	MSFT	Stock	330.68	331.24	330.4	331.2	5461.0
2023-10-19 05:30:00	MSFT	Stock	331.75	332.54	331.75	332.54	1563.0
2023-10-19 06:00:00	MSFT	Stock	332.33	332.9	332.33	332.75	5209.0
2023-10-19 06:30:00	MSFT	Stock	332.75	333.25	332.65	332.79	11195.0
2023-10-19 07:00:00	MSFT	Stock	332.88	332.88	331.7	332.1	10282.0
2023-10-19 07:30:00	MSFT	Stock	332.17	332.6	331.73	331.95	7636.0
2023-10-19 08:00:00	MSFT	Stock	332.45	332.75	330.0	332.5001	21757.0
2023-10-19 08:30:00	MSFT	Stock	332.5	333.9	332.0	333.5	45828.0
2023-10-19 09:00:00	MSFT	Stock	333.68	333.81	332.13	332.13	32579.0
2023-10-19 09:30:00	MSFT	Stock	332.25	334.8	332.03	334.005	2447696.0
2023-10-19 10:00:00	MSFT	Stock	334.05	334.77	332.19	332.39	1397143.0
2023-10-19 10:30:00	MSFT	Stock	332.365	334.28	332.365	333.375	898041.0
2023-10-19 11:00:00	MSFT	Stock	333.4355	333.715	332.09	333.12	638410.0
2023-10-19 11:30:00	MSFT	Stock	333.075	334.735	332.935	334.3355	863793.0
2023-10-19 12:00:00	MSFT	Stock	334.36	336.88	333.82	335.04	1725016.0
2023-10-19 12:30:00	MSFT	Stock	335.085	335.37	332.24	334.9	1158259.0
2023-10-19 13:00:00	MSFT	Stock	335.04	336.63	334.69	335.0	1264900.0

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

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