PREVIEW / stock_1hour / 2002-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-01.parquet
  size:    400 KB
  rows:    18,442
  symbols: 1,450

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-08-01 08:00:00	AAPL	Stock	0.2725	0.2725	0.2725	0.2725	1859200.0
2002-08-01 09:00:00	AAPL	Stock	0.2725	0.2754	0.2695	0.2739	14018200.0
2002-08-01 10:00:00	AAPL	Stock	0.2739	0.2739	0.2668	0.2673	40737928.0
2002-08-01 11:00:00	AAPL	Stock	0.2675	0.2679	0.2648	0.2666	25236288.0
2002-08-01 12:00:00	AAPL	Stock	0.2666	0.267	0.2657	0.2664	19400304.0
2002-08-01 13:00:00	AAPL	Stock	0.2664	0.27	0.2661	0.2696	16388568.0
2002-08-01 14:00:00	AAPL	Stock	0.2691	0.2709	0.2679	0.2692	24774064.0
2002-08-01 15:00:00	AAPL	Stock	0.2691	0.2709	0.263	0.2634	57969912.0
2002-08-01 16:00:00	AAPL	Stock	0.2641	0.2679	0.2627	0.2679	17679200.0
2002-08-01 17:00:00	AAPL	Stock	0.2643	0.2643	0.2643	0.2643	1136800.0
2002-08-01 08:00:00	MSFT	Stock	23.85	23.99	23.72	23.985	67598.0
2002-08-01 09:00:00	MSFT	Stock	23.785	24.045	23.735	23.9135	8199080.0
2002-08-01 10:00:00	MSFT	Stock	23.912	23.915	23.225	23.394	20643938.0
2002-08-01 11:00:00	MSFT	Stock	23.394	23.42	23.09	23.265	11085282.0
2002-08-01 12:00:00	MSFT	Stock	23.2555	23.3215	23.065	23.255	9172960.0
2002-08-01 13:00:00	MSFT	Stock	23.25	23.29	23.065	23.22	8140216.0
2002-08-01 14:00:00	MSFT	Stock	23.22	23.24	23.045	23.15	9022474.0
2002-08-01 15:00:00	MSFT	Stock	23.15	23.315	22.75	22.88	20034684.0
2002-08-01 16:00:00	MSFT	Stock	22.88	23.2806	22.65	22.71	4348586.0
2002-08-01 17:00:00	MSFT	Stock	22.715	22.875	22.68	22.7	204200.0
2002-08-01 18:00:00	MSFT	Stock	22.7	22.73	22.7	22.7	4800.0
2002-08-01 08:00:00	NVDA	Stock	0.0933	0.0933	0.091	0.0917	9157200.0
2002-08-01 09:00:00	NVDA	Stock	0.092	0.0933	0.0902	0.0918	286163280.0
2002-08-01 10:00:00	NVDA	Stock	0.092	0.0922	0.0884	0.0885	266863200.0
2002-08-01 11:00:00	NVDA	Stock	0.0885	0.089	0.0868	0.0874	207387720.0
2002-08-01 12:00:00	NVDA	Stock	0.0874	0.0877	0.0852	0.0854	216689280.0
2002-08-01 13:00:00	NVDA	Stock	0.0854	0.0866	0.0835	0.0857	251430000.0
2002-08-01 14:00:00	NVDA	Stock	0.0857	0.086	0.0837	0.0846	169777440.0
2002-08-01 15:00:00	NVDA	Stock	0.0846	0.0852	0.0833	0.0837	254108400.0
2002-08-01 16:00:00	NVDA	Stock	0.0838	0.084	0.0829	0.0833	22983000.0
2002-08-01 17:00:00	NVDA	Stock	0.0833	0.0837	0.0833	0.0835	1999800.0
2002-08-01 18:00:00	NVDA	Stock	0.0835	0.0835	0.0833	0.0833	842400.0
2002-08-01 08:00:00	AMZN	Stock	0.7213	0.723	0.7075	0.723	558000.0
2002-08-01 09:00:00	AMZN	Stock	0.714	0.7215	0.708	0.7155	6225260.0
2002-08-01 10:00:00	AMZN	Stock	0.7165	0.7173	0.7	0.7025	19687360.0
2002-08-01 11:00:00	AMZN	Stock	0.7025	0.71	0.6995	0.703	13650540.0
2002-08-01 12:00:00	AMZN	Stock	0.7035	0.707	0.6995	0.704	9737160.0
2002-08-01 13:00:00	AMZN	Stock	0.704	0.7185	0.6995	0.715	11680980.0
2002-08-01 14:00:00	AMZN	Stock	0.715	0.7175	0.7075	0.715	15598460.0
2002-08-01 15:00:00	AMZN	Stock	0.715	0.725	0.709	0.714	26018640.0
2002-08-01 16:00:00	AMZN	Stock	0.7115	0.714	0.703	0.7095	3370720.0
2002-08-01 17:00:00	AMZN	Stock	0.708	0.7095	0.708	0.708	224000.0
2002-08-01 09:00:00	CL	Stock	25.65	26.19	25.55	26.185	559600.0
2002-08-01 10:00:00	CL	Stock	26.16	26.16	25.635	25.885	1034800.0
2002-08-01 11:00:00	CL	Stock	25.9	26.06	25.85	25.98	1125400.0
2002-08-01 12:00:00	CL	Stock	25.985	26.21	25.94	26.195	596800.0
2002-08-01 13:00:00	CL	Stock	26.22	26.295	26.05	26.27	575200.0
2002-08-01 14:00:00	CL	Stock	26.27	26.45	26.1	26.235	514600.0
2002-08-01 15:00:00	CL	Stock	26.235	26.495	26.19	26.21	1358800.0
2002-08-01 16:00:00	CL	Stock	26.21	26.21	26.21	26.21	312400.0

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

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