PREVIEW / stock_1hour / 2002-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-20.parquet
  size:    394 KB
  rows:    18,611
  symbols: 1,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
2002-09-20 08:00:00	AAPL	Stock	0.2609	0.2609	0.2579	0.2598	291200.0
2002-09-20 09:00:00	AAPL	Stock	0.2609	0.2652	0.2593	0.2652	43497720.0
2002-09-20 10:00:00	AAPL	Stock	0.265	0.2663	0.2618	0.262	41094760.0
2002-09-20 11:00:00	AAPL	Stock	0.262	0.2648	0.2618	0.2636	16198784.0
2002-09-20 12:00:00	AAPL	Stock	0.2637	0.2657	0.2625	0.265	22832600.0
2002-09-20 13:00:00	AAPL	Stock	0.2648	0.2661	0.2636	0.2654	16119712.0
2002-09-20 14:00:00	AAPL	Stock	0.2654	0.2654	0.2623	0.2638	37266656.0
2002-09-20 15:00:00	AAPL	Stock	0.2638	0.2668	0.2625	0.2646	50708280.0
2002-09-20 16:00:00	AAPL	Stock	0.2654	0.2655	0.2621	0.2655	22648472.0
2002-09-20 17:00:00	AAPL	Stock	0.2655	0.2655	0.2655	0.2655	1142400.0
2002-09-20 08:00:00	MSFT	Stock	23.83	23.85	23.675	23.8	96620.0
2002-09-20 09:00:00	MSFT	Stock	23.79	23.925	23.65	23.73	31681274.0
2002-09-20 10:00:00	MSFT	Stock	23.725	23.955	23.675	23.75	17915444.0
2002-09-20 11:00:00	MSFT	Stock	23.75	23.875	23.73	23.84	7676952.0
2002-09-20 12:00:00	MSFT	Stock	23.84	24.0	23.82	23.93	6143324.0
2002-09-20 13:00:00	MSFT	Stock	23.93	23.985	23.815	23.85	6260596.0
2002-09-20 14:00:00	MSFT	Stock	23.847	24.0	23.73	23.945	8557690.0
2002-09-20 15:00:00	MSFT	Stock	23.94	23.995	23.715	23.73	15998216.0
2002-09-20 16:00:00	MSFT	Stock	23.7395	23.8444	23.7	23.755	10103210.0
2002-09-20 17:00:00	MSFT	Stock	23.755	23.8706	23.73	23.76	358200.0
2002-09-20 18:00:00	MSFT	Stock	23.775	23.775	23.77	23.77	8800.0
2002-09-20 08:00:00	NVDA	Stock	0.0775	0.0782	0.0775	0.0776	360000.0
2002-09-20 09:00:00	NVDA	Stock	0.0775	0.0785	0.0764	0.0764	93836400.0
2002-09-20 10:00:00	NVDA	Stock	0.0765	0.0773	0.0757	0.0761	97498200.0
2002-09-20 11:00:00	NVDA	Stock	0.0762	0.077	0.076	0.0765	53287560.0
2002-09-20 12:00:00	NVDA	Stock	0.0767	0.0768	0.0759	0.0762	42399360.0
2002-09-20 13:00:00	NVDA	Stock	0.0761	0.0763	0.0755	0.0758	43930200.0
2002-09-20 14:00:00	NVDA	Stock	0.0758	0.0762	0.0751	0.0758	65933640.0
2002-09-20 15:00:00	NVDA	Stock	0.0758	0.0776	0.0754	0.0767	169163640.0
2002-09-20 16:00:00	NVDA	Stock	0.0767	0.0776	0.0766	0.0772	51408000.0
2002-09-20 17:00:00	NVDA	Stock	0.0767	0.077	0.0766	0.0766	2076000.0
2002-09-20 18:00:00	NVDA	Stock	0.0767	0.0768	0.0762	0.0768	612000.0
2002-09-20 08:00:00	AMZN	Stock	0.875	0.8756	0.875	0.8755	29800.0
2002-09-20 09:00:00	AMZN	Stock	0.87	0.875	0.8585	0.864	11479360.0
2002-09-20 10:00:00	AMZN	Stock	0.8642	0.882	0.863	0.8645	19876820.0
2002-09-20 11:00:00	AMZN	Stock	0.8645	0.8655	0.84	0.841	30355140.0
2002-09-20 12:00:00	AMZN	Stock	0.8415	0.852	0.84	0.843	14899940.0
2002-09-20 13:00:00	AMZN	Stock	0.843	0.843	0.8175	0.8205	40546340.0
2002-09-20 14:00:00	AMZN	Stock	0.821	0.8215	0.7835	0.784	57955160.0
2002-09-20 15:00:00	AMZN	Stock	0.7835	0.804	0.7725	0.794	52854640.0
2002-09-20 16:00:00	AMZN	Stock	0.7925	0.8357	0.7905	0.7925	7913240.0
2002-09-20 17:00:00	AMZN	Stock	0.793	0.794	0.793	0.794	475000.0
2002-09-20 18:00:00	AMZN	Stock	0.794	0.794	0.794	0.794	26000.0
2002-09-20 09:00:00	CL	Stock	26.655	26.655	26.435	26.57	1730000.0
2002-09-20 10:00:00	CL	Stock	26.57	26.775	26.5	26.505	571800.0
2002-09-20 11:00:00	CL	Stock	26.5	26.675	26.385	26.56	489400.0
2002-09-20 12:00:00	CL	Stock	26.535	26.65	26.51	26.535	265800.0
2002-09-20 13:00:00	CL	Stock	26.535	26.63	26.475	26.56	327400.0
2002-09-20 14:00:00	CL	Stock	26.56	26.65	26.535	26.575	283200.0
2002-09-20 15:00:00	CL	Stock	26.575	26.75	26.525	26.645	490800.0

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

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