PREVIEW / stock_30min / 2023-07-10

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-10.parquet
  size:    2.1 MB
  rows:    100,258
  symbols: 1,543

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-10 04:00:00	AAPL	Stock	189.9	190.07	189.28	189.4	47723.0
2023-07-10 04:30:00	AAPL	Stock	189.4	189.5	189.2	189.22	25527.0
2023-07-10 05:00:00	AAPL	Stock	189.44	189.5	189.18	189.2	22649.0
2023-07-10 05:30:00	AAPL	Stock	189.2	189.24	188.99	189.19	12927.0
2023-07-10 06:00:00	AAPL	Stock	189.13	189.13	188.91	189.09	37546.0
2023-07-10 06:30:00	AAPL	Stock	189.06	189.16	188.8	189.16	36623.0
2023-07-10 07:00:00	AAPL	Stock	189.12	189.57	189.12	189.57	82421.0
2023-07-10 07:30:00	AAPL	Stock	189.54	190.38	189.54	190.19	39796.0
2023-07-10 08:00:00	AAPL	Stock	189.27	190.42	189.15	189.98	121733.0
2023-07-10 08:30:00	AAPL	Stock	190.03	190.08	189.41	189.44	152054.0
2023-07-10 09:00:00	AAPL	Stock	189.45	190.68	189.15	189.22	191862.0
2023-07-10 09:30:00	AAPL	Stock	189.23	189.99	187.15	187.62	9141709.0
2023-07-10 10:00:00	AAPL	Stock	187.62	189.51	187.6	188.9599	4635986.0
2023-07-10 10:30:00	AAPL	Stock	188.9401	189.0455	188.14	188.15	3263587.0
2023-07-10 11:00:00	AAPL	Stock	188.155	188.28	187.64	187.86	2892316.0
2023-07-10 11:30:00	AAPL	Stock	187.86	188.4514	187.52	187.53	2716319.0
2023-07-10 12:00:00	AAPL	Stock	187.5208	187.66	187.035	187.562	3067380.0
2023-07-10 12:30:00	AAPL	Stock	187.55	188.13	187.5	188.03	2098030.0
2023-07-10 13:00:00	AAPL	Stock	188.03	188.35	187.76	188.09	1765020.0
2023-07-10 13:30:00	AAPL	Stock	188.1	188.34	187.92	188.283	1427207.0
2023-07-10 14:00:00	AAPL	Stock	188.29	188.7	187.9936	188.615	1611871.0
2023-07-10 14:30:00	AAPL	Stock	188.61	188.65	188.2	188.575	1510067.0
2023-07-10 15:00:00	AAPL	Stock	188.58	188.61	188.1	188.3	1729309.0
2023-07-10 15:30:00	AAPL	Stock	188.29	188.79	188.24	188.63	5044738.0
2023-07-10 16:00:00	AAPL	Stock	188.64	188.74	188.61	188.67	6601914.0
2023-07-10 16:30:00	AAPL	Stock	188.65	188.68	188.52	188.57	105292.0
2023-07-10 17:00:00	AAPL	Stock	188.56	188.56	188.53	188.54	5331.0
2023-07-10 17:30:00	AAPL	Stock	188.54	188.55	188.51	188.54	10883.0
2023-07-10 18:00:00	AAPL	Stock	188.53	188.61	188.45	188.5005	21940.0
2023-07-10 18:30:00	AAPL	Stock	188.55	188.62	188.5081	188.62	4168.0
2023-07-10 19:00:00	AAPL	Stock	188.54	188.6	188.51	188.51	8349.0
2023-07-10 19:30:00	AAPL	Stock	188.51	188.5701	188.45	188.5701	14942.0
2023-07-10 04:00:00	MSFT	Stock	334.66	335.98	333.8	333.84	20156.0
2023-07-10 04:30:00	MSFT	Stock	334.28	334.28	333.75	334.0	3403.0
2023-07-10 05:00:00	MSFT	Stock	334.24	334.51	334.0	334.0	5247.0
2023-07-10 05:30:00	MSFT	Stock	334.0	334.26	333.78	333.91	7359.0
2023-07-10 06:00:00	MSFT	Stock	334.24	334.5	334.03	334.08	9915.0
2023-07-10 06:30:00	MSFT	Stock	333.99	334.42	333.64	334.3	10890.0
2023-07-10 07:00:00	MSFT	Stock	334.6	334.6	333.63	334.33	41756.0
2023-07-10 07:30:00	MSFT	Stock	334.3	335.17	333.7	334.9	31983.0
2023-07-10 08:00:00	MSFT	Stock	334.62	336.49	333.7	335.5	54930.0
2023-07-10 08:30:00	MSFT	Stock	335.4	335.67	334.23	334.49	35530.0
2023-07-10 09:00:00	MSFT	Stock	334.48	337.22	334.15	334.59	63724.0
2023-07-10 09:30:00	MSFT	Stock	334.59	335.23	329.23	329.655	4856120.0
2023-07-10 10:00:00	MSFT	Stock	329.72	332.87	329.635	331.94	2261565.0
2023-07-10 10:30:00	MSFT	Stock	331.92	332.01	329.68	330.4	1401130.0
2023-07-10 11:00:00	MSFT	Stock	330.39	330.49	329.69	330.27	1165911.0
2023-07-10 11:30:00	MSFT	Stock	330.28	331.12	328.84	328.92	1441719.0
2023-07-10 12:00:00	MSFT	Stock	328.915	329.4	327.59	329.2599	1719646.0
2023-07-10 12:30:00	MSFT	Stock	329.255	330.37	329.03	330.22	1052195.0

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

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