PREVIEW / stock_1hour / 2002-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-31.parquet
  size:    410 KB
  rows:    19,615
  symbols: 1,505

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-31 08:00:00	AAPL	Stock	0.2854	0.2857	0.2854	0.2857	1612800.0
2002-10-31 09:00:00	AAPL	Stock	0.2821	0.2923	0.2821	0.2873	20985720.0
2002-10-31 10:00:00	AAPL	Stock	0.2873	0.2936	0.2866	0.2877	33530224.0
2002-10-31 11:00:00	AAPL	Stock	0.2877	0.2894	0.2854	0.2893	19322072.0
2002-10-31 12:00:00	AAPL	Stock	0.2893	0.2898	0.2875	0.2889	11344144.0
2002-10-31 13:00:00	AAPL	Stock	0.2889	0.2913	0.2888	0.2911	13602680.0
2002-10-31 14:00:00	AAPL	Stock	0.2911	0.2923	0.287	0.2907	16688840.0
2002-10-31 15:00:00	AAPL	Stock	0.2907	0.2909	0.2857	0.287	30789192.0
2002-10-31 16:00:00	AAPL	Stock	0.2868	0.2871	0.2857	0.287	8366400.0
2002-10-31 17:00:00	AAPL	Stock	0.2902	0.2902	0.2902	0.2902	308000.0
2002-10-31 08:00:00	MSFT	Stock	26.555	26.625	26.355	26.59	256542.0
2002-10-31 09:00:00	MSFT	Stock	26.59	26.885	26.5	26.555	12447068.0
2002-10-31 10:00:00	MSFT	Stock	26.55	26.99	26.512	26.575	19578964.0
2002-10-31 11:00:00	MSFT	Stock	26.575	26.785	26.425	26.775	11256678.0
2002-10-31 12:00:00	MSFT	Stock	26.78	26.82	26.65	26.7	6800140.0
2002-10-31 13:00:00	MSFT	Stock	26.7005	26.9	26.665	26.9	6822566.0
2002-10-31 14:00:00	MSFT	Stock	26.895	27.03	26.785	26.91	14972754.0
2002-10-31 15:00:00	MSFT	Stock	26.913	26.975	26.575	26.7305	18373488.0
2002-10-31 16:00:00	MSFT	Stock	26.74	26.84	26.425	26.425	4583996.0
2002-10-31 17:00:00	MSFT	Stock	26.425	26.735	26.235	26.4	746600.0
2002-10-31 18:00:00	MSFT	Stock	26.375	26.45	26.36	26.45	16950.0
2002-10-31 08:00:00	NVDA	Stock	0.0936	0.0958	0.0936	0.0957	1866720.0
2002-10-31 09:00:00	NVDA	Stock	0.0952	0.0982	0.0937	0.0967	221331720.0
2002-10-31 10:00:00	NVDA	Stock	0.0967	0.0992	0.0962	0.097	282400200.0
2002-10-31 11:00:00	NVDA	Stock	0.0971	0.0981	0.0954	0.0978	110875200.0
2002-10-31 12:00:00	NVDA	Stock	0.0978	0.0981	0.0967	0.0974	43640520.0
2002-10-31 13:00:00	NVDA	Stock	0.0974	0.0995	0.0972	0.0994	96961200.0
2002-10-31 14:00:00	NVDA	Stock	0.0994	0.0998	0.0983	0.0988	121767000.0
2002-10-31 15:00:00	NVDA	Stock	0.0988	0.0996	0.0975	0.0992	239031240.0
2002-10-31 16:00:00	NVDA	Stock	0.0992	0.1001	0.0983	0.0993	35216400.0
2002-10-31 17:00:00	NVDA	Stock	0.0992	0.0992	0.0988	0.0988	498000.0
2002-10-31 18:00:00	NVDA	Stock	0.0988	0.0988	0.0985	0.0985	132000.0
2002-10-31 08:00:00	AMZN	Stock	0.9535	0.9535	0.953	0.953	28000.0
2002-10-31 09:00:00	AMZN	Stock	0.955	0.9605	0.9515	0.955	9014120.0
2002-10-31 10:00:00	AMZN	Stock	0.955	0.9645	0.952	0.953	18487220.0
2002-10-31 11:00:00	AMZN	Stock	0.9525	0.9575	0.9425	0.9505	15281960.0
2002-10-31 12:00:00	AMZN	Stock	0.951	0.9675	0.9462	0.964	21300980.0
2002-10-31 13:00:00	AMZN	Stock	0.9645	0.973	0.96	0.9695	13294440.0
2002-10-31 14:00:00	AMZN	Stock	0.9695	0.974	0.965	0.97	13762700.0
2002-10-31 15:00:00	AMZN	Stock	0.97	0.9715	0.9625	0.968	22398340.0
2002-10-31 16:00:00	AMZN	Stock	0.965	0.9695	0.9625	0.968	6248000.0
2002-10-31 17:00:00	AMZN	Stock	0.968	0.9695	0.9627	0.9695	2630000.0
2002-10-31 18:00:00	AMZN	Stock	0.97	0.97	0.97	0.97	24680.0
2002-10-31 09:00:00	CL	Stock	27.98	28.0	27.885	27.885	228200.0
2002-10-31 10:00:00	CL	Stock	27.88	27.965	27.69	27.7	509600.0
2002-10-31 11:00:00	CL	Stock	27.69	27.845	27.625	27.845	362000.0
2002-10-31 12:00:00	CL	Stock	27.845	27.855	27.545	27.625	303000.0
2002-10-31 13:00:00	CL	Stock	27.625	27.665	27.515	27.635	195200.0
2002-10-31 14:00:00	CL	Stock	27.635	27.69	27.52	27.565	434800.0
2002-10-31 15:00:00	CL	Stock	27.565	27.565	27.35	27.49	639600.0

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

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