PREVIEW / stock_1hour / 2002-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-18.parquet
  size:    404 KB
  rows:    19,221
  symbols: 1,485

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-18 08:00:00	AAPL	Stock	0.252	0.252	0.25	0.25	233744.0
2002-10-18 09:00:00	AAPL	Stock	0.2502	0.2527	0.2488	0.2504	57125208.0
2002-10-18 10:00:00	AAPL	Stock	0.2502	0.255	0.2502	0.253	65861768.0
2002-10-18 11:00:00	AAPL	Stock	0.2529	0.2554	0.2527	0.2534	32820536.0
2002-10-18 12:00:00	AAPL	Stock	0.2534	0.2536	0.2507	0.2518	20626424.0
2002-10-18 13:00:00	AAPL	Stock	0.2518	0.2552	0.2518	0.2545	15506680.0
2002-10-18 14:00:00	AAPL	Stock	0.2545	0.2554	0.254	0.2548	26795496.0
2002-10-18 15:00:00	AAPL	Stock	0.2548	0.2563	0.2536	0.2563	33686240.0
2002-10-18 16:00:00	AAPL	Stock	0.2557	0.2566	0.2533	0.2561	11870992.0
2002-10-18 17:00:00	AAPL	Stock	0.2561	0.2561	0.2561	0.2561	268800.0
2002-10-18 18:00:00	AAPL	Stock	0.2561	0.2561	0.2561	0.2561	638400.0
2002-10-18 08:00:00	MSFT	Stock	25.75	27.5	25.5	26.21	3393556.0
2002-10-18 09:00:00	MSFT	Stock	26.23	26.435	25.505	25.735	31150206.0
2002-10-18 10:00:00	MSFT	Stock	25.735	26.376	25.57	26.27	34185500.0
2002-10-18 11:00:00	MSFT	Stock	26.27	26.6	26.26	26.44	23878980.0
2002-10-18 12:00:00	MSFT	Stock	26.44	26.45	26.177	26.315	11684942.0
2002-10-18 13:00:00	MSFT	Stock	26.325	26.45	26.225	26.39	7454658.0
2002-10-18 14:00:00	MSFT	Stock	26.415	26.55	26.275	26.515	12403158.0
2002-10-18 15:00:00	MSFT	Stock	26.515	26.595	26.26	26.57	21882140.0
2002-10-18 16:00:00	MSFT	Stock	26.575	26.65	26.225	26.62	4444734.0
2002-10-18 17:00:00	MSFT	Stock	26.625	26.625	26.575	26.575	92588.0
2002-10-18 18:00:00	MSFT	Stock	26.595	26.595	26.535	26.595	107660.0
2002-10-18 08:00:00	NVDA	Stock	0.0772	0.0779	0.0754	0.0758	1538520.0
2002-10-18 09:00:00	NVDA	Stock	0.0767	0.0776	0.0743	0.0746	69410040.0
2002-10-18 10:00:00	NVDA	Stock	0.0746	0.0771	0.0742	0.0767	71164800.0
2002-10-18 11:00:00	NVDA	Stock	0.0769	0.079	0.0768	0.0781	80618880.0
2002-10-18 12:00:00	NVDA	Stock	0.0779	0.0779	0.0765	0.0778	83538480.0
2002-10-18 13:00:00	NVDA	Stock	0.0779	0.0787	0.0771	0.0783	38403600.0
2002-10-18 14:00:00	NVDA	Stock	0.0782	0.0789	0.0772	0.078	46033080.0
2002-10-18 15:00:00	NVDA	Stock	0.0781	0.0792	0.0773	0.0783	89276040.0
2002-10-18 16:00:00	NVDA	Stock	0.0782	0.0784	0.0779	0.0784	14832240.0
2002-10-18 17:00:00	NVDA	Stock	0.0784	0.0784	0.0783	0.0783	612000.0
2002-10-18 18:00:00	NVDA	Stock	0.0783	0.0789	0.0783	0.0783	528000.0
2002-10-18 08:00:00	AMZN	Stock	0.93	0.932	0.9225	0.932	292000.0
2002-10-18 09:00:00	AMZN	Stock	0.9275	0.937	0.918	0.9215	28571320.0
2002-10-18 10:00:00	AMZN	Stock	0.9205	0.9645	0.9196	0.9584	32516260.0
2002-10-18 11:00:00	AMZN	Stock	0.958	0.963	0.9458	0.9485	15740100.0
2002-10-18 12:00:00	AMZN	Stock	0.9485	0.95	0.932	0.9435	15400660.0
2002-10-18 13:00:00	AMZN	Stock	0.943	0.96	0.943	0.958	10172000.0
2002-10-18 14:00:00	AMZN	Stock	0.9575	0.958	0.9455	0.951	8980780.0
2002-10-18 15:00:00	AMZN	Stock	0.952	0.9547	0.948	0.9525	12413680.0
2002-10-18 16:00:00	AMZN	Stock	0.9525	0.958	0.945	0.952	5510000.0
2002-10-18 17:00:00	AMZN	Stock	0.952	0.954	0.952	0.952	432000.0
2002-10-18 18:00:00	AMZN	Stock	0.952	0.955	0.952	0.955	116000.0
2002-10-18 09:00:00	CL	Stock	27.5	27.745	27.5	27.735	625800.0
2002-10-18 10:00:00	CL	Stock	27.735	28.065	27.735	28.05	841800.0
2002-10-18 11:00:00	CL	Stock	28.05	28.45	28.04	28.32	782200.0
2002-10-18 12:00:00	CL	Stock	28.325	28.47	28.29	28.45	475000.0
2002-10-18 13:00:00	CL	Stock	28.46	28.625	28.425	28.475	358400.0
2002-10-18 14:00:00	CL	Stock	28.475	28.55	28.275	28.29	427600.0

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

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