PREVIEW / stock_1hour / 2005-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-20.parquet
  size:    563 KB
  rows:    26,624
  symbols: 1,962

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
2005-04-20 08:00:00	AAPL	Stock	1.35	1.3554	1.3364	1.3496	4955972.0
2005-04-20 09:00:00	AAPL	Stock	1.35	1.35	1.3168	1.3196	146778464.0
2005-04-20 10:00:00	AAPL	Stock	1.3193	1.3286	1.3086	1.3204	199847620.0
2005-04-20 11:00:00	AAPL	Stock	1.3204	1.3271	1.3136	1.3261	82412876.0
2005-04-20 12:00:00	AAPL	Stock	1.3264	1.3286	1.3004	1.3018	87173072.0
2005-04-20 13:00:00	AAPL	Stock	1.3025	1.3214	1.2893	1.2929	103568388.0
2005-04-20 14:00:00	AAPL	Stock	1.2932	1.2939	1.2732	1.2871	135164988.0
2005-04-20 15:00:00	AAPL	Stock	1.2871	1.2907	1.2657	1.27	164969056.0
2005-04-20 16:00:00	AAPL	Stock	1.2679	1.2786	1.2654	1.2714	10144568.0
2005-04-20 17:00:00	AAPL	Stock	1.2721	1.3041	1.2679	1.2721	9774100.0
2005-04-20 18:00:00	AAPL	Stock	1.2721	1.2743	1.2721	1.2736	171528.0
2005-04-20 08:00:00	MSFT	Stock	24.76	24.85	24.75	24.79	110181.0
2005-04-20 09:00:00	MSFT	Stock	24.78	24.85	24.53	24.56	9214876.0
2005-04-20 10:00:00	MSFT	Stock	24.57	24.69	24.5	24.61	14139401.0
2005-04-20 11:00:00	MSFT	Stock	24.6	24.64	24.53	24.61	7344651.0
2005-04-20 12:00:00	MSFT	Stock	24.61	24.65	24.46	24.47	6074457.0
2005-04-20 13:00:00	MSFT	Stock	24.47	24.5	24.4	24.45	8678490.0
2005-04-20 14:00:00	MSFT	Stock	24.45	24.48	24.37	24.48	12584961.0
2005-04-20 15:00:00	MSFT	Stock	24.48	24.5	24.3	24.33	16489888.0
2005-04-20 16:00:00	MSFT	Stock	24.33	24.409	24.29	24.36	15699094.0
2005-04-20 17:00:00	MSFT	Stock	24.34	24.518	24.31	24.518	262336.0
2005-04-20 18:00:00	MSFT	Stock	24.33	24.33	24.32	24.32	3170.0
2005-04-20 08:00:00	NVDA	Stock	0.1858	0.1877	0.1858	0.1875	348000.0
2005-04-20 09:00:00	NVDA	Stock	0.1867	0.1871	0.1835	0.1835	62401200.0
2005-04-20 10:00:00	NVDA	Stock	0.1835	0.1837	0.1817	0.1828	83970480.0
2005-04-20 11:00:00	NVDA	Stock	0.1827	0.1832	0.1817	0.1825	58199280.0
2005-04-20 12:00:00	NVDA	Stock	0.1825	0.1829	0.1796	0.1797	38056200.0
2005-04-20 13:00:00	NVDA	Stock	0.1797	0.1804	0.1785	0.179	98697240.0
2005-04-20 14:00:00	NVDA	Stock	0.179	0.1793	0.1776	0.1787	69185040.0
2005-04-20 15:00:00	NVDA	Stock	0.1788	0.1788	0.1771	0.1772	131329200.0
2005-04-20 16:00:00	NVDA	Stock	0.1772	0.1777	0.1771	0.1773	4399200.0
2005-04-20 17:00:00	NVDA	Stock	0.1778	0.1826	0.1763	0.1826	885960.0
2005-04-20 18:00:00	NVDA	Stock	0.176	0.176	0.1759	0.1759	132000.0
2005-04-20 07:00:00	AMZN	Stock	1.6745	1.6745	1.6745	1.6745	8000.0
2005-04-20 08:00:00	AMZN	Stock	1.663	1.663	1.65	1.663	172940.0
2005-04-20 09:00:00	AMZN	Stock	1.663	1.6665	1.645	1.666	30213120.0
2005-04-20 10:00:00	AMZN	Stock	1.6665	1.688	1.6625	1.68	27602940.0
2005-04-20 11:00:00	AMZN	Stock	1.6795	1.6825	1.666	1.6715	29176940.0
2005-04-20 12:00:00	AMZN	Stock	1.671	1.673	1.662	1.6655	18266340.0
2005-04-20 13:00:00	AMZN	Stock	1.665	1.6695	1.662	1.665	13988460.0
2005-04-20 14:00:00	AMZN	Stock	1.6645	1.6675	1.6625	1.6665	12795060.0
2005-04-20 15:00:00	AMZN	Stock	1.666	1.6705	1.6575	1.6625	44584360.0
2005-04-20 16:00:00	AMZN	Stock	1.6595	1.6755	1.65	1.66	5554360.0
2005-04-20 17:00:00	AMZN	Stock	1.6605	1.6646	1.659	1.6646	135980.0
2005-04-20 09:00:00	CL	Stock	25.985	25.99	25.79	25.815	434000.0
2005-04-20 10:00:00	CL	Stock	25.805	25.9	25.755	25.845	553400.0
2005-04-20 11:00:00	CL	Stock	25.86	25.975	25.76	25.865	401800.0
2005-04-20 12:00:00	CL	Stock	25.86	25.875	25.63	25.64	637200.0
2005-04-20 13:00:00	CL	Stock	25.64	25.71	25.575	25.635	443200.0
2005-04-20 14:00:00	CL	Stock	25.62	25.7	25.515	25.665	568600.0

> showing 50 of 26,624 rows — these rows as CSV

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