PREVIEW / stock_1hour / 2003-01-02

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-02.parquet
  size:    429 KB
  rows:    19,984
  symbols: 1,522

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-02 09:00:00	AAPL	Stock	0.2564	0.2598	0.2563	0.258	31748696.0
2003-01-02 10:00:00	AAPL	Stock	0.258	0.2652	0.258	0.2645	37815400.0
2003-01-02 11:00:00	AAPL	Stock	0.2645	0.2652	0.2625	0.2652	16800112.0
2003-01-02 12:00:00	AAPL	Stock	0.265	0.2661	0.2643	0.2646	15038968.0
2003-01-02 13:00:00	AAPL	Stock	0.2646	0.265	0.2629	0.2638	9005752.0
2003-01-02 14:00:00	AAPL	Stock	0.2639	0.2664	0.2632	0.2655	20297144.0
2003-01-02 15:00:00	AAPL	Stock	0.2652	0.2661	0.2636	0.2643	27761664.0
2003-01-02 16:00:00	AAPL	Stock	0.2645	0.2648	0.2598	0.2643	8360800.0
2003-01-02 08:00:00	MSFT	Stock	26.0	26.17	25.85	26.1	170214.0
2003-01-02 09:00:00	MSFT	Stock	26.1005	26.2	25.855	26.034	9528560.0
2003-01-02 10:00:00	MSFT	Stock	26.025	26.455	26.01	26.425	14120194.0
2003-01-02 11:00:00	MSFT	Stock	26.425	26.6	26.315	26.5945	6449088.0
2003-01-02 12:00:00	MSFT	Stock	26.595	26.635	26.525	26.585	10314790.0
2003-01-02 13:00:00	MSFT	Stock	26.59	26.66	26.54	26.595	3204604.0
2003-01-02 14:00:00	MSFT	Stock	26.6	26.75	26.59	26.7205	5818482.0
2003-01-02 15:00:00	MSFT	Stock	26.725	26.875	26.715	26.865	8820992.0
2003-01-02 16:00:00	MSFT	Stock	26.865	26.88	25.85	26.86	2325146.0
2003-01-02 17:00:00	MSFT	Stock	26.8452	26.875	26.715	26.77	48212.0
2003-01-02 18:00:00	MSFT	Stock	26.785	26.84	26.78	26.825	4700.0
2003-01-02 08:00:00	NVDA	Stock	0.0975	0.0992	0.0975	0.0987	4496400.0
2003-01-02 09:00:00	NVDA	Stock	0.0987	0.1008	0.0966	0.0982	188428560.0
2003-01-02 10:00:00	NVDA	Stock	0.0982	0.1023	0.0981	0.1019	275085360.0
2003-01-02 11:00:00	NVDA	Stock	0.1019	0.1029	0.1012	0.1029	129228600.0
2003-01-02 12:00:00	NVDA	Stock	0.103	0.1037	0.1022	0.1025	135209640.0
2003-01-02 13:00:00	NVDA	Stock	0.1025	0.1025	0.1013	0.1018	135782040.0
2003-01-02 14:00:00	NVDA	Stock	0.1018	0.103	0.1015	0.102	96245160.0
2003-01-02 15:00:00	NVDA	Stock	0.1019	0.1028	0.1017	0.1026	204666360.0
2003-01-02 16:00:00	NVDA	Stock	0.1026	0.1027	0.1019	0.1025	14790600.0
2003-01-02 17:00:00	NVDA	Stock	0.1025	0.1025	0.1021	0.1021	2883000.0
2003-01-02 18:00:00	NVDA	Stock	0.1021	0.1027	0.1021	0.1027	358560.0
2003-01-02 08:00:00	AMZN	Stock	0.946	0.962	0.945	0.953	175000.0
2003-01-02 09:00:00	AMZN	Stock	0.953	0.966	0.9275	0.934	27234340.0
2003-01-02 10:00:00	AMZN	Stock	0.9345	0.9675	0.934	0.9635	29759140.0
2003-01-02 11:00:00	AMZN	Stock	0.964	0.971	0.958	0.97	10368480.0
2003-01-02 12:00:00	AMZN	Stock	0.9705	0.9815	0.9688	0.9785	11430020.0
2003-01-02 13:00:00	AMZN	Stock	0.9785	0.984	0.9715	0.973	7992260.0
2003-01-02 14:00:00	AMZN	Stock	0.9735	0.9765	0.9715	0.9755	9662780.0
2003-01-02 15:00:00	AMZN	Stock	0.976	0.98	0.974	0.9785	14348500.0
2003-01-02 16:00:00	AMZN	Stock	0.979	0.98	0.9755	0.9785	7886100.0
2003-01-02 17:00:00	AMZN	Stock	0.9785	0.9785	0.976	0.978	680000.0
2003-01-02 18:00:00	AMZN	Stock	0.976	0.976	0.976	0.976	2000.0
2003-01-02 09:00:00	CL	Stock	26.26	26.47	26.26	26.455	184600.0
2003-01-02 10:00:00	CL	Stock	26.455	26.715	26.455	26.63	622200.0
2003-01-02 11:00:00	CL	Stock	26.65	26.715	26.58	26.6	218600.0
2003-01-02 12:00:00	CL	Stock	26.605	26.68	26.585	26.68	268000.0
2003-01-02 13:00:00	CL	Stock	26.68	26.715	26.645	26.7	119800.0
2003-01-02 14:00:00	CL	Stock	26.715	26.8	26.675	26.795	292800.0
2003-01-02 15:00:00	CL	Stock	26.795	26.915	26.775	26.88	805800.0
2003-01-02 16:00:00	CL	Stock	26.9	26.9	26.88	26.9	264800.0

> showing 49 of 19,984 rows — these rows as CSV

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