PREVIEW / stock_1hour / 2023-05-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-17.parquet
  size:    1.3 MB
  rows:    60,051
  symbols: 1,677

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-17 04:00:00	AAPL	Stock	172.18	172.35	172.0	172.2	12800.0
2023-05-17 05:00:00	AAPL	Stock	172.22	172.22	172.01	172.15	6039.0
2023-05-17 06:00:00	AAPL	Stock	172.16	172.17	171.99	172.11	11850.0
2023-05-17 07:00:00	AAPL	Stock	172.13	172.22	171.93	172.01	97998.0
2023-05-17 08:00:00	AAPL	Stock	172.1987	172.29	170.8	171.51	451805.0
2023-05-17 09:00:00	AAPL	Stock	171.5783	172.15	170.43	170.5299	6592797.0
2023-05-17 10:00:00	AAPL	Stock	170.52	171.2109	170.4201	171.03	5888867.0
2023-05-17 11:00:00	AAPL	Stock	171.045	171.27	170.47	171.07	4728955.0
2023-05-17 12:00:00	AAPL	Stock	171.07	171.74	170.83	171.6299	3582431.0
2023-05-17 13:00:00	AAPL	Stock	171.64	172.86	171.6	172.8286	6186108.0
2023-05-17 14:00:00	AAPL	Stock	172.825	172.85	171.95	172.1285	4459720.0
2023-05-17 15:00:00	AAPL	Stock	172.13	172.925	171.94	172.65	6784538.0
2023-05-17 16:00:00	AAPL	Stock	172.63	172.75	172.6	172.7	7683417.0
2023-05-17 17:00:00	AAPL	Stock	172.7	172.73	172.63	172.667	50494.0
2023-05-17 18:00:00	AAPL	Stock	172.67	172.6792	172.61	172.64	13501.0
2023-05-17 19:00:00	AAPL	Stock	172.64	172.72	172.54	172.72	22826.0
2023-05-17 04:00:00	MSFT	Stock	311.72	311.72	311.4	311.49	2368.0
2023-05-17 05:00:00	MSFT	Stock	311.49	311.6	311.35	311.6	2306.0
2023-05-17 06:00:00	MSFT	Stock	311.61	311.94	310.93	310.93	3890.0
2023-05-17 07:00:00	MSFT	Stock	311.36	311.94	311.1	311.5	19414.0
2023-05-17 08:00:00	MSFT	Stock	311.6	311.94	311.0	311.9373	43689.0
2023-05-17 09:00:00	MSFT	Stock	311.9211	313.11	311.43	311.75	2142607.0
2023-05-17 10:00:00	MSFT	Stock	311.68	312.0	311.07	311.8	1827277.0
2023-05-17 11:00:00	MSFT	Stock	311.81	312.35	310.74	312.31	1799821.0
2023-05-17 12:00:00	MSFT	Stock	312.29	313.14	311.87	312.935	1195203.0
2023-05-17 13:00:00	MSFT	Stock	312.9918	314.06	312.9918	313.9627	1463136.0
2023-05-17 14:00:00	MSFT	Stock	313.97	313.98	313.13	313.23	1139122.0
2023-05-17 15:00:00	MSFT	Stock	313.23	314.43	313.06	314.005	2739569.0
2023-05-17 16:00:00	MSFT	Stock	313.99	314.26	313.9	313.97	5262214.0
2023-05-17 17:00:00	MSFT	Stock	313.99	314.1	313.71	313.71	8235.0
2023-05-17 18:00:00	MSFT	Stock	313.71	313.99	313.5046	313.91	4038.0
2023-05-17 19:00:00	MSFT	Stock	313.93	314.1	313.85	313.95	3478.0
2023-05-17 04:00:00	NVDA	Stock	29.34	29.388	29.326	29.335	78760.0
2023-05-17 05:00:00	NVDA	Stock	29.34	29.368	29.323	29.365	48870.0
2023-05-17 06:00:00	NVDA	Stock	29.357	29.57	29.345	29.499	441630.0
2023-05-17 07:00:00	NVDA	Stock	29.5	29.73	29.45	29.577	793710.0
2023-05-17 08:00:00	NVDA	Stock	29.491	29.7	29.258	29.59	1264560.0
2023-05-17 09:00:00	NVDA	Stock	29.585	29.638	29.43	29.541	42845410.0
2023-05-17 10:00:00	NVDA	Stock	29.54	29.853	29.5112	29.782	58043150.0
2023-05-17 11:00:00	NVDA	Stock	29.7789	29.82	29.626	29.789	33296070.0
2023-05-17 12:00:00	NVDA	Stock	29.788	29.922	29.71	29.887	32263260.0
2023-05-17 13:00:00	NVDA	Stock	29.888	30.0819	29.871	30.0585	55861160.0
2023-05-17 14:00:00	NVDA	Stock	30.0565	30.094	29.948	30.007	35425350.0
2023-05-17 15:00:00	NVDA	Stock	30.004	30.199	29.9689	30.183	54685820.0
2023-05-17 16:00:00	NVDA	Stock	30.184	30.315	30.165	30.265	23405650.0
2023-05-17 17:00:00	NVDA	Stock	30.268	30.285	30.245	30.27	285090.0
2023-05-17 18:00:00	NVDA	Stock	30.273	30.3	30.24	30.28	569820.0
2023-05-17 19:00:00	NVDA	Stock	30.279	30.349	30.278	30.31	640630.0
2023-05-17 04:00:00	AMZN	Stock	113.1	113.72	112.93	113.52	14772.0
2023-05-17 05:00:00	AMZN	Stock	113.57	113.58	113.4	113.48	6138.0

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

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