PREVIEW / stock_1hour / 2002-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-09-19.parquet
  size:    399 KB
  rows:    18,880
  symbols: 1,498

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-09-19 08:00:00	AAPL	Stock	0.2675	0.2675	0.2675	0.2675	11200.0
2002-09-19 09:00:00	AAPL	Stock	0.2673	0.2673	0.2602	0.2616	34504064.0
2002-09-19 10:00:00	AAPL	Stock	0.2618	0.2636	0.2609	0.2621	26982816.0
2002-09-19 11:00:00	AAPL	Stock	0.262	0.2636	0.2604	0.2609	18236848.0
2002-09-19 12:00:00	AAPL	Stock	0.2609	0.2625	0.2607	0.2614	15654688.0
2002-09-19 13:00:00	AAPL	Stock	0.2614	0.2616	0.2589	0.2598	19631192.0
2002-09-19 14:00:00	AAPL	Stock	0.2595	0.2614	0.2589	0.2589	20595176.0
2002-09-19 15:00:00	AAPL	Stock	0.2591	0.2611	0.2586	0.2604	51735264.0
2002-09-19 16:00:00	AAPL	Stock	0.2604	0.2616	0.2596	0.2604	7504280.0
2002-09-19 17:00:00	AAPL	Stock	0.26	0.2604	0.26	0.2604	2430400.0
2002-09-19 08:00:00	MSFT	Stock	23.875	23.875	23.2	23.425	633736.0
2002-09-19 09:00:00	MSFT	Stock	23.42	23.875	23.295	23.555	11475824.0
2002-09-19 10:00:00	MSFT	Stock	23.56	23.815	23.4945	23.755	15798966.0
2002-09-19 11:00:00	MSFT	Stock	23.75	23.895	23.64	23.65	9940848.0
2002-09-19 12:00:00	MSFT	Stock	23.65	23.91	23.645	23.775	8859892.0
2002-09-19 13:00:00	MSFT	Stock	23.7805	23.7805	23.6	23.63	5552012.0
2002-09-19 14:00:00	MSFT	Stock	23.63	23.805	23.585	23.615	8758716.0
2002-09-19 15:00:00	MSFT	Stock	23.625	23.8	23.51	23.6	14546996.0
2002-09-19 16:00:00	MSFT	Stock	23.624	23.83	23.5	23.77	1142284.0
2002-09-19 17:00:00	MSFT	Stock	23.795	23.84	23.6	23.7765	174050.0
2002-09-19 18:00:00	MSFT	Stock	23.8	23.8	23.755	23.785	11400.0
2002-09-19 08:00:00	NVDA	Stock	0.0782	0.0782	0.0767	0.0771	840000.0
2002-09-19 09:00:00	NVDA	Stock	0.0771	0.0787	0.0762	0.0775	99101280.0
2002-09-19 10:00:00	NVDA	Stock	0.0775	0.0787	0.0768	0.0784	118602000.0
2002-09-19 11:00:00	NVDA	Stock	0.0785	0.08	0.0777	0.0777	86656680.0
2002-09-19 12:00:00	NVDA	Stock	0.0779	0.0785	0.0774	0.0777	63673320.0
2002-09-19 13:00:00	NVDA	Stock	0.0776	0.0777	0.0767	0.0773	52072920.0
2002-09-19 14:00:00	NVDA	Stock	0.0772	0.0779	0.0761	0.0764	63578640.0
2002-09-19 15:00:00	NVDA	Stock	0.0764	0.077	0.0759	0.0762	96855120.0
2002-09-19 16:00:00	NVDA	Stock	0.0762	0.077	0.0758	0.0763	15264000.0
2002-09-19 17:00:00	NVDA	Stock	0.0769	0.0775	0.0763	0.0772	1524000.0
2002-09-19 18:00:00	NVDA	Stock	0.0772	0.0772	0.0772	0.0772	12000.0
2002-09-19 08:00:00	AMZN	Stock	0.88	0.8845	0.8715	0.8715	122000.0
2002-09-19 09:00:00	AMZN	Stock	0.8745	0.8845	0.8585	0.8675	21294860.0
2002-09-19 10:00:00	AMZN	Stock	0.8666	0.8735	0.8615	0.871	22783120.0
2002-09-19 11:00:00	AMZN	Stock	0.871	0.882	0.8655	0.868	11307600.0
2002-09-19 12:00:00	AMZN	Stock	0.868	0.879	0.8675	0.875	6730600.0
2002-09-19 13:00:00	AMZN	Stock	0.875	0.8751	0.8675	0.8695	4965900.0
2002-09-19 14:00:00	AMZN	Stock	0.869	0.876	0.8675	0.874	10430600.0
2002-09-19 15:00:00	AMZN	Stock	0.875	0.875	0.86	0.861	14465500.0
2002-09-19 16:00:00	AMZN	Stock	0.8615	0.8682	0.859	0.8605	1449360.0
2002-09-19 17:00:00	AMZN	Stock	0.871	0.875	0.8605	0.8605	357000.0
2002-09-19 18:00:00	AMZN	Stock	0.87	0.875	0.8665	0.875	90000.0
2002-09-19 09:00:00	CL	Stock	27.05	27.125	27.035	27.125	193000.0
2002-09-19 10:00:00	CL	Stock	27.075	27.14	26.825	26.9	693200.0
2002-09-19 11:00:00	CL	Stock	26.9	27.005	26.825	26.985	495000.0
2002-09-19 12:00:00	CL	Stock	27.0	27.175	26.95	27.1	242800.0
2002-09-19 13:00:00	CL	Stock	27.095	27.175	26.96	26.96	242600.0
2002-09-19 14:00:00	CL	Stock	26.965	27.0	26.79	26.795	520800.0
2002-09-19 15:00:00	CL	Stock	26.795	26.87	26.66	26.705	497200.0

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

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