PREVIEW / stock_1hour / 2022-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-20.parquet
  size:    1.4 MB
  rows:    61,380
  symbols: 2,231

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-20 04:00:00	AAPL	Stock	154.54	154.54	153.68	153.85	29675.0
2022-09-20 05:00:00	AAPL	Stock	153.89	153.89	153.5	153.5	29671.0
2022-09-20 06:00:00	AAPL	Stock	153.52	153.8	153.45	153.54	20572.0
2022-09-20 07:00:00	AAPL	Stock	153.67	154.05	153.55	153.55	126487.0
2022-09-20 08:00:00	AAPL	Stock	153.7793	155.3	153.25	153.56	250199.0
2022-09-20 09:00:00	AAPL	Stock	153.6	154.88	153.08	154.76	10896436.0
2022-09-20 10:00:00	AAPL	Stock	154.76	155.44	154.13	155.37	12137914.0
2022-09-20 11:00:00	AAPL	Stock	155.385	157.88	155.22	157.825	16051194.0
2022-09-20 12:00:00	AAPL	Stock	157.83	158.08	156.6201	157.06	11842320.0
2022-09-20 13:00:00	AAPL	Stock	157.03	157.1	155.4	155.615	10466166.0
2022-09-20 14:00:00	AAPL	Stock	155.61	156.59	155.53	156.42	10558902.0
2022-09-20 15:00:00	AAPL	Stock	156.4101	157.76	156.21	156.9	15989304.0
2022-09-20 16:00:00	AAPL	Stock	156.92	157.2	156.85	157.09	6433131.0
2022-09-20 17:00:00	AAPL	Stock	157.05	157.12	156.96	157.0	71958.0
2022-09-20 18:00:00	AAPL	Stock	157.03	157.04	156.67	156.81	51785.0
2022-09-20 19:00:00	AAPL	Stock	156.81	156.87	156.45	156.49	66141.0
2022-09-20 04:00:00	MSFT	Stock	244.07	244.1	242.92	243.22	4383.0
2022-09-20 05:00:00	MSFT	Stock	243.28	243.28	242.29	242.3	5076.0
2022-09-20 06:00:00	MSFT	Stock	242.32	243.0	242.25	242.75	1193.0
2022-09-20 07:00:00	MSFT	Stock	243.0	243.35	242.88	242.9	7661.0
2022-09-20 08:00:00	MSFT	Stock	242.9116	243.909	242.1817	242.7	50565.0
2022-09-20 09:00:00	MSFT	Stock	242.74	243.5	241.08	242.47	2389823.0
2022-09-20 10:00:00	MSFT	Stock	242.47	242.98	241.24	242.7742	2837154.0
2022-09-20 11:00:00	MSFT	Stock	242.76	243.44	242.0	243.322	1626941.0
2022-09-20 12:00:00	MSFT	Stock	243.35	243.51	241.54	241.9617	1521326.0
2022-09-20 13:00:00	MSFT	Stock	241.96	242.12	239.64	239.8762	2619097.0
2022-09-20 14:00:00	MSFT	Stock	239.85	241.67	239.83	241.4801	2457648.0
2022-09-20 15:00:00	MSFT	Stock	241.47	243.07	241.28	242.45	3448743.0
2022-09-20 16:00:00	MSFT	Stock	242.46	243.32	242.33	242.89	3041620.0
2022-09-20 17:00:00	MSFT	Stock	242.9	243.15	242.65	243.05	17562.0
2022-09-20 18:00:00	MSFT	Stock	243.05	243.05	242.5	242.63	33675.0
2022-09-20 19:00:00	MSFT	Stock	242.55	242.65	242.25	242.45	22398.0
2022-09-20 04:00:00	NVDA	Stock	13.338	13.338	13.265	13.3	93050.0
2022-09-20 05:00:00	NVDA	Stock	13.285	13.304	13.251	13.269	101560.0
2022-09-20 06:00:00	NVDA	Stock	13.253	13.288	13.252	13.271	33970.0
2022-09-20 07:00:00	NVDA	Stock	13.291	13.314	13.266	13.281	337950.0
2022-09-20 08:00:00	NVDA	Stock	13.5	13.5	13.229	13.27	1352670.0
2022-09-20 09:00:00	NVDA	Stock	13.27	13.32	13.164	13.251	53513880.0
2022-09-20 10:00:00	NVDA	Stock	13.252	13.422	13.221	13.409	82716550.0
2022-09-20 11:00:00	NVDA	Stock	13.409	13.4828	13.347	13.4675	66439530.0
2022-09-20 12:00:00	NVDA	Stock	13.469	13.478	13.267	13.3123	49427270.0
2022-09-20 13:00:00	NVDA	Stock	13.312	13.328	13.057	13.072	63714320.0
2022-09-20 14:00:00	NVDA	Stock	13.0681	13.229	13.065	13.189	52975640.0
2022-09-20 15:00:00	NVDA	Stock	13.188	13.258	13.158	13.174	62796340.0
2022-09-20 16:00:00	NVDA	Stock	13.175	13.218	13.164	13.186	14445570.0
2022-09-20 17:00:00	NVDA	Stock	13.189	13.196	13.176	13.186	220630.0
2022-09-20 18:00:00	NVDA	Stock	13.185	13.19	13.163	13.189	285110.0
2022-09-20 19:00:00	NVDA	Stock	13.187	13.187	13.153	13.153	199120.0
2022-09-20 04:00:00	AMZN	Stock	124.66	124.73	124.03	124.2	31919.0
2022-09-20 05:00:00	AMZN	Stock	124.3	124.3	123.72	123.92	14391.0

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

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