PREVIEW / stock_1hour / 2023-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-26.parquet
  size:    1.4 MB
  rows:    61,501
  symbols: 1,900

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-01-26 04:00:00	AAPL	Stock	142.9	142.95	142.21	142.32	14672.0
2023-01-26 05:00:00	AAPL	Stock	142.31	142.65	142.29	142.61	3617.0
2023-01-26 06:00:00	AAPL	Stock	142.63	142.74	142.49	142.55	10398.0
2023-01-26 07:00:00	AAPL	Stock	142.59	143.42	142.44	143.31	57084.0
2023-01-26 08:00:00	AAPL	Stock	142.6	143.4	142.1	143.07	415744.0
2023-01-26 09:00:00	AAPL	Stock	143.05	144.25	142.78	143.25	7264195.0
2023-01-26 10:00:00	AAPL	Stock	143.26	143.99	142.26	142.39	7641108.0
2023-01-26 11:00:00	AAPL	Stock	142.39	142.86	141.9	142.6799	5299139.0
2023-01-26 12:00:00	AAPL	Stock	142.68	143.27	142.59	142.81	3826509.0
2023-01-26 13:00:00	AAPL	Stock	142.82	143.43	142.49	143.15	3597528.0
2023-01-26 14:00:00	AAPL	Stock	143.15	143.8325	142.93	143.5204	4739121.0
2023-01-26 15:00:00	AAPL	Stock	143.53	144.04	143.25	143.92	7767486.0
2023-01-26 16:00:00	AAPL	Stock	143.93	144.0	143.54	143.64	6395636.0
2023-01-26 17:00:00	AAPL	Stock	143.65	143.96	143.41	143.48	244924.0
2023-01-26 18:00:00	AAPL	Stock	143.48	143.6	143.41	143.45	29134.0
2023-01-26 19:00:00	AAPL	Stock	143.44	143.77	143.43	143.69	52351.0
2023-01-26 04:00:00	MSFT	Stock	240.6	242.22	240.6	241.33	11214.0
2023-01-26 05:00:00	MSFT	Stock	241.22	241.72	241.15	241.7	4753.0
2023-01-26 06:00:00	MSFT	Stock	241.9	241.9	241.57	241.62	5509.0
2023-01-26 07:00:00	MSFT	Stock	241.67	241.76	241.3	241.33	43952.0
2023-01-26 08:00:00	MSFT	Stock	241.61	242.37	240.009	241.7	135616.0
2023-01-26 09:00:00	MSFT	Stock	241.64	246.06	241.64	243.1328	4544710.0
2023-01-26 10:00:00	MSFT	Stock	243.2	245.4629	242.0	242.495	3689765.0
2023-01-26 11:00:00	MSFT	Stock	242.52	244.73	242.24	244.6193	2214169.0
2023-01-26 12:00:00	MSFT	Stock	244.62	245.715	244.28	244.3	2092975.0
2023-01-26 13:00:00	MSFT	Stock	244.29	245.29	243.34	244.73	1979974.0
2023-01-26 14:00:00	MSFT	Stock	244.72	246.45	244.45	246.17	2614720.0
2023-01-26 15:00:00	MSFT	Stock	246.18	248.31	246.03	248.03	5629735.0
2023-01-26 16:00:00	MSFT	Stock	248.0	248.05	247.63	247.74	3418794.0
2023-01-26 17:00:00	MSFT	Stock	247.75	248.0	247.3	247.35	42642.0
2023-01-26 18:00:00	MSFT	Stock	247.3	247.55	247.0	247.1	10108.0
2023-01-26 19:00:00	MSFT	Stock	247.07	247.4	247.0	247.4	23125.0
2023-01-26 04:00:00	NVDA	Stock	19.49	19.685	19.49	19.55	351280.0
2023-01-26 05:00:00	NVDA	Stock	19.591	19.65	19.591	19.64	85630.0
2023-01-26 06:00:00	NVDA	Stock	19.648	19.68	19.6	19.613	142210.0
2023-01-26 07:00:00	NVDA	Stock	19.628	19.7	19.61	19.668	478480.0
2023-01-26 08:00:00	NVDA	Stock	19.646	19.697	19.4	19.655	1718460.0
2023-01-26 09:00:00	NVDA	Stock	19.665	20.166	19.416	19.588	90909660.0
2023-01-26 10:00:00	NVDA	Stock	19.599	19.7	19.307	19.354	72949250.0
2023-01-26 11:00:00	NVDA	Stock	19.353	19.48	19.278	19.451	40912420.0
2023-01-26 12:00:00	NVDA	Stock	19.451	19.736	19.436	19.664	47627600.0
2023-01-26 13:00:00	NVDA	Stock	19.6635	19.6941	19.51	19.664	31761770.0
2023-01-26 14:00:00	NVDA	Stock	19.661	19.779	19.628	19.7582	36467660.0
2023-01-26 15:00:00	NVDA	Stock	19.762	19.819	19.614	19.7992	59244820.0
2023-01-26 16:00:00	NVDA	Stock	19.799	19.829	19.376	19.425	20909300.0
2023-01-26 17:00:00	NVDA	Stock	19.425	19.802	19.324	19.37	1104040.0
2023-01-26 18:00:00	NVDA	Stock	19.37	19.439	19.34	19.381	383560.0
2023-01-26 19:00:00	NVDA	Stock	19.388	19.424	19.324	19.324	374250.0
2023-01-26 04:00:00	AMZN	Stock	97.76	97.76	97.26	97.36	19512.0
2023-01-26 05:00:00	AMZN	Stock	97.41	97.6	97.41	97.59	9114.0

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

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