PREVIEW / stock_1hour / 2023-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-17.parquet
  size:    1.4 MB
  rows:    63,048
  symbols: 1,938

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-17 04:00:00	AAPL	Stock	134.53	135.66	134.15	134.2	18245.0
2023-01-17 05:00:00	AAPL	Stock	134.24	134.55	134.15	134.55	12157.0
2023-01-17 06:00:00	AAPL	Stock	134.52	134.6	134.39	134.46	7015.0
2023-01-17 07:00:00	AAPL	Stock	134.57	134.9	134.48	134.67	51593.0
2023-01-17 08:00:00	AAPL	Stock	134.57	135.41	133.51	135.22	234293.0
2023-01-17 09:00:00	AAPL	Stock	135.24	135.61	134.13	135.19	8428636.0
2023-01-17 10:00:00	AAPL	Stock	135.19	137.29	135.19	135.54	12112652.0
2023-01-17 11:00:00	AAPL	Stock	135.535	136.14	134.68	135.86	7094863.0
2023-01-17 12:00:00	AAPL	Stock	135.87	136.28	135.31	136.25	4550690.0
2023-01-17 13:00:00	AAPL	Stock	136.24	136.4	135.91	136.055	3655662.0
2023-01-17 14:00:00	AAPL	Stock	136.06	136.0899	135.4	135.9075	4171110.0
2023-01-17 15:00:00	AAPL	Stock	135.895	136.08	135.6	135.93	7158512.0
2023-01-17 16:00:00	AAPL	Stock	135.91	136.05	135.9	136.02	7379245.0
2023-01-17 17:00:00	AAPL	Stock	136.0197	136.02	135.91	135.97	23488.0
2023-01-17 18:00:00	AAPL	Stock	135.93	135.94	135.49	135.6	56664.0
2023-01-17 19:00:00	AAPL	Stock	135.62	135.62	135.49	135.5	48945.0
2023-01-17 04:00:00	MSFT	Stock	239.18	239.18	238.02	238.63	8353.0
2023-01-17 05:00:00	MSFT	Stock	238.72	239.19	238.57	239.02	3663.0
2023-01-17 06:00:00	MSFT	Stock	238.8	238.95	238.71	238.79	2919.0
2023-01-17 07:00:00	MSFT	Stock	239.19	239.24	235.61	236.0	101888.0
2023-01-17 08:00:00	MSFT	Stock	238.7636	239.29	235.65	236.31	85596.0
2023-01-17 09:00:00	MSFT	Stock	236.15	239.78	236.07	239.73	3471636.0
2023-01-17 10:00:00	MSFT	Stock	239.78	240.91	238.3606	239.68	3099452.0
2023-01-17 11:00:00	MSFT	Stock	239.68	239.8632	238.18	239.34	1958742.0
2023-01-17 12:00:00	MSFT	Stock	239.36	239.73	238.92	239.5	1272152.0
2023-01-17 13:00:00	MSFT	Stock	239.5	240.79	239.24	240.67	1818545.0
2023-01-17 14:00:00	MSFT	Stock	240.68	240.76	239.55	239.8253	1975332.0
2023-01-17 15:00:00	MSFT	Stock	239.81	240.48	239.15	240.35	3123083.0
2023-01-17 16:00:00	MSFT	Stock	240.435	240.465	240.05	240.2	6339224.0
2023-01-17 17:00:00	MSFT	Stock	240.2	240.35	240.02	240.02	23213.0
2023-01-17 18:00:00	MSFT	Stock	240.01	240.35	239.1	239.27	30556.0
2023-01-17 19:00:00	MSFT	Stock	239.4	239.65	239.14	239.65	6909.0
2023-01-17 04:00:00	NVDA	Stock	16.906	16.906	16.749	16.805	115740.0
2023-01-17 05:00:00	NVDA	Stock	16.812	16.856	16.783	16.856	26100.0
2023-01-17 06:00:00	NVDA	Stock	16.831	16.849	16.812	16.84	33420.0
2023-01-17 07:00:00	NVDA	Stock	16.85	16.905	16.83	16.873	251530.0
2023-01-17 08:00:00	NVDA	Stock	16.9	16.9	16.78	16.831	738280.0
2023-01-17 09:00:00	NVDA	Stock	16.85	17.443	16.849	17.349	77535220.0
2023-01-17 10:00:00	NVDA	Stock	17.35	17.684	17.349	17.477	89651870.0
2023-01-17 11:00:00	NVDA	Stock	17.48	17.554	17.2811	17.5261	56099800.0
2023-01-17 12:00:00	NVDA	Stock	17.529	17.5919	17.463	17.5602	33812360.0
2023-01-17 13:00:00	NVDA	Stock	17.561	17.694	17.546	17.683	38169150.0
2023-01-17 14:00:00	NVDA	Stock	17.681	17.704	17.584	17.669	35128110.0
2023-01-17 15:00:00	NVDA	Stock	17.669	17.728	17.613	17.701	60863500.0
2023-01-17 16:00:00	NVDA	Stock	17.7015	17.72	17.69	17.712	28426590.0
2023-01-17 17:00:00	NVDA	Stock	17.715	17.716	17.702	17.702	305610.0
2023-01-17 18:00:00	NVDA	Stock	17.704	17.705	17.665	17.665	407870.0
2023-01-17 19:00:00	NVDA	Stock	17.67	17.695	17.642	17.68	387510.0
2023-01-17 04:00:00	AMZN	Stock	97.91	98.5	97.63	98.0	15819.0
2023-01-17 05:00:00	AMZN	Stock	97.93	98.11	97.8	98.05	10964.0

> showing 50 of 63,048 rows — these rows as CSV

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