PREVIEW / stock_1hour / 2023-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-28.parquet
  size:    1.3 MB
  rows:    60,417
  symbols: 1,676

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-04-28 04:00:00	AAPL	Stock	167.76	167.76	167.48	167.55	11365.0
2023-04-28 05:00:00	AAPL	Stock	167.42	167.61	167.41	167.48	11285.0
2023-04-28 06:00:00	AAPL	Stock	167.45	167.62	167.42	167.52	6166.0
2023-04-28 07:00:00	AAPL	Stock	167.51	167.75	167.48	167.52	49695.0
2023-04-28 08:00:00	AAPL	Stock	167.6007	168.19	167.27	167.9	215437.0
2023-04-28 09:00:00	AAPL	Stock	167.95	169.04	167.8801	168.51	5762839.0
2023-04-28 10:00:00	AAPL	Stock	168.51	169.85	168.23	168.78	8966917.0
2023-04-28 11:00:00	AAPL	Stock	168.78	168.83	168.03	168.76	4560427.0
2023-04-28 12:00:00	AAPL	Stock	168.77	168.97	168.33	168.8353	3480553.0
2023-04-28 13:00:00	AAPL	Stock	168.83	168.89	168.15	168.35	3659604.0
2023-04-28 14:00:00	AAPL	Stock	168.345	168.5917	168.12	168.5701	3639124.0
2023-04-28 15:00:00	AAPL	Stock	168.57	169.71	168.5219	169.69	8108256.0
2023-04-28 16:00:00	AAPL	Stock	169.69	169.77	169.42	169.46	8087496.0
2023-04-28 17:00:00	AAPL	Stock	169.46	169.68	169.12	169.18	80622.0
2023-04-28 18:00:00	AAPL	Stock	169.15	169.42	169.15	169.39	25098.0
2023-04-28 19:00:00	AAPL	Stock	169.39	169.59	169.27	169.59	36795.0
2023-04-28 04:00:00	MSFT	Stock	304.3	304.63	303.14	303.23	15280.0
2023-04-28 05:00:00	MSFT	Stock	303.35	304.5	303.0	304.05	29080.0
2023-04-28 06:00:00	MSFT	Stock	304.15	304.45	304.0	304.2	17896.0
2023-04-28 07:00:00	MSFT	Stock	304.32	304.5	303.75	304.1	23299.0
2023-04-28 08:00:00	MSFT	Stock	304.35	304.7588	303.2	304.6	66256.0
2023-04-28 09:00:00	MSFT	Stock	304.6	307.33	303.31	307.03	4542751.0
2023-04-28 10:00:00	MSFT	Stock	307.06	308.93	305.0	305.56	6378613.0
2023-04-28 11:00:00	MSFT	Stock	305.56	306.03	304.7	305.63	2698498.0
2023-04-28 12:00:00	MSFT	Stock	305.6964	306.64	304.1	305.02	2370557.0
2023-04-28 13:00:00	MSFT	Stock	305.02	305.745	304.31	305.465	1681324.0
2023-04-28 14:00:00	MSFT	Stock	305.47	306.1561	305.11	305.88	1736867.0
2023-04-28 15:00:00	MSFT	Stock	305.86	307.42	305.53	307.32	3217356.0
2023-04-28 16:00:00	MSFT	Stock	307.32	307.6	307.26	307.47	4307741.0
2023-04-28 17:00:00	MSFT	Stock	307.47	307.47	307.1	307.2244	20990.0
2023-04-28 18:00:00	MSFT	Stock	307.0643	307.35	307.06	307.2	7848.0
2023-04-28 19:00:00	MSFT	Stock	307.1	307.5	307.1	307.5	7729.0
2023-04-28 04:00:00	NVDA	Stock	27.154	27.154	27.021	27.021	14870.0
2023-04-28 05:00:00	NVDA	Stock	27.035	27.087	27.008	27.086	44210.0
2023-04-28 06:00:00	NVDA	Stock	27.049	27.12	27.049	27.12	15710.0
2023-04-28 07:00:00	NVDA	Stock	27.125	27.531	27.125	27.32	720840.0
2023-04-28 08:00:00	NVDA	Stock	27.325	27.52	27.034	27.3	1080120.0
2023-04-28 09:00:00	NVDA	Stock	27.291	27.375	27.0715	27.197	31517450.0
2023-04-28 10:00:00	NVDA	Stock	27.197	27.517	27.122	27.314	46881180.0
2023-04-28 11:00:00	NVDA	Stock	27.317	27.4788	27.241	27.4788	25938020.0
2023-04-28 12:00:00	NVDA	Stock	27.479	27.5752	27.359	27.5574	24563850.0
2023-04-28 13:00:00	NVDA	Stock	27.562	27.595	27.496	27.536	23455090.0
2023-04-28 14:00:00	NVDA	Stock	27.5355	27.593	27.509	27.576	18387410.0
2023-04-28 15:00:00	NVDA	Stock	27.5747	27.758	27.573	27.75	35212170.0
2023-04-28 16:00:00	NVDA	Stock	27.75	27.759	27.73	27.75	20016850.0
2023-04-28 17:00:00	NVDA	Stock	27.752	27.752	27.74	27.749	174610.0
2023-04-28 18:00:00	NVDA	Stock	27.7446	27.759	27.7421	27.759	185360.0
2023-04-28 19:00:00	NVDA	Stock	27.755	27.794	27.745	27.794	196120.0
2023-04-28 04:00:00	AMZN	Stock	107.6	108.7	107.0	108.27	146065.0
2023-04-28 05:00:00	AMZN	Stock	108.25	108.93	107.95	108.6	77431.0

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

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