PREVIEW / stock_1hour / 2000-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-06-22.parquet
  size:    297 KB
  rows:    15,249
  symbols: 1,180

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
2000-06-22 08:00:00	AAPL	Stock	0.99	1.0089	0.99	1.0089	6507200.0
2000-06-22 09:00:00	AAPL	Stock	1.01	1.0179	0.9565	0.9799	68297600.0
2000-06-22 10:00:00	AAPL	Stock	0.981	1.0268	0.9766	1.0134	119644000.0
2000-06-22 11:00:00	AAPL	Stock	1.0134	1.029	0.9933	1.0045	66892000.0
2000-06-22 12:00:00	AAPL	Stock	1.0033	1.0089	0.971	0.9777	38992800.0
2000-06-22 13:00:00	AAPL	Stock	0.9766	1.01	0.9754	1.0	39351200.0
2000-06-22 14:00:00	AAPL	Stock	1.0011	1.0033	0.9688	0.9732	34344800.0
2000-06-22 15:00:00	AAPL	Stock	0.9738	0.9888	0.9565	0.9587	67037600.0
2000-06-22 16:00:00	AAPL	Stock	0.9598	0.9676	0.942	0.9643	4211200.0
2000-06-22 17:00:00	AAPL	Stock	0.9615	0.9615	0.9464	0.9464	1584800.0
2000-06-22 18:00:00	AAPL	Stock	0.9643	0.9643	0.9643	0.9643	22400.0
2000-06-22 08:00:00	MSFT	Stock	40.5	40.875	40.25	40.6875	994800.0
2000-06-22 09:00:00	MSFT	Stock	40.5938	40.75	39.8438	40.5312	17068600.0
2000-06-22 10:00:00	MSFT	Stock	40.5	41.0	40.2188	40.5625	17361600.0
2000-06-22 11:00:00	MSFT	Stock	40.5938	40.75	40.25	40.5938	9262400.0
2000-06-22 12:00:00	MSFT	Stock	40.625	40.8125	40.375	40.6875	5262800.0
2000-06-22 13:00:00	MSFT	Stock	40.6875	40.9688	40.5	40.875	6122400.0
2000-06-22 14:00:00	MSFT	Stock	40.875	40.9375	40.3125	40.3438	10216800.0
2000-06-22 15:00:00	MSFT	Stock	40.3438	40.375	39.6562	39.9062	17215200.0
2000-06-22 16:00:00	MSFT	Stock	39.9062	40.4062	39.875	40.0	1760600.0
2000-06-22 17:00:00	MSFT	Stock	39.5	40.4688	39.5	40.0	24600.0
2000-06-22 18:00:00	MSFT	Stock	39.9375	40.0	39.875	39.875	4400.0
2000-06-22 08:00:00	NVDA	Stock	0.3615	0.3625	0.3615	0.3615	336000.0
2000-06-22 09:00:00	NVDA	Stock	0.3615	0.3615	0.3417	0.3542	92112000.0
2000-06-22 10:00:00	NVDA	Stock	0.3557	0.3661	0.3488	0.3576	135120000.0
2000-06-22 11:00:00	NVDA	Stock	0.3576	0.3617	0.3521	0.3565	60288000.0
2000-06-22 12:00:00	NVDA	Stock	0.3572	0.3578	0.3536	0.3538	39264000.0
2000-06-22 13:00:00	NVDA	Stock	0.3536	0.3551	0.3503	0.3521	66768000.0
2000-06-22 14:00:00	NVDA	Stock	0.3527	0.3539	0.3422	0.3423	54528000.0
2000-06-22 15:00:00	NVDA	Stock	0.3422	0.344	0.3372	0.3405	145632000.0
2000-06-22 16:00:00	NVDA	Stock	0.3408	0.3539	0.3406	0.3427	10272000.0
2000-06-22 17:00:00	NVDA	Stock	0.3427	0.3427	0.3427	0.3427	432000.0
2000-06-22 18:00:00	NVDA	Stock	0.3419	0.3419	0.3419	0.3419	48000.0
2000-06-22 08:00:00	AMZN	Stock	2.3031	2.3031	2.2969	2.3	174000.0
2000-06-22 09:00:00	AMZN	Stock	2.3031	2.3219	2.2719	2.2906	19656000.0
2000-06-22 10:00:00	AMZN	Stock	2.2875	2.2938	2.1812	2.1969	42242000.0
2000-06-22 11:00:00	AMZN	Stock	2.1969	2.2063	2.1562	2.1656	28368000.0
2000-06-22 12:00:00	AMZN	Stock	2.1656	2.1781	2.1594	2.1688	12556000.0
2000-06-22 13:00:00	AMZN	Stock	2.1688	2.175	2.15	2.1562	15220000.0
2000-06-22 14:00:00	AMZN	Stock	2.1547	2.1625	2.1062	2.1062	41044000.0
2000-06-22 15:00:00	AMZN	Stock	2.1078	2.1375	2.0813	2.1	43802000.0
2000-06-22 16:00:00	AMZN	Stock	2.1031	2.175	2.0938	2.125	3544000.0
2000-06-22 17:00:00	AMZN	Stock	2.1125	2.15	2.1	2.1062	90000.0
2000-06-22 18:00:00	AMZN	Stock	2.1234	2.1438	2.1234	2.1375	18000.0
2000-06-22 09:00:00	CL	Stock	28.5	28.5	28.1562	28.3125	224000.0
2000-06-22 10:00:00	CL	Stock	28.2812	28.2812	27.9062	27.9375	302600.0
2000-06-22 11:00:00	CL	Stock	27.9375	28.1562	27.8125	28.0625	679600.0
2000-06-22 12:00:00	CL	Stock	28.0312	28.25	28.0	28.0938	320000.0
2000-06-22 13:00:00	CL	Stock	28.125	28.2188	28.0	28.0312	224000.0
2000-06-22 14:00:00	CL	Stock	28.0312	28.0938	27.9375	27.9688	262600.0

> showing 50 of 15,249 rows — these rows as CSV

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