PREVIEW / stock_30min / 2022-06-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-14.parquet
  size:    2.2 MB
  rows:    107,578
  symbols: 2,420

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
2022-06-14 04:00:00	AAPL	Stock	133.01	134.0	133.01	133.68	23761.0
2022-06-14 04:30:00	AAPL	Stock	133.71	133.78	133.02	133.1	14796.0
2022-06-14 05:00:00	AAPL	Stock	133.15	133.3	133.03	133.13	10333.0
2022-06-14 05:30:00	AAPL	Stock	133.05	133.27	133.0	133.15	4168.0
2022-06-14 06:00:00	AAPL	Stock	133.0	133.01	132.5	132.52	15757.0
2022-06-14 06:30:00	AAPL	Stock	132.59	133.28	132.59	133.13	9443.0
2022-06-14 07:00:00	AAPL	Stock	133.0	133.06	132.53	132.75	33245.0
2022-06-14 07:30:00	AAPL	Stock	132.76	132.76	132.35	132.4	40363.0
2022-06-14 08:00:00	AAPL	Stock	132.8299	134.47	131.551	132.8	296094.0
2022-06-14 08:30:00	AAPL	Stock	132.8	133.79	132.8	133.2	439786.0
2022-06-14 09:00:00	AAPL	Stock	133.16	133.77	132.84	133.11	367645.0
2022-06-14 09:30:00	AAPL	Stock	133.13	133.2099	131.53	133.1001	10067714.0
2022-06-14 10:00:00	AAPL	Stock	133.11	133.25	131.87	131.93	6452367.0
2022-06-14 10:30:00	AAPL	Stock	131.94	132.85	131.48	132.5898	5315266.0
2022-06-14 11:00:00	AAPL	Stock	132.58	132.765	131.82	132.28	4288743.0
2022-06-14 11:30:00	AAPL	Stock	132.28	132.95	132.01	132.81	3588956.0
2022-06-14 12:00:00	AAPL	Stock	132.81	132.84	131.91	132.315	2823205.0
2022-06-14 12:30:00	AAPL	Stock	132.32	132.5432	131.94	132.5	2682240.0
2022-06-14 13:00:00	AAPL	Stock	132.5	133.89	132.3001	133.26	4112709.0
2022-06-14 13:30:00	AAPL	Stock	133.26	133.37	132.29	132.4802	3292679.0
2022-06-14 14:00:00	AAPL	Stock	132.49	133.085	132.455	132.955	3375173.0
2022-06-14 14:30:00	AAPL	Stock	132.945	133.14	132.285	132.4	3264807.0
2022-06-14 15:00:00	AAPL	Stock	132.395	132.485	131.71	132.3887	4403200.0
2022-06-14 15:30:00	AAPL	Stock	132.38	133.49	132.34	132.86	9189242.0
2022-06-14 16:00:00	AAPL	Stock	132.76	132.85	132.62	132.68	8285488.0
2022-06-14 16:30:00	AAPL	Stock	132.7	132.87	132.68	132.84	56071.0
2022-06-14 17:00:00	AAPL	Stock	132.81	132.9099	132.76	132.87	162391.0
2022-06-14 17:30:00	AAPL	Stock	132.87	132.88	132.69	132.72	16766.0
2022-06-14 18:00:00	AAPL	Stock	132.74	133.1	132.74	133.02	47678.0
2022-06-14 18:30:00	AAPL	Stock	133.02	133.3	133.0	133.07	50221.0
2022-06-14 19:00:00	AAPL	Stock	133.15	133.46	133.0	133.35	50885.0
2022-06-14 19:30:00	AAPL	Stock	133.31	133.9	133.14	133.79	70901.0
2022-06-14 04:00:00	MSFT	Stock	244.87	245.28	244.77	245.2	5306.0
2022-06-14 04:30:00	MSFT	Stock	245.2	245.4	243.82	243.89	8034.0
2022-06-14 05:00:00	MSFT	Stock	243.9	244.5	243.84	244.02	5052.0
2022-06-14 05:30:00	MSFT	Stock	244.14	244.45	244.06	244.06	1107.0
2022-06-14 06:00:00	MSFT	Stock	244.03	244.03	243.63	243.63	326.0
2022-06-14 06:30:00	MSFT	Stock	243.87	244.85	243.87	244.85	3762.0
2022-06-14 07:00:00	MSFT	Stock	244.52	244.61	243.95	244.28	8883.0
2022-06-14 07:30:00	MSFT	Stock	244.0	244.0	243.16	243.16	4790.0
2022-06-14 08:00:00	MSFT	Stock	244.891	247.42	241.655	243.6	15812.0
2022-06-14 08:30:00	MSFT	Stock	243.52	245.3899	243.0807	243.4274	48936.0
2022-06-14 09:00:00	MSFT	Stock	243.38	244.5	243.38	243.81	31176.0
2022-06-14 09:30:00	MSFT	Stock	243.83	245.19	241.85	243.575	2422241.0
2022-06-14 10:00:00	MSFT	Stock	243.58	244.25	241.66	242.1645	1517150.0
2022-06-14 10:30:00	MSFT	Stock	242.2	244.06	241.51	243.27	1072355.0
2022-06-14 11:00:00	MSFT	Stock	243.27	243.48	241.89	242.73	1020357.0
2022-06-14 11:30:00	MSFT	Stock	242.71	244.32	242.32	244.12	870236.0
2022-06-14 12:00:00	MSFT	Stock	244.105	244.135	242.94	243.46	707390.0
2022-06-14 12:30:00	MSFT	Stock	243.49	244.23	242.86	244.17	643706.0

> showing 50 of 107,578 rows — these rows as CSV

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