PREVIEW / stock_1hour / 2003-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-22.parquet
  size:    460 KB
  rows:    21,774
  symbols: 1,603

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
2003-08-22 08:00:00	AAPL	Stock	0.3845	0.3948	0.3845	0.3948	361704.0
2003-08-22 09:00:00	AAPL	Stock	0.3929	0.3929	0.3845	0.3875	24833032.0
2003-08-22 10:00:00	AAPL	Stock	0.3873	0.3873	0.3795	0.3823	42927080.0
2003-08-22 11:00:00	AAPL	Stock	0.3823	0.3829	0.3773	0.3784	20120968.0
2003-08-22 12:00:00	AAPL	Stock	0.3782	0.3791	0.3746	0.375	46617256.0
2003-08-22 13:00:00	AAPL	Stock	0.3748	0.3759	0.3711	0.3716	29287776.0
2003-08-22 14:00:00	AAPL	Stock	0.3716	0.3734	0.3685	0.3727	21698992.0
2003-08-22 15:00:00	AAPL	Stock	0.3727	0.3761	0.3725	0.3725	38654784.0
2003-08-22 16:00:00	AAPL	Stock	0.3725	0.3734	0.3711	0.3725	4192272.0
2003-08-22 08:00:00	MSFT	Stock	26.23	26.9	26.22	26.9	1232751.0
2003-08-22 09:00:00	MSFT	Stock	26.9	26.96	26.67	26.89	14045272.0
2003-08-22 10:00:00	MSFT	Stock	26.89	26.9	26.52	26.69	13460843.0
2003-08-22 11:00:00	MSFT	Stock	26.69	26.76	26.52	26.56	7765305.0
2003-08-22 12:00:00	MSFT	Stock	26.56	26.63	26.52	26.54	4173921.0
2003-08-22 13:00:00	MSFT	Stock	26.53	26.59	26.39	26.57	3939581.0
2003-08-22 14:00:00	MSFT	Stock	26.57	26.57	26.24	26.28	5678132.0
2003-08-22 15:00:00	MSFT	Stock	26.27	26.45	26.21	26.26	6853046.0
2003-08-22 16:00:00	MSFT	Stock	26.23	26.34	26.201	26.299	1322584.0
2003-08-22 17:00:00	MSFT	Stock	26.299	26.299	26.27	26.27	11189.0
2003-08-22 18:00:00	MSFT	Stock	26.28	26.3	26.28	26.29	7490.0
2003-08-22 08:00:00	NVDA	Stock	0.1517	0.1577	0.1517	0.1575	4584000.0
2003-08-22 09:00:00	NVDA	Stock	0.1569	0.1623	0.1563	0.1614	263362200.0
2003-08-22 10:00:00	NVDA	Stock	0.1614	0.1614	0.1562	0.1566	235766400.0
2003-08-22 11:00:00	NVDA	Stock	0.1567	0.1572	0.1536	0.1546	125489640.0
2003-08-22 12:00:00	NVDA	Stock	0.1546	0.1564	0.1544	0.1556	59032320.0
2003-08-22 13:00:00	NVDA	Stock	0.1556	0.1557	0.1535	0.1552	57171600.0
2003-08-22 14:00:00	NVDA	Stock	0.1551	0.1551	0.1526	0.153	62892720.0
2003-08-22 15:00:00	NVDA	Stock	0.153	0.1545	0.1522	0.1522	98806320.0
2003-08-22 16:00:00	NVDA	Stock	0.1522	0.1528	0.1511	0.1515	9978480.0
2003-08-22 17:00:00	NVDA	Stock	0.1515	0.1517	0.1515	0.1517	270000.0
2003-08-22 18:00:00	NVDA	Stock	0.1517	0.1517	0.1512	0.1512	216000.0
2003-08-22 08:00:00	AMZN	Stock	2.285	2.314	2.285	2.3125	719600.0
2003-08-22 09:00:00	AMZN	Stock	2.3125	2.3475	2.3055	2.325	40456200.0
2003-08-22 10:00:00	AMZN	Stock	2.325	2.3275	2.2745	2.2885	52812660.0
2003-08-22 11:00:00	AMZN	Stock	2.288	2.2915	2.275	2.285	23246200.0
2003-08-22 12:00:00	AMZN	Stock	2.2855	2.2875	2.2605	2.2615	17866520.0
2003-08-22 13:00:00	AMZN	Stock	2.2615	2.2725	2.26	2.27	15666060.0
2003-08-22 14:00:00	AMZN	Stock	2.2705	2.2705	2.2405	2.2435	18412880.0
2003-08-22 15:00:00	AMZN	Stock	2.243	2.2695	2.2415	2.2625	20669880.0
2003-08-22 16:00:00	AMZN	Stock	2.268	2.269	2.2585	2.261	1967760.0
2003-08-22 17:00:00	AMZN	Stock	2.2675	2.2675	2.261	2.261	110640.0
2003-08-22 18:00:00	AMZN	Stock	2.2635	2.2635	2.2635	2.2635	10000.0
2003-08-22 09:00:00	CL	Stock	27.15	27.175	27.05	27.11	276800.0
2003-08-22 10:00:00	CL	Stock	27.11	27.115	26.875	26.94	815800.0
2003-08-22 11:00:00	CL	Stock	26.935	26.97	26.845	26.895	688600.0
2003-08-22 12:00:00	CL	Stock	26.89	27.01	26.89	27.0	209600.0
2003-08-22 13:00:00	CL	Stock	27.0	27.05	26.945	27.005	172000.0
2003-08-22 14:00:00	CL	Stock	27.0	27.0	26.7	26.705	561600.0
2003-08-22 15:00:00	CL	Stock	26.705	26.715	26.6	26.63	803000.0
2003-08-22 16:00:00	CL	Stock	26.63	26.675	26.63	26.675	229800.0

> showing 50 of 21,774 rows — these rows as CSV

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