PREVIEW / stock_1hour / 2025-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-03-27.parquet
  size:    1.4 MB
  rows:    60,028
  symbols: 479

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-03-27 04:00:00	AAPL	Stock	221.0	221.3	220.5	221.2	22322.0
2025-03-27 05:00:00	AAPL	Stock	221.3	221.45	220.9	221.14	4338.0
2025-03-27 06:00:00	AAPL	Stock	221.27	221.28	220.55	220.6	2868.0
2025-03-27 07:00:00	AAPL	Stock	220.64	221.47	220.64	221.47	13240.0
2025-03-27 08:00:00	AAPL	Stock	220.66	222.35	220.64	221.66	40817.0
2025-03-27 09:00:00	AAPL	Stock	221.64	222.1	220.5601	221.555	2746351.0
2025-03-27 10:00:00	AAPL	Stock	221.58	222.56	220.81	222.485	2545003.0
2025-03-27 11:00:00	AAPL	Stock	222.485	223.5771	222.35	223.0	2416197.0
2025-03-27 12:00:00	AAPL	Stock	223.005	223.98	222.72	222.89	1956024.0
2025-03-27 13:00:00	AAPL	Stock	222.905	223.7	222.72	223.32	1721334.0
2025-03-27 14:00:00	AAPL	Stock	223.32	224.95	223.295	224.106	3335669.0
2025-03-27 15:00:00	AAPL	Stock	224.095	224.99	223.59	223.93	4854960.0
2025-03-27 16:00:00	AAPL	Stock	223.93	223.95	223.39	223.6	5851346.0
2025-03-27 17:00:00	AAPL	Stock	223.6	223.85	223.4	223.52	4848.0
2025-03-27 18:00:00	AAPL	Stock	223.47	223.6	223.41	223.5	7991.0
2025-03-27 19:00:00	AAPL	Stock	223.37	223.46	223.25	223.46	13645.0
2025-03-27 04:00:00	MSFT	Stock	390.14	391.33	389.41	391.33	3962.0
2025-03-27 05:00:00	MSFT	Stock	390.72	391.36	390.63	391.36	9281.0
2025-03-27 06:00:00	MSFT	Stock	391.03	391.03	390.24	390.27	2457.0
2025-03-27 07:00:00	MSFT	Stock	390.0	390.68	389.23	390.67	6164.0
2025-03-27 08:00:00	MSFT	Stock	390.24	391.2	389.2379	390.34	16114.0
2025-03-27 09:00:00	MSFT	Stock	389.94	390.65	387.395	389.72	1150844.0
2025-03-27 10:00:00	MSFT	Stock	389.68	391.2	389.46	390.54	1028994.0
2025-03-27 11:00:00	MSFT	Stock	390.625	391.19	389.71	390.28	591620.0
2025-03-27 12:00:00	MSFT	Stock	390.275	391.79	389.64	389.67	564444.0
2025-03-27 13:00:00	MSFT	Stock	389.7	390.51	389.41	389.7611	599423.0
2025-03-27 14:00:00	MSFT	Stock	389.78	391.795	389.67	390.98	587147.0
2025-03-27 15:00:00	MSFT	Stock	390.96	392.24	390.1811	390.53	1224336.0
2025-03-27 16:00:00	MSFT	Stock	390.58	391.09	389.8	390.18	2724860.0
2025-03-27 17:00:00	MSFT	Stock	390.2501	390.58	390.2501	390.5	1772.0
2025-03-27 18:00:00	MSFT	Stock	390.43	390.61	390.25	390.5	2070.0
2025-03-27 19:00:00	MSFT	Stock	390.31	390.31	389.06	389.88	4478.0
2025-03-27 04:00:00	NVDA	Stock	111.61	112.7	111.54	112.63	576664.0
2025-03-27 05:00:00	NVDA	Stock	112.63	113.44	112.41	112.92	423314.0
2025-03-27 06:00:00	NVDA	Stock	112.95	113.13	112.22	112.28	291997.0
2025-03-27 07:00:00	NVDA	Stock	112.29	112.49	111.65	111.97	868392.0
2025-03-27 08:00:00	NVDA	Stock	111.96	113.39	111.55	111.93	3185095.0
2025-03-27 09:00:00	NVDA	Stock	111.94	113.29	110.66	112.7852	37936404.0
2025-03-27 10:00:00	NVDA	Stock	112.79	114.45	112.0701	114.0757	32933890.0
2025-03-27 11:00:00	NVDA	Stock	114.0799	114.32	112.1	112.205	25476914.0
2025-03-27 12:00:00	NVDA	Stock	112.21	113.05	111.75	111.795	20370946.0
2025-03-27 13:00:00	NVDA	Stock	111.795	112.43	111.52	111.904	15713785.0
2025-03-27 14:00:00	NVDA	Stock	111.9	112.87	111.83	112.22	15414438.0
2025-03-27 15:00:00	NVDA	Stock	112.215	112.97	111.18	111.43	23428579.0
2025-03-27 16:00:00	NVDA	Stock	111.43	111.85	111.07	111.65	17866999.0
2025-03-27 17:00:00	NVDA	Stock	111.65	111.72	111.43	111.61	300982.0
2025-03-27 18:00:00	NVDA	Stock	111.6	111.68	111.55	111.6102	200142.0
2025-03-27 19:00:00	NVDA	Stock	111.62	111.62	111.25	111.2699	366980.0
2025-03-27 04:00:00	AMZN	Stock	200.44	200.75	199.59	200.75	12885.0
2025-03-27 05:00:00	AMZN	Stock	200.71	201.14	200.61	201.0	8929.0

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

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