PREVIEW / stock_1hour / 2023-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-24.parquet
  size:    1.3 MB
  rows:    59,482
  symbols: 1,668

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-04-24 04:00:00	AAPL	Stock	164.84	164.84	164.06	164.2	8413.0
2023-04-24 05:00:00	AAPL	Stock	164.25	164.61	164.25	164.61	7650.0
2023-04-24 06:00:00	AAPL	Stock	164.56	164.57	164.33	164.57	6066.0
2023-04-24 07:00:00	AAPL	Stock	164.5	164.98	164.5	164.73	52868.0
2023-04-24 08:00:00	AAPL	Stock	164.7	164.99	163.86	164.67	155514.0
2023-04-24 09:00:00	AAPL	Stock	164.67	165.47	164.4	165.16	4504888.0
2023-04-24 10:00:00	AAPL	Stock	165.16	165.4279	164.03	164.04	5258306.0
2023-04-24 11:00:00	AAPL	Stock	164.035	164.41	163.89	164.125	3199104.0
2023-04-24 12:00:00	AAPL	Stock	164.14	164.62	164.04	164.5117	2550159.0
2023-04-24 13:00:00	AAPL	Stock	164.515	165.2199	164.38	165.1324	3412845.0
2023-04-24 14:00:00	AAPL	Stock	165.15	165.44	164.98	165.2942	3115116.0
2023-04-24 15:00:00	AAPL	Stock	165.3	165.6	165.09	165.36	6331437.0
2023-04-24 16:00:00	AAPL	Stock	165.35	165.45	165.0	165.14	3304173.0
2023-04-24 17:00:00	AAPL	Stock	165.16	165.16	165.05	165.08	35852.0
2023-04-24 18:00:00	AAPL	Stock	165.12	165.27	165.1101	165.13	17813.0
2023-04-24 19:00:00	AAPL	Stock	165.16	165.27	165.11	165.22	9506.0
2023-04-24 04:00:00	MSFT	Stock	284.35	285.28	284.1	284.44	5548.0
2023-04-24 05:00:00	MSFT	Stock	284.8	285.69	284.8	285.5	2067.0
2023-04-24 06:00:00	MSFT	Stock	285.24	285.24	284.6	284.9	6293.0
2023-04-24 07:00:00	MSFT	Stock	285.35	285.7	283.63	283.99	32081.0
2023-04-24 08:00:00	MSFT	Stock	285.35	285.7213	283.7	283.99	70563.0
2023-04-24 09:00:00	MSFT	Stock	283.99	284.95	281.2535	284.04	2892659.0
2023-04-24 10:00:00	MSFT	Stock	284.03	284.22	282.4	283.63	2545726.0
2023-04-24 11:00:00	MSFT	Stock	283.62	283.82	278.72	279.36	3554776.0
2023-04-24 12:00:00	MSFT	Stock	279.39	280.56	279.25	280.47	2200052.0
2023-04-24 13:00:00	MSFT	Stock	280.48	281.19	280.01	281.0099	1585401.0
2023-04-24 14:00:00	MSFT	Stock	281.01	281.91	280.96	281.48	1863851.0
2023-04-24 15:00:00	MSFT	Stock	281.48	281.98	281.25	281.85	2828264.0
2023-04-24 16:00:00	MSFT	Stock	281.87	282.3873	281.0	281.44	2195198.0
2023-04-24 17:00:00	MSFT	Stock	281.39	281.5099	280.6212	280.87	42406.0
2023-04-24 18:00:00	MSFT	Stock	280.88	281.46	280.88	281.46	10084.0
2023-04-24 19:00:00	MSFT	Stock	281.36	281.47	281.11	281.11	6676.0
2023-04-24 04:00:00	NVDA	Stock	26.985	27.022	26.921	26.94	86950.0
2023-04-24 05:00:00	NVDA	Stock	26.96	27.03	26.96	27.002	29880.0
2023-04-24 06:00:00	NVDA	Stock	26.971	27.041	26.948	27.041	31580.0
2023-04-24 07:00:00	NVDA	Stock	27.065	27.145	27.045	27.085	287530.0
2023-04-24 08:00:00	NVDA	Stock	27.0508	27.145	26.8	27.0548	518350.0
2023-04-24 09:00:00	NVDA	Stock	27.049	27.366	26.988	27.224	34548660.0
2023-04-24 10:00:00	NVDA	Stock	27.222	27.231	26.848	26.876	50194750.0
2023-04-24 11:00:00	NVDA	Stock	26.879	26.915	26.671	26.7212	37088970.0
2023-04-24 12:00:00	NVDA	Stock	26.7161	26.953	26.71	26.927	25427200.0
2023-04-24 13:00:00	NVDA	Stock	26.928	27.006	26.8875	26.9836	22041170.0
2023-04-24 14:00:00	NVDA	Stock	26.984	27.129	26.979	27.081	29383480.0
2023-04-24 15:00:00	NVDA	Stock	27.08	27.1	26.956	27.042	35602910.0
2023-04-24 16:00:00	NVDA	Stock	27.042	27.0475	27.011	27.03	15640890.0
2023-04-24 17:00:00	NVDA	Stock	27.024	27.03	26.98	27.0098	204920.0
2023-04-24 18:00:00	NVDA	Stock	27.012	27.0282	27.0	27.015	113190.0
2023-04-24 19:00:00	NVDA	Stock	27.01	27.03	26.98	27.03	220250.0
2023-04-24 04:00:00	AMZN	Stock	106.7	107.29	106.46	106.51	11440.0
2023-04-24 05:00:00	AMZN	Stock	106.68	107.15	106.68	107.0	14074.0

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

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