PREVIEW / stock_1hour / 2003-09-09

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-09-09.parquet
  size:    469 KB
  rows:    22,057
  symbols: 1,612

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-09-09 08:00:00	AAPL	Stock	0.4055	0.4055	0.4048	0.4054	2332232.0
2003-09-09 09:00:00	AAPL	Stock	0.4046	0.4046	0.4002	0.4018	31130568.0
2003-09-09 10:00:00	AAPL	Stock	0.4018	0.4023	0.395	0.398	40781608.0
2003-09-09 11:00:00	AAPL	Stock	0.398	0.4029	0.3979	0.4016	17577672.0
2003-09-09 12:00:00	AAPL	Stock	0.4018	0.4048	0.4004	0.4016	16075808.0
2003-09-09 13:00:00	AAPL	Stock	0.4016	0.4021	0.3996	0.4011	14536200.0
2003-09-09 14:00:00	AAPL	Stock	0.4011	0.4027	0.3984	0.3991	16982504.0
2003-09-09 15:00:00	AAPL	Stock	0.3991	0.4	0.3971	0.3995	25512088.0
2003-09-09 16:00:00	AAPL	Stock	0.3995	0.3995	0.3993	0.3995	498400.0
2003-09-09 17:00:00	AAPL	Stock	0.3995	0.3995	0.3995	0.3995	996800.0
2003-09-09 08:00:00	MSFT	Stock	28.84	28.9	28.8	28.83	21498.0
2003-09-09 09:00:00	MSFT	Stock	28.83	28.84	28.48	28.53	6857661.0
2003-09-09 10:00:00	MSFT	Stock	28.54	28.63	28.37	28.49	9438245.0
2003-09-09 11:00:00	MSFT	Stock	28.49	28.55	28.38	28.48	4966042.0
2003-09-09 12:00:00	MSFT	Stock	28.48	28.56	28.42	28.49	3198977.0
2003-09-09 13:00:00	MSFT	Stock	28.5	28.54	28.42	28.54	3685564.0
2003-09-09 14:00:00	MSFT	Stock	28.54	28.56	28.38	28.49	4026322.0
2003-09-09 15:00:00	MSFT	Stock	28.49	28.5	28.314	28.44	6401333.0
2003-09-09 16:00:00	MSFT	Stock	28.37	28.44	28.302	28.32	568788.0
2003-09-09 17:00:00	MSFT	Stock	28.31	28.38	28.26	28.339	161469.0
2003-09-09 18:00:00	MSFT	Stock	28.37	28.37	28.3	28.35	129600.0
2003-09-09 08:00:00	NVDA	Stock	0.1633	0.1642	0.1625	0.1625	2532000.0
2003-09-09 09:00:00	NVDA	Stock	0.1625	0.1625	0.1562	0.1618	300802680.0
2003-09-09 10:00:00	NVDA	Stock	0.1619	0.1643	0.1598	0.1641	231650880.0
2003-09-09 11:00:00	NVDA	Stock	0.1641	0.1708	0.1638	0.1692	437472600.0
2003-09-09 12:00:00	NVDA	Stock	0.1692	0.1718	0.1691	0.1713	160760400.0
2003-09-09 13:00:00	NVDA	Stock	0.1712	0.1788	0.1706	0.1771	407645040.0
2003-09-09 14:00:00	NVDA	Stock	0.1772	0.1789	0.174	0.1748	318874680.0
2003-09-09 15:00:00	NVDA	Stock	0.1748	0.1756	0.1717	0.1729	386122200.0
2003-09-09 16:00:00	NVDA	Stock	0.1729	0.1729	0.1704	0.1709	7452840.0
2003-09-09 17:00:00	NVDA	Stock	0.1729	0.1729	0.1708	0.1708	1801800.0
2003-09-09 18:00:00	NVDA	Stock	0.1714	0.1714	0.1709	0.1714	324000.0
2003-09-09 08:00:00	AMZN	Stock	2.355	2.3625	2.3505	2.355	120000.0
2003-09-09 09:00:00	AMZN	Stock	2.3505	2.3635	2.338	2.3415	13297120.0
2003-09-09 10:00:00	AMZN	Stock	2.3415	2.357	2.32	2.3515	28802940.0
2003-09-09 11:00:00	AMZN	Stock	2.352	2.3537	2.3345	2.3425	12844720.0
2003-09-09 12:00:00	AMZN	Stock	2.3425	2.357	2.3425	2.35	8363660.0
2003-09-09 13:00:00	AMZN	Stock	2.3505	2.3635	2.3463	2.3595	10056500.0
2003-09-09 14:00:00	AMZN	Stock	2.36	2.369	2.331	2.3415	39848520.0
2003-09-09 15:00:00	AMZN	Stock	2.341	2.346	2.315	2.3355	32825560.0
2003-09-09 16:00:00	AMZN	Stock	2.336	2.339	2.3225	2.3225	1064000.0
2003-09-09 17:00:00	AMZN	Stock	2.336	2.336	2.327	2.3305	130000.0
2003-09-09 18:00:00	AMZN	Stock	2.3295	2.3305	2.3295	2.3305	72000.0
2003-09-09 09:00:00	CL	Stock	28.245	28.265	28.135	28.175	199000.0
2003-09-09 10:00:00	CL	Stock	28.175	28.275	28.165	28.18	431000.0
2003-09-09 11:00:00	CL	Stock	28.18	28.2	28.135	28.145	305200.0
2003-09-09 12:00:00	CL	Stock	28.15	28.18	28.105	28.125	268000.0
2003-09-09 13:00:00	CL	Stock	28.125	28.18	28.11	28.13	268000.0
2003-09-09 14:00:00	CL	Stock	28.125	28.16	28.075	28.1	234000.0
2003-09-09 15:00:00	CL	Stock	28.1	28.115	27.975	28.0	452000.0

> showing 50 of 22,057 rows — these rows as CSV

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