PREVIEW / stock_1hour / 2002-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-27.parquet
  size:    390 KB
  rows:    18,485
  symbols: 1,485

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
2002-09-27 08:00:00	AAPL	Stock	0.2623	0.2623	0.2623	0.2623	11200.0
2002-09-27 09:00:00	AAPL	Stock	0.2616	0.2625	0.258	0.2618	15000328.0
2002-09-27 10:00:00	AAPL	Stock	0.2618	0.2648	0.2589	0.2639	35896280.0
2002-09-27 11:00:00	AAPL	Stock	0.2643	0.2652	0.2607	0.2611	24963456.0
2002-09-27 12:00:00	AAPL	Stock	0.2611	0.2643	0.2609	0.2634	25278736.0
2002-09-27 13:00:00	AAPL	Stock	0.2636	0.2645	0.2625	0.2638	18035248.0
2002-09-27 14:00:00	AAPL	Stock	0.2636	0.2641	0.2605	0.2632	24916808.0
2002-09-27 15:00:00	AAPL	Stock	0.263	0.2643	0.2598	0.2629	43780408.0
2002-09-27 16:00:00	AAPL	Stock	0.262	0.263	0.2616	0.2629	7492800.0
2002-09-27 17:00:00	AAPL	Stock	0.2607	0.2629	0.2607	0.2629	599200.0
2002-09-27 08:00:00	MSFT	Stock	23.025	23.1	23.0	23.06	19600.0
2002-09-27 09:00:00	MSFT	Stock	23.05	23.24	22.95	23.105	9654636.0
2002-09-27 10:00:00	MSFT	Stock	23.11	23.48	23.08	23.4	16053138.0
2002-09-27 11:00:00	MSFT	Stock	23.395	23.55	23.305	23.38	9738642.0
2002-09-27 12:00:00	MSFT	Stock	23.38	23.48	23.165	23.21	7102358.0
2002-09-27 13:00:00	MSFT	Stock	23.21	23.28	23.0	23.07	7741908.0
2002-09-27 14:00:00	MSFT	Stock	23.075	23.16	23.0	23.035	8573892.0
2002-09-27 15:00:00	MSFT	Stock	23.05	23.05	22.595	22.63	17506934.0
2002-09-27 16:00:00	MSFT	Stock	22.63	23.0752	22.56	22.58	2023268.0
2002-09-27 17:00:00	MSFT	Stock	22.5755	22.625	22.55	22.585	118558.0
2002-09-27 18:00:00	MSFT	Stock	22.585	22.625	22.5655	22.615	11600.0
2002-09-27 08:00:00	NVDA	Stock	0.0712	0.0722	0.0712	0.0717	972000.0
2002-09-27 09:00:00	NVDA	Stock	0.0722	0.0757	0.0722	0.0748	97889640.0
2002-09-27 10:00:00	NVDA	Stock	0.075	0.0757	0.0729	0.0744	138171360.0
2002-09-27 11:00:00	NVDA	Stock	0.0744	0.0746	0.0737	0.0745	61982400.0
2002-09-27 12:00:00	NVDA	Stock	0.0745	0.0753	0.0737	0.0737	68997600.0
2002-09-27 13:00:00	NVDA	Stock	0.0738	0.0744	0.0731	0.0732	37233000.0
2002-09-27 14:00:00	NVDA	Stock	0.0732	0.0735	0.0713	0.0722	124782480.0
2002-09-27 15:00:00	NVDA	Stock	0.0725	0.0725	0.0712	0.0714	96221160.0
2002-09-27 16:00:00	NVDA	Stock	0.0713	0.0724	0.0712	0.0716	14418000.0
2002-09-27 17:00:00	NVDA	Stock	0.0717	0.0722	0.0713	0.0717	1614000.0
2002-09-27 08:00:00	AMZN	Stock	0.845	0.849	0.845	0.8485	46000.0
2002-09-27 09:00:00	AMZN	Stock	0.8475	0.8701	0.841	0.866	22760880.0
2002-09-27 10:00:00	AMZN	Stock	0.8662	0.87	0.8485	0.86	25313520.0
2002-09-27 11:00:00	AMZN	Stock	0.8615	0.867	0.853	0.86	16524000.0
2002-09-27 12:00:00	AMZN	Stock	0.859	0.8625	0.8545	0.856	13681140.0
2002-09-27 13:00:00	AMZN	Stock	0.8555	0.862	0.8535	0.861	18281560.0
2002-09-27 14:00:00	AMZN	Stock	0.861	0.864	0.855	0.86	8970560.0
2002-09-27 15:00:00	AMZN	Stock	0.86	0.8605	0.8495	0.8505	23859260.0
2002-09-27 16:00:00	AMZN	Stock	0.851	0.851	0.8475	0.8505	2882000.0
2002-09-27 17:00:00	AMZN	Stock	0.849	0.8505	0.849	0.8505	143000.0
2002-09-27 18:00:00	AMZN	Stock	0.8495	0.8495	0.8495	0.8495	40000.0
2002-09-27 09:00:00	CL	Stock	27.775	27.825	27.63	27.65	639200.0
2002-09-27 10:00:00	CL	Stock	27.63	27.65	27.35	27.355	1381400.0
2002-09-27 11:00:00	CL	Stock	27.355	27.54	27.355	27.45	745200.0
2002-09-27 12:00:00	CL	Stock	27.44	27.54	27.315	27.49	747600.0
2002-09-27 13:00:00	CL	Stock	27.49	27.6	27.475	27.525	567800.0
2002-09-27 14:00:00	CL	Stock	27.53	27.53	27.32	27.425	729000.0
2002-09-27 15:00:00	CL	Stock	27.425	27.425	27.25	27.355	931600.0
2002-09-27 16:00:00	CL	Stock	27.35	27.355	27.35	27.355	109200.0

> showing 50 of 18,485 rows — these rows as CSV

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