PREVIEW / stock_1hour / 2002-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-13.parquet
  size:    410 KB
  rows:    19,574
  symbols: 1,507

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-11-13 08:00:00	AAPL	Stock	0.277	0.277	0.2768	0.2768	190400.0
2002-11-13 09:00:00	AAPL	Stock	0.2768	0.28	0.2759	0.2791	19107480.0
2002-11-13 10:00:00	AAPL	Stock	0.2793	0.287	0.2729	0.2829	47358976.0
2002-11-13 11:00:00	AAPL	Stock	0.2829	0.2859	0.2814	0.2857	23248456.0
2002-11-13 12:00:00	AAPL	Stock	0.2857	0.2859	0.2832	0.2832	14519288.0
2002-11-13 13:00:00	AAPL	Stock	0.2836	0.2845	0.2809	0.2811	12475232.0
2002-11-13 14:00:00	AAPL	Stock	0.2811	0.2821	0.2734	0.2738	31514672.0
2002-11-13 15:00:00	AAPL	Stock	0.2738	0.2793	0.2734	0.2782	52340792.0
2002-11-13 16:00:00	AAPL	Stock	0.2784	0.28	0.2768	0.2768	6221600.0
2002-11-13 17:00:00	AAPL	Stock	0.2784	0.2788	0.2768	0.2784	1204000.0
2002-11-13 08:00:00	MSFT	Stock	27.265	27.265	27.05	27.255	94328.0
2002-11-13 09:00:00	MSFT	Stock	27.1945	27.29	27.055	27.28	10226938.0
2002-11-13 10:00:00	MSFT	Stock	27.28	27.75	27.11	27.56	21450710.0
2002-11-13 11:00:00	MSFT	Stock	27.56	27.96	27.525	27.91	15222426.0
2002-11-13 12:00:00	MSFT	Stock	27.91	27.965	27.735	27.785	12642114.0
2002-11-13 13:00:00	MSFT	Stock	27.77	27.775	27.405	27.427	12216768.0
2002-11-13 14:00:00	MSFT	Stock	27.43	27.6325	27.205	27.2395	13065344.0
2002-11-13 15:00:00	MSFT	Stock	27.24	27.695	27.174	27.69	14972104.0
2002-11-13 16:00:00	MSFT	Stock	27.685	27.805	27.53	27.595	1747504.0
2002-11-13 17:00:00	MSFT	Stock	27.605	28.065	27.565	27.655	230420.0
2002-11-13 18:00:00	MSFT	Stock	27.655	27.675	27.61	27.61	24400.0
2002-11-13 08:00:00	NVDA	Stock	0.095	0.095	0.0932	0.0933	3282000.0
2002-11-13 09:00:00	NVDA	Stock	0.0937	0.0947	0.0917	0.0927	188708280.0
2002-11-13 10:00:00	NVDA	Stock	0.0923	0.0971	0.091	0.0962	316879560.0
2002-11-13 11:00:00	NVDA	Stock	0.0963	0.0995	0.0947	0.0987	292206120.0
2002-11-13 12:00:00	NVDA	Stock	0.0986	0.1008	0.0979	0.0995	233723760.0
2002-11-13 13:00:00	NVDA	Stock	0.0994	0.0999	0.0975	0.0977	148666440.0
2002-11-13 14:00:00	NVDA	Stock	0.0976	0.0986	0.0961	0.0961	191569200.0
2002-11-13 15:00:00	NVDA	Stock	0.0961	0.0983	0.0954	0.0981	262525560.0
2002-11-13 16:00:00	NVDA	Stock	0.0981	0.0987	0.0962	0.0962	30838080.0
2002-11-13 17:00:00	NVDA	Stock	0.0967	0.0982	0.0959	0.0967	2212080.0
2002-11-13 18:00:00	NVDA	Stock	0.0972	0.0972	0.0969	0.0969	241680.0
2002-11-13 08:00:00	AMZN	Stock	0.9912	0.9912	0.9845	0.985	581000.0
2002-11-13 09:00:00	AMZN	Stock	0.985	1.0	0.9805	0.9975	20983860.0
2002-11-13 10:00:00	AMZN	Stock	0.9975	1.0125	0.9885	1.0085	41025720.0
2002-11-13 11:00:00	AMZN	Stock	1.0082	1.0465	1.0048	1.046	86598060.0
2002-11-13 12:00:00	AMZN	Stock	1.0465	1.05	1.0385	1.039	40267460.0
2002-11-13 13:00:00	AMZN	Stock	1.0385	1.043	1.034	1.036	26498960.0
2002-11-13 14:00:00	AMZN	Stock	1.0345	1.0415	1.0255	1.028	32612960.0
2002-11-13 15:00:00	AMZN	Stock	1.0275	1.0315	1.01	1.019	70790480.0
2002-11-13 16:00:00	AMZN	Stock	1.019	1.035	1.0125	1.0175	13082800.0
2002-11-13 17:00:00	AMZN	Stock	1.015	1.0206	1.015	1.0175	859000.0
2002-11-13 18:00:00	AMZN	Stock	1.0165	1.0245	1.0165	1.0245	276000.0
2002-11-13 09:00:00	CL	Stock	26.375	26.575	26.325	26.45	416200.0
2002-11-13 10:00:00	CL	Stock	26.45	26.45	26.175	26.355	916200.0
2002-11-13 11:00:00	CL	Stock	26.355	26.575	26.33	26.54	548600.0
2002-11-13 12:00:00	CL	Stock	26.55	26.55	26.43	26.46	806800.0
2002-11-13 13:00:00	CL	Stock	26.45	26.48	26.24	26.25	574600.0
2002-11-13 14:00:00	CL	Stock	26.325	26.325	26.105	26.105	1344800.0
2002-11-13 15:00:00	CL	Stock	26.115	26.305	26.105	26.3	1262000.0

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

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