PREVIEW / stock_1hour / 2025-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-02-25.parquet
  size:    1.4 MB
  rows:    63,531
  symbols: 519

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
2025-02-25 04:00:00	AAPL	Stock	247.76	247.77	246.55	246.55	23846.0
2025-02-25 05:00:00	AAPL	Stock	246.54	246.81	246.37	246.38	16802.0
2025-02-25 06:00:00	AAPL	Stock	246.4	247.16	246.37	247.09	20286.0
2025-02-25 07:00:00	AAPL	Stock	247.0	247.81	247.0	247.65	26492.0
2025-02-25 08:00:00	AAPL	Stock	247.11	248.1	246.29	247.2	99138.0
2025-02-25 09:00:00	AAPL	Stock	247.1415	249.52	246.61	247.825	4547067.0
2025-02-25 10:00:00	AAPL	Stock	247.825	247.9	244.91	246.06	5619267.0
2025-02-25 11:00:00	AAPL	Stock	246.09	250.0	245.65	249.542	4937616.0
2025-02-25 12:00:00	AAPL	Stock	249.565	249.69	248.08	248.17	3416672.0
2025-02-25 13:00:00	AAPL	Stock	248.18	248.84	247.73	248.14	2062459.0
2025-02-25 14:00:00	AAPL	Stock	248.13	248.59	247.16	248.43	2695564.0
2025-02-25 15:00:00	AAPL	Stock	248.42	248.54	246.045	247.05	4416327.0
2025-02-25 16:00:00	AAPL	Stock	247.05	247.3399	246.39	246.39	5723040.0
2025-02-25 17:00:00	AAPL	Stock	246.39	246.66	246.35	246.497	34146.0
2025-02-25 18:00:00	AAPL	Stock	246.5	246.67	246.35	246.35	21720.0
2025-02-25 19:00:00	AAPL	Stock	246.43	246.65	246.2537	246.5	25288.0
2025-02-25 04:00:00	MSFT	Stock	402.08	403.8	401.31	401.31	11064.0
2025-02-25 05:00:00	MSFT	Stock	401.18	402.02	401.18	401.49	3593.0
2025-02-25 06:00:00	MSFT	Stock	401.7	402.5	401.62	402.3	6175.0
2025-02-25 07:00:00	MSFT	Stock	402.3	403.14	402.08	403.14	7701.0
2025-02-25 08:00:00	MSFT	Stock	402.75	403.96	401.81	402.55	28777.0
2025-02-25 09:00:00	MSFT	Stock	402.58	402.871	399.54	401.461	2552344.0
2025-02-25 10:00:00	MSFT	Stock	401.43	401.6	397.69	399.64	2625046.0
2025-02-25 11:00:00	MSFT	Stock	399.69	399.74	396.7	399.38	1758208.0
2025-02-25 12:00:00	MSFT	Stock	399.32	400.48	398.0	399.01	1628846.0
2025-02-25 13:00:00	MSFT	Stock	399.025	399.8	398.12	398.47	1223533.0
2025-02-25 14:00:00	MSFT	Stock	398.46	398.5678	397.01	398.05	1267729.0
2025-02-25 15:00:00	MSFT	Stock	398.09	399.29	397.38	397.91	2077140.0
2025-02-25 16:00:00	MSFT	Stock	397.9	399.1665	397.51	399.1665	3732446.0
2025-02-25 17:00:00	MSFT	Stock	398.92	399.4	398.9	399.3008	12360.0
2025-02-25 18:00:00	MSFT	Stock	399.33	399.406	398.1894	398.31	11241.0
2025-02-25 19:00:00	MSFT	Stock	398.59	399.56	398.3	399.28	12243.0
2025-02-25 04:00:00	NVDA	Stock	128.4	134.0	128.2	128.79	556340.0
2025-02-25 05:00:00	NVDA	Stock	128.79	129.1	127.46	128.02	592546.0
2025-02-25 06:00:00	NVDA	Stock	128.03	129.43	128.01	129.29	479512.0
2025-02-25 07:00:00	NVDA	Stock	129.28	130.54	128.92	130.52	1031286.0
2025-02-25 08:00:00	NVDA	Stock	129.26	131.96	127.06	130.53	4497996.0
2025-02-25 09:00:00	NVDA	Stock	130.53	130.56	125.94	127.595	35648662.0
2025-02-25 10:00:00	NVDA	Stock	127.5899	127.6499	124.44	126.545	45214237.0
2025-02-25 11:00:00	NVDA	Stock	126.555	128.17	125.42	127.875	25173805.0
2025-02-25 12:00:00	NVDA	Stock	127.87	129.59	127.18	129.23	21839107.0
2025-02-25 13:00:00	NVDA	Stock	129.24	129.89	127.82	128.062	20059498.0
2025-02-25 14:00:00	NVDA	Stock	128.06	128.43	127.04	127.84	17092057.0
2025-02-25 15:00:00	NVDA	Stock	127.845	129.38	126.16	126.61	30733738.0
2025-02-25 16:00:00	NVDA	Stock	126.62	128.0	126.46	127.46	16875529.0
2025-02-25 17:00:00	NVDA	Stock	127.46	127.65	127.28	127.59	581922.0
2025-02-25 18:00:00	NVDA	Stock	127.62	128.24	127.5204	128.16	529786.0
2025-02-25 19:00:00	NVDA	Stock	128.1698	128.82	127.93	128.4998	785712.0
2025-02-25 04:00:00	AMZN	Stock	211.38	212.19	210.7	210.75	40486.0
2025-02-25 05:00:00	AMZN	Stock	210.75	211.49	210.75	211.13	27957.0

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

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