PREVIEW / stock_1hour / 2023-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-27.parquet
  size:    1.3 MB
  rows:    56,784
  symbols: 1,361

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-10-27 04:00:00	AAPL	Stock	167.4	167.68	167.19	167.59	25853.0
2023-10-27 05:00:00	AAPL	Stock	167.58	167.68	167.12	167.23	24995.0
2023-10-27 06:00:00	AAPL	Stock	167.39	167.52	167.0	167.0	11231.0
2023-10-27 07:00:00	AAPL	Stock	167.12	167.3	166.46	166.46	61127.0
2023-10-27 08:00:00	AAPL	Stock	167.02	167.47	166.28	167.0898	261759.0
2023-10-27 09:00:00	AAPL	Stock	167.0865	168.42	166.65	167.89	6638380.0
2023-10-27 10:00:00	AAPL	Stock	167.88	168.77	167.39	168.435	6846070.0
2023-10-27 11:00:00	AAPL	Stock	168.44	168.96	168.02	168.37	4309462.0
2023-10-27 12:00:00	AAPL	Stock	168.35	168.49	167.29	167.42	3237502.0
2023-10-27 13:00:00	AAPL	Stock	167.43	167.91	166.83	167.66	5261268.0
2023-10-27 14:00:00	AAPL	Stock	167.65	168.23	167.3	167.62	5006154.0
2023-10-27 15:00:00	AAPL	Stock	167.62	168.34	167.49	168.285	8233928.0
2023-10-27 16:00:00	AAPL	Stock	168.29	168.3301	167.52	167.88	10280886.0
2023-10-27 17:00:00	AAPL	Stock	167.86	168.0	167.78	167.97	10721.0
2023-10-27 18:00:00	AAPL	Stock	167.97	168.09	167.97	168.03	12166.0
2023-10-27 19:00:00	AAPL	Stock	168.0	168.05	168.0	168.02	12157.0
2023-10-27 04:00:00	MSFT	Stock	330.93	332.49	330.93	331.9	13336.0
2023-10-27 05:00:00	MSFT	Stock	332.09	332.42	331.39	331.5	3354.0
2023-10-27 06:00:00	MSFT	Stock	331.77	332.0	330.57	330.57	4099.0
2023-10-27 07:00:00	MSFT	Stock	331.18	331.42	330.0	330.6	16347.0
2023-10-27 08:00:00	MSFT	Stock	330.9	332.0	330.1501	331.42	75867.0
2023-10-27 09:00:00	MSFT	Stock	331.49	333.73	329.37	333.63	3728538.0
2023-10-27 10:00:00	MSFT	Stock	333.66	334.88	332.53	334.14	3634922.0
2023-10-27 11:00:00	MSFT	Stock	334.17	336.72	333.6701	334.38	2378027.0
2023-10-27 12:00:00	MSFT	Stock	334.32	334.86	332.29	332.43	1383464.0
2023-10-27 13:00:00	MSFT	Stock	332.421	332.6	330.07	330.2	1808769.0
2023-10-27 14:00:00	MSFT	Stock	330.16	330.39	328.4007	328.895	2589975.0
2023-10-27 15:00:00	MSFT	Stock	328.88	330.03	328.46	329.8289	3209050.0
2023-10-27 16:00:00	MSFT	Stock	329.83	330.21	329.5317	330.0	3247941.0
2023-10-27 17:00:00	MSFT	Stock	330.0291	330.03	329.7	329.85	5333.0
2023-10-27 18:00:00	MSFT	Stock	329.95	330.0	329.8	329.81	7762.0
2023-10-27 19:00:00	MSFT	Stock	329.81	330.1	329.8	329.81	8301.0
2023-10-27 04:00:00	NVDA	Stock	40.911	40.955	40.827	40.955	133070.0
2023-10-27 05:00:00	NVDA	Stock	40.96	41.086	40.948	40.967	87810.0
2023-10-27 06:00:00	NVDA	Stock	41.0	41.08	40.975	40.975	66820.0
2023-10-27 07:00:00	NVDA	Stock	40.993	41.0	40.788	40.83	730290.0
2023-10-27 08:00:00	NVDA	Stock	40.9645	41.159	40.784	41.05	2438600.0
2023-10-27 09:00:00	NVDA	Stock	41.073	41.206	40.5818	40.788	47469940.0
2023-10-27 10:00:00	NVDA	Stock	40.771	40.924	40.422	40.569	61795540.0
2023-10-27 11:00:00	NVDA	Stock	40.576	41.039	40.491	40.887	46685700.0
2023-10-27 12:00:00	NVDA	Stock	40.878	40.959	40.595	40.62	25037880.0
2023-10-27 13:00:00	NVDA	Stock	40.62	40.644	40.16	40.2316	37431090.0
2023-10-27 14:00:00	NVDA	Stock	40.2224	40.407	40.015	40.19	41650690.0
2023-10-27 15:00:00	NVDA	Stock	40.186	40.535	40.159	40.505	48276220.0
2023-10-27 16:00:00	NVDA	Stock	40.5025	40.519	40.461	40.473	14250890.0
2023-10-27 17:00:00	NVDA	Stock	40.472	40.644	40.466	40.5684	570350.0
2023-10-27 18:00:00	NVDA	Stock	40.566	40.62	40.54	40.619	157460.0
2023-10-27 19:00:00	NVDA	Stock	40.61	40.63	40.5	40.53	364580.0
2023-10-27 04:00:00	AMZN	Stock	125.55	126.13	125.1	126.12	96096.0
2023-10-27 05:00:00	AMZN	Stock	126.0	127.24	126.0	126.5	87499.0

> showing 50 of 56,784 rows — these rows as CSV

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