PREVIEW / stock_1hour / 2023-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-15.parquet
  size:    1.4 MB
  rows:    60,380
  symbols: 1,669

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-05-15 04:00:00	AAPL	Stock	172.59	173.0	172.59	172.75	15721.0
2023-05-15 05:00:00	AAPL	Stock	172.89	172.94	172.85	172.9	12398.0
2023-05-15 06:00:00	AAPL	Stock	172.89	172.95	172.78	172.9	3467.0
2023-05-15 07:00:00	AAPL	Stock	172.9	173.32	172.86	173.0	92421.0
2023-05-15 08:00:00	AAPL	Stock	172.9219	173.3	172.16	173.09	140275.0
2023-05-15 09:00:00	AAPL	Stock	173.1	173.26	171.83	171.98	5079747.0
2023-05-15 10:00:00	AAPL	Stock	171.975	172.28	171.47	171.905	4837176.0
2023-05-15 11:00:00	AAPL	Stock	171.905	172.42	171.88	172.3518	3201953.0
2023-05-15 12:00:00	AAPL	Stock	172.365	172.43	171.94	172.19	2306200.0
2023-05-15 13:00:00	AAPL	Stock	172.2	172.3	171.525	171.865	3270445.0
2023-05-15 14:00:00	AAPL	Stock	171.87	172.02	171.66	171.73	2442456.0
2023-05-15 15:00:00	AAPL	Stock	171.73	172.185	171.67	172.14	4593729.0
2023-05-15 16:00:00	AAPL	Stock	172.14	172.19	170.07	171.97	4897221.0
2023-05-15 17:00:00	AAPL	Stock	171.99	172.05	171.97	172.03	10917.0
2023-05-15 18:00:00	AAPL	Stock	171.97	172.14	171.95	172.03	7843.0
2023-05-15 19:00:00	AAPL	Stock	172.02	172.04	171.93	172.0	13617.0
2023-05-15 04:00:00	MSFT	Stock	309.08	309.85	309.02	309.6	2670.0
2023-05-15 05:00:00	MSFT	Stock	309.84	309.89	309.64	309.65	1095.0
2023-05-15 06:00:00	MSFT	Stock	309.25	309.48	309.25	309.47	1862.0
2023-05-15 07:00:00	MSFT	Stock	309.54	309.7	309.26	309.33	6578.0
2023-05-15 08:00:00	MSFT	Stock	309.5516	309.8	308.6	309.47	25819.0
2023-05-15 09:00:00	MSFT	Stock	309.55	309.75	307.64	308.79	2028763.0
2023-05-15 10:00:00	MSFT	Stock	308.83	309.905	307.59	309.18	2032851.0
2023-05-15 11:00:00	MSFT	Stock	309.185	309.8815	308.7801	309.7799	1165622.0
2023-05-15 12:00:00	MSFT	Stock	309.8	309.84	308.47	308.96	917054.0
2023-05-15 13:00:00	MSFT	Stock	308.9701	309.73	308.37	308.94	999970.0
2023-05-15 14:00:00	MSFT	Stock	308.96	309.345	308.69	309.025	910218.0
2023-05-15 15:00:00	MSFT	Stock	308.97	309.595	308.8813	309.51	1768316.0
2023-05-15 16:00:00	MSFT	Stock	309.51	309.75	309.052	309.45	2274833.0
2023-05-15 17:00:00	MSFT	Stock	309.45	309.54	309.11	309.4	3304.0
2023-05-15 18:00:00	MSFT	Stock	309.5	309.52	309.3	309.4	4246.0
2023-05-15 19:00:00	MSFT	Stock	309.4	309.54	309.4	309.54	5982.0
2023-05-15 04:00:00	NVDA	Stock	28.356	28.444	28.316	28.358	55390.0
2023-05-15 05:00:00	NVDA	Stock	28.36	28.414	28.338	28.402	49500.0
2023-05-15 06:00:00	NVDA	Stock	28.405	28.424	28.37	28.424	16910.0
2023-05-15 07:00:00	NVDA	Stock	28.404	28.43	28.37	28.424	152900.0
2023-05-15 08:00:00	NVDA	Stock	28.31	28.464	28.29	28.421	426260.0
2023-05-15 09:00:00	NVDA	Stock	28.43	28.535	28.254	28.257	28490290.0
2023-05-15 10:00:00	NVDA	Stock	28.261	28.423	28.152	28.3622	31231120.0
2023-05-15 11:00:00	NVDA	Stock	28.3648	28.743	28.348	28.7329	42239450.0
2023-05-15 12:00:00	NVDA	Stock	28.733	28.838	28.679	28.811	28704810.0
2023-05-15 13:00:00	NVDA	Stock	28.821	28.879	28.743	28.8205	25524300.0
2023-05-15 14:00:00	NVDA	Stock	28.821	28.929	28.798	28.8725	25551180.0
2023-05-15 15:00:00	NVDA	Stock	28.871	28.969	28.82	28.959	30118140.0
2023-05-15 16:00:00	NVDA	Stock	28.959	28.975	28.907	28.916	17777050.0
2023-05-15 17:00:00	NVDA	Stock	28.929	28.949	28.9199	28.949	182350.0
2023-05-15 18:00:00	NVDA	Stock	28.9484	28.949	28.929	28.939	171680.0
2023-05-15 19:00:00	NVDA	Stock	28.935	28.942	28.928	28.942	203640.0
2023-05-15 04:00:00	AMZN	Stock	110.05	110.7	110.05	110.57	7597.0
2023-05-15 05:00:00	AMZN	Stock	110.57	110.63	110.48	110.59	2628.0

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

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