PREVIEW / stock_1hour / 2002-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-15.parquet
  size:    435 KB
  rows:    20,273
  symbols: 1,496

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-15 08:00:00	AAPL	Stock	0.2677	0.2714	0.2638	0.2705	985600.0
2002-10-15 09:00:00	AAPL	Stock	0.2705	0.2723	0.2655	0.2666	50807344.0
2002-10-15 10:00:00	AAPL	Stock	0.2668	0.2671	0.2639	0.2666	54618032.0
2002-10-15 11:00:00	AAPL	Stock	0.2666	0.2671	0.2652	0.2655	32910976.0
2002-10-15 12:00:00	AAPL	Stock	0.2655	0.2679	0.265	0.267	59644032.0
2002-10-15 13:00:00	AAPL	Stock	0.267	0.267	0.2648	0.2652	19563376.0
2002-10-15 14:00:00	AAPL	Stock	0.2654	0.2675	0.2648	0.2671	42729512.0
2002-10-15 15:00:00	AAPL	Stock	0.267	0.2702	0.2664	0.2702	93771328.0
2002-10-15 16:00:00	AAPL	Stock	0.2702	0.2714	0.2589	0.2707	16998688.0
2002-10-15 17:00:00	AAPL	Stock	0.2707	0.2707	0.2707	0.2707	6020000.0
2002-10-15 18:00:00	AAPL	Stock	0.2589	0.2589	0.2589	0.2589	5600.0
2002-10-15 08:00:00	MSFT	Stock	25.25	25.75	24.74	25.655	731486.0
2002-10-15 09:00:00	MSFT	Stock	25.675	25.725	25.325	25.5	24401394.0
2002-10-15 10:00:00	MSFT	Stock	25.515	25.735	25.475	25.63	20420382.0
2002-10-15 11:00:00	MSFT	Stock	25.625	25.9	25.58	25.635	18072776.0
2002-10-15 12:00:00	MSFT	Stock	25.625	25.85	25.625	25.8	8171052.0
2002-10-15 13:00:00	MSFT	Stock	25.8	25.9	25.725	25.805	9690234.0
2002-10-15 14:00:00	MSFT	Stock	25.81	25.935	25.68	25.705	13318432.0
2002-10-15 15:00:00	MSFT	Stock	25.71	26.175	25.64	26.1505	25862186.0
2002-10-15 16:00:00	MSFT	Stock	26.15	26.22	24.76	25.2	7406424.0
2002-10-15 17:00:00	MSFT	Stock	25.2	26.15	25.15	25.28	1281840.0
2002-10-15 18:00:00	MSFT	Stock	25.265	25.3606	25.225	25.27	65000.0
2002-10-15 08:00:00	NVDA	Stock	0.0733	0.0782	0.0711	0.0782	6403200.0
2002-10-15 09:00:00	NVDA	Stock	0.0782	0.082	0.0775	0.0789	249289320.0
2002-10-15 10:00:00	NVDA	Stock	0.079	0.08	0.0782	0.0796	127615200.0
2002-10-15 11:00:00	NVDA	Stock	0.0796	0.0799	0.0776	0.0777	71032320.0
2002-10-15 12:00:00	NVDA	Stock	0.0777	0.079	0.0777	0.0786	86950920.0
2002-10-15 13:00:00	NVDA	Stock	0.0787	0.0792	0.0777	0.0791	59872920.0
2002-10-15 14:00:00	NVDA	Stock	0.0791	0.0796	0.0781	0.0789	67399200.0
2002-10-15 15:00:00	NVDA	Stock	0.0789	0.0792	0.0782	0.0783	128312880.0
2002-10-15 16:00:00	NVDA	Stock	0.0787	0.0792	0.0717	0.0717	30964800.0
2002-10-15 17:00:00	NVDA	Stock	0.0717	0.0792	0.0717	0.0733	9701520.0
2002-10-15 18:00:00	NVDA	Stock	0.0729	0.0763	0.0722	0.0727	2328000.0
2002-10-15 08:00:00	AMZN	Stock	0.9875	0.9995	0.975	0.995	831820.0
2002-10-15 09:00:00	AMZN	Stock	1.0	1.002	0.983	0.9925	51979940.0
2002-10-15 10:00:00	AMZN	Stock	0.993	0.9965	0.98	0.9855	38761980.0
2002-10-15 11:00:00	AMZN	Stock	0.9855	0.9945	0.98	0.9805	23378240.0
2002-10-15 12:00:00	AMZN	Stock	0.98	0.9865	0.9785	0.9825	21003540.0
2002-10-15 13:00:00	AMZN	Stock	0.983	0.987	0.951	0.9535	42841140.0
2002-10-15 14:00:00	AMZN	Stock	0.954	0.9577	0.9325	0.948	39862280.0
2002-10-15 15:00:00	AMZN	Stock	0.948	0.9535	0.9395	0.947	34043280.0
2002-10-15 16:00:00	AMZN	Stock	0.9475	0.995	0.9225	0.925	6124980.0
2002-10-15 17:00:00	AMZN	Stock	0.9235	0.9739	0.92	0.926	2096000.0
2002-10-15 18:00:00	AMZN	Stock	0.926	0.926	0.926	0.926	8000.0
2002-10-15 09:00:00	CL	Stock	28.875	28.875	28.6	28.62	734800.0
2002-10-15 10:00:00	CL	Stock	28.605	28.625	27.945	27.95	1356600.0
2002-10-15 11:00:00	CL	Stock	27.95	27.95	27.545	27.555	1757200.0
2002-10-15 12:00:00	CL	Stock	27.55	27.7	27.445	27.595	868200.0
2002-10-15 13:00:00	CL	Stock	27.595	27.8	27.49	27.79	965200.0
2002-10-15 14:00:00	CL	Stock	27.79	28.045	27.715	27.955	1510400.0

> showing 50 of 20,273 rows — these rows as CSV

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