PREVIEW / stock_1hour / 2002-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-06.parquet
  size:    397 KB
  rows:    19,052
  symbols: 1,464

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-06 08:00:00	AAPL	Stock	0.2505	0.2529	0.2505	0.2529	100800.0
2002-08-06 09:00:00	AAPL	Stock	0.2529	0.2569	0.2514	0.2523	23706928.0
2002-08-06 10:00:00	AAPL	Stock	0.2521	0.2593	0.2521	0.2579	61100872.0
2002-08-06 11:00:00	AAPL	Stock	0.2577	0.2629	0.2571	0.2611	32103176.0
2002-08-06 12:00:00	AAPL	Stock	0.2609	0.2673	0.2609	0.2663	21086408.0
2002-08-06 13:00:00	AAPL	Stock	0.2659	0.2671	0.2609	0.2652	24383296.0
2002-08-06 14:00:00	AAPL	Stock	0.2652	0.2713	0.2634	0.2705	31761744.0
2002-08-06 15:00:00	AAPL	Stock	0.2707	0.272	0.2591	0.263	58728880.0
2002-08-06 16:00:00	AAPL	Stock	0.263	0.2645	0.2625	0.2645	5863200.0
2002-08-06 17:00:00	AAPL	Stock	0.2645	0.2675	0.2645	0.2675	336000.0
2002-08-06 18:00:00	AAPL	Stock	0.2673	0.2679	0.2673	0.2679	207200.0
2002-08-06 08:00:00	MSFT	Stock	22.285	22.485	21.975	22.435	494104.0
2002-08-06 09:00:00	MSFT	Stock	22.435	22.6895	22.375	22.545	12078870.0
2002-08-06 10:00:00	MSFT	Stock	22.545	23.12	22.535	22.915	18410536.0
2002-08-06 11:00:00	MSFT	Stock	22.917	23.12	22.849	23.025	8318762.0
2002-08-06 12:00:00	MSFT	Stock	23.025	23.25	23.005	23.165	7674648.0
2002-08-06 13:00:00	MSFT	Stock	23.16	23.205	23.005	23.155	5922232.0
2002-08-06 14:00:00	MSFT	Stock	23.15	23.525	23.045	23.505	10712088.0
2002-08-06 15:00:00	MSFT	Stock	23.505	23.625	22.8185	22.835	20620914.0
2002-08-06 16:00:00	MSFT	Stock	22.835	23.045	22.76	22.975	2843502.0
2002-08-06 17:00:00	MSFT	Stock	22.95	23.335	22.945	23.325	177822.0
2002-08-06 18:00:00	MSFT	Stock	23.35	23.35	23.25	23.3	15160.0
2002-08-06 08:00:00	NVDA	Stock	0.0729	0.0747	0.0712	0.0744	6276000.0
2002-08-06 09:00:00	NVDA	Stock	0.0744	0.0766	0.0738	0.0739	200572440.0
2002-08-06 10:00:00	NVDA	Stock	0.074	0.0779	0.0739	0.0767	340245360.0
2002-08-06 11:00:00	NVDA	Stock	0.0767	0.0782	0.0758	0.0775	205322520.0
2002-08-06 12:00:00	NVDA	Stock	0.0775	0.0782	0.0772	0.0777	86051400.0
2002-08-06 13:00:00	NVDA	Stock	0.0777	0.0778	0.0766	0.0771	60354600.0
2002-08-06 14:00:00	NVDA	Stock	0.0772	0.0782	0.0767	0.0782	72336360.0
2002-08-06 15:00:00	NVDA	Stock	0.0782	0.0782	0.075	0.0752	169113000.0
2002-08-06 16:00:00	NVDA	Stock	0.0752	0.0765	0.075	0.0755	15206880.0
2002-08-06 17:00:00	NVDA	Stock	0.0762	0.0781	0.0757	0.078	7966800.0
2002-08-06 18:00:00	NVDA	Stock	0.078	0.0782	0.0778	0.0782	2472600.0
2002-08-06 08:00:00	AMZN	Stock	0.6465	0.6595	0.6465	0.6575	48000.0
2002-08-06 09:00:00	AMZN	Stock	0.66	0.675	0.657	0.6595	11887480.0
2002-08-06 10:00:00	AMZN	Stock	0.6595	0.674	0.659	0.6655	13178280.0
2002-08-06 11:00:00	AMZN	Stock	0.666	0.671	0.6645	0.669	9394420.0
2002-08-06 12:00:00	AMZN	Stock	0.668	0.6815	0.6675	0.679	10039020.0
2002-08-06 13:00:00	AMZN	Stock	0.679	0.684	0.671	0.684	15515060.0
2002-08-06 14:00:00	AMZN	Stock	0.684	0.6885	0.682	0.688	12759440.0
2002-08-06 15:00:00	AMZN	Stock	0.688	0.695	0.682	0.6875	15465340.0
2002-08-06 16:00:00	AMZN	Stock	0.6875	0.6875	0.682	0.6835	1210000.0
2002-08-06 17:00:00	AMZN	Stock	0.6835	0.7	0.6835	0.7	94000.0
2002-08-06 18:00:00	AMZN	Stock	0.7	0.7025	0.687	0.6875	1146400.0
2002-08-06 09:00:00	CL	Stock	25.585	25.955	25.585	25.89	423000.0
2002-08-06 10:00:00	CL	Stock	25.915	26.26	25.895	26.01	1043800.0
2002-08-06 11:00:00	CL	Stock	26.01	26.03	25.815	25.885	1108400.0
2002-08-06 12:00:00	CL	Stock	25.89	26.025	25.87	25.91	1133600.0
2002-08-06 13:00:00	CL	Stock	25.91	25.955	25.825	25.92	444000.0
2002-08-06 14:00:00	CL	Stock	25.92	25.95	25.805	25.925	1036000.0

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

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