PREVIEW / stock_1hour / 2022-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-22.parquet
  size:    1.4 MB
  rows:    61,858
  symbols: 2,234

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-09-22 04:00:00	AAPL	Stock	153.02	154.96	153.02	154.46	74149.0
2022-09-22 05:00:00	AAPL	Stock	154.5	154.53	153.57	153.88	36949.0
2022-09-22 06:00:00	AAPL	Stock	153.78	154.0	153.55	153.98	9180.0
2022-09-22 07:00:00	AAPL	Stock	153.9	154.0	153.0	153.53	71512.0
2022-09-22 08:00:00	AAPL	Stock	153.581	154.51	152.91	153.96	287835.0
2022-09-22 09:00:00	AAPL	Stock	153.93	154.09	151.66	152.11	11465594.0
2022-09-22 10:00:00	AAPL	Stock	152.12	153.09	151.71	151.7599	12585850.0
2022-09-22 11:00:00	AAPL	Stock	151.76	152.25	150.91	151.855	9408414.0
2022-09-22 12:00:00	AAPL	Stock	151.83	152.91	151.515	152.56	7143911.0
2022-09-22 13:00:00	AAPL	Stock	152.56	152.98	151.88	152.6995	6781179.0
2022-09-22 14:00:00	AAPL	Stock	152.69	152.88	151.9698	152.82	6531021.0
2022-09-22 15:00:00	AAPL	Stock	152.81	154.47	152.61	152.7	15414608.0
2022-09-22 16:00:00	AAPL	Stock	152.69	152.86	152.3	152.63	6003142.0
2022-09-22 17:00:00	AAPL	Stock	152.66	152.89	152.47	152.7935	59529.0
2022-09-22 18:00:00	AAPL	Stock	152.8	152.99	152.51	152.54	31170.0
2022-09-22 19:00:00	AAPL	Stock	152.57	153.1	152.57	153.0	31394.0
2022-09-22 04:00:00	MSFT	Stock	238.95	241.48	238.95	240.75	7468.0
2022-09-22 05:00:00	MSFT	Stock	240.15	240.15	239.0	239.4	4484.0
2022-09-22 06:00:00	MSFT	Stock	239.27	239.4	239.27	239.4	1705.0
2022-09-22 07:00:00	MSFT	Stock	239.69	239.7	237.62	239.21	32019.0
2022-09-22 08:00:00	MSFT	Stock	239.6	240.5	237.8107	239.63	48941.0
2022-09-22 09:00:00	MSFT	Stock	239.811	240.919	237.51	240.28	3251593.0
2022-09-22 10:00:00	MSFT	Stock	240.26	241.06	239.37	239.59	3602607.0
2022-09-22 11:00:00	MSFT	Stock	239.595	241.3147	239.1775	241.14	2715979.0
2022-09-22 12:00:00	MSFT	Stock	241.12	241.67	240.2	240.27	1793291.0
2022-09-22 13:00:00	MSFT	Stock	240.3	241.85	239.75	241.34	1812223.0
2022-09-22 14:00:00	MSFT	Stock	241.3	241.84	239.7801	241.75	2100861.0
2022-09-22 15:00:00	MSFT	Stock	241.785	243.86	240.66	240.78	5205736.0
2022-09-22 16:00:00	MSFT	Stock	240.98	241.13	240.35	240.9	3306195.0
2022-09-22 17:00:00	MSFT	Stock	240.85	241.37	240.8	241.1	29480.0
2022-09-22 18:00:00	MSFT	Stock	241.29	241.55	240.82	241.0	9423.0
2022-09-22 19:00:00	MSFT	Stock	241.29	241.29	241.0	241.2	6217.0
2022-09-22 04:00:00	NVDA	Stock	13.2	13.406	13.2	13.316	477480.0
2022-09-22 05:00:00	NVDA	Stock	13.321	13.321	13.2	13.235	152350.0
2022-09-22 06:00:00	NVDA	Stock	13.218	13.303	13.214	13.287	135230.0
2022-09-22 07:00:00	NVDA	Stock	13.287	13.32	13.141	13.225	504570.0
2022-09-22 08:00:00	NVDA	Stock	13.287	13.315	13.1351	13.23	2248440.0
2022-09-22 09:00:00	NVDA	Stock	13.25	13.25	12.704	12.76	101704130.0
2022-09-22 10:00:00	NVDA	Stock	12.762	12.8525	12.564	12.5759	135511860.0
2022-09-22 11:00:00	NVDA	Stock	12.575	12.666	12.5212	12.598	91363720.0
2022-09-22 12:00:00	NVDA	Stock	12.598	12.679	12.546	12.6301	58229750.0
2022-09-22 13:00:00	NVDA	Stock	12.631	12.6382	12.546	12.599	51391060.0
2022-09-22 14:00:00	NVDA	Stock	12.599	12.6238	12.428	12.523	63721180.0
2022-09-22 15:00:00	NVDA	Stock	12.523	12.761	12.523	12.559	110952820.0
2022-09-22 16:00:00	NVDA	Stock	12.561	12.574	12.513	12.552	22300770.0
2022-09-22 17:00:00	NVDA	Stock	12.552	12.566	12.536	12.555	456440.0
2022-09-22 18:00:00	NVDA	Stock	12.554	12.562	12.537	12.538	353660.0
2022-09-22 19:00:00	NVDA	Stock	12.548	12.572	12.539	12.565	468130.0
2022-09-22 04:00:00	AMZN	Stock	118.35	119.1	118.12	118.84	42413.0
2022-09-22 05:00:00	AMZN	Stock	118.86	118.86	118.02	118.34	11442.0

> showing 50 of 61,858 rows — these rows as CSV

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