PREVIEW / stock_1hour / 2024-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-12-23.parquet
  size:    1.4 MB
  rows:    64,483
  symbols: 617

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-12-23 04:00:00	AAPL	Stock	255.55	255.97	255.01	255.38	27068.0
2024-12-23 05:00:00	AAPL	Stock	255.55	255.61	255.01	255.1	18053.0
2024-12-23 06:00:00	AAPL	Stock	255.09	255.09	254.6	254.78	17699.0
2024-12-23 07:00:00	AAPL	Stock	254.79	255.49	254.71	255.41	27825.0
2024-12-23 08:00:00	AAPL	Stock	254.93	256.76	253.854	254.88	147663.0
2024-12-23 09:00:00	AAPL	Stock	254.88	255.65	253.9	254.9686	4173176.0
2024-12-23 10:00:00	AAPL	Stock	254.98	255.04	253.45	253.62	3570700.0
2024-12-23 11:00:00	AAPL	Stock	253.6	255.23	253.56	254.905	2000220.0
2024-12-23 12:00:00	AAPL	Stock	254.9	255.15	254.185	254.21	2104828.0
2024-12-23 13:00:00	AAPL	Stock	254.2131	254.31	253.72	254.2238	2188341.0
2024-12-23 14:00:00	AAPL	Stock	254.22	254.46	253.8989	253.93	1789769.0
2024-12-23 15:00:00	AAPL	Stock	253.915	255.65	253.68	255.31	4525333.0
2024-12-23 16:00:00	AAPL	Stock	255.3	255.8	255.03	255.12	9636146.0
2024-12-23 17:00:00	AAPL	Stock	255.0704	255.2	255.01	255.12	14747.0
2024-12-23 18:00:00	AAPL	Stock	255.04	255.15	254.75	254.7685	9724.0
2024-12-23 19:00:00	AAPL	Stock	254.77	254.95	254.58	254.95	13249.0
2024-12-23 04:00:00	MSFT	Stock	437.64	438.29	437.64	437.84	1983.0
2024-12-23 05:00:00	MSFT	Stock	437.77	437.77	436.88	437.0	1988.0
2024-12-23 06:00:00	MSFT	Stock	436.0	436.07	435.99	436.0	1066.0
2024-12-23 07:00:00	MSFT	Stock	436.35	437.7	436.35	437.0	9213.0
2024-12-23 08:00:00	MSFT	Stock	436.64	439.92	435.509	436.14	28949.0
2024-12-23 09:00:00	MSFT	Stock	436.1	437.65	434.6599	436.09	985951.0
2024-12-23 10:00:00	MSFT	Stock	436.09	436.42	432.91	433.3	1019650.0
2024-12-23 11:00:00	MSFT	Stock	433.245	434.65	432.83	434.1299	885497.0
2024-12-23 12:00:00	MSFT	Stock	434.09	434.93	433.6	434.26	720931.0
2024-12-23 13:00:00	MSFT	Stock	434.31	436.46	434.2	435.6399	695304.0
2024-12-23 14:00:00	MSFT	Stock	435.665	436.3199	434.51	434.575	517952.0
2024-12-23 15:00:00	MSFT	Stock	434.59	436.31	433.65	435.22	1604265.0
2024-12-23 16:00:00	MSFT	Stock	435.22	435.25	433.2	433.41	5034485.0
2024-12-23 17:00:00	MSFT	Stock	433.44	433.598	433.195	433.34	14173.0
2024-12-23 18:00:00	MSFT	Stock	433.32	433.7229	433.1419	433.5	7065.0
2024-12-23 19:00:00	MSFT	Stock	433.4	433.75	433.01	433.75	7743.0
2024-12-23 04:00:00	NVDA	Stock	136.55	137.71	135.8	136.4	573346.0
2024-12-23 05:00:00	NVDA	Stock	136.32	136.4	135.53	135.68	312553.0
2024-12-23 06:00:00	NVDA	Stock	135.7	135.73	134.57	135.52	426808.0
2024-12-23 07:00:00	NVDA	Stock	135.47	136.69	135.43	136.68	829123.0
2024-12-23 08:00:00	NVDA	Stock	135.55	137.29	134.725	135.85	2332735.0
2024-12-23 09:00:00	NVDA	Stock	135.86	137.82	134.7	137.3195	24588875.0
2024-12-23 10:00:00	NVDA	Stock	137.305	137.38	135.1201	136.55	22627577.0
2024-12-23 11:00:00	NVDA	Stock	136.54	138.37	136.5007	138.37	17701403.0
2024-12-23 12:00:00	NVDA	Stock	138.37	138.49	137.755	138.46	12706413.0
2024-12-23 13:00:00	NVDA	Stock	138.4695	139.13	138.35	139.06	15552044.0
2024-12-23 14:00:00	NVDA	Stock	139.06	139.7	138.82	138.965	15416735.0
2024-12-23 15:00:00	NVDA	Stock	138.955	139.79	138.34	139.66	21046959.0
2024-12-23 16:00:00	NVDA	Stock	139.67	139.7	139.2	139.42	18095614.0
2024-12-23 17:00:00	NVDA	Stock	139.4	139.45	139.28	139.34	183225.0
2024-12-23 18:00:00	NVDA	Stock	139.33	139.37	139.06	139.15	251646.0
2024-12-23 19:00:00	NVDA	Stock	139.15	139.2	138.99	139.01	322179.0
2024-12-23 04:00:00	AMZN	Stock	226.71	226.78	225.98	226.14	20207.0
2024-12-23 05:00:00	AMZN	Stock	226.09	226.25	225.06	225.14	9876.0

> showing 50 of 64,483 rows — these rows as CSV

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