PREVIEW / stock_1hour / 2023-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-09.parquet
  size:    1.4 MB
  rows:    61,149
  symbols: 1,798

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-03-09 04:00:00	AAPL	Stock	152.16	152.3	151.86	151.86	17327.0
2023-03-09 05:00:00	AAPL	Stock	151.87	151.99	151.73	151.91	4595.0
2023-03-09 06:00:00	AAPL	Stock	151.97	152.39	151.97	152.24	13443.0
2023-03-09 07:00:00	AAPL	Stock	152.3	152.66	152.22	152.52	44824.0
2023-03-09 08:00:00	AAPL	Stock	152.35	153.65	151.8615	153.65	237615.0
2023-03-09 09:00:00	AAPL	Stock	153.65	154.385	152.9488	154.2949	5643231.0
2023-03-09 10:00:00	AAPL	Stock	154.295	154.535	153.63	153.8885	6307544.0
2023-03-09 11:00:00	AAPL	Stock	153.88	154.4513	153.7	154.1	4072585.0
2023-03-09 12:00:00	AAPL	Stock	154.11	154.22	153.45	153.55	4103617.0
2023-03-09 13:00:00	AAPL	Stock	153.56	153.63	151.83	151.9513	5246024.0
2023-03-09 14:00:00	AAPL	Stock	151.96	152.12	151.22	151.3025	5265874.0
2023-03-09 15:00:00	AAPL	Stock	151.31	151.41	150.225	150.55	9559326.0
2023-03-09 16:00:00	AAPL	Stock	150.56	150.7	150.37	150.6101	6427447.0
2023-03-09 17:00:00	AAPL	Stock	150.61	150.75	150.55	150.5623	193952.0
2023-03-09 18:00:00	AAPL	Stock	150.57	150.57	150.11	150.4	45375.0
2023-03-09 19:00:00	AAPL	Stock	150.4	150.5	150.19	150.4	40827.0
2023-03-09 04:00:00	MSFT	Stock	252.75	252.75	252.02	252.02	2987.0
2023-03-09 05:00:00	MSFT	Stock	252.11	252.28	251.81	252.28	3453.0
2023-03-09 06:00:00	MSFT	Stock	252.3	252.42	252.15	252.42	3297.0
2023-03-09 07:00:00	MSFT	Stock	252.54	252.62	252.2	252.4	5218.0
2023-03-09 08:00:00	MSFT	Stock	252.16	255.2	252.0	255.01	54449.0
2023-03-09 09:00:00	MSFT	Stock	255.34	258.32	254.96	258.0092	2395276.0
2023-03-09 10:00:00	MSFT	Stock	258.02	259.56	257.77	258.51	2807301.0
2023-03-09 11:00:00	MSFT	Stock	258.51	259.0	257.67	258.18	1861718.0
2023-03-09 12:00:00	MSFT	Stock	258.2	258.3	256.13	256.62	1791729.0
2023-03-09 13:00:00	MSFT	Stock	256.63	256.88	253.76	254.1043	1878309.0
2023-03-09 14:00:00	MSFT	Stock	254.07	254.46	252.92	253.56	1845775.0
2023-03-09 15:00:00	MSFT	Stock	253.6	253.74	251.58	252.28	3680362.0
2023-03-09 16:00:00	MSFT	Stock	252.32	252.8	251.81	252.32	3638628.0
2023-03-09 17:00:00	MSFT	Stock	252.12	252.75	252.06	252.1	13920.0
2023-03-09 18:00:00	MSFT	Stock	252.11	252.11	251.11	251.66	10083.0
2023-03-09 19:00:00	MSFT	Stock	251.75	251.98	251.25	251.45	16883.0
2023-03-09 04:00:00	NVDA	Stock	24.1	24.1	23.967	23.967	337040.0
2023-03-09 05:00:00	NVDA	Stock	23.979	24.016	23.902	23.934	285130.0
2023-03-09 06:00:00	NVDA	Stock	23.96	23.975	23.913	23.93	439200.0
2023-03-09 07:00:00	NVDA	Stock	23.93	24.038	23.92	23.984	1113900.0
2023-03-09 08:00:00	NVDA	Stock	24.007	24.269	23.92	24.269	2912990.0
2023-03-09 09:00:00	NVDA	Stock	24.2695	24.3829	24.068	24.365	68368290.0
2023-03-09 10:00:00	NVDA	Stock	24.368	24.454	24.072	24.1357	76426870.0
2023-03-09 11:00:00	NVDA	Stock	24.135	24.24	24.083	24.109	38966800.0
2023-03-09 12:00:00	NVDA	Stock	24.1144	24.144	23.871	23.9805	44287990.0
2023-03-09 13:00:00	NVDA	Stock	23.98	24.048	23.667	23.7112	37703160.0
2023-03-09 14:00:00	NVDA	Stock	23.708	23.7861	23.563	23.6817	44945810.0
2023-03-09 15:00:00	NVDA	Stock	23.683	23.704	23.3828	23.43	68188070.0
2023-03-09 16:00:00	NVDA	Stock	23.431	23.8732	23.394	23.415	26131590.0
2023-03-09 17:00:00	NVDA	Stock	23.408	23.414	23.356	23.388	372740.0
2023-03-09 18:00:00	NVDA	Stock	23.388	23.388	23.284	23.34	419750.0
2023-03-09 19:00:00	NVDA	Stock	23.34	23.345	23.292	23.301	314140.0
2023-03-09 04:00:00	AMZN	Stock	93.67	93.67	93.16	93.17	8927.0
2023-03-09 05:00:00	AMZN	Stock	93.16	93.22	93.09	93.18	4530.0

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

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