PREVIEW / stock_30min / 2023-06-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-14.parquet
  size:    2.1 MB
  rows:    103,714
  symbols: 1,621

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-06-14 04:00:00	AAPL	Stock	183.31	183.6	183.26	183.46	8061.0
2023-06-14 04:30:00	AAPL	Stock	183.5	183.62	183.5	183.55	3441.0
2023-06-14 05:00:00	AAPL	Stock	183.45	183.53	183.25	183.45	5673.0
2023-06-14 05:30:00	AAPL	Stock	183.45	183.45	183.32	183.36	1509.0
2023-06-14 06:00:00	AAPL	Stock	183.37	183.4	183.29	183.29	3422.0
2023-06-14 06:30:00	AAPL	Stock	183.3	183.4	183.3	183.34	3038.0
2023-06-14 07:00:00	AAPL	Stock	183.3	183.39	183.25	183.39	10896.0
2023-06-14 07:30:00	AAPL	Stock	183.39	183.4	183.27	183.35	8408.0
2023-06-14 08:00:00	AAPL	Stock	183.32	183.5	182.81	183.38	68634.0
2023-06-14 08:30:00	AAPL	Stock	183.38	183.55	183.14	183.3	75759.0
2023-06-14 09:00:00	AAPL	Stock	183.27	183.39	183.11	183.34	76594.0
2023-06-14 09:30:00	AAPL	Stock	183.37	184.03	182.91	183.91	5370434.0
2023-06-14 10:00:00	AAPL	Stock	183.91	184.28	183.85	184.225	4199433.0
2023-06-14 10:30:00	AAPL	Stock	184.23	184.335	183.68	183.78	3029381.0
2023-06-14 11:00:00	AAPL	Stock	183.7809	184.39	183.52	184.2	2374517.0
2023-06-14 11:30:00	AAPL	Stock	184.21	184.39	184.0	184.09	1702672.0
2023-06-14 12:00:00	AAPL	Stock	184.09	184.25	183.84	184.115	1336298.0
2023-06-14 12:30:00	AAPL	Stock	184.1199	184.16	183.95	184.09	1089777.0
2023-06-14 13:00:00	AAPL	Stock	184.09	184.09	183.51	183.73	1552347.0
2023-06-14 13:30:00	AAPL	Stock	183.73	183.88	183.56	183.71	1206366.0
2023-06-14 14:00:00	AAPL	Stock	183.71	183.71	182.02	182.65	4344186.0
2023-06-14 14:30:00	AAPL	Stock	182.66	184.13	182.42	183.56	4211928.0
2023-06-14 15:00:00	AAPL	Stock	183.59	184.205	183.171	183.51	3464952.0
2023-06-14 15:30:00	AAPL	Stock	183.52	183.97	182.95	183.96	5011414.0
2023-06-14 16:00:00	AAPL	Stock	183.97	184.12	183.86	184.0	6873920.0
2023-06-14 16:30:00	AAPL	Stock	184.0	184.25	183.95	184.08	86575.0
2023-06-14 17:00:00	AAPL	Stock	184.15	184.15	183.95	184.0143	41299.0
2023-06-14 17:30:00	AAPL	Stock	184.04	184.08	183.96	184.05	10715.0
2023-06-14 18:00:00	AAPL	Stock	184.06	184.11	184.0	184.03	10178.0
2023-06-14 18:30:00	AAPL	Stock	184.022	184.08	184.0	184.03	8645.0
2023-06-14 19:00:00	AAPL	Stock	184.0	184.0001	183.9	183.9	7781.0
2023-06-14 19:30:00	AAPL	Stock	183.91	183.92	183.82	183.88	7172.0
2023-06-14 04:00:00	MSFT	Stock	334.69	334.69	334.48	334.5	1089.0
2023-06-14 04:30:00	MSFT	Stock	334.57	334.68	334.4	334.55	1024.0
2023-06-14 05:00:00	MSFT	Stock	334.74	335.0	334.6	334.9	2850.0
2023-06-14 05:30:00	MSFT	Stock	334.88	335.0	334.85	334.85	2821.0
2023-06-14 06:00:00	MSFT	Stock	334.6	334.6	334.48	334.48	1297.0
2023-06-14 06:30:00	MSFT	Stock	334.7	334.78	334.18	334.23	2369.0
2023-06-14 07:00:00	MSFT	Stock	334.42	334.56	334.1	334.4	2848.0
2023-06-14 07:30:00	MSFT	Stock	334.28	334.3	333.82	334.1	3642.0
2023-06-14 08:00:00	MSFT	Stock	334.3049	335.42	333.6	334.45	17523.0
2023-06-14 08:30:00	MSFT	Stock	334.3	334.58	333.45	333.56	20348.0
2023-06-14 09:00:00	MSFT	Stock	333.8087	334.76	333.28	334.25	19464.0
2023-06-14 09:30:00	MSFT	Stock	334.05	335.86	333.59	335.67	1869618.0
2023-06-14 10:00:00	MSFT	Stock	335.675	337.05	335.41	336.3055	1208549.0
2023-06-14 10:30:00	MSFT	Stock	336.3055	337.14	336.1	336.28	878601.0
2023-06-14 11:00:00	MSFT	Stock	336.32	338.57	335.73	338.15	1124470.0
2023-06-14 11:30:00	MSFT	Stock	338.14	339.04	337.54	337.82	881521.0
2023-06-14 12:00:00	MSFT	Stock	337.83	338.08	337.03	338.0	620616.0
2023-06-14 12:30:00	MSFT	Stock	337.99	338.0	337.42	337.72	405409.0

> showing 50 of 103,714 rows — these rows as CSV

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