PREVIEW / stock_1hour / 2023-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-17.parquet
  size:    1.4 MB
  rows:    60,737
  symbols: 1,541

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-07-17 04:00:00	AAPL	Stock	190.67	191.0	190.65	190.9	16835.0
2023-07-17 05:00:00	AAPL	Stock	190.83	191.0	190.71	190.78	13232.0
2023-07-17 06:00:00	AAPL	Stock	190.96	191.0	190.76	190.86	10752.0
2023-07-17 07:00:00	AAPL	Stock	190.86	191.25	190.86	191.2	79373.0
2023-07-17 08:00:00	AAPL	Stock	190.8996	191.61	190.22	191.44	223464.0
2023-07-17 09:00:00	AAPL	Stock	191.45	193.45	191.35	192.52	8092619.0
2023-07-17 10:00:00	AAPL	Stock	192.53	193.13	192.53	192.95	5207766.0
2023-07-17 11:00:00	AAPL	Stock	192.96	193.29	192.74	193.2313	3855514.0
2023-07-17 12:00:00	AAPL	Stock	193.24	193.25	192.4	192.9	2828592.0
2023-07-17 13:00:00	AAPL	Stock	192.9	193.49	192.8	193.31	2645863.0
2023-07-17 14:00:00	AAPL	Stock	193.3	193.8	193.17	193.6788	3162395.0
2023-07-17 15:00:00	AAPL	Stock	193.68	194.32	193.67	193.98	8829225.0
2023-07-17 16:00:00	AAPL	Stock	193.98	194.0	193.04	193.88	6286736.0
2023-07-17 17:00:00	AAPL	Stock	193.92	194.0897	193.92	193.9805	28113.0
2023-07-17 18:00:00	AAPL	Stock	193.98	193.99	193.85	193.89	15069.0
2023-07-17 19:00:00	AAPL	Stock	193.85	194.08	193.85	193.97	55736.0
2023-07-17 04:00:00	MSFT	Stock	348.51	348.51	346.8	347.13	14508.0
2023-07-17 05:00:00	MSFT	Stock	347.21	347.24	345.8	345.98	4345.0
2023-07-17 06:00:00	MSFT	Stock	346.03	346.48	345.54	345.54	3255.0
2023-07-17 07:00:00	MSFT	Stock	346.07	346.59	345.51	345.51	12838.0
2023-07-17 08:00:00	MSFT	Stock	346.0	348.33	344.79	345.2399	28719.0
2023-07-17 09:00:00	MSFT	Stock	345.2	346.99	342.2	343.35	2267367.0
2023-07-17 10:00:00	MSFT	Stock	343.41	345.12	343.01	344.92	1783477.0
2023-07-17 11:00:00	MSFT	Stock	344.96	345.99	344.63	345.9	1350632.0
2023-07-17 12:00:00	MSFT	Stock	345.94	346.49	345.16	345.91	869909.0
2023-07-17 13:00:00	MSFT	Stock	345.92	346.37	345.6	346.3	776442.0
2023-07-17 14:00:00	MSFT	Stock	346.3	346.67	345.16	345.2264	1020707.0
2023-07-17 15:00:00	MSFT	Stock	345.23	346.34	344.95	345.73	2749776.0
2023-07-17 16:00:00	MSFT	Stock	345.735	345.735	344.7115	344.7115	3443508.0
2023-07-17 17:00:00	MSFT	Stock	344.77	345.73	344.77	345.47	11354.0
2023-07-17 18:00:00	MSFT	Stock	345.35	345.35	344.66	344.8	6589.0
2023-07-17 19:00:00	MSFT	Stock	344.76	345.15	344.75	344.94	9427.0
2023-07-17 04:00:00	NVDA	Stock	45.83	45.938	45.66	45.661	169840.0
2023-07-17 05:00:00	NVDA	Stock	45.679	45.75	45.62	45.636	79060.0
2023-07-17 06:00:00	NVDA	Stock	45.646	45.818	45.628	45.76	337730.0
2023-07-17 07:00:00	NVDA	Stock	45.751	45.801	45.58	45.641	766690.0
2023-07-17 08:00:00	NVDA	Stock	45.78	46.049	45.231	45.898	2155560.0
2023-07-17 09:00:00	NVDA	Stock	45.898	46.496	45.2624	45.516	81851630.0
2023-07-17 10:00:00	NVDA	Stock	45.515	46.132	45.471	45.6605	65506800.0
2023-07-17 11:00:00	NVDA	Stock	45.666	45.862	45.3913	45.599	44899290.0
2023-07-17 12:00:00	NVDA	Stock	45.597	45.618	45.3085	45.548	40091400.0
2023-07-17 13:00:00	NVDA	Stock	45.552	46.085	45.484	46.0035	39966060.0
2023-07-17 14:00:00	NVDA	Stock	46.004	46.2168	45.785	46.1511	39649190.0
2023-07-17 15:00:00	NVDA	Stock	46.157	46.487	46.136	46.466	65412530.0
2023-07-17 16:00:00	NVDA	Stock	46.467	46.64	46.42	46.64	16215090.0
2023-07-17 17:00:00	NVDA	Stock	46.63	46.7197	46.5	46.704	1164890.0
2023-07-17 18:00:00	NVDA	Stock	46.7	46.71	46.585	46.64	673610.0
2023-07-17 19:00:00	NVDA	Stock	46.637	46.65	46.53	46.597	547660.0
2023-07-17 04:00:00	AMZN	Stock	134.62	134.9	134.39	134.7	17982.0
2023-07-17 05:00:00	AMZN	Stock	134.68	134.68	134.45	134.45	7359.0

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

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