PREVIEW / stock_30min / 2023-07-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-06.parquet
  size:    2.1 MB
  rows:    100,447
  symbols: 1,555

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-07-06 04:00:00	AAPL	Stock	190.53	190.55	190.02	190.03	13729.0
2023-07-06 04:30:00	AAPL	Stock	190.07	190.38	190.04	190.34	4669.0
2023-07-06 05:00:00	AAPL	Stock	190.35	190.4	190.18	190.4	5959.0
2023-07-06 05:30:00	AAPL	Stock	190.38	190.38	190.21	190.23	2268.0
2023-07-06 06:00:00	AAPL	Stock	190.25	190.25	190.06	190.09	10236.0
2023-07-06 06:30:00	AAPL	Stock	190.13	190.2	190.04	190.1	11680.0
2023-07-06 07:00:00	AAPL	Stock	190.07	190.3	190.05	190.2	35206.0
2023-07-06 07:30:00	AAPL	Stock	190.2	190.23	190.05	190.11	24759.0
2023-07-06 08:00:00	AAPL	Stock	190.18	191.11	189.78	189.84	146678.0
2023-07-06 08:30:00	AAPL	Stock	189.85	189.91	189.26	189.61	256849.0
2023-07-06 09:00:00	AAPL	Stock	189.64	190.0	189.32	189.91	179268.0
2023-07-06 09:30:00	AAPL	Stock	189.91	190.46	189.2	189.93	5583869.0
2023-07-06 10:00:00	AAPL	Stock	189.94	189.96	189.54	189.94	2641673.0
2023-07-06 10:30:00	AAPL	Stock	189.94	190.18	189.5	189.544	2138013.0
2023-07-06 11:00:00	AAPL	Stock	189.55	190.26	189.53	190.17	2065523.0
2023-07-06 11:30:00	AAPL	Stock	190.1601	190.61	190.16	190.495	2105621.0
2023-07-06 12:00:00	AAPL	Stock	190.5	191.01	190.49	190.935	1743276.0
2023-07-06 12:30:00	AAPL	Stock	190.935	191.17	190.88	190.9722	1433046.0
2023-07-06 13:00:00	AAPL	Stock	190.975	191.23	190.882	191.11	1140876.0
2023-07-06 13:30:00	AAPL	Stock	191.1099	191.41	190.74	191.408	1697572.0
2023-07-06 14:00:00	AAPL	Stock	191.41	191.44	190.914	191.03	1307977.0
2023-07-06 14:30:00	AAPL	Stock	191.02	191.53	190.99	191.425	1461984.0
2023-07-06 15:00:00	AAPL	Stock	191.425	191.685	191.3222	191.64	1682255.0
2023-07-06 15:30:00	AAPL	Stock	191.65	192.02	191.47	191.78	4289645.0
2023-07-06 16:00:00	AAPL	Stock	191.71	192.0491	191.71	191.85	5364767.0
2023-07-06 16:30:00	AAPL	Stock	191.85	191.89	191.81	191.86	38293.0
2023-07-06 17:00:00	AAPL	Stock	191.86	191.87	191.69	191.7527	13575.0
2023-07-06 17:30:00	AAPL	Stock	191.75	191.8399	191.721	191.765	11291.0
2023-07-06 18:00:00	AAPL	Stock	191.76	191.78	191.65	191.69	20759.0
2023-07-06 18:30:00	AAPL	Stock	191.68	191.8	191.65	191.7599	10728.0
2023-07-06 19:00:00	AAPL	Stock	191.75	191.89	191.75	191.82	16014.0
2023-07-06 19:30:00	AAPL	Stock	191.82	191.97	191.79	191.83	13231.0
2023-07-06 04:00:00	MSFT	Stock	338.2	340.5	337.49	340.05	30467.0
2023-07-06 04:30:00	MSFT	Stock	339.89	340.65	339.83	340.29	3185.0
2023-07-06 05:00:00	MSFT	Stock	340.18	340.42	339.99	340.42	3159.0
2023-07-06 05:30:00	MSFT	Stock	340.34	341.08	340.34	340.99	4372.0
2023-07-06 06:00:00	MSFT	Stock	340.75	341.69	340.75	341.0	9319.0
2023-07-06 06:30:00	MSFT	Stock	340.65	340.74	340.22	340.35	4748.0
2023-07-06 07:00:00	MSFT	Stock	340.3	341.3	340.3	341.15	21993.0
2023-07-06 07:30:00	MSFT	Stock	341.15	341.15	340.55	340.65	19097.0
2023-07-06 08:00:00	MSFT	Stock	340.31	341.33	336.0	340.39	110312.0
2023-07-06 08:30:00	MSFT	Stock	340.0	340.0	337.59	338.52	80439.0
2023-07-06 09:00:00	MSFT	Stock	338.65	339.0	336.02	337.33	159438.0
2023-07-06 09:30:00	MSFT	Stock	337.37	340.39	335.5	338.73	3895957.0
2023-07-06 10:00:00	MSFT	Stock	338.735	340.65	336.65	340.6097	1919174.0
2023-07-06 10:30:00	MSFT	Stock	340.58	341.12	338.22	338.72	1862632.0
2023-07-06 11:00:00	MSFT	Stock	338.76	339.435	338.09	338.7	889349.0
2023-07-06 11:30:00	MSFT	Stock	338.72	340.0	338.42	339.66	856991.0
2023-07-06 12:00:00	MSFT	Stock	339.69	341.66	339.65	341.62	1219530.0
2023-07-06 12:30:00	MSFT	Stock	341.59	342.465	341.4	341.63	1189891.0

> showing 50 of 100,447 rows — these rows as CSV

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