PREVIEW / stock_1hour / 2023-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-10.parquet
  size:    1.3 MB
  rows:    59,595
  symbols: 1,491

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-08-10 04:00:00	AAPL	Stock	179.39	179.39	178.92	179.25	26170.0
2023-08-10 05:00:00	AAPL	Stock	179.15	179.34	179.11	179.34	8630.0
2023-08-10 06:00:00	AAPL	Stock	179.34	179.48	179.05	179.14	13192.0
2023-08-10 07:00:00	AAPL	Stock	179.11	179.24	178.55	178.76	57148.0
2023-08-10 08:00:00	AAPL	Stock	179.14	179.95	178.5307	179.67	467041.0
2023-08-10 09:00:00	AAPL	Stock	179.7	180.58	178.86	180.55	6194991.0
2023-08-10 10:00:00	AAPL	Stock	180.5596	180.75	179.12	179.5701	7371455.0
2023-08-10 11:00:00	AAPL	Stock	179.58	179.6	178.01	178.355	6141116.0
2023-08-10 12:00:00	AAPL	Stock	178.35	178.9199	177.85	177.97	4531010.0
2023-08-10 13:00:00	AAPL	Stock	177.9637	178.3911	177.6	177.68	4149492.0
2023-08-10 14:00:00	AAPL	Stock	177.69	178.6904	177.65	178.615	4902813.0
2023-08-10 15:00:00	AAPL	Stock	178.62	178.7	177.72	178.01	6322121.0
2023-08-10 16:00:00	AAPL	Stock	177.97	178.1	177.8	178.06	3572722.0
2023-08-10 17:00:00	AAPL	Stock	178.0501	178.12	178.0	178.0801	22393.0
2023-08-10 18:00:00	AAPL	Stock	178.14	178.29	178.0925	178.24	31433.0
2023-08-10 19:00:00	AAPL	Stock	178.24	178.48	178.16	178.43	23944.0
2023-08-10 04:00:00	MSFT	Stock	322.93	324.69	322.93	324.61	10087.0
2023-08-10 05:00:00	MSFT	Stock	324.4	324.56	324.1	324.56	1446.0
2023-08-10 06:00:00	MSFT	Stock	324.3	325.05	324.3	325.05	2073.0
2023-08-10 07:00:00	MSFT	Stock	325.0	325.6	324.78	324.85	21395.0
2023-08-10 08:00:00	MSFT	Stock	325.02	326.98	322.5	326.5	112352.0
2023-08-10 09:00:00	MSFT	Stock	326.5	327.28	325.11	327.19	1904676.0
2023-08-10 10:00:00	MSFT	Stock	327.23	328.26	324.2	324.76	2269341.0
2023-08-10 11:00:00	MSFT	Stock	324.76	325.05	322.08	322.975	2074264.0
2023-08-10 12:00:00	MSFT	Stock	322.95	324.47	322.43	323.0	1171282.0
2023-08-10 13:00:00	MSFT	Stock	322.99	323.43	321.18	321.5001	1022984.0
2023-08-10 14:00:00	MSFT	Stock	321.52	324.0	321.45	323.785	1127739.0
2023-08-10 15:00:00	MSFT	Stock	323.8	323.85	322.33	322.95	1438367.0
2023-08-10 16:00:00	MSFT	Stock	322.93	323.35	322.71	323.23	1711679.0
2023-08-10 17:00:00	MSFT	Stock	323.2299	323.2299	322.51	323.09	12891.0
2023-08-10 18:00:00	MSFT	Stock	323.09	323.35	323.03	323.29	5554.0
2023-08-10 19:00:00	MSFT	Stock	323.25	323.5	323.13	323.5	8010.0
2023-08-10 04:00:00	NVDA	Stock	42.701	42.919	42.701	42.873	124450.0
2023-08-10 05:00:00	NVDA	Stock	42.85	42.89	42.826	42.88	50550.0
2023-08-10 06:00:00	NVDA	Stock	42.862	42.862	42.028	42.575	544080.0
2023-08-10 07:00:00	NVDA	Stock	42.553	42.65	42.251	42.255	1008620.0
2023-08-10 08:00:00	NVDA	Stock	42.598	42.999	42.169	42.28	5835720.0
2023-08-10 09:00:00	NVDA	Stock	42.26	43.388	41.835	43.366	69339290.0
2023-08-10 10:00:00	NVDA	Stock	43.3557	43.574	42.62	42.6312	79705480.0
2023-08-10 11:00:00	NVDA	Stock	42.645	42.741	42.127	42.25	61296020.0
2023-08-10 12:00:00	NVDA	Stock	42.251	42.585	42.128	42.28	40570120.0
2023-08-10 13:00:00	NVDA	Stock	42.28	42.41	41.966	42.082	33958900.0
2023-08-10 14:00:00	NVDA	Stock	42.082	42.624	42.074	42.6155	36995450.0
2023-08-10 15:00:00	NVDA	Stock	42.616	42.63	42.333	42.389	39775330.0
2023-08-10 16:00:00	NVDA	Stock	42.388	42.4299	42.313	42.339	9795120.0
2023-08-10 17:00:00	NVDA	Stock	42.3726	42.384	42.351	42.372	129370.0
2023-08-10 18:00:00	NVDA	Stock	42.372	42.428	42.372	42.4006	201310.0
2023-08-10 19:00:00	NVDA	Stock	42.404	42.458	42.4	42.425	215830.0
2023-08-10 04:00:00	AMZN	Stock	139.14	139.14	138.8	139.1	17818.0
2023-08-10 05:00:00	AMZN	Stock	139.0	139.11	138.85	139.03	9210.0

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

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