PREVIEW / stock_1hour / 2003-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-11-20.parquet
  size:    486 KB
  rows:    22,381
  symbols: 1,670

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-11-20 08:00:00	AAPL	Stock	0.3652	0.3652	0.3652	0.3652	22400.0
2003-11-20 09:00:00	AAPL	Stock	0.3627	0.3725	0.3607	0.3711	40437880.0
2003-11-20 10:00:00	AAPL	Stock	0.3705	0.3738	0.3693	0.3725	38808336.0
2003-11-20 11:00:00	AAPL	Stock	0.3725	0.3752	0.3723	0.3746	24389792.0
2003-11-20 12:00:00	AAPL	Stock	0.3745	0.3764	0.373	0.375	34690544.0
2003-11-20 13:00:00	AAPL	Stock	0.3752	0.3752	0.3732	0.3736	15540784.0
2003-11-20 14:00:00	AAPL	Stock	0.3736	0.3741	0.3702	0.3702	20811112.0
2003-11-20 15:00:00	AAPL	Stock	0.3702	0.3705	0.3618	0.3638	50100512.0
2003-11-20 16:00:00	AAPL	Stock	0.3639	0.3643	0.3618	0.3618	2614136.0
2003-11-20 17:00:00	AAPL	Stock	0.3625	0.3625	0.3625	0.3625	22400.0
2003-11-20 08:00:00	MSFT	Stock	25.35	25.35	25.2	25.3	58200.0
2003-11-20 09:00:00	MSFT	Stock	25.32	25.39	25.1	25.34	12585087.0
2003-11-20 10:00:00	MSFT	Stock	25.34	25.55	25.34	25.47	21713839.0
2003-11-20 11:00:00	MSFT	Stock	25.47	25.61	25.37	25.56	12901442.0
2003-11-20 12:00:00	MSFT	Stock	25.56	25.63	25.46	25.57	10312684.0
2003-11-20 13:00:00	MSFT	Stock	25.57	25.631	25.44	25.49	8938937.0
2003-11-20 14:00:00	MSFT	Stock	25.49	25.53	25.34	25.37	10799334.0
2003-11-20 15:00:00	MSFT	Stock	25.37	25.39	25.08	25.1	24718704.0
2003-11-20 16:00:00	MSFT	Stock	25.1	25.18	25.08	25.14	1296948.0
2003-11-20 17:00:00	MSFT	Stock	25.14	25.17	25.09	25.16	641065.0
2003-11-20 18:00:00	MSFT	Stock	25.16	25.16	25.15	25.15	8500.0
2003-11-20 08:00:00	NVDA	Stock	0.165	0.172	0.165	0.1675	996000.0
2003-11-20 09:00:00	NVDA	Stock	0.1679	0.1679	0.165	0.1668	88916280.0
2003-11-20 10:00:00	NVDA	Stock	0.1668	0.1683	0.1659	0.168	101580720.0
2003-11-20 11:00:00	NVDA	Stock	0.168	0.1687	0.1665	0.1676	78495960.0
2003-11-20 12:00:00	NVDA	Stock	0.1675	0.1689	0.1672	0.1683	64896120.0
2003-11-20 13:00:00	NVDA	Stock	0.1683	0.1695	0.1682	0.1682	49694880.0
2003-11-20 14:00:00	NVDA	Stock	0.1682	0.1682	0.1663	0.1664	71140080.0
2003-11-20 15:00:00	NVDA	Stock	0.1665	0.1666	0.1633	0.164	242826480.0
2003-11-20 16:00:00	NVDA	Stock	0.164	0.164	0.1629	0.1639	8122440.0
2003-11-20 17:00:00	NVDA	Stock	0.1636	0.1636	0.1634	0.1634	612000.0
2003-11-20 18:00:00	NVDA	Stock	0.1633	0.1633	0.1633	0.1633	24000.0
2003-11-20 08:00:00	AMZN	Stock	2.46	2.475	2.4475	2.4575	134000.0
2003-11-20 09:00:00	AMZN	Stock	2.455	2.462	2.417	2.4375	30421320.0
2003-11-20 10:00:00	AMZN	Stock	2.4373	2.479	2.425	2.473	47045920.0
2003-11-20 11:00:00	AMZN	Stock	2.473	2.5095	2.461	2.5075	32185260.0
2003-11-20 12:00:00	AMZN	Stock	2.5075	2.509	2.487	2.5025	18172160.0
2003-11-20 13:00:00	AMZN	Stock	2.5025	2.523	2.5025	2.5145	17926020.0
2003-11-20 14:00:00	AMZN	Stock	2.5145	2.5155	2.465	2.4703	34380220.0
2003-11-20 15:00:00	AMZN	Stock	2.469	2.4722	2.4275	2.44	57435580.0
2003-11-20 16:00:00	AMZN	Stock	2.4425	2.458	2.435	2.4465	1069040.0
2003-11-20 17:00:00	AMZN	Stock	2.4481	2.4481	2.4393	2.4475	428660.0
2003-11-20 18:00:00	AMZN	Stock	2.4515	2.454	2.4475	2.454	14000.0
2003-11-20 09:00:00	CL	Stock	25.75	26.015	25.75	26.005	435000.0
2003-11-20 10:00:00	CL	Stock	26.015	26.015	25.83	25.865	933400.0
2003-11-20 11:00:00	CL	Stock	25.92	26.01	25.92	25.965	811400.0
2003-11-20 12:00:00	CL	Stock	25.955	25.975	25.92	25.945	471600.0
2003-11-20 13:00:00	CL	Stock	25.945	26.045	25.945	26.03	547200.0
2003-11-20 14:00:00	CL	Stock	26.025	26.04	25.955	26.005	706200.0
2003-11-20 15:00:00	CL	Stock	26.01	26.01	25.85	25.86	700800.0

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

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