PREVIEW / stock_1hour / 2022-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-03.parquet
  size:    1.4 MB
  rows:    61,068
  symbols: 2,107

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
2022-11-03 04:00:00	AAPL	Stock	144.92	144.92	143.82	144.0	39809.0
2022-11-03 05:00:00	AAPL	Stock	144.05	144.15	143.7	143.99	28383.0
2022-11-03 06:00:00	AAPL	Stock	143.99	144.2	143.27	143.53	39540.0
2022-11-03 07:00:00	AAPL	Stock	143.64	143.74	142.59	142.75	123760.0
2022-11-03 08:00:00	AAPL	Stock	143.78	143.8015	141.73	141.92	528643.0
2022-11-03 09:00:00	AAPL	Stock	141.92	142.8	139.3601	139.6749	14927295.0
2022-11-03 10:00:00	AAPL	Stock	139.69	141.328	139.65	141.055	15557170.0
2022-11-03 11:00:00	AAPL	Stock	141.045	141.134	139.26	139.49	9117290.0
2022-11-03 12:00:00	AAPL	Stock	139.4763	140.77	139.27	140.6426	7457147.0
2022-11-03 13:00:00	AAPL	Stock	140.64	140.79	139.52	139.53	5057899.0
2022-11-03 14:00:00	AAPL	Stock	139.54	140.35	139.085	140.24	7773519.0
2022-11-03 15:00:00	AAPL	Stock	140.24	140.33	138.75	138.88	13843682.0
2022-11-03 16:00:00	AAPL	Stock	138.88	139.23	138.5102	139.12	8282581.0
2022-11-03 17:00:00	AAPL	Stock	139.12	139.2	137.8	137.91	333294.0
2022-11-03 18:00:00	AAPL	Stock	137.9	137.96	137.4	137.92	307368.0
2022-11-03 19:00:00	AAPL	Stock	137.9	137.93	137.69	137.73	107810.0
2022-11-03 04:00:00	MSFT	Stock	220.89	221.17	219.89	219.89	5542.0
2022-11-03 05:00:00	MSFT	Stock	220.65	220.76	219.8	220.32	3973.0
2022-11-03 06:00:00	MSFT	Stock	220.0	220.0	218.82	219.0	16102.0
2022-11-03 07:00:00	MSFT	Stock	219.21	219.33	218.85	219.0	19044.0
2022-11-03 08:00:00	MSFT	Stock	219.25	219.8	218.8201	219.5	57269.0
2022-11-03 09:00:00	MSFT	Stock	219.41	220.49	216.475	216.58	3657072.0
2022-11-03 10:00:00	MSFT	Stock	216.59	218.8	216.09	217.885	3859212.0
2022-11-03 11:00:00	MSFT	Stock	217.885	218.5501	215.9421	216.17	3352063.0
2022-11-03 12:00:00	MSFT	Stock	216.15	218.4991	215.91	218.22	3213772.0
2022-11-03 13:00:00	MSFT	Stock	218.2	218.3	216.295	216.63	1701324.0
2022-11-03 14:00:00	MSFT	Stock	216.6	216.92	215.95	216.58	2490840.0
2022-11-03 15:00:00	MSFT	Stock	216.57	216.63	213.98	214.24	6619058.0
2022-11-03 16:00:00	MSFT	Stock	214.25	214.49	213.95	214.04	3709511.0
2022-11-03 17:00:00	MSFT	Stock	214.03	214.04	213.75	213.8353	42907.0
2022-11-03 18:00:00	MSFT	Stock	213.9	214.15	213.45	213.61	39664.0
2022-11-03 19:00:00	MSFT	Stock	213.6	213.88	213.54	213.66	17734.0
2022-11-03 04:00:00	NVDA	Stock	13.191	13.205	13.139	13.15	308540.0
2022-11-03 05:00:00	NVDA	Stock	13.17	13.205	13.135	13.135	37150.0
2022-11-03 06:00:00	NVDA	Stock	13.143	13.151	13.072	13.111	83300.0
2022-11-03 07:00:00	NVDA	Stock	13.135	13.135	12.99	13.02	257050.0
2022-11-03 08:00:00	NVDA	Stock	13.06	13.221	12.885	12.92	1509860.0
2022-11-03 09:00:00	NVDA	Stock	12.921	13.224	12.905	13.0209	55304680.0
2022-11-03 10:00:00	NVDA	Stock	13.025	13.727	12.9701	13.676	117683650.0
2022-11-03 11:00:00	NVDA	Stock	13.677	13.781	13.4126	13.5025	66654320.0
2022-11-03 12:00:00	NVDA	Stock	13.4985	13.5929	13.425	13.576	37703240.0
2022-11-03 13:00:00	NVDA	Stock	13.576	13.5902	13.424	13.425	30014430.0
2022-11-03 14:00:00	NVDA	Stock	13.426	13.549	13.41	13.5225	33230260.0
2022-11-03 15:00:00	NVDA	Stock	13.524	13.6116	13.408	13.421	55747230.0
2022-11-03 16:00:00	NVDA	Stock	13.422	13.4948	13.408	13.444	20406060.0
2022-11-03 17:00:00	NVDA	Stock	13.425	13.444	13.412	13.42	171900.0
2022-11-03 18:00:00	NVDA	Stock	13.424	13.434	13.41	13.416	110320.0
2022-11-03 19:00:00	NVDA	Stock	13.422	13.475	13.422	13.466	244900.0
2022-11-03 04:00:00	AMZN	Stock	92.94	93.34	92.56	92.9	17361.0
2022-11-03 05:00:00	AMZN	Stock	92.97	93.23	92.8	92.8	27509.0

> showing 50 of 61,068 rows — these rows as CSV

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