PREVIEW / stock_1hour / 2024-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-02-28.parquet
  size:    1.4 MB
  rows:    60,790
  symbols: 1,134

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
2024-02-28 04:00:00	AAPL	Stock	183.3	183.3	181.9	181.9	32623.0
2024-02-28 05:00:00	AAPL	Stock	181.91	182.78	181.9	182.75	23777.0
2024-02-28 06:00:00	AAPL	Stock	182.78	182.89	182.06	182.64	25220.0
2024-02-28 07:00:00	AAPL	Stock	182.74	182.83	182.16	182.16	43420.0
2024-02-28 08:00:00	AAPL	Stock	182.75	183.47	182.1	182.45	181941.0
2024-02-28 09:00:00	AAPL	Stock	182.43	183.12	181.12	181.298	5427887.0
2024-02-28 10:00:00	AAPL	Stock	181.3	181.89	180.96	181.3001	5691809.0
2024-02-28 11:00:00	AAPL	Stock	181.31	181.765	181.15	181.24	4017540.0
2024-02-28 12:00:00	AAPL	Stock	181.24	181.4099	180.19	180.2156	6216983.0
2024-02-28 13:00:00	AAPL	Stock	180.21	180.88	180.13	180.88	3885694.0
2024-02-28 14:00:00	AAPL	Stock	180.88	180.93	180.35	180.7199	3240888.0
2024-02-28 15:00:00	AAPL	Stock	180.72	181.47	180.54	181.42	6572249.0
2024-02-28 16:00:00	AAPL	Stock	181.43	181.44	181.06	181.1518	5087255.0
2024-02-28 17:00:00	AAPL	Stock	181.15	181.42	180.91	181.18	42197.0
2024-02-28 18:00:00	AAPL	Stock	181.13	181.2	181.02	181.12	15746.0
2024-02-28 19:00:00	AAPL	Stock	181.11	181.4	181.08	181.22	28122.0
2024-02-28 04:00:00	MSFT	Stock	406.74	406.74	404.49	404.6	1580.0
2024-02-28 05:00:00	MSFT	Stock	404.72	405.86	404.72	405.86	1891.0
2024-02-28 06:00:00	MSFT	Stock	405.86	406.0	405.68	405.68	1300.0
2024-02-28 07:00:00	MSFT	Stock	405.59	406.8	405.59	406.16	6729.0
2024-02-28 08:00:00	MSFT	Stock	405.47	407.84	405.47	407.07	31115.0
2024-02-28 09:00:00	MSFT	Stock	407.1297	409.3	405.39	405.4241	1488893.0
2024-02-28 10:00:00	MSFT	Stock	405.43	407.65	405.3201	407.01	1173563.0
2024-02-28 11:00:00	MSFT	Stock	406.99	407.94	406.9801	407.32	658004.0
2024-02-28 12:00:00	MSFT	Stock	407.29	407.56	406.01	406.58	584743.0
2024-02-28 13:00:00	MSFT	Stock	406.55	407.6	406.0394	407.6	604376.0
2024-02-28 14:00:00	MSFT	Stock	407.62	407.79	406.21	407.15	629144.0
2024-02-28 15:00:00	MSFT	Stock	407.16	407.985	406.635	407.74	1687365.0
2024-02-28 16:00:00	MSFT	Stock	407.73	407.95	404.86	404.99	2105401.0
2024-02-28 17:00:00	MSFT	Stock	405.29	405.69	404.85	405.58	14634.0
2024-02-28 18:00:00	MSFT	Stock	405.65	406.5	405.5	406.0	10498.0
2024-02-28 19:00:00	MSFT	Stock	406.26	407.63	406.02	406.35	7441.0
2024-02-28 04:00:00	NVDA	Stock	78.336	78.336	77.02	77.236	516240.0
2024-02-28 05:00:00	NVDA	Stock	77.28	77.8	77.28	77.72	227220.0
2024-02-28 06:00:00	NVDA	Stock	77.72	77.97	77.624	77.77	101580.0
2024-02-28 07:00:00	NVDA	Stock	77.85	78.375	77.716	77.798	1305180.0
2024-02-28 08:00:00	NVDA	Stock	77.955	78.599	77.5082	77.8	3283510.0
2024-02-28 09:00:00	NVDA	Stock	77.8	78.16	77.222	77.511	48009440.0
2024-02-28 10:00:00	NVDA	Stock	77.5267	77.7	77.125	77.582	47266150.0
2024-02-28 11:00:00	NVDA	Stock	77.586	78.933	77.58	78.678	51480400.0
2024-02-28 12:00:00	NVDA	Stock	78.6675	78.6685	78.1302	78.378	26172590.0
2024-02-28 13:00:00	NVDA	Stock	78.372	78.543	78.101	78.3665	22820510.0
2024-02-28 14:00:00	NVDA	Stock	78.36	78.486	77.923	78.1584	21776150.0
2024-02-28 15:00:00	NVDA	Stock	78.173	78.327	77.5	77.679	30533810.0
2024-02-28 16:00:00	NVDA	Stock	77.663	77.669	76.942	77.18	21630930.0
2024-02-28 17:00:00	NVDA	Stock	77.1744	77.663	77.135	77.385	997470.0
2024-02-28 18:00:00	NVDA	Stock	77.385	77.45	77.3	77.33	377530.0
2024-02-28 19:00:00	NVDA	Stock	77.31	77.385	77.281	77.3	353170.0
2024-02-28 04:00:00	AMZN	Stock	172.5	172.84	172.13	172.19	7025.0
2024-02-28 05:00:00	AMZN	Stock	172.2	172.46	172.15	172.37	5590.0

> showing 50 of 60,790 rows — these rows as CSV

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