PREVIEW / stock_1hour / 2003-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-16.parquet
  size:    425 KB
  rows:    20,038
  symbols: 1,528

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
2003-01-16 08:00:00	AAPL	Stock	0.2554	0.257	0.2545	0.2552	973672.0
2003-01-16 09:00:00	AAPL	Stock	0.2548	0.2636	0.2489	0.2609	114303784.0
2003-01-16 10:00:00	AAPL	Stock	0.2609	0.2627	0.2561	0.2589	112870520.0
2003-01-16 11:00:00	AAPL	Stock	0.2588	0.2613	0.258	0.2607	67256672.0
2003-01-16 12:00:00	AAPL	Stock	0.2607	0.2613	0.26	0.2604	31397688.0
2003-01-16 13:00:00	AAPL	Stock	0.2605	0.2623	0.2598	0.2621	54627048.0
2003-01-16 14:00:00	AAPL	Stock	0.2623	0.2625	0.2604	0.262	44314872.0
2003-01-16 15:00:00	AAPL	Stock	0.262	0.2629	0.2605	0.2607	69080480.0
2003-01-16 16:00:00	AAPL	Stock	0.2607	0.2613	0.2589	0.2589	9027200.0
2003-01-16 17:00:00	AAPL	Stock	0.2586	0.2611	0.2586	0.2591	2045288.0
2003-01-16 18:00:00	AAPL	Stock	0.2591	0.2591	0.2589	0.2589	145600.0
2003-01-16 08:00:00	MSFT	Stock	28.135	28.235	28.025	28.175	148866.0
2003-01-16 09:00:00	MSFT	Stock	28.175	28.315	27.995	28.275	6700284.0
2003-01-16 10:00:00	MSFT	Stock	28.27	28.325	28.025	28.11	8688038.0
2003-01-16 11:00:00	MSFT	Stock	28.11	28.165	28.035	28.0905	6103404.0
2003-01-16 12:00:00	MSFT	Stock	28.09	28.16	27.88	27.885	8852570.0
2003-01-16 13:00:00	MSFT	Stock	27.885	27.885	27.701	27.8095	6955132.0
2003-01-16 14:00:00	MSFT	Stock	27.8	27.875	27.705	27.7265	6095416.0
2003-01-16 15:00:00	MSFT	Stock	27.73	27.8	27.56	27.685	14655700.0
2003-01-16 16:00:00	MSFT	Stock	27.675	28.845	26.875	26.9	9069626.0
2003-01-16 17:00:00	MSFT	Stock	26.945	27.9359	26.565	26.775	9706036.0
2003-01-16 18:00:00	MSFT	Stock	26.775	26.875	26.72	26.8175	420168.0
2003-01-16 08:00:00	NVDA	Stock	0.0996	0.1012	0.0993	0.1004	1844760.0
2003-01-16 09:00:00	NVDA	Stock	0.1006	0.1025	0.0946	0.0959	379243440.0
2003-01-16 10:00:00	NVDA	Stock	0.0959	0.0963	0.0918	0.0927	450908640.0
2003-01-16 11:00:00	NVDA	Stock	0.0927	0.0943	0.0921	0.0939	258135480.0
2003-01-16 12:00:00	NVDA	Stock	0.0939	0.0942	0.0929	0.093	126993600.0
2003-01-16 13:00:00	NVDA	Stock	0.093	0.0931	0.0917	0.0928	246601080.0
2003-01-16 14:00:00	NVDA	Stock	0.0929	0.0937	0.0927	0.0931	183302760.0
2003-01-16 15:00:00	NVDA	Stock	0.0932	0.0933	0.092	0.0931	196528920.0
2003-01-16 16:00:00	NVDA	Stock	0.0931	0.0936	0.0922	0.0922	11126880.0
2003-01-16 17:00:00	NVDA	Stock	0.0921	0.0931	0.09	0.0907	9162960.0
2003-01-16 18:00:00	NVDA	Stock	0.0905	0.0907	0.0896	0.0896	3829320.0
2003-01-16 08:00:00	AMZN	Stock	1.075	1.0945	1.075	1.086	293000.0
2003-01-16 09:00:00	AMZN	Stock	1.086	1.1085	1.076	1.0905	26357480.0
2003-01-16 10:00:00	AMZN	Stock	1.091	1.105	1.09	1.0912	29721220.0
2003-01-16 11:00:00	AMZN	Stock	1.0915	1.1	1.088	1.088	10917480.0
2003-01-16 12:00:00	AMZN	Stock	1.088	1.0925	1.0755	1.0865	19165340.0
2003-01-16 13:00:00	AMZN	Stock	1.087	1.0886	1.0725	1.0815	16479100.0
2003-01-16 14:00:00	AMZN	Stock	1.082	1.0868	1.0775	1.084	15707080.0
2003-01-16 15:00:00	AMZN	Stock	1.083	1.0915	1.0775	1.087	20360880.0
2003-01-16 16:00:00	AMZN	Stock	1.0915	1.1165	1.0825	1.0825	4354160.0
2003-01-16 17:00:00	AMZN	Stock	1.0806	1.09	1.079	1.085	1855400.0
2003-01-16 18:00:00	AMZN	Stock	1.08	1.08	1.08	1.08	20000.0
2003-01-16 09:00:00	CL	Stock	26.225	26.415	26.195	26.395	164800.0
2003-01-16 10:00:00	CL	Stock	26.41	26.595	26.41	26.55	227600.0
2003-01-16 11:00:00	CL	Stock	26.55	26.67	26.51	26.625	283200.0
2003-01-16 12:00:00	CL	Stock	26.63	26.715	26.55	26.715	409200.0
2003-01-16 13:00:00	CL	Stock	26.705	26.825	26.675	26.825	244600.0
2003-01-16 14:00:00	CL	Stock	26.84	27.125	26.835	27.015	1011800.0

> showing 50 of 20,038 rows — these rows as CSV

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