PREVIEW / stock_1hour / 2023-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-03.parquet
  size:    1.3 MB
  rows:    59,191
  symbols: 1,341

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-11-03 04:00:00	AAPL	Stock	172.08	172.63	171.51	171.6	87242.0
2023-11-03 05:00:00	AAPL	Stock	171.52	172.11	171.5	172.02	44963.0
2023-11-03 06:00:00	AAPL	Stock	172.09	172.3	171.88	172.13	40427.0
2023-11-03 07:00:00	AAPL	Stock	172.02	174.53	172.0	174.01	442995.0
2023-11-03 08:00:00	AAPL	Stock	172.02	175.3	171.89	174.06	1708291.0
2023-11-03 09:00:00	AAPL	Stock	174.11	176.4	173.33	175.35	14842256.0
2023-11-03 10:00:00	AAPL	Stock	175.36	175.94	174.46	175.7201	11158637.0
2023-11-03 11:00:00	AAPL	Stock	175.725	175.79	174.6	175.4301	5994440.0
2023-11-03 12:00:00	AAPL	Stock	175.44	176.49	175.309	176.1993	6234087.0
2023-11-03 13:00:00	AAPL	Stock	176.1803	176.42	175.18	175.56	4624245.0
2023-11-03 14:00:00	AAPL	Stock	175.56	176.24	175.07	176.11	4967038.0
2023-11-03 15:00:00	AAPL	Stock	176.11	176.82	175.85	176.63	8678393.0
2023-11-03 16:00:00	AAPL	Stock	176.56	176.85	176.56	176.74	7498229.0
2023-11-03 17:00:00	AAPL	Stock	176.7201	176.81	176.62	176.64	394474.0
2023-11-03 18:00:00	AAPL	Stock	176.64	176.6918	176.64	176.69	16997.0
2023-11-03 19:00:00	AAPL	Stock	176.69	176.71	176.61	176.66	36776.0
2023-11-03 04:00:00	MSFT	Stock	349.74	349.81	348.63	349.51	5178.0
2023-11-03 05:00:00	MSFT	Stock	349.67	349.67	349.4	349.65	4803.0
2023-11-03 06:00:00	MSFT	Stock	349.45	349.69	349.31	349.31	4874.0
2023-11-03 07:00:00	MSFT	Stock	349.34	349.55	348.89	349.02	17850.0
2023-11-03 08:00:00	MSFT	Stock	349.15	351.63	348.8	349.94	95818.0
2023-11-03 09:00:00	MSFT	Stock	349.73	350.6	347.33	350.0555	2532771.0
2023-11-03 10:00:00	MSFT	Stock	350.09	351.86	349.6274	350.84	2675195.0
2023-11-03 11:00:00	MSFT	Stock	350.855	351.73	350.02	351.33	1505148.0
2023-11-03 12:00:00	MSFT	Stock	351.335	353.3999	351.14	353.29	1300682.0
2023-11-03 13:00:00	MSFT	Stock	353.28	354.06	353.09	353.88	1445492.0
2023-11-03 14:00:00	MSFT	Stock	353.85	354.39	353.23	353.72	1251176.0
2023-11-03 15:00:00	MSFT	Stock	353.73	354.35	352.61	352.8	2612434.0
2023-11-03 16:00:00	MSFT	Stock	352.8	353.0	352.6	352.75	3542647.0
2023-11-03 17:00:00	MSFT	Stock	352.8	352.85	352.51	352.6	7905.0
2023-11-03 18:00:00	MSFT	Stock	352.6	352.7	352.6	352.6	2034.0
2023-11-03 19:00:00	MSFT	Stock	352.6	352.8499	352.6	352.84	6503.0
2023-11-03 04:00:00	NVDA	Stock	43.39	43.39	43.262	43.36	22550.0
2023-11-03 05:00:00	NVDA	Stock	43.303	43.309	43.27	43.3	12280.0
2023-11-03 06:00:00	NVDA	Stock	43.3	43.38	43.285	43.38	22300.0
2023-11-03 07:00:00	NVDA	Stock	43.363	43.7	43.24	43.7	323010.0
2023-11-03 08:00:00	NVDA	Stock	43.35	44.178	43.227	44.065	4609060.0
2023-11-03 09:00:00	NVDA	Stock	44.05	44.344	43.723	44.1815	50518460.0
2023-11-03 10:00:00	NVDA	Stock	44.187	44.443	43.891	44.44	52127370.0
2023-11-03 11:00:00	NVDA	Stock	44.443	44.709	44.32	44.622	40313950.0
2023-11-03 12:00:00	NVDA	Stock	44.6255	44.859	44.552	44.7963	33711850.0
2023-11-03 13:00:00	NVDA	Stock	44.796	45.049	44.651	44.9903	38495500.0
2023-11-03 14:00:00	NVDA	Stock	44.992	45.247	44.901	45.227	34947350.0
2023-11-03 15:00:00	NVDA	Stock	45.2301	45.309	44.951	45.004	54468500.0
2023-11-03 16:00:00	NVDA	Stock	45.005	45.036	44.96	45.01	17230980.0
2023-11-03 17:00:00	NVDA	Stock	45.008	45.067	45.008	45.028	715450.0
2023-11-03 18:00:00	NVDA	Stock	45.029	45.048	45.004	45.0114	294490.0
2023-11-03 19:00:00	NVDA	Stock	45.013	45.089	45.009	45.089	270460.0
2023-11-03 04:00:00	AMZN	Stock	138.18	138.33	137.8	138.21	8508.0
2023-11-03 05:00:00	AMZN	Stock	138.1	138.15	137.92	138.09	8816.0

> showing 50 of 59,191 rows — these rows as CSV

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