PREVIEW / stock_1hour / 2002-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-02.parquet
  size:    397 KB
  rows:    18,634
  symbols: 1,456

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-02 08:00:00	AAPL	Stock	0.2642	0.2642	0.2625	0.2625	341600.0
2002-08-02 09:00:00	AAPL	Stock	0.2625	0.2679	0.2616	0.2657	19015752.0
2002-08-02 10:00:00	AAPL	Stock	0.2652	0.2661	0.2591	0.2598	26376336.0
2002-08-02 11:00:00	AAPL	Stock	0.2598	0.2618	0.2589	0.2591	17375568.0
2002-08-02 12:00:00	AAPL	Stock	0.2591	0.2595	0.2584	0.2584	22272320.0
2002-08-02 13:00:00	AAPL	Stock	0.2588	0.2609	0.2554	0.2573	20576192.0
2002-08-02 14:00:00	AAPL	Stock	0.2573	0.2598	0.2566	0.2589	19412344.0
2002-08-02 15:00:00	AAPL	Stock	0.2591	0.2621	0.2545	0.2577	43584240.0
2002-08-02 16:00:00	AAPL	Stock	0.2577	0.2604	0.2575	0.258	3147200.0
2002-08-02 17:00:00	AAPL	Stock	0.258	0.2634	0.258	0.2634	683200.0
2002-08-02 08:00:00	MSFT	Stock	22.8675	22.875	22.599	22.8	212394.0
2002-08-02 09:00:00	MSFT	Stock	22.8	22.925	22.51	22.665	11167730.0
2002-08-02 10:00:00	MSFT	Stock	22.672	22.845	22.54	22.675	13747500.0
2002-08-02 11:00:00	MSFT	Stock	22.695	22.72	22.365	22.396	12505144.0
2002-08-02 12:00:00	MSFT	Stock	22.395	22.4	22.045	22.075	11327506.0
2002-08-02 13:00:00	MSFT	Stock	22.09	22.35	22.025	22.093	8992818.0
2002-08-02 14:00:00	MSFT	Stock	22.095	22.1415	21.93	21.9755	9051666.0
2002-08-02 15:00:00	MSFT	Stock	21.99	22.28	21.9	22.195	15993188.0
2002-08-02 16:00:00	MSFT	Stock	22.205	22.245	21.94	22.14	1737578.0
2002-08-02 17:00:00	MSFT	Stock	22.16	22.205	22.14	22.205	102000.0
2002-08-02 18:00:00	MSFT	Stock	22.1605	22.161	22.1605	22.161	3200.0
2002-08-02 08:00:00	NVDA	Stock	0.0833	0.085	0.0825	0.0842	10225560.0
2002-08-02 09:00:00	NVDA	Stock	0.0849	0.0867	0.0815	0.0825	281530200.0
2002-08-02 10:00:00	NVDA	Stock	0.0825	0.0828	0.0758	0.0769	568851960.0
2002-08-02 11:00:00	NVDA	Stock	0.0769	0.0797	0.0762	0.0777	279789120.0
2002-08-02 12:00:00	NVDA	Stock	0.0777	0.078	0.0766	0.0769	139422480.0
2002-08-02 13:00:00	NVDA	Stock	0.0769	0.0791	0.0768	0.0777	151582680.0
2002-08-02 14:00:00	NVDA	Stock	0.0775	0.0779	0.0769	0.0773	101215800.0
2002-08-02 15:00:00	NVDA	Stock	0.0774	0.0782	0.076	0.0779	231580680.0
2002-08-02 16:00:00	NVDA	Stock	0.0779	0.0782	0.0771	0.0777	24998280.0
2002-08-02 17:00:00	NVDA	Stock	0.0777	0.0782	0.0776	0.0778	2559000.0
2002-08-02 18:00:00	NVDA	Stock	0.0777	0.0782	0.0777	0.0782	266400.0
2002-08-02 08:00:00	AMZN	Stock	0.7108	0.7108	0.705	0.708	44000.0
2002-08-02 09:00:00	AMZN	Stock	0.7055	0.7085	0.6825	0.687	12873660.0
2002-08-02 10:00:00	AMZN	Stock	0.6855	0.6905	0.675	0.678	14509740.0
2002-08-02 11:00:00	AMZN	Stock	0.6785	0.691	0.6775	0.6825	8993980.0
2002-08-02 12:00:00	AMZN	Stock	0.6825	0.6835	0.6755	0.6775	8418140.0
2002-08-02 13:00:00	AMZN	Stock	0.677	0.6835	0.6765	0.6785	4964000.0
2002-08-02 14:00:00	AMZN	Stock	0.6785	0.6785	0.675	0.676	8278200.0
2002-08-02 15:00:00	AMZN	Stock	0.6755	0.692	0.6725	0.6905	19253640.0
2002-08-02 16:00:00	AMZN	Stock	0.692	0.6925	0.6835	0.6885	2664000.0
2002-08-02 17:00:00	AMZN	Stock	0.692	0.692	0.692	0.692	306000.0
2002-08-02 09:00:00	CL	Stock	26.21	26.405	26.15	26.4	705600.0
2002-08-02 10:00:00	CL	Stock	26.425	26.425	26.16	26.4	853600.0
2002-08-02 11:00:00	CL	Stock	26.4	26.41	26.255	26.4	787600.0
2002-08-02 12:00:00	CL	Stock	26.37	26.475	26.155	26.21	940000.0
2002-08-02 13:00:00	CL	Stock	26.22	26.24	26.01	26.03	488000.0
2002-08-02 14:00:00	CL	Stock	26.055	26.055	25.83	25.905	443000.0
2002-08-02 15:00:00	CL	Stock	25.905	26.12	25.71	26.105	733600.0
2002-08-02 16:00:00	CL	Stock	26.175	26.175	26.175	26.175	123800.0

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

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