PREVIEW / stock_1hour / 2024-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-04-01.parquet
  size:    1.4 MB
  rows:    60,934
  symbols: 1,049

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-04-01 04:00:00	AAPL	Stock	172.02	172.02	171.42	171.7	8719.0
2024-04-01 05:00:00	AAPL	Stock	171.71	171.9	171.71	171.75	4854.0
2024-04-01 06:00:00	AAPL	Stock	171.83	171.83	171.5	171.5	4297.0
2024-04-01 07:00:00	AAPL	Stock	171.5	171.61	171.38	171.58	24701.0
2024-04-01 08:00:00	AAPL	Stock	171.57	171.99	171.36	171.5005	94160.0
2024-04-01 09:00:00	AAPL	Stock	171.49	171.49	170.05	170.135	5782186.0
2024-04-01 10:00:00	AAPL	Stock	170.135	170.4521	169.82	169.88	6236572.0
2024-04-01 11:00:00	AAPL	Stock	169.885	170.08	169.475	169.6431	4083714.0
2024-04-01 12:00:00	AAPL	Stock	169.65	170.0	169.5803	169.835	2409133.0
2024-04-01 13:00:00	AAPL	Stock	169.835	170.09	169.76	169.9968	2518828.0
2024-04-01 14:00:00	AAPL	Stock	169.995	170.08	169.86	170.01	2291380.0
2024-04-01 15:00:00	AAPL	Stock	170.015	170.24	169.85	170.01	6830673.0
2024-04-01 16:00:00	AAPL	Stock	170.0	170.05	169.8	169.86	5975642.0
2024-04-01 17:00:00	AAPL	Stock	169.87	170.03	169.75	169.84	33607.0
2024-04-01 18:00:00	AAPL	Stock	169.83	169.84	169.6	169.6874	46405.0
2024-04-01 19:00:00	AAPL	Stock	169.67	169.69	169.5	169.5	40185.0
2024-04-01 04:00:00	MSFT	Stock	423.0	425.14	423.0	423.66	14744.0
2024-04-01 05:00:00	MSFT	Stock	423.66	424.68	423.1	424.68	4834.0
2024-04-01 06:00:00	MSFT	Stock	424.68	424.83	424.43	424.43	401.0
2024-04-01 07:00:00	MSFT	Stock	424.0	424.01	422.7	423.46	8897.0
2024-04-01 08:00:00	MSFT	Stock	423.87	424.2	420.72	423.5	30107.0
2024-04-01 09:00:00	MSFT	Stock	423.65	427.89	422.47	424.285	2302118.0
2024-04-01 10:00:00	MSFT	Stock	424.25	426.07	423.71	424.06	1542860.0
2024-04-01 11:00:00	MSFT	Stock	424.01	424.835	422.64	423.17	836029.0
2024-04-01 12:00:00	MSFT	Stock	423.25	424.89	423.11	423.25	571722.0
2024-04-01 13:00:00	MSFT	Stock	423.22	423.622	422.22	422.64	605095.0
2024-04-01 14:00:00	MSFT	Stock	422.65	423.25	422.4378	423.065	583004.0
2024-04-01 15:00:00	MSFT	Stock	423.08	425.2	422.888	424.55	1725206.0
2024-04-01 16:00:00	MSFT	Stock	424.57	424.58	424.1	424.5	2316102.0
2024-04-01 17:00:00	MSFT	Stock	424.48	424.57	424.4	424.43	4359.0
2024-04-01 18:00:00	MSFT	Stock	424.4	424.5	424.25	424.4	2832.0
2024-04-01 19:00:00	MSFT	Stock	424.4	424.54	424.17	424.49	7822.0
2024-04-01 04:00:00	NVDA	Stock	91.2	91.5	91.0	91.337	156790.0
2024-04-01 05:00:00	NVDA	Stock	91.33	91.35	91.08	91.35	93870.0
2024-04-01 06:00:00	NVDA	Stock	91.202	91.269	91.151	91.178	28010.0
2024-04-01 07:00:00	NVDA	Stock	91.142	91.2	90.386	90.58	662660.0
2024-04-01 08:00:00	NVDA	Stock	91.06	91.4	90.356	90.536	1667220.0
2024-04-01 09:00:00	NVDA	Stock	90.52	92.225	90.02	91.676	60972950.0
2024-04-01 10:00:00	NVDA	Stock	91.652	91.92	90.521	90.725	62959810.0
2024-04-01 11:00:00	NVDA	Stock	90.7	90.853	89.29	89.365	61317160.0
2024-04-01 12:00:00	NVDA	Stock	89.38	90.184	89.204	89.9565	36931910.0
2024-04-01 13:00:00	NVDA	Stock	89.967	90.081	89.494	89.914	26813660.0
2024-04-01 14:00:00	NVDA	Stock	89.932	90.471	89.78	90.2445	26376670.0
2024-04-01 15:00:00	NVDA	Stock	90.241	90.4	89.662	90.372	41044080.0
2024-04-01 16:00:00	NVDA	Stock	90.324	90.363	89.5	90.179	11053070.0
2024-04-01 17:00:00	NVDA	Stock	90.174	90.363	90.146	90.168	162560.0
2024-04-01 18:00:00	NVDA	Stock	90.151	90.163	90.0255	90.085	278800.0
2024-04-01 19:00:00	NVDA	Stock	90.08	90.15	90.025	90.15	302130.0
2024-04-01 04:00:00	AMZN	Stock	180.1	181.4	180.1	181.28	9347.0
2024-04-01 05:00:00	AMZN	Stock	181.3	181.85	181.21	181.85	15206.0

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

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