PREVIEW / stock_30min / 2023-07-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-14.parquet
  size:    2.1 MB
  rows:    101,266
  symbols: 1,572

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-14 04:00:00	AAPL	Stock	190.65	190.78	190.31	190.34	14527.0
2023-07-14 04:30:00	AAPL	Stock	190.33	190.33	189.99	189.99	17002.0
2023-07-14 05:00:00	AAPL	Stock	189.99	190.05	189.88	189.99	11958.0
2023-07-14 05:30:00	AAPL	Stock	189.96	190.0	189.95	189.95	11023.0
2023-07-14 06:00:00	AAPL	Stock	189.95	190.05	189.85	189.94	7445.0
2023-07-14 06:30:00	AAPL	Stock	189.94	190.04	189.64	189.83	10467.0
2023-07-14 07:00:00	AAPL	Stock	190.0	190.12	189.8	189.95	22055.0
2023-07-14 07:30:00	AAPL	Stock	189.98	190.14	189.75	189.86	27553.0
2023-07-14 08:00:00	AAPL	Stock	189.97	190.83	189.78	189.93	131066.0
2023-07-14 08:30:00	AAPL	Stock	189.94	190.17	189.87	190.11	66806.0
2023-07-14 09:00:00	AAPL	Stock	190.05	190.25	189.9	190.25	130328.0
2023-07-14 09:30:00	AAPL	Stock	190.23	191.0	190.1	190.81	4745646.0
2023-07-14 10:00:00	AAPL	Stock	190.79	191.1799	190.37	190.85	3140905.0
2023-07-14 10:30:00	AAPL	Stock	190.85	191.04	190.48	190.62	2213049.0
2023-07-14 11:00:00	AAPL	Stock	190.62	190.72	190.295	190.36	2023690.0
2023-07-14 11:30:00	AAPL	Stock	190.365	190.62	190.28	190.48	1379974.0
2023-07-14 12:00:00	AAPL	Stock	190.49	190.5	189.89	189.95	1827523.0
2023-07-14 12:30:00	AAPL	Stock	189.95	190.15	189.7226	190.0208	1400810.0
2023-07-14 13:00:00	AAPL	Stock	190.02	190.0673	189.63	190.015	1426247.0
2023-07-14 13:30:00	AAPL	Stock	190.0101	190.4172	189.9501	190.215	1316564.0
2023-07-14 14:00:00	AAPL	Stock	190.215	190.565	190.16	190.19	1418293.0
2023-07-14 14:30:00	AAPL	Stock	190.2	190.25	189.98	190.04	1323175.0
2023-07-14 15:00:00	AAPL	Stock	190.04	190.42	189.78	190.275	2127901.0
2023-07-14 15:30:00	AAPL	Stock	190.275	190.74	190.16	190.72	4259204.0
2023-07-14 16:00:00	AAPL	Stock	190.73	190.81	190.3978	190.79	5121872.0
2023-07-14 16:30:00	AAPL	Stock	190.77	190.78	190.58	190.66	88561.0
2023-07-14 17:00:00	AAPL	Stock	190.65	190.69	190.52	190.59	44682.0
2023-07-14 17:30:00	AAPL	Stock	190.6	190.68	190.56	190.59	7250.0
2023-07-14 18:00:00	AAPL	Stock	190.58	190.71	190.58	190.7	9793.0
2023-07-14 18:30:00	AAPL	Stock	190.7	190.75	190.7	190.75	13714.0
2023-07-14 19:00:00	AAPL	Stock	190.72	190.8	190.72	190.76	4031.0
2023-07-14 19:30:00	AAPL	Stock	190.75	190.75	190.69	190.7	10017.0
2023-07-14 04:00:00	MSFT	Stock	345.0	349.94	345.0	348.0	28252.0
2023-07-14 04:30:00	MSFT	Stock	348.14	349.0	348.14	348.5	10420.0
2023-07-14 05:00:00	MSFT	Stock	348.28	348.35	347.4	348.06	6764.0
2023-07-14 05:30:00	MSFT	Stock	348.06	348.06	346.7	346.8	3993.0
2023-07-14 06:00:00	MSFT	Stock	347.17	348.0	347.17	347.53	5789.0
2023-07-14 06:30:00	MSFT	Stock	347.5	347.6	347.01	347.57	5526.0
2023-07-14 07:00:00	MSFT	Stock	347.24	349.1	346.15	348.8	52595.0
2023-07-14 07:30:00	MSFT	Stock	348.83	349.0	348.45	348.6	28736.0
2023-07-14 08:00:00	MSFT	Stock	346.92	349.57	344.4	349.0	205640.0
2023-07-14 08:30:00	MSFT	Stock	349.1	349.12	347.94	347.95	72573.0
2023-07-14 09:00:00	MSFT	Stock	347.95	348.35	346.51	347.44	68518.0
2023-07-14 09:30:00	MSFT	Stock	347.59	348.91	346.03	347.65	3437245.0
2023-07-14 10:00:00	MSFT	Stock	347.57	351.43	346.65	350.4799	3337622.0
2023-07-14 10:30:00	MSFT	Stock	350.44	350.93	348.09	349.5965	1908279.0
2023-07-14 11:00:00	MSFT	Stock	349.615	350.39	348.95	349.44	1064112.0
2023-07-14 11:30:00	MSFT	Stock	349.455	349.71	349.0	349.32	536615.0
2023-07-14 12:00:00	MSFT	Stock	349.36	349.38	347.06	347.42	885421.0
2023-07-14 12:30:00	MSFT	Stock	347.42	347.8266	346.51	347.05	602576.0

> showing 50 of 101,266 rows — these rows as CSV

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