PREVIEW / stock_1hour / 2022-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-22.parquet
  size:    1.4 MB
  rows:    60,417
  symbols: 2,045

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-11-22 04:00:00	AAPL	Stock	147.91	148.69	147.65	148.4	18526.0
2022-11-22 05:00:00	AAPL	Stock	148.44	148.44	148.03	148.23	5270.0
2022-11-22 06:00:00	AAPL	Stock	148.23	148.23	147.7	147.95	21322.0
2022-11-22 07:00:00	AAPL	Stock	147.99	148.35	147.9	148.22	54412.0
2022-11-22 08:00:00	AAPL	Stock	147.95	148.64	146.86	148.43	148657.0
2022-11-22 09:00:00	AAPL	Stock	148.45	148.55	146.925	147.51	5514357.0
2022-11-22 10:00:00	AAPL	Stock	147.5	148.83	147.41	148.71	7420535.0
2022-11-22 11:00:00	AAPL	Stock	148.715	148.98	148.38	148.865	4593729.0
2022-11-22 12:00:00	AAPL	Stock	148.86	149.53	148.8471	149.2	4534315.0
2022-11-22 13:00:00	AAPL	Stock	149.19	150.04	149.04	149.97	4350474.0
2022-11-22 14:00:00	AAPL	Stock	149.97	150.05	149.46	149.79	4213155.0
2022-11-22 15:00:00	AAPL	Stock	149.7905	150.42	149.74	150.25	7729119.0
2022-11-22 16:00:00	AAPL	Stock	150.22	150.26	150.01	150.03	7810190.0
2022-11-22 17:00:00	AAPL	Stock	150.02	150.08	149.99	150.05	20205.0
2022-11-22 18:00:00	AAPL	Stock	150.06	150.14	150.01	150.09	32354.0
2022-11-22 19:00:00	AAPL	Stock	150.06	150.35	150.05	150.1	40406.0
2022-11-22 04:00:00	MSFT	Stock	241.9	242.59	241.41	242.59	2653.0
2022-11-22 05:00:00	MSFT	Stock	242.15	242.32	242.15	242.23	673.0
2022-11-22 06:00:00	MSFT	Stock	242.11	242.15	240.86	241.76	8741.0
2022-11-22 07:00:00	MSFT	Stock	241.59	242.23	241.59	242.12	1750.0
2022-11-22 08:00:00	MSFT	Stock	241.86	243.35	241.86	243.1312	12061.0
2022-11-22 09:00:00	MSFT	Stock	243.14	243.9	240.71	241.43	1872298.0
2022-11-22 10:00:00	MSFT	Stock	241.41	243.16	241.32	243.1	2093424.0
2022-11-22 11:00:00	MSFT	Stock	243.11	243.1495	242.11	242.55	1243184.0
2022-11-22 12:00:00	MSFT	Stock	242.53	243.29	242.5	242.9	1201224.0
2022-11-22 13:00:00	MSFT	Stock	242.91	244.21	242.635	244.1601	1243941.0
2022-11-22 14:00:00	MSFT	Stock	244.1798	244.44	243.58	244.0408	1315571.0
2022-11-22 15:00:00	MSFT	Stock	244.05	245.31	244.03	245.08	2780014.0
2022-11-22 16:00:00	MSFT	Stock	245.03	245.1	244.84	244.84	4413917.0
2022-11-22 17:00:00	MSFT	Stock	244.82	244.9	244.82	244.9	3477.0
2022-11-22 18:00:00	MSFT	Stock	244.95	244.98	244.75	244.75	4172.0
2022-11-22 19:00:00	MSFT	Stock	245.01	245.11	244.77	244.77	3500.0
2022-11-22 04:00:00	NVDA	Stock	15.252	15.37	15.232	15.348	41740.0
2022-11-22 05:00:00	NVDA	Stock	15.37	15.37	15.315	15.335	42020.0
2022-11-22 06:00:00	NVDA	Stock	15.301	15.318	15.252	15.255	19490.0
2022-11-22 07:00:00	NVDA	Stock	15.293	15.355	15.279	15.348	103270.0
2022-11-22 08:00:00	NVDA	Stock	15.349	15.419	15.275	15.405	423780.0
2022-11-22 09:00:00	NVDA	Stock	15.41	15.475	15.1216	15.384	48532510.0
2022-11-22 10:00:00	NVDA	Stock	15.3825	15.806	15.351	15.7893	97035560.0
2022-11-22 11:00:00	NVDA	Stock	15.789	15.908	15.7041	15.853	62914310.0
2022-11-22 12:00:00	NVDA	Stock	15.851	15.926	15.758	15.7615	44339730.0
2022-11-22 13:00:00	NVDA	Stock	15.763	15.893	15.7315	15.8822	33405940.0
2022-11-22 14:00:00	NVDA	Stock	15.883	15.924	15.836	15.892	32670770.0
2022-11-22 15:00:00	NVDA	Stock	15.892	16.0576	15.889	16.039	57166470.0
2022-11-22 16:00:00	NVDA	Stock	16.038	16.059	16.009	16.03	21353410.0
2022-11-22 17:00:00	NVDA	Stock	16.03	16.0503	16.025	16.0503	318060.0
2022-11-22 18:00:00	NVDA	Stock	16.057	16.09	16.03	16.09	229790.0
2022-11-22 19:00:00	NVDA	Stock	16.09	16.1	16.075	16.092	486530.0
2022-11-22 04:00:00	AMZN	Stock	92.28	92.83	92.15	92.7	11401.0
2022-11-22 05:00:00	AMZN	Stock	92.7	92.73	92.54	92.73	8252.0

> showing 50 of 60,417 rows — these rows as CSV

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