PREVIEW / stock_1hour / 2002-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-08.parquet
  size:    398 KB
  rows:    18,864
  symbols: 1,470

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-11-08 08:00:00	AAPL	Stock	0.2886	0.2886	0.2886	0.2886	50400.0
2002-11-08 09:00:00	AAPL	Stock	0.2861	0.2893	0.285	0.2893	22457456.0
2002-11-08 10:00:00	AAPL	Stock	0.2893	0.2893	0.2843	0.2852	31521000.0
2002-11-08 11:00:00	AAPL	Stock	0.2852	0.2855	0.2786	0.28	23808456.0
2002-11-08 12:00:00	AAPL	Stock	0.28	0.2804	0.2777	0.2796	15397984.0
2002-11-08 13:00:00	AAPL	Stock	0.2796	0.2804	0.2771	0.2788	18302760.0
2002-11-08 14:00:00	AAPL	Stock	0.2788	0.2848	0.2788	0.2829	15769600.0
2002-11-08 15:00:00	AAPL	Stock	0.2829	0.285	0.2816	0.283	26392296.0
2002-11-08 16:00:00	AAPL	Stock	0.2827	0.2834	0.2795	0.2804	3113600.0
2002-11-08 17:00:00	AAPL	Stock	0.2838	0.2838	0.2838	0.2838	5600.0
2002-11-08 08:00:00	MSFT	Stock	28.0075	28.05	27.95	28.0	115400.0
2002-11-08 09:00:00	MSFT	Stock	27.975	28.221	27.925	28.205	8068028.0
2002-11-08 10:00:00	MSFT	Stock	28.203	28.275	28.06	28.1	11639554.0
2002-11-08 11:00:00	MSFT	Stock	28.098	28.1	27.655	27.72	11825982.0
2002-11-08 12:00:00	MSFT	Stock	27.73	27.85	27.6	27.6795	6832578.0
2002-11-08 13:00:00	MSFT	Stock	27.675	27.775	27.65	27.665	5652434.0
2002-11-08 14:00:00	MSFT	Stock	27.66	27.775	27.6	27.635	4263608.0
2002-11-08 15:00:00	MSFT	Stock	27.635	27.825	27.53	27.55	9773312.0
2002-11-08 16:00:00	MSFT	Stock	27.545	27.71	27.5	27.585	1317968.0
2002-11-08 17:00:00	MSFT	Stock	27.565	27.585	27.55	27.555	13220.0
2002-11-08 18:00:00	MSFT	Stock	27.555	27.555	27.515	27.515	6790.0
2002-11-08 08:00:00	NVDA	Stock	0.1133	0.1209	0.1043	0.1059	49711200.0
2002-11-08 09:00:00	NVDA	Stock	0.1061	0.1209	0.1018	0.1068	770912640.0
2002-11-08 10:00:00	NVDA	Stock	0.1068	0.1086	0.1031	0.1037	700784400.0
2002-11-08 11:00:00	NVDA	Stock	0.1038	0.1038	0.0977	0.0983	491315280.0
2002-11-08 12:00:00	NVDA	Stock	0.0982	0.0987	0.0977	0.0982	242137800.0
2002-11-08 13:00:00	NVDA	Stock	0.0983	0.1	0.098	0.0987	172917600.0
2002-11-08 14:00:00	NVDA	Stock	0.0987	0.0987	0.0917	0.0922	357961200.0
2002-11-08 15:00:00	NVDA	Stock	0.0927	0.0967	0.092	0.0946	614147400.0
2002-11-08 16:00:00	NVDA	Stock	0.0947	0.0958	0.0934	0.0942	63266280.0
2002-11-08 17:00:00	NVDA	Stock	0.0942	0.0949	0.093	0.0937	1901280.0
2002-11-08 18:00:00	NVDA	Stock	0.0938	0.0941	0.0936	0.0941	1272720.0
2002-11-08 08:00:00	AMZN	Stock	0.9595	0.9595	0.9475	0.9475	42000.0
2002-11-08 09:00:00	AMZN	Stock	0.955	0.957	0.9405	0.953	14061760.0
2002-11-08 10:00:00	AMZN	Stock	0.9535	0.9635	0.946	0.95	15830620.0
2002-11-08 11:00:00	AMZN	Stock	0.95	0.952	0.9425	0.9475	13320520.0
2002-11-08 12:00:00	AMZN	Stock	0.9475	0.9595	0.9465	0.9585	12256960.0
2002-11-08 13:00:00	AMZN	Stock	0.958	0.967	0.952	0.953	13139080.0
2002-11-08 14:00:00	AMZN	Stock	0.9525	0.9685	0.9525	0.965	16312000.0
2002-11-08 15:00:00	AMZN	Stock	0.965	0.9832	0.9645	0.975	41190740.0
2002-11-08 16:00:00	AMZN	Stock	0.975	0.9786	0.9705	0.9755	2826000.0
2002-11-08 17:00:00	AMZN	Stock	0.9755	0.9755	0.9725	0.9725	12000.0
2002-11-08 18:00:00	AMZN	Stock	0.973	0.9745	0.9725	0.9745	38000.0
2002-11-08 09:00:00	CL	Stock	27.0	27.315	27.0	27.315	250600.0
2002-11-08 10:00:00	CL	Stock	27.325	27.475	27.28	27.3	418800.0
2002-11-08 11:00:00	CL	Stock	27.3	27.3	27.045	27.135	300800.0
2002-11-08 12:00:00	CL	Stock	27.14	27.25	27.085	27.105	206400.0
2002-11-08 13:00:00	CL	Stock	27.13	27.205	27.0	27.005	226000.0
2002-11-08 14:00:00	CL	Stock	27.005	27.08	26.815	26.825	278800.0
2002-11-08 15:00:00	CL	Stock	26.835	27.1	26.8	27.015	731400.0

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

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