PREVIEW / stock_30min / 2024-07-01

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-01.parquet
  size:    2.0 MB
  rows:    99,277
  symbols: 905

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-07-01 04:00:00	AAPL	Stock	211.89	211.89	211.59	211.8	7665.0
2024-07-01 04:30:00	AAPL	Stock	211.81	211.82	211.04	211.09	19270.0
2024-07-01 05:00:00	AAPL	Stock	211.09	211.09	210.5	210.81	12069.0
2024-07-01 05:30:00	AAPL	Stock	210.71	211.39	210.63	210.99	4717.0
2024-07-01 06:00:00	AAPL	Stock	211.19	211.51	211.19	211.3	2738.0
2024-07-01 06:30:00	AAPL	Stock	211.3	211.37	211.15	211.15	1858.0
2024-07-01 07:00:00	AAPL	Stock	211.14	211.5	211.14	211.5	13166.0
2024-07-01 07:30:00	AAPL	Stock	211.5	211.66	211.36	211.65	16171.0
2024-07-01 08:00:00	AAPL	Stock	211.32	212.2	210.62	211.3999	107187.0
2024-07-01 08:30:00	AAPL	Stock	211.4	211.518	211.25	211.45	24323.0
2024-07-01 09:00:00	AAPL	Stock	211.51	212.25	211.4	212.02	104192.0
2024-07-01 09:30:00	AAPL	Stock	212.09	214.04	211.92	213.15	6631584.0
2024-07-01 10:00:00	AAPL	Stock	213.15	215.59	212.78	215.23	5560988.0
2024-07-01 10:30:00	AAPL	Stock	215.22	215.3724	214.09	215.36	3571333.0
2024-07-01 11:00:00	AAPL	Stock	215.36	215.56	214.34	215.0133	2748036.0
2024-07-01 11:30:00	AAPL	Stock	215.01	215.73	214.7	215.69	2345553.0
2024-07-01 12:00:00	AAPL	Stock	215.685	216.58	215.33	216.505	3339062.0
2024-07-01 12:30:00	AAPL	Stock	216.51	217.5	216.47	216.9824	4387862.0
2024-07-01 13:00:00	AAPL	Stock	216.9999	217.51	216.92	217.2543	2900672.0
2024-07-01 13:30:00	AAPL	Stock	217.25	217.25	216.32	216.72	1775691.0
2024-07-01 14:00:00	AAPL	Stock	216.72	216.9	215.92	215.935	1635822.0
2024-07-01 14:30:00	AAPL	Stock	215.93	216.09	215.41	215.75	2081865.0
2024-07-01 15:00:00	AAPL	Stock	215.74	216.25	215.14	215.54	1945261.0
2024-07-01 15:30:00	AAPL	Stock	215.53	217.0	215.46	216.73	4583824.0
2024-07-01 16:00:00	AAPL	Stock	216.75	217.36	216.62	216.92	6131042.0
2024-07-01 16:30:00	AAPL	Stock	216.89	217.11	216.76	216.95	66849.0
2024-07-01 17:00:00	AAPL	Stock	216.93	217.1	216.75	217.04	142129.0
2024-07-01 17:30:00	AAPL	Stock	217.03	217.07	216.9	217.05	12998.0
2024-07-01 18:00:00	AAPL	Stock	217.05	217.1	216.98	217.02	11061.0
2024-07-01 18:30:00	AAPL	Stock	217.0	217.0491	216.8006	216.8006	18592.0
2024-07-01 19:00:00	AAPL	Stock	216.9267	216.9267	216.6414	216.75	17346.0
2024-07-01 19:30:00	AAPL	Stock	216.64	216.71	216.54	216.66	22956.0
2024-07-01 04:00:00	MSFT	Stock	448.4	448.96	447.85	448.67	3370.0
2024-07-01 04:30:00	MSFT	Stock	449.24	449.24	448.52	448.61	1727.0
2024-07-01 05:00:00	MSFT	Stock	448.33	448.35	448.05	448.08	1260.0
2024-07-01 05:30:00	MSFT	Stock	448.46	448.47	448.46	448.47	309.0
2024-07-01 06:00:00	MSFT	Stock	448.59	448.79	448.59	448.79	200.0
2024-07-01 06:30:00	MSFT	Stock	448.61	449.52	448.61	449.35	4784.0
2024-07-01 07:00:00	MSFT	Stock	449.2	449.4	448.55	448.55	11215.0
2024-07-01 07:30:00	MSFT	Stock	448.75	448.85	448.53	448.53	854.0
2024-07-01 08:00:00	MSFT	Stock	448.75	449.5	446.95	449.2	48166.0
2024-07-01 08:30:00	MSFT	Stock	449.3989	449.4	448.65	449.24	5472.0
2024-07-01 09:00:00	MSFT	Stock	449.45	449.45	446.95	448.82	22857.0
2024-07-01 09:30:00	MSFT	Stock	448.8	449.455	445.66	447.87	1770412.0
2024-07-01 10:00:00	MSFT	Stock	448.1	451.5355	447.98	451.5355	858748.0
2024-07-01 10:30:00	MSFT	Stock	451.495	452.3099	450.3	451.105	563319.0
2024-07-01 11:00:00	MSFT	Stock	451.05	452.38	450.19	451.97	462904.0
2024-07-01 11:30:00	MSFT	Stock	451.9699	452.8296	451.27	452.8	423439.0
2024-07-01 12:00:00	MSFT	Stock	452.825	454.31	452.6201	453.9	527915.0
2024-07-01 12:30:00	MSFT	Stock	453.89	454.77	453.73	454.421	358874.0

> showing 50 of 99,277 rows — these rows as CSV

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