PREVIEW / stock_1hour / 2025-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-04-07.parquet
  size:    1.5 MB
  rows:    68,026
  symbols: 451

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-04-07 04:00:00	AAPL	Stock	177.87	181.94	177.09	180.55	293559.0
2025-04-07 05:00:00	AAPL	Stock	180.55	182.0	179.5	181.1	104969.0
2025-04-07 06:00:00	AAPL	Stock	181.07	186.43	180.73	184.5	238331.0
2025-04-07 07:00:00	AAPL	Stock	184.82	184.9	180.58	182.06	474133.0
2025-04-07 08:00:00	AAPL	Stock	183.7	185.98	174.43	182.98	1274146.0
2025-04-07 09:00:00	AAPL	Stock	182.97	183.65	174.62	180.49	26792843.0
2025-04-07 10:00:00	AAPL	Stock	180.49	194.15	179.0	183.87	23855873.0
2025-04-07 11:00:00	AAPL	Stock	183.88	185.18	175.7	178.78	13528936.0
2025-04-07 12:00:00	AAPL	Stock	178.78	179.8	175.75	177.6	7614955.0
2025-04-07 13:00:00	AAPL	Stock	177.6125	182.95	177.1	182.605	8318987.0
2025-04-07 14:00:00	AAPL	Stock	182.605	183.9	179.45	179.97	9754826.0
2025-04-07 15:00:00	AAPL	Stock	179.965	182.0	178.2801	181.59	14350150.0
2025-04-07 16:00:00	AAPL	Stock	181.52	183.2	181.25	181.32	13517949.0
2025-04-07 17:00:00	AAPL	Stock	181.49	182.39	181.27	182.2	148605.0
2025-04-07 18:00:00	AAPL	Stock	182.3	183.65	182.0	183.4	97441.0
2025-04-07 19:00:00	AAPL	Stock	183.45	183.77	181.99	182.68	86725.0
2025-04-07 04:00:00	MSFT	Stock	343.0	350.0	342.17	345.5	56069.0
2025-04-07 05:00:00	MSFT	Stock	345.5	347.25	341.5	345.65	38503.0
2025-04-07 06:00:00	MSFT	Stock	346.14	356.8	345.0	352.62	78651.0
2025-04-07 07:00:00	MSFT	Stock	352.86	356.13	351.14	352.84	44885.0
2025-04-07 08:00:00	MSFT	Stock	352.75	358.0	338.0	356.0	194798.0
2025-04-07 09:00:00	MSFT	Stock	355.33	355.99	344.79	353.35	5989884.0
2025-04-07 10:00:00	MSFT	Stock	353.35	370.9999	349.71	360.46	6855643.0
2025-04-07 11:00:00	MSFT	Stock	360.405	362.09	350.0	355.92	3211479.0
2025-04-07 12:00:00	MSFT	Stock	355.87	357.56	352.11	352.52	1612483.0
2025-04-07 13:00:00	MSFT	Stock	352.52	360.79	352.515	360.35	2497054.0
2025-04-07 14:00:00	MSFT	Stock	360.3725	361.64	356.92	357.255	2262126.0
2025-04-07 15:00:00	MSFT	Stock	357.26	359.37	354.81	357.75	3844513.0
2025-04-07 16:00:00	MSFT	Stock	357.74	361.24	357.23	359.98	6671948.0
2025-04-07 17:00:00	MSFT	Stock	359.05	360.1699	359.05	360.0	10540.0
2025-04-07 18:00:00	MSFT	Stock	360.47	360.5	359.29	360.303	10695.0
2025-04-07 19:00:00	MSFT	Stock	360.5	361.99	359.6324	360.5	15750.0
2025-04-07 04:00:00	NVDA	Stock	86.27	91.1	86.0	89.8	4677561.0
2025-04-07 05:00:00	NVDA	Stock	89.8	90.25	88.56	89.74	1904430.0
2025-04-07 06:00:00	NVDA	Stock	89.78	93.58	89.36	91.41	4116002.0
2025-04-07 07:00:00	NVDA	Stock	91.44	91.66	88.71	89.48	5171450.0
2025-04-07 08:00:00	NVDA	Stock	91.0	94.075	83.66	90.29	12681416.0
2025-04-07 09:00:00	NVDA	Stock	90.29	94.3	86.62	93.9	91786383.0
2025-04-07 10:00:00	NVDA	Stock	93.9	101.75	92.02	96.94	127769559.0
2025-04-07 11:00:00	NVDA	Stock	96.91	98.29	93.64	95.74	60224733.0
2025-04-07 12:00:00	NVDA	Stock	95.75	96.785	94.56	95.16	32489996.0
2025-04-07 13:00:00	NVDA	Stock	95.16	99.5	95.02	99.4	46978361.0
2025-04-07 14:00:00	NVDA	Stock	99.42	99.69	96.84	97.18	39897139.0
2025-04-07 15:00:00	NVDA	Stock	97.18	98.37	96.27	97.71	46516375.0
2025-04-07 16:00:00	NVDA	Stock	97.71	98.6	97.4	98.37	34907618.0
2025-04-07 17:00:00	NVDA	Stock	98.3705	98.45	98.2	98.32	548713.0
2025-04-07 18:00:00	NVDA	Stock	98.33	99.3	98.25	99.21	996204.0
2025-04-07 19:00:00	NVDA	Stock	99.23	99.4898	98.8903	99.1799	861333.0
2025-04-07 04:00:00	AMZN	Stock	165.66	165.66	160.4	164.44	220475.0
2025-04-07 05:00:00	AMZN	Stock	164.67	165.29	163.04	164.42	78225.0

> showing 50 of 68,026 rows — these rows as CSV

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