PREVIEW / stock_1hour / 2002-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-24.parquet
  size:    409 KB
  rows:    19,598
  symbols: 1,498

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-10-24 08:00:00	AAPL	Stock	0.2655	0.2655	0.2655	0.2655	5600.0
2002-10-24 09:00:00	AAPL	Stock	0.2677	0.2714	0.2664	0.2709	28528024.0
2002-10-24 10:00:00	AAPL	Stock	0.2714	0.2716	0.2682	0.2699	41796888.0
2002-10-24 11:00:00	AAPL	Stock	0.2698	0.2711	0.2671	0.2696	22261456.0
2002-10-24 12:00:00	AAPL	Stock	0.2698	0.2707	0.2677	0.2702	10018344.0
2002-10-24 13:00:00	AAPL	Stock	0.2702	0.2705	0.2661	0.268	15237488.0
2002-10-24 14:00:00	AAPL	Stock	0.2681	0.2689	0.2643	0.2655	18811184.0
2002-10-24 15:00:00	AAPL	Stock	0.2655	0.2663	0.2598	0.2636	29588216.0
2002-10-24 16:00:00	AAPL	Stock	0.2638	0.2639	0.262	0.2623	3595200.0
2002-10-24 08:00:00	MSFT	Stock	26.625	26.8	26.46	26.756	326074.0
2002-10-24 09:00:00	MSFT	Stock	26.77	27.25	26.305	26.5	13612764.0
2002-10-24 10:00:00	MSFT	Stock	26.5	26.55	26.12	26.225	18929048.0
2002-10-24 11:00:00	MSFT	Stock	26.21	26.435	26.065	26.26	14370960.0
2002-10-24 12:00:00	MSFT	Stock	26.255	26.295	26.055	26.145	7732966.0
2002-10-24 13:00:00	MSFT	Stock	26.145	26.207	25.81	25.9295	9348240.0
2002-10-24 14:00:00	MSFT	Stock	25.93	26.05	25.67	25.71	12493302.0
2002-10-24 15:00:00	MSFT	Stock	25.705	25.8	25.525	25.615	15475964.0
2002-10-24 16:00:00	MSFT	Stock	25.61	25.7	25.57	25.645	1290836.0
2002-10-24 17:00:00	MSFT	Stock	25.625	25.635	25.58	25.625	48100.0
2002-10-24 18:00:00	MSFT	Stock	25.61	25.61	25.555	25.585	3400.0
2002-10-24 08:00:00	NVDA	Stock	0.092	0.0924	0.0916	0.0917	1176000.0
2002-10-24 09:00:00	NVDA	Stock	0.0924	0.0938	0.0908	0.0932	151157880.0
2002-10-24 10:00:00	NVDA	Stock	0.0932	0.0938	0.0903	0.0929	135587880.0
2002-10-24 11:00:00	NVDA	Stock	0.0928	0.0937	0.0917	0.0927	103432080.0
2002-10-24 12:00:00	NVDA	Stock	0.0927	0.0947	0.0926	0.0933	145893000.0
2002-10-24 13:00:00	NVDA	Stock	0.0933	0.0937	0.0908	0.0914	95326920.0
2002-10-24 14:00:00	NVDA	Stock	0.0912	0.0916	0.0878	0.0882	172058040.0
2002-10-24 15:00:00	NVDA	Stock	0.0882	0.0885	0.0859	0.0872	222037200.0
2002-10-24 16:00:00	NVDA	Stock	0.0872	0.0883	0.0867	0.087	19591800.0
2002-10-24 17:00:00	NVDA	Stock	0.0872	0.0874	0.0863	0.0863	225000.0
2002-10-24 18:00:00	NVDA	Stock	0.0867	0.0867	0.0862	0.0862	345000.0
2002-10-24 08:00:00	AMZN	Stock	0.9985	0.9985	0.995	0.997	19000.0
2002-10-24 09:00:00	AMZN	Stock	0.9965	1.013	0.9905	0.998	34055300.0
2002-10-24 10:00:00	AMZN	Stock	0.998	1.005	0.991	1.0045	20698460.0
2002-10-24 11:00:00	AMZN	Stock	1.004	1.0055	0.998	1.002	20784980.0
2002-10-24 12:00:00	AMZN	Stock	1.002	1.0075	0.9995	1.0025	16906340.0
2002-10-24 13:00:00	AMZN	Stock	1.003	1.009	1.0	1.004	18061220.0
2002-10-24 14:00:00	AMZN	Stock	1.0045	1.005	0.9905	0.995	28046820.0
2002-10-24 15:00:00	AMZN	Stock	0.9954	1.0045	0.99	0.9935	49336540.0
2002-10-24 16:00:00	AMZN	Stock	0.9935	1.055	0.95	0.97	57926940.0
2002-10-24 17:00:00	AMZN	Stock	0.9724	0.993	0.9431	0.947	9956660.0
2002-10-24 18:00:00	AMZN	Stock	0.947	0.9485	0.938	0.9425	763660.0
2002-10-24 09:00:00	CL	Stock	28.625	28.625	28.47	28.6	363000.0
2002-10-24 10:00:00	CL	Stock	28.6	28.6	28.235	28.36	446400.0
2002-10-24 11:00:00	CL	Stock	28.35	28.36	28.14	28.275	396600.0
2002-10-24 12:00:00	CL	Stock	28.255	28.265	28.05	28.05	211400.0
2002-10-24 13:00:00	CL	Stock	28.035	28.1	27.825	27.895	259000.0
2002-10-24 14:00:00	CL	Stock	27.895	27.895	27.625	27.675	481000.0
2002-10-24 15:00:00	CL	Stock	27.655	27.78	27.635	27.675	484000.0
2002-10-24 16:00:00	CL	Stock	27.675	27.72	27.67	27.72	119000.0

> showing 50 of 19,598 rows — these rows as CSV

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