PREVIEW / stock_1hour / 2005-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-03.parquet
  size:    552 KB
  rows:    26,474
  symbols: 1,963

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
2005-05-03 08:00:00	AAPL	Stock	1.2946	1.3011	1.2925	1.2957	781312.0
2005-05-03 09:00:00	AAPL	Stock	1.2957	1.3039	1.2929	1.2993	44638720.0
2005-05-03 10:00:00	AAPL	Stock	1.2993	1.3021	1.2971	1.3004	72411668.0
2005-05-03 11:00:00	AAPL	Stock	1.3004	1.3014	1.2968	1.2982	42969444.0
2005-05-03 12:00:00	AAPL	Stock	1.2982	1.2996	1.2929	1.2968	34628944.0
2005-05-03 13:00:00	AAPL	Stock	1.2968	1.2986	1.2943	1.2986	31253628.0
2005-05-03 14:00:00	AAPL	Stock	1.2986	1.3121	1.2911	1.3029	139460132.0
2005-05-03 15:00:00	AAPL	Stock	1.3043	1.3064	1.2868	1.2957	116037600.0
2005-05-03 16:00:00	AAPL	Stock	1.2943	1.2968	1.2918	1.2929	3545332.0
2005-05-03 17:00:00	AAPL	Stock	1.2946	1.295	1.2929	1.2932	291172.0
2005-05-03 18:00:00	AAPL	Stock	1.2943	1.2946	1.2929	1.2946	95200.0
2005-05-03 08:00:00	MSFT	Stock	25.16	25.17	25.16	25.16	10700.0
2005-05-03 09:00:00	MSFT	Stock	25.16	25.21	25.09	25.19	6303602.0
2005-05-03 10:00:00	MSFT	Stock	25.19	25.26	25.14	25.16	9779074.0
2005-05-03 11:00:00	MSFT	Stock	25.168	25.23	25.16	25.2	5831347.0
2005-05-03 12:00:00	MSFT	Stock	25.21	25.24	25.15	25.221	3842078.0
2005-05-03 13:00:00	MSFT	Stock	25.228	25.27	25.15	25.25	6875701.0
2005-05-03 14:00:00	MSFT	Stock	25.258	25.4	25.17	25.378	15887528.0
2005-05-03 15:00:00	MSFT	Stock	25.37	25.38	25.11	25.34	17586373.0
2005-05-03 16:00:00	MSFT	Stock	25.32	25.45	25.3	25.34	662031.0
2005-05-03 17:00:00	MSFT	Stock	25.32	25.33	25.32	25.33	325692.0
2005-05-03 18:00:00	MSFT	Stock	25.33	25.33	25.32	25.32	11335.0
2005-05-03 09:00:00	NVDA	Stock	0.183	0.1854	0.1807	0.1839	44202360.0
2005-05-03 10:00:00	NVDA	Stock	0.1839	0.1852	0.1837	0.1845	55324080.0
2005-05-03 11:00:00	NVDA	Stock	0.1845	0.1847	0.1836	0.1838	28739880.0
2005-05-03 12:00:00	NVDA	Stock	0.1837	0.1843	0.1834	0.1837	18696840.0
2005-05-03 13:00:00	NVDA	Stock	0.1837	0.1837	0.1828	0.1837	17136480.0
2005-05-03 14:00:00	NVDA	Stock	0.1837	0.1856	0.1817	0.1842	84699000.0
2005-05-03 15:00:00	NVDA	Stock	0.1843	0.1845	0.1803	0.1811	179536080.0
2005-05-03 16:00:00	NVDA	Stock	0.1811	0.1812	0.1807	0.1809	1252440.0
2005-05-03 17:00:00	NVDA	Stock	0.1812	0.1812	0.1812	0.1812	65640.0
2005-05-03 18:00:00	NVDA	Stock	0.1816	0.1816	0.1816	0.1816	120000.0
2005-05-03 08:00:00	AMZN	Stock	1.645	1.649	1.6435	1.6435	73400.0
2005-05-03 09:00:00	AMZN	Stock	1.6435	1.655	1.643	1.6515	15694180.0
2005-05-03 10:00:00	AMZN	Stock	1.651	1.666	1.6505	1.6585	22433700.0
2005-05-03 11:00:00	AMZN	Stock	1.659	1.66	1.6535	1.6575	8775280.0
2005-05-03 12:00:00	AMZN	Stock	1.6575	1.6625	1.6555	1.662	12705500.0
2005-05-03 13:00:00	AMZN	Stock	1.662	1.6631	1.655	1.663	8432240.0
2005-05-03 14:00:00	AMZN	Stock	1.6635	1.678	1.6575	1.6745	27842760.0
2005-05-03 15:00:00	AMZN	Stock	1.674	1.675	1.656	1.661	37768520.0
2005-05-03 16:00:00	AMZN	Stock	1.662	1.6685	1.661	1.668	424380.0
2005-05-03 17:00:00	AMZN	Stock	1.6605	1.674	1.6605	1.661	179400.0
2005-05-03 09:00:00	CL	Stock	25.01	25.02	24.825	24.915	470400.0
2005-05-03 10:00:00	CL	Stock	24.92	24.985	24.83	24.85	553800.0
2005-05-03 11:00:00	CL	Stock	24.85	24.895	24.84	24.85	506000.0
2005-05-03 12:00:00	CL	Stock	24.845	24.965	24.805	24.95	554800.0
2005-05-03 13:00:00	CL	Stock	24.955	25.01	24.875	25.01	791200.0
2005-05-03 14:00:00	CL	Stock	25.01	25.045	24.89	24.945	774800.0
2005-05-03 15:00:00	CL	Stock	24.945	24.955	24.805	24.925	1083800.0
2005-05-03 16:00:00	CL	Stock	24.925	24.925	24.925	24.925	11000.0

> showing 50 of 26,474 rows — these rows as CSV

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